AFKO

Transparent Table Application Table
171 Fields 34 CDS Views

Order Header Data PP Orders

AFKO is an SAP database table in S/4HANA. Order Header Data PP Orders. It contains 171 fields. 34 CDS views read from this table.

CDS Views using this table (34)

ViewTypeJoinVDMDescription
/MERP/PP_PO_DELAY view from Production Order Delay Calculation
ATPC_CDS_AFPO_QTY_DIST view inner 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
FINOC_RULE_ORD_BASE view left_outer Orgl Change-Rule: Order 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_ProjSchedMaintOrdOpByIntKey view_entity inner BASIC Order Operation By Internal Key
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

Fields (171)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY aufnr AUFNR Order
gltrp CO_GLTRP Basic fin. date
gstrp PM_ORDGSTRP Bas. Start Date
ftrms CO_FTRMS Release
gltrs CO_GLTRS Sched. finish
gstrs CO_GSTRS Sched. start
gstri CO_GSTRI Actual start
getri CO_GETRI Actual Finish
gltri CO_GLTRI Actual finish
ftrmi CO_FTRMI Actual release
ftrmp CO_FTRMP Planned Release
rsnum RSNUM Reservation
gasmg GASMG Total Scrap
gamng GAMNG Target Quantity
gmein MEINS Base Unit
plnbez MATNR Material
plnty PLNTY Task List Type
plnnr PLNNR Group
plnaw PLNAW Application
plnal PLNAL Group Counter
pverw PLN_VERWE Usage
plauf CO_PLAUF Explosion Date
plsvb LOSGRBIS Lot Size To
plnme PLNME Task List Unit
plsvn LOSGRVON Lot Size From
pdatv DATUV Valid From
paenr AENNR Change Number
plgrp VAGRP Planner Group
lodiv LOSDIV Lot size div.
stlty STLTY BOM category
stlbez MATNR Material
stlst STLST BOM Status
stlnr STNUM BOM
sdatv DATUV Valid From
sbmng BASMN Base quantity
sbmeh MEINS Base Unit
saenr AENNR Change Number
stlal STALT Alternative
stlan STLAN Usage
slsvn LOSVN From Lot Size
slsbs LOSBS To Lot Size
aufld CO_AUFLD BOM Expl. Date
dispo CO_DISPO MRP controller
aufpl CO_AUFPL Plan No.f.Oper.
fevor FEVOR Prodn Supervisor
fhori FHORI Margin Key
terkz TERMKZ Scheduling type
redkz REDKZ Reduction Ind.
aprio CO_APRIO Priority
ntzue NETZ_UEBER Network
vorue VORG_UEBER Superior act.
profid PROFIDNZPL Network Profile
vorgz VORGZ Float bef. prod
sichz SICHZ Float aft. prod
freiz FREIZ Release period
upter CO_UPTER Dates Changed
bedid BEDID Capacity Requirement
pronr PS_PSP_PRO Project def.
zaehl CIM_COUNT Counter
mzaehl CIM_COUNT Counter
zkriz DZKRIZ Add. Crit. Cntr
prueflos QPLOS Inspection Lot
klvarp KALKVARPLN Plnd Costing Variant
klvari KALKVARIST Act. Costing Variant
rgekz CO_RGEKZ Backflushing
plart PS_PLART Sched. basis
flg_aob FLG_AOB Ind:Relshp.data
flg_arbei FLG_ARBEI Ind. work
gltpp CO_GLTPP Finish date
gstpp CO_GSTPP Start date
gltps CO_GLTPS Finish date
gstps CO_GSTPS Start date
ftrps CO_FTRPS Release
rdkzp REDKZP Reduction ind.
trkzp TERMKZP Sched. type for
rueck CO_RUECK Confirmation
rmzhl CIM_COUNT Counter
igmng CO_IGMNG Confirmed Yield
ratid RATID Rate ID
groid GROID Rough sched. ID
cuobj CUOBJ Int. object no.
gluzs CO_GLUZS Finish time
gsuzs CO_GSUZS SchedStartTime
revlv REVLV Revision Level
rshty CR_OBJTY Object Type
rshid CR_OBJID Object ID
rsnty CR_OBJTY Object Type
rsnid CR_OBJID Object ID
nauterm CO_NAUTERM No auto. cost.
naucost CO_NAUCOST NoAutomatCost
stufe HISTU Level
wegxx WEGXX Path
vwegx WEGXX Path
arsnr RSNUM Reservation
arsps CO_POSNR Item Number
maufnr MAUFNR Superior Order
lknot CO_LKNOT Left node
rknot CO_RKNOT Right node
prodnet CO_PRODNET Collective Order
iasmg CO_IASMG Confirmed Scrap
abarb CO_ABARB Processing %
aufnt CO_TEILNET Subnetwork of
aufpt CO_AUFPL Plan No.f.Oper.
aplzt CO_APLZL Counter
no_disp NO_DISP_PLUS Eff. mat. plng
csplit CSPLIT Apportionment
aennr AENNR Change Number
cy_seqnr CY_SEQNR Sequence Number
breaks BREAKS Exact breaks
vorgz_trm VORGZ_TRM Float bef. prod
sichz_trm SICHZ_TRM Flt after prod.
trmdt TRMDT Scheduled on
gluzp CO_GLUZP Basic Fin. Time
gsuzp CO_GSUZP Start time
gsuzi CO_GSUZI ActualStart
geuzi CO_GEUZI Actual Finish
glupp CO_GLUPP Finish time
gsupp CO_GSUPP Start time
glups CO_GLUPS Finish time
gsups CO_GSUPS Sched. start
chsch KALSMA_CH Search Proced.
kapt_vorgz KAPT_VORGZ RemPreProdFloat
kapt_sichz KAPT_SICHZ Remaining float
lead_aufnr CO_LAUFNR Leading Order
pnetstartd CO_PSTARTD Start
pnetstartt CO_PSTARTT Start
pnetendd CO_PENDD Finish
pnetendt CO_PENDT Finish
kbed KBED_D No Cap. Reqmts.
kkalkr COMP_CALC CostCompInd
sfcpf CO_PRODPRF Prod. Sched. Profile
rmnga RMNGA Confirmed Rework
gsbtr CO_GSBTR Commitment Date
vfmng CO_VFMNG Committed
nopcost CO_NOPCOST No planned costs
netzkont NETZKONT Account assgnt
atrkz ATRKZ Request ID
objtype OCM_OBJ_TYPE ChangeInd
ch_proc OCM_CH_PROC ChangeProcType
kapversa KAPVERSA Version
colordproc CO_COLORDPRC CO processing
kzerb PS_KZERB Proj. summ. MastDa
conf_key CC_CONF_KEY Identical obj.
st_arbid OBJEKTID Object ID
vsnmr_v VSNMR_V Version
terhw TERHW Sched. note
splstat SPLIT_STAT Split Status
costupd CN_COSTUPD Update costs
max_gamng CO_MES_MAX_GAMNG Maximum Qty
mes_routingid CO_MES_INT_ROUTINGID MES Routing
tl_versn PLNVERSN Routing Version
bom_versn CS_VERSN BOM Version
flexible_processing MPE_FLEXIBLE_PROCESSING Flexible
extended_quality_checks MPE_EXTENDED_QUALITY_CHECKS EQC Relevant Order
adpsp ADCOMPARE PM/PS Ref. Element
rmanr VBELN SD Document
posnr_rma POSNR Item
posnv_rma POSNR Item
cfb_maxlz MAXLZ Max. Storage
cfb_lzeih LZEIH Time unit
cfb_adtdays CFB_ADTDAYS Additional Days
cfb_datofm CFB_DATOFM Date of Manuf.
cfb_bbdpi CFB_BBD_PPPI BBD/SLED
oihantyp OIH_HANTYP Handling Type
fsh_mprod_ord FSH_MPROD_ORD Master Prod. Ord.
flg_bundle FLG_BUNDLE Bundle
mill_ratio MILL_RATIO Adjustmt factor
bmeins MEINS Base Unit
bmenge BASMN Base quantity
mill_oc_zuskz MILL_OC_ZUSKZ Combination Ind.

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]
    GLTRP,                    -- Basic fin. date [CO_GLTRP]
    GSTRP,                    -- Bas. Start Date [PM_ORDGSTRP]
    FTRMS,                    -- Release [CO_FTRMS]
    GLTRS,                    -- Sched. finish [CO_GLTRS]
    GSTRS,                    -- Sched. start [CO_GSTRS]
    GSTRI,                    -- Actual start [CO_GSTRI]
    GETRI,                    -- Actual Finish [CO_GETRI]
    GLTRI,                    -- Actual finish [CO_GLTRI]
    FTRMI,                    -- Actual release [CO_FTRMI]
    FTRMP,                    -- Planned Release [CO_FTRMP]
    RSNUM,                    -- Reservation [RSNUM]
    GASMG,                    -- Total Scrap [GASMG]
    GAMNG,                    -- Target Quantity [GAMNG]
    GMEIN,                    -- Base Unit [MEINS]
    PLNBEZ,                   -- Material [MATNR]
    PLNTY,                    -- Task List Type [PLNTY]
    PLNNR,                    -- Group [PLNNR]
    PLNAW,                    -- Application [PLNAW]
    PLNAL,                    -- Group Counter [PLNAL]
    PVERW,                    -- Usage [PLN_VERWE]
    PLAUF,                    -- Explosion Date [CO_PLAUF]
    PLSVB,                    -- Lot Size To [LOSGRBIS]
    PLNME,                    -- Task List Unit [PLNME]
    PLSVN,                    -- Lot Size From [LOSGRVON]
    PDATV,                    -- Valid From [DATUV]
    PAENR,                    -- Change Number [AENNR]
    PLGRP,                    -- Planner Group [VAGRP]
    LODIV,                    -- Lot size div. [LOSDIV]
    STLTY,                    -- BOM category [STLTY]
    STLBEZ,                   -- Material [MATNR]
    STLST,                    -- BOM Status [STLST]
    STLNR,                    -- BOM [STNUM]
    SDATV,                    -- Valid From [DATUV]
    SBMNG,                    -- Base quantity [BASMN]
    SBMEH,                    -- Base Unit [MEINS]
    SAENR,                    -- Change Number [AENNR]
    STLAL,                    -- Alternative [STALT]
    STLAN,                    -- Usage [STLAN]
    SLSVN,                    -- From Lot Size [LOSVN]
    SLSBS,                    -- To Lot Size [LOSBS]
    AUFLD,                    -- BOM Expl. Date [CO_AUFLD]
    DISPO,                    -- MRP controller [CO_DISPO]
    AUFPL,                    -- Plan No.f.Oper. [CO_AUFPL]
    FEVOR,                    -- Prodn Supervisor [FEVOR]
    FHORI,                    -- Margin Key [FHORI]
    TERKZ,                    -- Scheduling type [TERMKZ]
    REDKZ,                    -- Reduction Ind. [REDKZ]
    APRIO,                    -- Priority [CO_APRIO]
    NTZUE,                    -- Network [NETZ_UEBER]
    VORUE,                    -- Superior act. [VORG_UEBER]
    PROFID,                   -- Network Profile [PROFIDNZPL]
    VORGZ,                    -- Float bef. prod [VORGZ]
    SICHZ,                    -- Float aft. prod [SICHZ]
    FREIZ,                    -- Release period [FREIZ]
    UPTER,                    -- Dates Changed [CO_UPTER]
    BEDID,                    -- Capacity Requirement [BEDID]
    PRONR,                    -- Project def. [PS_PSP_PRO]
    ZAEHL,                    -- Counter [CIM_COUNT]
    MZAEHL,                   -- Counter [CIM_COUNT]
    ZKRIZ,                    -- Add. Crit. Cntr [DZKRIZ]
    PRUEFLOS,                 -- Inspection Lot [QPLOS]
    KLVARP,                   -- Plnd Costing Variant [KALKVARPLN]
    KLVARI,                   -- Act. Costing Variant [KALKVARIST]
    RGEKZ,                    -- Backflushing [CO_RGEKZ]
    PLART,                    -- Sched. basis [PS_PLART]
    FLG_AOB,                  -- Ind:Relshp.data [FLG_AOB]
    FLG_ARBEI,                -- Ind. work [FLG_ARBEI]
    GLTPP,                    -- Finish date [CO_GLTPP]
    GSTPP,                    -- Start date [CO_GSTPP]
    GLTPS,                    -- Finish date [CO_GLTPS]
    GSTPS,                    -- Start date [CO_GSTPS]
    FTRPS,                    -- Release [CO_FTRPS]
    RDKZP,                    -- Reduction ind. [REDKZP]
    TRKZP,                    -- Sched. type for [TERMKZP]
    RUECK,                    -- Confirmation [CO_RUECK]
    RMZHL,                    -- Counter [CIM_COUNT]
    IGMNG,                    -- Confirmed Yield [CO_IGMNG]
    RATID,                    -- Rate ID [RATID]
    GROID,                    -- Rough sched. ID [GROID]
    CUOBJ,                    -- Int. object no. [CUOBJ]
    GLUZS,                    -- Finish time [CO_GLUZS]
    GSUZS,                    -- SchedStartTime [CO_GSUZS]
    REVLV,                    -- Revision Level [REVLV]
    RSHTY,                    -- Object Type [CR_OBJTY]
    RSHID,                    -- Object ID [CR_OBJID]
    RSNTY,                    -- Object Type [CR_OBJTY]
    RSNID,                    -- Object ID [CR_OBJID]
    NAUTERM,                  -- No auto. cost. [CO_NAUTERM]
    NAUCOST,                  -- NoAutomatCost [CO_NAUCOST]
    STUFE,                    -- Level [HISTU]
    WEGXX,                    -- Path [WEGXX]
    VWEGX,                    -- Path [WEGXX]
    ARSNR,                    -- Reservation [RSNUM]
    ARSPS,                    -- Item Number [CO_POSNR]
    MAUFNR,                   -- Superior Order [MAUFNR]
    LKNOT,                    -- Left node [CO_LKNOT]
    RKNOT,                    -- Right node [CO_RKNOT]
    PRODNET,                  -- Collective Order [CO_PRODNET]
    IASMG,                    -- Confirmed Scrap [CO_IASMG]
    ABARB,                    -- Processing % [CO_ABARB]
    AUFNT,                    -- Subnetwork of [CO_TEILNET]
    AUFPT,                    -- Plan No.f.Oper. [CO_AUFPL]
    APLZT,                    -- Counter [CO_APLZL]
    NO_DISP,                  -- Eff. mat. plng [NO_DISP_PLUS]
    CSPLIT,                   -- Apportionment [CSPLIT]
    AENNR,                    -- Change Number [AENNR]
    CY_SEQNR,                 -- Sequence Number [CY_SEQNR]
    BREAKS,                   -- Exact breaks [BREAKS]
    VORGZ_TRM,                -- Float bef. prod [VORGZ_TRM]
    SICHZ_TRM,                -- Flt after prod. [SICHZ_TRM]
    TRMDT,                    -- Scheduled on [TRMDT]
    GLUZP,                    -- Basic Fin. Time [CO_GLUZP]
    GSUZP,                    -- Start time [CO_GSUZP]
    GSUZI,                    -- ActualStart [CO_GSUZI]
    GEUZI,                    -- Actual Finish [CO_GEUZI]
    GLUPP,                    -- Finish time [CO_GLUPP]
    GSUPP,                    -- Start time [CO_GSUPP]
    GLUPS,                    -- Finish time [CO_GLUPS]
    GSUPS,                    -- Sched. start [CO_GSUPS]
    CHSCH,                    -- Search Proced. [KALSMA_CH]
    KAPT_VORGZ,               -- RemPreProdFloat [KAPT_VORGZ]
    KAPT_SICHZ,               -- Remaining float [KAPT_SICHZ]
    LEAD_AUFNR,               -- Leading Order [CO_LAUFNR]
    PNETSTARTD,               -- Start [CO_PSTARTD]
    PNETSTARTT,               -- Start [CO_PSTARTT]
    PNETENDD,                 -- Finish [CO_PENDD]
    PNETENDT,                 -- Finish [CO_PENDT]
    KBED,                     -- No Cap. Reqmts. [KBED_D]
    KKALKR,                   -- CostCompInd [COMP_CALC]
    SFCPF,                    -- Prod. Sched. Profile [CO_PRODPRF]
    RMNGA,                    -- Confirmed Rework [RMNGA]
    GSBTR,                    -- Commitment Date [CO_GSBTR]
    VFMNG,                    -- Committed [CO_VFMNG]
    NOPCOST,                  -- No planned costs [CO_NOPCOST]
    NETZKONT,                 -- Account assgnt [NETZKONT]
    ATRKZ,                    -- Request ID [ATRKZ]
    OBJTYPE,                  -- ChangeInd [OCM_OBJ_TYPE]
    CH_PROC,                  -- ChangeProcType [OCM_CH_PROC]
    KAPVERSA,                 -- Version [KAPVERSA]
    COLORDPROC,               -- CO processing [CO_COLORDPRC]
    KZERB,                    -- Proj. summ. MastDa [PS_KZERB]
    CONF_KEY,                 -- Identical obj. [CC_CONF_KEY]
    ST_ARBID,                 -- Object ID [OBJEKTID]
    VSNMR_V,                  -- Version [VSNMR_V]
    TERHW,                    -- Sched. note [TERHW]
    SPLSTAT,                  -- Split Status [SPLIT_STAT]
    COSTUPD,                  -- Update costs [CN_COSTUPD]
    MAX_GAMNG,                -- Maximum Qty [CO_MES_MAX_GAMNG]
    MES_ROUTINGID,            -- MES Routing [CO_MES_INT_ROUTINGID]
    TL_VERSN,                 -- Routing Version [PLNVERSN]
    BOM_VERSN,                -- BOM Version [CS_VERSN]
    FLEXIBLE_PROCESSING,      -- Flexible [MPE_FLEXIBLE_PROCESSING]
    EXTENDED_QUALITY_CHECKS,  -- EQC Relevant Order [MPE_EXTENDED_QUALITY_CHECKS]
    ADPSP,                    -- PM/PS Ref. Element [ADCOMPARE]
    RMANR,                    -- SD Document [VBELN]
    POSNR_RMA,                -- Item [POSNR]
    POSNV_RMA,                -- Item [POSNR]
    CFB_MAXLZ,                -- Max. Storage [MAXLZ]
    CFB_LZEIH,                -- Time unit [LZEIH]
    CFB_ADTDAYS,              -- Additional Days [CFB_ADTDAYS]
    CFB_DATOFM,               -- Date of Manuf. [CFB_DATOFM]
    CFB_BBDPI,                -- BBD/SLED [CFB_BBD_PPPI]
    OIHANTYP,                 -- Handling Type [OIH_HANTYP]
    FSH_MPROD_ORD,            -- Master Prod. Ord. [FSH_MPROD_ORD]
    FLG_BUNDLE,               -- Bundle [FLG_BUNDLE]
    MILL_RATIO,               -- Adjustmt factor [MILL_RATIO]
    BMEINS,                   -- Base Unit [MEINS]
    BMENGE,                   -- Base quantity [BASMN]
    MILL_OC_ZUSKZ,            -- Combination Ind. [MILL_OC_ZUSKZ]
    PRIMARY KEY (MANDT, AUFNR)
);

Learn More