SAP AFPO Order item Table
Overview
AFPO is a standard SAP S/4HANA table that stores Order item data. There are total 100 fields in the AFPO table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFPO belongs to Production Orders (PP-SFC) module and is located in the package Application Development ERP PP Production Orders (CO).
In addition, following links provide an overview of foreign key relationships, if any, that link AFPO to other SAP tables and standard CDS views available based on AFPO table in S/4HANA 2020.
Techincal Settings of AFPO
Below are technical details of the table AFPO
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFPO Fields
The following table gives you an overview of the fields available in AFPO
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 |
| POSNR | Order item number | CO_POSNR | NUMC | 4 | |
| PSOBS | Special procurement type | SOBES | CHAR | 1 | |
| QUNUM | Number of quota arrangement | QUNUM | CHAR | 10 | |
| QUPOS | Quota arrangement item | QUPOS | NUMC | 3 | |
| PROJN | Work breakdown structure element (WBS element) | PS_PSP_ELE | PRPS | NUMC | 8 |
| PLNUM | Planned Order | PLNUM | CHAR | 10 | |
| STRMP | Planned Order Planned Start Date | CO_STRMP | DATS | 8 | |
| ETRMP | Opening Date of the Planned Order | CO_ETRMP | DATS | 8 | |
| KDAUF | Sales Order | CO_KDAUF | VBAK | CHAR | 10 |
| KDPOS | Sales Order Item | CO_KDPOS | VBAP | NUMC | 6 |
| KDEIN | Delivery schedule for sales order | KDEIN | NUMC | 4 | |
| BESKZ | Procurement Type | BESKZ | CHAR | 1 | |
| PSAMG | Order Item Planned Scrap Quantity | CO_PSAMG | QUAN | 13 | |
| PSMNG | Order Item Planned Total Quantity | CO_PSMNG | QUAN | 13 | |
| WEMNG | Quantity of Goods Received for the Order Item | CO_WEMNG | QUAN | 13 | |
| IAMNG | Expected Surplus/Deficit For Goods Receipt | CO_IAMNG | QUAN | 13 | |
| AMEIN | Unit of measure for in-house production | CO_AUFME | T006 | UNIT | 3 |
| MEINS | Base Unit of Measure | LAGME | T006 | UNIT | 3 |
| MATNR | Material Number for Order | CO_MATNR | MARA | CHAR | 40 |
| PAMNG | Planned Scrap Quantity | AVMNG | QUAN | 13 | |
| PGMNG | Planned Total Order Quantity | GSMNG | QUAN | 13 | |
| KNTTP | Account Assignment Category | KNTTP | T163K | CHAR | 1 |
| TPAUF | Indicator: Partial Conversion | TPAUF | CHAR | 1 | |
| LTRMI | Actual Delivery/Finish Date | CO_LTRMI | DATS | 8 | |
| LTRMP | Delivery Date From Planned Order | CO_LTRMP | DATS | 8 | |
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | CKHS | NUMC | 12 |
| UEBTO | Overdelivery Tolerance | UEBTO | DEC | 3 | |
| UEBTK | Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | |
| UNTTO | Underdelivery Tolerance | UNTTO | DEC | 3 | |
| INSMK | Stock Type | INSMK | CHAR | 1 | |
| WEPOS | Goods Receipt Indicator | WEPOS | CHAR | 1 | |
| BWTAR | Valuation Type | BWTAR_D | T149D | CHAR | 10 |
| BWTTY | Valuation Category | BWTTY_D | T149C | CHAR | 1 |
| PWERK | Planning Plant for an Order | CO_PWERK | T001W | CHAR | 4 |
| LGORT | Storage location | LGORT_D | T001L | CHAR | 4 |
| UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | |
| UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | |
| WEBAZ | Goods Receipt Processing Duration in Days | PLWEZ | DEC | 3 | |
| ELIKZ | Delivery Completed Indicator | ELIKZ | CHAR | 1 | |
| SAFNR | Run schedule header number | SA_AUFNR | * | CHAR | 12 |
| VERID | Production Version | VERID | * | CHAR | 4 |
| SERNR | BOM explosion number | SERNR | SNUM | CHAR | 8 |
| TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | |
| DWERK | Plant | WERKS_D | T001W | CHAR | 4 |
| DAUTY | Order category | AUFTYP | NUMC | 2 | |
| DAUAT | Order Type | AUFART | T003O | CHAR | 4 |
| DGLTP | Basic finish date | CO_GLTRP | DATS | 8 | |
| DGLTS | Scheduled finish | CO_GLTRS | DATS | 8 | |
| DFREI | Indicator: Order released/partially released (for MRP) | CO_FREI | CHAR | 1 | |
| DNREL | Indicator: Order Item is not Relevant for MRP | CO_DNREL | CHAR | 1 | |
| VERTO | MRP Distribution Key | SA_VERTL | T437V | CHAR | 4 |
| SOBKZ | Special Stock Indicator | SOBKZ | T148 | CHAR | 1 |
| KZVBR | Consumption posting | KZVBR | CHAR | 1 | |
| WEWRT | Value of goods received in local currency | WEWRT | CURR | 13 | |
| WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1 | |
| ABLAD | Unloading Point | ABLAD | CHAR | 25 | |
| WEMPF | Goods Recipient | WEMPF | CHAR | 12 | |
| CHARG | Batch Number | CHARG_D | MCHA | CHAR | 10 |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| WEAED | Indicator: Goods receipt indicator can be changed | CO_WEAE | CHAR | 1 | |
| CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | |
| KBNKZ | Kanban Indicator | KBNKZ | CHAR | 1 | |
| ARSNR | Settlement reservation number | ARSNR | NUMC | 10 | |
| ARSPS | Item number of the settlement reservation | ARSPS | NUMC | 4 | |
| KRSNR | Number of reservation/dependent requirements | RSNUM | * | NUMC | 10 |
| KRSPS | Item Number of Reservation / Dependent Requirements | RSPOS | NUMC | 4 | |
| KCKEY | Cost Collector Key | CCKEY | * | CHAR | 23 |
| RTP01 | Cost collector for repetitive manufacturing | RTP01 | CHAR | 1 | |
| RTP02 | Cost collector for KANBAN | RTP02 | CHAR | 1 | |
| RTP03 | Cost collector for valuated sales order stock | RTP03 | CHAR | 1 | |
| RTP04 | Cost collector for external PPC | RTP04 | CHAR | 1 | |
| KSVON | Cost collector valid from | KSVON | DATS | 8 | |
| KSBIS | Cost collector valid to | KSBIS | DATS | 8 | |
| OBJNP | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| NDISR | Ind.: Material in order item is not relevant for MRP | CO_NDISR | CHAR | 1 | |
| VFMNG | Committed quantity for order acc. to ATP check components | CO_VFMNG | QUAN | 13 | |
| GSBTR | Total Commitment Date | CO_GSBTR | DATS | 8 | |
| KZAVC | Indicator for type of availability check | KZAVC | CHAR | 1 | |
| KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | |
| XLOEK | Deletion Flag | AUFLOEKZ | CHAR | 1 | |
| SERNP | Serial Number Profile | SERAIL | T377P | CHAR | 4 |
| ANZSN | Number of serial numbers | ANZSN | INT4 | 10 | |
| OBJTYPE | Change indicator | OCM_OBJ_TYPE | CHAR | 1 | |
| CH_PROC | Process that has lead to the change of an object | OCM_CH_PROC | CHAR | 1 | |
| FXPRU | Fixed-Price Co-Product | CK_FIXPRKU | CHAR | 1 | |
| CUOBJ_ROOT | Configuration (internal object number) | CUOBJ | NUMC | 18 | |
| BERID | MRP Area | BERID | * | CHAR | 10 |
| TECHS_COPY | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | |
| SGT_SCAT | Stock Segment | SGT_SCAT | CHAR | 40 | |
| KUNNR2 | Customer Number | KUNNR | CHAR | 10 | |
| FSH_SEASON_YEAR | Season Year | FSH_SAISJ | FSH_SEASONS | CHAR | 4 |
| FSH_SEASON | Season | FSH_SAISO | FSH_SEASONS | CHAR | 10 |
| FSH_COLLECTION | Fashion Collection | FSH_COLLECTION | FSH_COLLECTIONS | CHAR | 10 |
| FSH_THEME | Fashion Theme | FSH_THEME | FSH_THEMES | CHAR | 10 |
| FSH_SALLOC_QTY | Allocated Stock Quantity | FSH_SALLOC_QTY | QUAN | 13 | |
| MILL_OC_AUFNR_U | Number of original order | MILL_OC_AUFNR_U | * | CHAR | 12 |
| MILL_OC_RUMNG | Confirmed Quantity for Item | MILL_OC_RUMNG | QUAN | 13 | |
| MILL_OC_SORT | Item Sequence | MILL_OC_SORT | NUMC | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AFPO
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFPO | AMEIN | C: CN | T006 |
| AFPO | AUFNR | 1: N | AUFK |
| AFPO | BWTAR | C: CN | T149D |
| AFPO | BWTTY | C: CN | T149C |
| AFPO | CHARG | C: CN | MCHA |
| AFPO | DAUAT | 1: CN | T003O |
| AFPO | DWERK | 1: CN | T001W |
| AFPO | FSH_COLLECTION | : | FSH_COLLECTIONS |
| AFPO | FSH_SEASON | : | FSH_SEASONS |
| AFPO | FSH_SEASON_YEAR | : | FSH_SEASONS |
| AFPO | FSH_THEME | : | FSH_THEMES |
| AFPO | GSBER | C: CN | TGSB |
| AFPO | KALNR | C: CN | CKHS |
| AFPO | KCKEY | 1: C | * |
| AFPO | KDAUF | : | VBAK |
| AFPO | KDPOS | : | VBAP |
| AFPO | KNTTP | 1: CN | T163K |
| AFPO | LGORT | C: CN | T001L |
| AFPO | MANDT | 1: CN | T000 |
| AFPO | MATNR | 1: CN | MARA |
| AFPO | MEINS | 1: CN | T006 |
| AFPO | OBJNP | C: C | ONR00 |
| AFPO | PROJN | C: CN | PRPS |
| AFPO | PWERK | C: CN | T001W |
| AFPO | SERNP | : | T377P |
| AFPO | SERNR | : | SNUM |
| AFPO | SOBKZ | C: CN | T148 |
| AFPO | VERTO | C: CN | T437V |