SAP table AFPO (Order item)

SAP table AFPO has 3 primary key fields being MANDT,AUFNR,POSNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
AUFNR Order Number CHAR 12 0 AUFK AUFNR
POSNR Order item number NUMC 4 0 CO_POSNR
PSOBS Special procurement type CHAR 1 0 SOBES
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
9 IS-OIL only: Stock transfer reservation
E Standard in-house production
P Production in plant 2
QUNUM Number of quota arrangement CHAR 10 0 QUNUM
QUPOS Quota arrangement item NUMC 3 0 QUPOS
PROJN Work breakdown structure element (WBS element) NUMC 8 0 PRPS PS_PSP_ELE
PLNUM Planned Order CHAR 10 0 PLNUM
STRMP Planned Order Planned Start Date DATS 8 0 CO_STRMP
ETRMP Opening Date of the Planned Order DATS 8 0 CO_ETRMP
KDAUF Sales Order CHAR 10 0 VBAK CO_KDAUF
KDPOS Sales Order Item NUMC 6 0 VBAP CO_KDPOS
KDEIN Delivery schedule for sales order NUMC 4 0 KDEIN
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
PSAMG Order Item Planned Scrap Quantity QUAN 13 3 CO_PSAMG
PSMNG Order Item Planned Total Quantity QUAN 13 3 CO_PSMNG
WEMNG Quantity of Goods Received for the Order Item QUAN 13 3 CO_WEMNG
IAMNG Expected Surplus/Deficit For Goods Receipt QUAN 13 3 CO_IAMNG
AMEIN Unit of measure for in-house production UNIT 3 0 T006 CO_AUFME
MEINS Base Unit of Measure UNIT 3 0 T006 LAGME
MATNR Material Number for Order CHAR 40 0 MARA CO_MATNR
PAMNG Planned Scrap Quantity QUAN 13 3 AVMNG
PGMNG Planned Total Order Quantity QUAN 13 3 GSMNG
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
TPAUF Indicator: Partial Conversion CHAR 1 0 TPAUF
LTRMI Actual Delivery/Finish Date DATS 8 0 CO_LTRMI
LTRMP Delivery Date From Planned Order DATS 8 0 CO_LTRMP
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure NUMC 12 0 CKHS CK_KALNR
UEBTO Overdelivery Tolerance DEC 3 1 UEBTO
UEBTK Unlimited Overdelivery Allowed CHAR 1 0 UEBTK
UNTTO Underdelivery Tolerance DEC 3 1 UNTTO
INSMK Stock Type CHAR 1 0 INSMK
Unrestricted use
S Blocked stock
X Quality inspection
WEPOS Goods Receipt Indicator CHAR 1 0 WEPOS
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
BWTTY Valuation Category CHAR 1 0 T149C BWTTY_D
PWERK Planning Plant for an Order CHAR 4 0 T001W CO_PWERK
LGORT Storage location CHAR 4 0 T001L LGORT_D
UMREZ Numerator for Conversion to Base Units of Measure DEC 5 0 UMREZ
UMREN Denominator for conversion to base units of measure DEC 5 0 UMREN
WEBAZ Goods Receipt Processing Duration in Days DEC 3 0 PLWEZ
ELIKZ "Delivery Completed" Indicator CHAR 1 0 ELIKZ
SAFNR Run schedule header number CHAR 12 0 * SA_AUFNR
VERID Production Version CHAR 4 0 * VERID
SERNR BOM explosion number CHAR 8 0 SNUM SERNR
TECHS Parameter Variant/Standard Variant CHAR 12 0 TECHS
DWERK Plant CHAR 4 0 T001W WERKS_D
DAUTY Order category NUMC 2 0 AUFTYP
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
99 Master Planned order
DAUAT Order Type CHAR 4 0 T003O AUFART
DGLTP Basic finish date DATS 8 0 CO_GLTRP
DGLTS Scheduled finish DATS 8 0 CO_GLTRS
DFREI Indicator: Order released/partially released (for MRP) CHAR 1 0 CO_FREI
DNREL Indicator: Order Item is not Relevant for MRP CHAR 1 0 CO_DNREL
VERTO MRP Distribution Key CHAR 4 0 T437V SA_VERTL
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
WEWRT Value of goods received in local currency CURR 13 2 WEWRT
WEUNB Goods Receipt, Non-Valuated CHAR 1 0 WEUNB
ABLAD Unloading Point CHAR 25 0 ABLAD
WEMPF Goods Recipient CHAR 12 0 WEMPF
CHARG Batch Number CHAR 10 0 MCHA CHARG_D
GSBER Business Area CHAR 4 0 TGSB GSBER
WEAED Indicator: Goods receipt indicator can be changed CHAR 1 0 CO_WEAE
CUOBJ Configuration (internal object number) NUMC 18 0 CUOBJ
KBNKZ Kanban Indicator CHAR 1 0 KBNKZ
X Replenishment Element for Kanban
Y Scheduling Agreement for Summarized JIT Call
Z Scheduling Agreement for JIT calls
ARSNR Settlement reservation number NUMC 10 0 ARSNR
ARSPS Item number of the settlement reservation NUMC 4 0 ARSPS
KRSNR Number of reservation/dependent requirements NUMC 10 0 * RSNUM
KRSPS Item Number of Reservation / Dependent Requirements NUMC 4 0 RSPOS
KCKEY Cost Collector Key CHAR 23 0 * CCKEY
RTP01 Cost collector for repetitive manufacturing CHAR 1 0 RTP01
RTP02 Cost collector for KANBAN CHAR 1 0 RTP02
RTP03 Cost collector for valuated sales order stock CHAR 1 0 RTP03
RTP04 Cost collector for external PPC CHAR 1 0 RTP04
KSVON Cost collector valid from DATS 8 0 KSVON
KSBIS Cost collector valid to DATS 8 0 KSBIS
OBJNP Object number CHAR 22 0 ONR00 J_OBJNR
NDISR Ind.: Material in order item is not relevant for MRP CHAR 1 0 CO_NDISR
VFMNG Committed quantity for order acc. to ATP check components QUAN 13 3 CO_VFMNG
GSBTR Total Commitment Date DATS 8 0 CO_GSBTR
KZAVC Indicator for type of availability check CHAR 1 0 KZAVC
1 ATP check
2 Check against preliminary planning
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
XLOEK Deletion Flag CHAR 1 0 AUFLOEKZ
SERNP Serial Number Profile CHAR 4 0 T377P SERAIL
ANZSN Number of serial numbers INT4 10 0 ANZSN
OBJTYPE Change indicator CHAR 1 0 OCM_OBJ_TYPE
Normal object
+ Object created
- Object is to be deleted
0 Zero Object
C Object changed
M Object reassigned
CH_PROC Process that has lead to the change of an object CHAR 1 0 OCM_CH_PROC
Not changed
1 Manually changed
2 Change sales order
3 Release of change number
4 Change assembly order
5 Change number supplement
6 Change number shift
7 Direct assignment
FXPRU Fixed-Price Co-Product CHAR 1 0 CK_FIXPRKU
CUOBJ_ROOT Configuration (internal object number) NUMC 18 0 CUOBJ
BERID MRP Area CHAR 10 0 * BERID
TECHS_COPY Parameter Variant/Standard Variant CHAR 12 0 TECHS
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
KUNNR2 Customer Number CHAR 10 0 KUNNR
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SEASONS FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SEASONS FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 FSH_COLLECTIONS FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEMES FSH_THEME
FSH_SALLOC_QTY Allocated Stock Quantity QUAN 13 3 FSH_SALLOC_QTY
MILL_OC_AUFNR_U Number of original order CHAR 12 0 * MILL_OC_AUFNR_U
MILL_OC_RUMNG Confirmed Quantity for Item QUAN 13 3 MILL_OC_RUMNG
MILL_OC_SORT Item Sequence NUMC 8 0 MILL_OC_SORT

AFPO foreign key relationships

Table Field Check Table Check Field
0 AFPO AMEIN T006 Units of Measurement MANDT
0 AFPO AMEIN T006 Units of Measurement MSEHI
1 AFPO AUFNR AUFK Order master data AUFNR
0 AFPO BWTAR T149D Global Valuation Types MANDT
0 AFPO BWTAR T149D Global Valuation Types BWTAR
1 AFPO BWTTY T149C Global Valuation Categories BWTTY
0 AFPO CHARG MCHA Batches MANDT
0 AFPO CHARG MCHA Batches WERKS
0 AFPO CHARG MCHA Batches CHARG
1 AFPO DAUAT T003O Order Types AUART
0 AFPO DWERK T001W Plants/Branches MANDT
0 AFPO DWERK T001W Plants/Branches WERKS
1 AFPO FSH_COLLECTION FSH_COLLECTIONS Database table for FSH Collections FSH_SEASON_YEAR
1 AFPO FSH_COLLECTION FSH_COLLECTIONS Database table for FSH Collections FSH_SEASON
1 AFPO FSH_COLLECTION FSH_COLLECTIONS Database table for FSH Collections FSH_COLLECTION
0 AFPO FSH_SEASON FSH_SEASONS Database table for FSH Seasons FSH_SEASON_YEAR
0 AFPO FSH_SEASON FSH_SEASONS Database table for FSH Seasons FSH_SEASON
1 AFPO FSH_SEASON_YEAR FSH_SEASONS Database table for FSH Seasons FSH_SEASON_YEAR
1 AFPO FSH_SEASON_YEAR FSH_SEASONS Database table for FSH Seasons FSH_SEASON
0 AFPO FSH_THEME FSH_THEMES Database table for FSH Themes FSH_SEASON_YEAR
0 AFPO FSH_THEME FSH_THEMES Database table for FSH Themes FSH_SEASON
0 AFPO FSH_THEME FSH_THEMES Database table for FSH Themes FSH_COLLECTION
0 AFPO FSH_THEME FSH_THEMES Database table for FSH Themes FSH_THEME
1 AFPO GSBER TGSB Business Areas MANDT
1 AFPO GSBER TGSB Business Areas GSBER
0 AFPO KALNR CKHS Header: Unit Costing (Control + Totals) MANDT
0 AFPO KALNR CKHS Header: Unit Costing (Control + Totals) LEDNR
0 AFPO KALNR CKHS Header: Unit Costing (Control + Totals) KALNR
0 AFPO KALNR CKHS Header: Unit Costing (Control + Totals) KALKA
0 AFPO KALNR CKHS Header: Unit Costing (Control + Totals) KADKY
0 AFPO KALNR CKHS Header: Unit Costing (Control + Totals) TVERS
0 AFPO KALNR CKHS Header: Unit Costing (Control + Totals) BWVAR
0 AFPO KALNR CKHS Header: Unit Costing (Control + Totals) KKZMA
1 AFPO KDAUF VBAK Sales Document: Header Data MANDT
1 AFPO KDAUF VBAK Sales Document: Header Data VBELN
0 AFPO KDPOS VBAP Sales Document: Item Data VBELN
0 AFPO KDPOS VBAP Sales Document: Item Data POSNR
1 AFPO KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
1 AFPO KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
0 AFPO LGORT T001L Storage Locations MANDT
0 AFPO LGORT T001L Storage Locations WERKS
1 AFPO MANDT T000 Clients MANDT
0 AFPO MATNR MARA General Material Data MANDT
0 AFPO MATNR MARA General Material Data MATNR
1 AFPO MEINS T006 Units of Measurement MANDT
1 AFPO MEINS T006 Units of Measurement MSEHI
0 AFPO OBJNP ONR00 General Object Number MANDT
1 AFPO PROJN PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 AFPO PROJN PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 AFPO PWERK T001W Plants/Branches MANDT
0 AFPO PWERK T001W Plants/Branches WERKS
1 AFPO SERNP T377P Serial Number Management Profiles MANDT
0 AFPO SERNR SNUM BOM explosion number MANDT
1 AFPO SOBKZ T148 Special Stock Indicator MANDT
1 AFPO SOBKZ T148 Special Stock Indicator SOBKZ
0 AFPO VERTO T437V Distribution key in MRP MANDT
0 AFPO VERTO T437V Distribution key in MRP WERKS