AFKO
Order Header Data PP Orders
AFKO is an SAP database table in S/4HANA. Order Header Data PP Orders. It contains 3 fields. 32 CDS views read from this table.
CDS Views using this table (32)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /MERP/PP_PO_DELAY | view | from | Production Order Delay Calculation | |
| ATPC_CDS_AFPO_QTY_DIST | view | left_outer | CDS View on AFPO,RESB,AFKO for Qty. Dist for ATP | |
| CTE_CDS_FIN_MON_NA | view | inner | CDS View for Monotoring NA exp to Concur | |
| e_mrp_mfg_comps | view | inner | ||
| e_mrp_prod_demands | view | inner | ||
| FINOC_RULE_NWA_BASE | view | inner | O/C Rule: Network Activity Base | |
| fins_prctr_of_object_acdoca | view | left_outer | Derive PRCTR & PPRCTR for ACDOCA object | |
| I_FldLogsProcRcptMaintOrd | view | inner | BASIC | Maintenance orders for process receipts FL |
| I_LogisticsOrderBasic | view | from | BASIC | Logistics Order Basic |
| I_MaintenanceOrderSubOperation | view | inner | BASIC | Maintenance Order Sub-Operation |
| I_MaintOrderOpAndSubOp_2 | view | inner | BASIC | Maintenance Order Operation and Suboperation |
| I_MaintOrderOperAndSubOper | view | inner | BASIC | Maintenance Order Operation and Suboperation |
| I_MaintOrderOpRqmtAssgmt | view_entity | from | BASIC | Maint Order Op Requirement Assignment |
| I_MaintOrdOpInternalID | view | from | BASIC | Maintenance Order Operation internal key |
| I_NetworkActivity | view | left_outer | BASIC | Network Activity Details |
| I_NetworkActivityByInternalKey | view | inner | BASIC | Network Activity Information By Internal Key |
| I_NetworkRouting | view_entity | from | COMPOSITE | Network and Routing relation |
| I_OrderHeader | view | from | BASIC | Order Header Data |
| I_OrderHeaderWithOrderId | view | from | BASIC | Order Header Data |
| I_OrdInternalBillOfOperations | view | from | BASIC | Order Internal Bill Of Operations |
| I_ProcessOrderOperation | view | inner | BASIC | Interface View for Process Order Operation |
| I_ProductionOrderOperation | view | inner | BASIC | Interface View for Production Order Operation |
| I_ProjectNetworkBasicData | view | from | BASIC | Project Network Basic Data |
| I_ProjSchedMaintOrderData | view | from | BASIC | Project Schedule Data for Work Order |
| I_RFM_MasterOrderDetail | view_entity | from | BASIC | Master Order Details |
| P_MaintOrderDuration | view | left_outer | BASIC | |
| P_MfgOrderItem | view | inner | BASIC | |
| P_ONRNV1 | view | inner | BASIC | |
| SHSM_M_AUKOA | view | inner | View for matchcode ID AUKO-A | |
| SHSM_V_NPACT | view | inner | cds view for search help NPACT | |
| vfco_dll_co88_with_op_l1 | view | inner | ||
| vfco_dll_co88_wo_op_l1 | view | inner |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Order Header Data PP Orders
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFKO (
MANDT, -- Client [mandt]
AUFNR, -- Order [aufnr]
OIHANTYP, -- Handling Type [oih_hantyp]
PRIMARY KEY (MANDT, AUFNR)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA