1. Home
  2. Resources
  3. SAP Tables
  4. AFPO - Order item

SAP Table AFPO

Order item

AFPO (Order item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link AFPO to other SAP tables.

AFPO table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
POSNR Order Item Number CO_POSNR NUMC 4 0
PSOBS Special procurement type SOBES CHAR 1 0
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
E Standard in-house production
P Production in plant 2
9 IS-OIL only: Stock transfer reservation
QUNUM Number of Quota Arrangement QUNUM CHAR 10 0
QUPOS Quota Arrangement Item QUPOS NUMC 3 0
PROJN Work breakdown structure element (WBS element) PS_PSP_ELE PRPS NUMC 8 0
PLNUM Planned order number PLNUM CHAR 10 0
STRMP Start date of the planned order CO_STRMP DATS 8 0
ETRMP Opening date of the planned order CO_ETRMP DATS 8 0
KDAUF Sales order number CO_KDAUF VBUK CHAR 10 0
KDPOS Sales order item CO_KDPOS VBUP NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
PSAMG Scrap quantity in item CO_PSAMG QUAN 13 3
PSMNG Order item quantity CO_PSMNG QUAN 13 3
WEMNG Quantity of goods received for the order item CO_WEMNG QUAN 13 3
IAMNG Expected surplus/deficit for goods receipt CO_IAMNG QUAN 13 3
AMEIN Unit of measure for in-house production CO_AUFME T006 UNIT 3 0
MEINS Base Unit of Measure LAGME T006 UNIT 3 0
MATNR Material Number for Order CO_MATNR MARA CHAR 18 0
PAMNG Fixed quantity of scrap from production AVMNG QUAN 13 3
PGMNG Total planned order quantity GSMNG QUAN 13 3
KNTTP Account Assignment Category KNTTP T163K CHAR 1 0
TPAUF Indicator: Partial conversion TPAUF CHAR 1 0
LTRMI Actual delivery/finish date CO_LTRMI DATS 8 0
LTRMP Delivery date from planned order CO_LTRMP DATS 8 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR CKHS NUMC 12 0
UEBTO Overdelivery Tolerance Limit UEBTO DEC 3 1
UEBTK Indicator: Unlimited Overdelivery Allowed UEBTK CHAR 1 0
X Yes
NULL No
UNTTO Underdelivery Tolerance Limit UNTTO DEC 3 1
INSMK Stock Type INSMK CHAR 1 0
NULL Unrestricted use
X Quality inspection
S Blocked stock
WEPOS Goods Receipt Indicator WEPOS CHAR 1 0
X Yes
NULL No
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
BWTTY Valuation Category BWTTY_D T149C CHAR 1 0
PWERK Planning plant for the order CO_PWERK T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
WEBAZ Goods receipt processing time in days PLWEZ DEC 3 0
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
SAFNR Run schedule header number SA_AUFNR CHAR 12 0
VERID Production Version VERID CHAR 4 0
SERNR BOM explosion number SERNR SNUM CHAR 8 0
TECHS Parameter Variant/Standard Variant TECHS CHAR 12 0
DWERK Plant WERKS_D T001W CHAR 4 0
DAUTY Order category AUFTYP NUMC 2 0
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
DAUAT Order Type AUFART T003O CHAR 4 0
DGLTP Basic finish date CO_GLTRP DATS 8 0
DGLTS Scheduled finish CO_GLTRS DATS 8 0
DFREI Indicator: Order released/partially released (for MRP) CO_FREI CHAR 1 0
DNREL Indicator: Order item not relevant for MRP CO_DNREL CHAR 1 0
VERTO MRP Distribution Key SA_VERTL T437V CHAR 4 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
WEWRT Value of goods received in local currency WEWRT CURR 13 2
WEUNB Goods Receipt, Non-Valuated WEUNB CHAR 1 0
X Yes
NULL No
ABLAD Unloading Point ABLAD CHAR 25 0
WEMPF Goods Recipient/Ship-To Party WEMPF CHAR 12 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
GSBER Business Area GSBER TGSB CHAR 4 0
WEAED Indicator: Goods receipt indicator can be changed CO_WEAE CHAR 1 0
X Yes
NULL No
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
KBNKZ Kanban Indicator KBNKZ CHAR 1 0
X Replenishment Element for Kanban
Y Scheduling Agreement for Summarized JIT Call
ARSNR Settlement reservation number ARSNR NUMC 10 0
ARSPS Item number of the settlement reservation ARSPS NUMC 4 0
KRSNR Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
KRSPS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
KCKEY Cost collector key CCKEY CHAR 23 0
RTP01 Cost collector for repetitive manufacturing RTP01 CHAR 1 0
X Yes
NULL No
RTP02 Cost collector for KANBAN RTP02 CHAR 1 0
X Yes
NULL No
RTP03 Cost collector for valuated sales order stock RTP03 CHAR 1 0
X Yes
NULL No
RTP04 Cost collector for external PPC RTP04 CHAR 1 0
X Yes
NULL No
KSVON Cost collector valid from KSVON DATS 8 0
KSBIS Cost collector valid to KSBIS DATS 8 0
OBJNP Object number J_OBJNR ONR00 CHAR 22 0
NDISR Ind.: Material in order item is not relevant for MRP CO_NDISR CHAR 1 0
VFMNG Committed quantity for order acc. to ATP check components CO_VFMNG QUAN 13 3
GSBTR Overall commitment date CO_GSBTR DATS 8 0
KZAVC Indicator for type of availability check KZAVC CHAR 1 0
1 ATP check
2 Check against preliminary planning
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
XLOEK Deletion flag AUFLOEKZ CHAR 1 0
X Yes
NULL No
SERNP Serial Number Profile SERAIL T377P CHAR 4 0
ANZSN Number of serial numbers ANZSN INT4 10 0
OBJTYPE Change indicator OCM_OBJ_TYPE CHAR 1 0
+ Object created
- Object is to be deleted
C Object changed
M Object reassigned
NULL Normal object
0 Zero Object
CH_PROC Process that has lead to the change of an object OCM_CH_PROC CHAR 1 0
NULL 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 CK_FIXPRKU CHAR 1 0
X Yes
NULL No
CUOBJ_ROOT Configuration (internal object number) CUOBJ NUMC 18 0
BERID MRP Area BERID CHAR 10 0
TECHS_COPY Parameter Variant/Standard Variant TECHS CHAR 12 0
KUNNR2 Customer Number KUNNR CHAR 10 0
MILL_OC_AUFNR_U Number of original order MILL_OC_AUFNR_U CHAR 12 0
MILL_OC_RUMNG Confirmed Quantity for Item MILL_OC_RUMNG QUAN 13 3
MILL_OC_SORT Item Sequence MILL_OC_SORT NUMC 8 0
OIHANTYPI Excise Duty Handling Type OIH_HANTYP OIH5 CHAR 2 0

AFPO foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
AFPO AMEIN AFPO AMEIN T006 Units of Measurement MSEHI
AFPO AMEIN AFPO MANDT T006 Units of Measurement MANDT
AFPO AUFNR AFPO MANDT AUFK Order master data MANDT
AFPO AUFNR AFPO AUFNR AUFK Order master data AUFNR
AFPO BWTAR AFPO MANDT T149D Global Valuation Types MANDT
AFPO BWTAR AFPO BWTAR T149D Global Valuation Types BWTAR
AFPO BWTTY AFPO BWTTY T149C Global Valuation Categories BWTTY
AFPO BWTTY AFPO MANDT T149C Global Valuation Categories MANDT
AFPO CHARG AFPO DWERK MCHA Batches WERKS
AFPO CHARG AFPO CHARG MCHA Batches CHARG
AFPO CHARG AFPO MANDT MCHA Batches MANDT
AFPO CHARG AFPO MATNR MCHA Batches MATNR
AFPO DAUAT AFPO MANDT T003O Order Types CLIENT
AFPO DAUAT AFPO DAUAT T003O Order Types AUART
AFPO DWERK AFPO MANDT T001W Plants/Branches MANDT
AFPO DWERK AFPO DWERK T001W Plants/Branches WERKS
AFPO GSBER AFPO MANDT TGSB Business Areas MANDT
AFPO GSBER AFPO GSBER TGSB Business Areas GSBER
AFPO KALNR CKHS BZOBJ CKHS Header: Unit Costing (Control + Totals) BZOBJ
AFPO KALNR CKHS KKZMA CKHS Header: Unit Costing (Control + Totals) KKZMA
AFPO KALNR AFPO KALNR CKHS Header: Unit Costing (Control + Totals) KALNR
AFPO KALNR CKHS KALKA CKHS Header: Unit Costing (Control + Totals) KALKA
AFPO KALNR CKHS KADKY CKHS Header: Unit Costing (Control + Totals) KADKY
AFPO KALNR AFPO MANDT CKHS Header: Unit Costing (Control + Totals) MANDT
AFPO KALNR CKHS TVERS CKHS Header: Unit Costing (Control + Totals) TVERS
AFPO KALNR CKHS LEDNR CKHS Header: Unit Costing (Control + Totals) LEDNR
AFPO KALNR CKHS BWVAR CKHS Header: Unit Costing (Control + Totals) BWVAR
AFPO KDAUF AFPO MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
AFPO KDAUF AFPO KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
AFPO KDPOS AFPO KDPOS VBUP Sales Document: Item Status POSNR
AFPO KDPOS AFPO MANDT VBUP Sales Document: Item Status MANDT
AFPO KDPOS AFPO KDAUF VBUP Sales Document: Item Status VBELN
AFPO KNTTP AFPO MANDT T163K Account Assignment Categories in Purchasing Document MANDT
AFPO KNTTP AFPO KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
AFPO LGORT AFPO MANDT T001L Storage Locations MANDT
AFPO LGORT AFPO PWERK T001L Storage Locations WERKS
AFPO LGORT AFPO LGORT T001L Storage Locations LGORT
AFPO MANDT AFPO MANDT T000 Clients MANDT
AFPO MATNR AFPO MANDT MARA General Material Data MANDT
AFPO MATNR AFPO MATNR MARA General Material Data MATNR
AFPO MEINS AFPO MANDT T006 Units of Measurement MANDT
AFPO MEINS AFPO MEINS T006 Units of Measurement MSEHI
AFPO OBJNP AFPO OBJNP ONR00 General Object Number OBJNR
AFPO OBJNP AFPO MANDT ONR00 General Object Number MANDT
AFPO OIHANTYPI AFPO MANDT OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) MANDT
AFPO OIHANTYPI AFPO OIHANTYPI OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) HANTYP
AFPO PROJN AFPO MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
AFPO PROJN AFPO PROJN PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
AFPO PWERK AFPO MANDT T001W Plants/Branches MANDT
AFPO PWERK AFPO PWERK T001W Plants/Branches WERKS
AFPO SERNP AFPO MANDT T377P Serial Number Management Profiles MANDT
AFPO SERNP AFPO SERNP T377P Serial Number Management Profiles SERAIL
AFPO SERNR SYST MANDT SNUM BOM explosion number MANDT
AFPO SERNR AFPO SERNR SNUM BOM explosion number SERNR
AFPO SOBKZ AFPO MANDT T148 Special Stock Indicator MANDT
AFPO SOBKZ AFPO SOBKZ T148 Special Stock Indicator SOBKZ
AFPO VERTO AFPO MANDT T437V Distribution key in MRP MANDT
AFPO VERTO AFPO DWERK T437V Distribution key in MRP WERKS
AFPO VERTO AFPO VERTO T437V Distribution key in MRP VERTL