SE11 ABAP Dictionary SE11 AFPO

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

AFPO

Order item
SAP PP Transparent Table 94 Fields
Primary Key:
MANDT AUFNR POSNR

Dictionary Fields Fields

(94 dari 94 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
AUFNR
KEY Order CHAR 12 - - Order Number
3
POSNR
KEY Item No. NUMC 4 - - Order Item Number
4
PSOBS
- Spec.proc. CHAR 1 - - Special procurement type
5
QUNUM
- Quota Arr. CHAR 10 - - Number of Quota Arrangement
6
QUPOS
- QuotArrItm NUMC 3 - - Quota Arrangement Item
7
PROJN
- WBS elem. NUMC 8 - - Work breakdown structure element (WBS element)
8
PLNUM
- Plnd order CHAR 10 - - Planned order number
9
STRMP
- Pld start DATS 8 - - Start date of the planned order
10
ETRMP
- OpengDtPln DATS 8 - - Opening date of the planned order
11
KDAUF
- SO no. CHAR 10 - - Sales order number
12
KDPOS
- SO item NUMC 6 - - Sales order item
13
KDEIN
- SO Sched. NUMC 4 - - Delivery Schedule for Sales Order
14
BESKZ
- Proc. type CHAR 1 - - Procurement Type
15
PSAMG
- Scrap QUAN 13 3 - Scrap quantity in item
16
PSMNG
- Quantity QUAN 13 3 - Order item quantity
17
WEMNG
- GR qty QUAN 13 3 - Quantity of goods received for the order item
18
IAMNG
- ExpVarRcpt QUAN 13 3 - Expected surplus/deficit for goods receipt
19
AMEIN
- Order Un UNIT 3 - - Unit of measure for in-house production
20
MEINS
- Base Unit UNIT 3 - - Base Unit of Measure
21
MATNR
- Material CHAR 18 - MARA Material Number for Order
22
PAMNG
- Scrap QUAN 13 3 - Fixed quantity of scrap from production
23
PGMNG
- Order qty QUAN 13 3 - Total planned order quantity
24
KNTTP
- AcctAssCat CHAR 1 - - Account Assignment Category
25
TPAUF
- PC CHAR 1 - - Indicator: Partial conversion
26
LTRMI
- Act. del. DATS 8 - - Actual delivery/finish date
27
LTRMP
- PldDelDate DATS 8 - - Delivery date from planned order
28
KALNR
- CENo NUMC 12 - - Cost Estimate Number for Cost Est. w/o Qty Structure
29
UEBTO
- Over. Tol. DEC 3 1 - Overdelivery Tolerance Limit
30
UEBTK
- Unlimited CHAR 1 - - Indicator: Unlimited Overdelivery Allowed
31
UNTTO
- Under.Tol. DEC 3 1 - Underdelivery Tolerance Limit
32
INSMK
- Stock Type CHAR 1 - - Stock Type
33
WEPOS
- GR CHAR 1 - - Goods Receipt Indicator
34
BWTAR
- Val. Type CHAR 10 - - Valuation Type
35
BWTTY
- Val. Cat. CHAR 1 - - Valuation Category
36
PWERK
- Plang plnt CHAR 4 - - Planning plant for the order
37
LGORT
- Stor. Loc. CHAR 4 - T001L Storage Location
38
UMREZ
- Counter DEC 5 - - Numerator for Conversion to Base Units of Measure
39
UMREN
- Denominat. DEC 5 - - Denominator for conversion to base units of measure
40
WEBAZ
- GR time DEC 3 - - Goods receipt processing time in days
41
ELIKZ
- Del. Cmpl. CHAR 1 - - "Delivery Completed" Indicator
42
SAFNR
- RS header CHAR 12 - - Run schedule header number
43
VERID
- Version CHAR 4 - - Production Version
44
SERNR
- BOMexpl.no CHAR 8 - - BOM explosion number
45
TECHS
- StdVariant CHAR 12 - - Parameter Variant/Standard Variant
46
DWERK
- Plant CHAR 4 - - Plant
47
DAUTY
- Order catg NUMC 2 - - Order category
48
DAUAT
- Order Type CHAR 4 - - Order Type
49
DGLTP
- Basic fin. DATS 8 - - Basic finish date
50
DGLTS
- Sched.Fin. DATS 8 - - Scheduled finish
51
DFREI
- Release CHAR 1 - - Indicator: Order released/partially released (for MRP)
52
DNREL
- Not relevt CHAR 1 - - Indicator: Order item not relevant for MRP
53
VERTO
- Distribut. CHAR 4 - - MRP distribution key
54
SOBKZ
- Spec.Stock CHAR 1 - - Special Stock Indicator
55
KZVBR
- Consumpt. CHAR 1 - - Consumption Posting
56
WEWRT
- GR value CURR 13 2 - Value of goods received in local currency
57
WEUNB
- GR Non-Val CHAR 1 - - Goods Receipt, Non-Valuated
58
ABLAD
- Unl. Point CHAR 25 - - Unloading Point
59
WEMPF
- Recipient CHAR 12 - - Goods Recipient/Ship-To Party
60
CHARG
- Batch CHAR 10 - - Batch Number
61
GSBER
- Bus. Area CHAR 4 - - Business Area
62
WEAED
- GR change CHAR 1 - - Indicator: Goods receipt indicator can be changed
63
CUOBJ
- Int.obj.no NUMC 18 - - Configuration (internal object number)
64
KBNKZ
- KanbanInd. CHAR 1 - - Kanban Indicator
65
ARSNR
- SetReserNo NUMC 10 - - Settlement reservation number
66
ARSPS
- SettlItmNo NUMC 4 - - Item number of the settlement reservation
67
KRSNR
- Reserv.No. NUMC 10 - - Number of Reservation/Dependent Requirement
68
KRSPS
- Item NUMC 4 - - Item Number of Reservation/Dependent Requirement
69
KCKEY
- Key CHAR 23 - - Cost collector key
70
RTP01
- Repet. mfg CHAR 1 - - Cost collector for repetitive manufacturing
71
RTP02
- Kanban CHAR 1 - - Cost collector for KANBAN
72
RTP03
- SOrd.stock CHAR 1 - - Cost collector for valuated sales order stock
73
RTP04
- Extern.PPC CHAR 1 - - Cost collector for external PPC
74
KSVON
- Valid from DATS 8 - - Cost collector valid from
75
KSBIS
- Valid to DATS 8 - - Cost collector valid to
76
OBJNP
- Obj. no. CHAR 22 - - Object number
77
NDISR
- Not relevt CHAR 1 - - Ind.: Material in order item is not relevant for MRP
78
VFMNG
- Ord.qty QUAN 13 3 - Committed quantity for order acc. to ATP check components
79
GSBTR
- Ov.commit. DATS 8 - - Overall commitment date
80
KZAVC
- TypeAvChck CHAR 1 - - Indicator for type of availability check
81
KZBWS
- Valuation CHAR 1 - - Valuation of Special Stock
82
XLOEK
- Del. flag CHAR 1 - - Deletion flag
83
SERNP
- Profile CHAR 4 - - Serial Number Profile
84
ANZSN
- No.ser.no. INT4 10 - - Number of serial numbers
85
OBJTYPE
- ChD CHAR 1 - - Change indicator
86
CH_PROC
- ChgPrcType CHAR 1 - - Process that has lead to the change of an object
87
FXPRU
- Fxd Price CHAR 1 - - Fixed-Price Co-Product
88
CUOBJ_ROOT
- Int.obj.no NUMC 18 - - Configuration (internal object number)
89
BERID
- MRP Area CHAR 10 - - MRP Area
90
TECHS_COPY
- StdVariant CHAR 12 - - Parameter Variant/Standard Variant
91
KUNNR2
- Customer CHAR 10 - - Customer Number 1
92
MILL_OC_AUFNR_U
- OrigOrder CHAR 12 - - Number of original order
93
MILL_OC_RUMNG
- Conf. Qty QUAN 13 3 - Confirmed Quantity for Item
94
MILL_OC_SORT
- Sort NUMC 8 - - Item Sequence

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk AFPO.

Standard T-Codes
ANSI SQL Query 
SELECT a.AUFNR,
       a.POSNR,
       a.PSOBS,
       a.QUNUM,
       a.QUPOS,
       a.PROJN,
       a.PLNUM
FROM AFPO AS a
WHERE a.AUFNR = '0001'
  AND a.POSNR = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~aufnr,
       a~posnr,
       a~psobs,
       a~qunum,
       a~qupos,
       a~projn,
       a~plnum
  FROM afpo AS a
  WHERE a~aufnr = '0001'
  and a~posnr = '0001'
  INTO TABLE @DATA(lt_afpo)
  UP TO 100 ROWS.
Mencari di seluruh SAP Knowledge Hub...
Tidak ditemukan hasil untuk ""
Cek "" langsung di Kamus SE11