AFVC
Operation within an order
AFVC is an SAP database table in S/4HANA. Operation within an order. It contains 207 fields. 42 CDS views read from this table.
CDS Views using this table (42)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| CTE_CDS_FIN_MON_NA | view | inner | CDS View for Monotoring NA exp to Concur | |
| E_InspectionOperation | view | inner | EXTENSION | Inspection Operation Extension |
| E_MaintenanceOrderOperation | view | from | EXTENSION | Maintenance Order Operation - Extension |
| E_NetworkActivity | view | from | EXTENSION | Network Activity - Extension Include View |
| FCO_COR_HSL_DER | view | left_outer | HSL Corr. for Stat. Records in CO: Derivation of CurrKey | |
| FCO_MIG_DERIV_P | view | left_outer | CO Delta Entries (COSP+COSS) - Derivation of Dep. Fields | |
| fco_mig_nplnr | view | inner | Network number from routing number | |
| FINOC_RULE_NWA_BASE | view | from | O/C Rule: Network Activity Base | |
| fins_prctr_of_object_acdoca | view | left_outer | Derive PRCTR & PPRCTR for ACDOCA object | |
| I_InspectionOperation | view | inner | BASIC | Inspection Operation |
| I_JVANetworkActivity | view_entity | from | BASIC | JVA Network Activity |
| I_MaintenanceOrderOperation | view | from | BASIC | Maintenance Order Operation |
| I_MaintenanceOrderSubOperation | view | from | BASIC | Maintenance Order Sub-Operation |
| I_MaintenanceOrderSubOperation | view | inner | BASIC | Maintenance Order Sub-Operation |
| I_MaintOrderOpAndSubOp_2 | view | from | BASIC | Maintenance Order Operation and Suboperation |
| I_MaintOrderOperAndSubOper | view | from | BASIC | Maintenance Order Operation and Suboperation |
| I_MaintOrderOpProdnRsceTool | view | inner | BASIC | Maintenance Order Operation PRT |
| I_MaintOrdOpInternalID | view | inner | BASIC | Maintenance Order Operation internal key |
| I_NetworkActivity | view | from | BASIC | Network Activity Details |
| I_NetworkActivity | view | left_outer | BASIC | Network Activity Details |
| I_NetworkActivityByInternalKey | view | from | BASIC | Network Activity Information By Internal Key |
| I_NetworkActivityForCostReport | view | from | BASIC | Network Activity For Cost Report |
| I_NetworkRouting | view_entity | inner | COMPOSITE | Network and Routing relation |
| I_NtwkActyForProjSchedHier | view | from | BASIC | Network Activity Information |
| I_OdOp | view | from | BASIC | Operation within an order |
| I_OrderOperationBasic | view | from | BASIC | Order Operation Basic |
| I_OrderOperationWithCrcy | view | from | BASIC | Order Operation With Currency |
| I_ProcessOrderOperation | view | from | BASIC | Interface View for Process Order Operation |
| I_ProcOrdOpsMgmtInspLotsBasic | view | inner | BASIC | Process order ops inspection lots basic |
| I_ProductionOrderOperation | view | from | BASIC | Interface View for Production Order Operation |
| I_ProjSchedMaintOrdOpByIntKey | view_entity | from | BASIC | Order Operation By Internal Key |
| I_Qm_FilterBar_OperationGroup | view | inner | BASIC | RR Filter Bar Inspection Operation Group |
| I_RSHOperationAssignment | view | inner | BASIC | Maintenance Order Operation Assignment |
| MPEV_OAI_FOR_AUFNR | view | inner | Network Instances for Orders | |
| N_OrderOperation | view | from | Order Operation Aux | |
| P_InspOPInterval | view | inner | BASIC | |
| P_MaintenanceOrderConfirmation | view | left_outer | BASIC | Maintenance Order Confirmation |
| P_ONRNV1 | view | from | BASIC | |
| P_ProcOrdOpsInspLot | view | inner | BASIC | |
| R_RSHPersonAssignmentTP | view_entity | inner | TRANSACTIONAL | Maint Order Op assigned to Person TP |
| V_SFIAtOpActyMissingStatus | view | inner | ||
| vfco_dll_co88_with_op_l1 | view | inner |
Fields (207)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | aufpl | CO_AUFPL | Plan No.f.Oper. | |||
| KEY | aplzl | CO_APLZL | Counter | |||
| plnfl | PLNFOLGE | Sequence | ||||
| plnkn | PLNKN | Node | ||||
| plnal | PLNAL | Group Counter | ||||
| plnty | PLNTY | Task List Type | ||||
| vintv | VINTV | Op. increment | ||||
| plnnr | PLNNR | Group | ||||
| zaehl | CIM_COUNT | Counter | ||||
| vornr | VORNR | Activity | ||||
| steus | STEUS | Control Key | ||||
| arbid | CR_OBJID | Object ID | ||||
| pdest | CR_PDEST | Printer | ||||
| werks | WERKS_D | Plant | ||||
| ktsch | KTSCH_CHG | Std Text Key | ||||
| ltxa1 | LTXA1 | Op. Short Text | ||||
| ltxa2 | LTXA2 | Description | ||||
| txtsp | SPRAS | Language | ||||
| vplty | VPLNTY | Ref TList type | ||||
| vplnr | VPLNNR | Ref. group | ||||
| vplal | VPLNAL | Ref. group cntr | ||||
| vplfl | VPLBFL | Ref. sequence | ||||
| vgwts | VORGSCHL | Std Value Key | ||||
| lar01 | LSTAR | Activity Type | ||||
| lar02 | LSTAR | Activity Type | ||||
| lar03 | LSTAR | Activity Type | ||||
| lar04 | LSTAR | Activity Type | ||||
| lar05 | LSTAR | Activity Type | ||||
| lar06 | LSTAR | Activity Type | ||||
| zerma | DZERMA | SV Determ. Type | ||||
| zgdat | DZGDAT | Std.val.date | ||||
| zcode | DZCODE | Std value code | ||||
| zulnr | DZULNR | BasisStdValCalc | ||||
| loanz | LOHNANZ | No.TimeTickets | ||||
| loart | LOHNART | Wage type | ||||
| rsanz | CR_RS_ANZ | No. of Conf. Slips | ||||
| qualf | QUALF | Suitability | ||||
| anzma | ANZMS | No. employees | ||||
| rfgrp | RUEFAGRP | Setup group cat | ||||
| rfsch | RUEFASCHLU | Setup group key | ||||
| rasch | RUEARSCHLU | Setup Type Key | ||||
| aufak | AUSCHUFAK | Scrap | ||||
| logrp | LOHNGRP | Wage Group | ||||
| uemus | UEMUSKZ | Req.Overlapping | ||||
| uekan | UEKANKZ | Opt.Overlapping | ||||
| flies | FLIESSKZ | Flow Manufact. | ||||
| spmus | SPLITTUNG | Splitting Reqd | ||||
| splim | SPLITTANZ | No. of Splits | ||||
| ablipkz | ABLIPKZ | Teardown/Wait Par. | ||||
| rstra | RSTRA | Red. Strategy | ||||
| sumnr | SUMKNTNR | Sup. Op. Node | ||||
| sortl | SORTI | Sort Term | ||||
| lifnr | LIFNR | Supplier | ||||
| preis | PREIS | Price | ||||
| peinh | PEINH | Price unit | ||||
| sakto | KSTAR | Cost Element | ||||
| waers | WAERS | Currency | ||||
| infnr | INFNR | Info Record | ||||
| esokz | ESOKZ | Infotype | ||||
| ekorg | EKORG | Purchasing Org. | ||||
| ekgrp | VG_EKGRP | Purch. Group | ||||
| kzlgf | KZLGF | LSI Ext. Proc. | ||||
| kzwrtf | KZWRTF | Fixed price | ||||
| matkl | MATKL | Material Group | ||||
| ddehn | DAUDEHN | Flex. duration | ||||
| anzzl | ANZKAP | Number | ||||
| prznt | APROZENT | Percent | ||||
| mlstn | MILESTONE | Usage | ||||
| pprio | PRIORITAET | Priority | ||||
| bukrs | BUKRS | Company Code | ||||
| anfko | ANFKO | Rqstg Cost Cntr | ||||
| anfkokrs | ANFKOKRS | Controll. Area | ||||
| indet | INDET | Calculation key | ||||
| larnt | LSTAR | Activity Type | ||||
| prkst | PRKST | Amount | ||||
| aplfl | PLNFOLGE | Sequence | ||||
| rueck | CO_RUECK | Confirmation | ||||
| rmzhl | CO_RMZHL | Counter | ||||
| projn | PS_PSP_ELE | WBS Element | ||||
| objnr | J_OBJNR | Object number | ||||
| spanz | SPLITTERM | No. of splits | ||||
| bedid | BEDID | Capacity Requirement | ||||
| bedzl | CIM_COUNT | Counter | ||||
| banfn | CO_BANFN | Requisition | ||||
| bnfpo | CO_BNFPO | Requisition Itm | ||||
| lek01 | CO_LEIKZ | No Remain. Act. | ||||
| lek02 | CO_LEIKZ | No Remain. Act. | ||||
| lek03 | CO_LEIKZ | No Remain. Act. | ||||
| lek04 | CO_LEIKZ | No Remain. Act. | ||||
| lek05 | CO_LEIKZ | No Remain. Act. | ||||
| lek06 | CO_LEIKZ | No Remain. Act. | ||||
| selkz | CO_SELKZ | Cost | ||||
| kalid | WFCID | Factory Cal. ID | ||||
| frsp | FRSP | Early/Late | ||||
| stdkn | STDKN | Nodes | ||||
| anlzu | ANLZU | SystemCondition | ||||
| istru | ISTRU | Assembly | ||||
| istty | STLTY | BOM category | ||||
| istnr | STNUM | BOM | ||||
| istkn | STLKN | Item node | ||||
| istpo | CIM_COUNT | Counter | ||||
| iupoz | UPOSZ | Subitem | ||||
| ebort | EBORT | Install. Point | ||||
| vertl | CR_VERTN | Int. dist. key | ||||
| leknw | LEKNW | No Remain. Work | ||||
| nprio | NW_PRIO | Priority | ||||
| pvzkn | CO_APLZL | Counter | ||||
| phflg | PHFLG | Ind.: Phase | ||||
| phseq | PHSEQ | CtrlRec.Destin. | ||||
| knobj | KNOBJ | Assgmt no. | ||||
| erfsicht | QERFSICHT | Recording View | ||||
| qppktabs | QPPKTABS | InspPtComplete | ||||
| otype | OTYPE | Object type | ||||
| objektid | OBJEKTID | Object ID | ||||
| qlkapar | QL_KAPART | Capacity cat. | ||||
| rstuf | RSTUF | Reduction Level | ||||
| nptxtky | TXTKY | Text number | ||||
| subsys | QEIFSUBSYS | QDR System | ||||
| pspnr | PS_SPS_ELE | Std.WBS element | ||||
| packno | PACKNO | Package number | ||||
| txjcd | TXJCD | Tax Jur. | ||||
| scope | SCOPE_CV | Object Class | ||||
| gsber | GSBER | Business Area | ||||
| prctr | PRCTR | Profit Center | ||||
| no_disp | NO_DISP_PLUS | Eff. mat. plng | ||||
| qkzprzeit | QKZPRZEIT | Time-related | ||||
| qkzztmg1 | QKZZTMG1 | Quan. pt. lot | ||||
| qkzprmeng | QKZPRMENG | Qty-related | ||||
| qkzprfrei | QKZPRFREI | No Reference | ||||
| kzfeat | QKZFEAT | Indicator Is Not Used Currently | ||||
| qkztlsbest | QKZTLSBEST | Last part. lot | ||||
| aennr | AENNR | Change Number | ||||
| cuobj_arb | CUOBJ | Int. object no. | ||||
| evgew | EV_WEIGHTD | POC weight | ||||
| arbii | CR_OBJID_I | Object ID | ||||
| werki | WERKS_I | Plant | ||||
| cy_seqnrv | CY_SEQNRV | Sequence number | ||||
| kapt_puffr | KAPT_PUFFR | Operation floats after finite scheduling (in seconds) | ||||
| ebeln | EBELN | Purchasing Doc. | ||||
| ebelp | EBELP | Item | ||||
| wempf | WEMPF | Recipient | ||||
| ablad | ABLAD | Unloading Point | ||||
| clasf | CLASF | Summarization | ||||
| frunv | FRUNV | Ext.dat.incompl | ||||
| zschl | AUFZSCHL | Overhead key | ||||
| kalsm | AUFKALSM | Costing Sheet | ||||
| sched_end | SCEND_ACT | Purch.Req. fin. | ||||
| netzkont | NETZKONT | Account assgnt | ||||
| owaer | OWAERS | Object crcy | ||||
| afnam | AFNAM | Requisitioner | ||||
| bednr | BEDNR | Tracking Number | ||||
| kzfix | CN_KZFIX | Price_fixed | ||||
| pernr | CO_PERNR | Personnel no. | ||||
| frdlb | CO_FRDLB | Subcontracting | ||||
| qpart | QPART | Inspection Type | ||||
| loekz | AUFLOEKZ | Deletion Flag | ||||
| wkurs | WKURS | Exchange Rate | ||||
| prod_act | PROD_ACT | Production activ. | ||||
| fplnr | FPLNR | Bill. Plan No. | ||||
| objtype | OCM_OBJ_TYPE | ChangeInd | ||||
| ch_proc | OCM_CH_PROC | ChangeProcType | ||||
| klvar | CK_KLVAR | Costing Variant | ||||
| kalnr | CK_KALNR | Cost EstimateNo | ||||
| fordn | SFORDN | Framework Order | ||||
| fordp | FORDP | Frwrk. ord. item | ||||
| mat_prkst | MAT_PRKST_CHG | Mat.planning | ||||
| prz01 | CO_PRZNR | Business Process | ||||
| rfpnt | CN_RFPNT | Reference point | ||||
| func_area | FKBER | Functional Area | ||||
| techs | TECHS | StandardVariant | ||||
| adpsp | ADDCOMPARE_CORE | Ref. Element PM/PS | ||||
| rfippnt | CN_RPIP | Reference Point | ||||
| mes_operid | CO_MES_INT_OPERID | MES Operation | ||||
| mes_stepid | CO_MES_INT_STEPID | Step ID | ||||
| oan_inst_id_setup | MPE_OAN_INSTANCE_ID | Instance ID | ||||
| oan_inst_id_produce | MPE_OAN_INSTANCE_ID | Instance ID | ||||
| oan_inst_id_teardown | MPE_OAN_INSTANCE_ID | Instance ID | ||||
| tl_versn | PLNVERSN | Routing Version | ||||
| versn_track_guid | CP_GUID | Guid | ||||
| set_versn_track_guid | CP_GUID | Guid | ||||
| maintordopprocessphasecode | EAM_OSTAT_PHASE | Process Phase | ||||
| maintordopprocesssubphasecode | EAM_OSTAT_SPHASE | Process Subphase | ||||
| cl_type | EAM_CL_TYPE | Checklist Type | ||||
| allmaintordcompcmtdqtsarekept | ALLMAINTORDCOMPCMTDQTSAREKEPT | Keep Committed Qties | ||||
| dummy_eam_afvc_incl_eew_ps | CFD_DUMMY | Dummy | ||||
| dummy_afvc_incl_eew_ps | DUMMY | Dummy function in length 1 | ||||
| afvc_status | ACTCMB_DELE | Status Comb | ||||
| adrnr | CADNR | Address number | ||||
| adrn2 | AD_ADDRNUM | Address Number | ||||
| kunn2 | QKUNUM | Customer | ||||
| ind_adr | XFELD | Checkbox | ||||
| fldlogsdelivisheldonshore | FLOG_HOLD | Hold On-Shore | ||||
| svobj_id | SVOBJ_ID | Service obj. ID | ||||
| svobj | SVOBJ | Service object | ||||
| kennz_incl | KENNZ_INCL | Copy task list | ||||
| mill_oc_aufnr_mo | MILL_OC_AUFNR_MO | Combined Order | ||||
| ps_adrnr | CADNR | Address number | ||||
| ps_adrn2 | AD_ADDRNUM | Address Number | ||||
| ps_kunnr | EKUNNR | Customer | ||||
| ps_emlif | EMLIF | Supplier | ||||
| wty_ind | WTYSC_WTY_INDICATOR | Warranty | ||||
| tplnr | TPLNR | Functional loc. | ||||
| equnr | EQUNR | Equipment | ||||
| maintopexecutionphasecode | EAM_PREMAINPOST | Execution Stage | ||||
| maintordophasleanservices | EAM_OPERATION_HAS_SERVICE | operation has srv | ||||
| cpd_updat | /CPD/PFP_SC_TSTMP | Time Stamp |
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.
-- Operation within an order
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFVC (
MANDT, -- Client [MANDT]
AUFPL, -- Plan No.f.Oper. [CO_AUFPL]
APLZL, -- Counter [CO_APLZL]
PLNFL, -- Sequence [PLNFOLGE]
PLNKN, -- Node [PLNKN]
PLNAL, -- Group Counter [PLNAL]
PLNTY, -- Task List Type [PLNTY]
VINTV, -- Op. increment [VINTV]
PLNNR, -- Group [PLNNR]
ZAEHL, -- Counter [CIM_COUNT]
VORNR, -- Activity [VORNR]
STEUS, -- Control Key [STEUS]
ARBID, -- Object ID [CR_OBJID]
PDEST, -- Printer [CR_PDEST]
WERKS, -- Plant [WERKS_D]
KTSCH, -- Std Text Key [KTSCH_CHG]
LTXA1, -- Op. Short Text [LTXA1]
LTXA2, -- Description [LTXA2]
TXTSP, -- Language [SPRAS]
VPLTY, -- Ref TList type [VPLNTY]
VPLNR, -- Ref. group [VPLNNR]
VPLAL, -- Ref. group cntr [VPLNAL]
VPLFL, -- Ref. sequence [VPLBFL]
VGWTS, -- Std Value Key [VORGSCHL]
LAR01, -- Activity Type [LSTAR]
LAR02, -- Activity Type [LSTAR]
LAR03, -- Activity Type [LSTAR]
LAR04, -- Activity Type [LSTAR]
LAR05, -- Activity Type [LSTAR]
LAR06, -- Activity Type [LSTAR]
ZERMA, -- SV Determ. Type [DZERMA]
ZGDAT, -- Std.val.date [DZGDAT]
ZCODE, -- Std value code [DZCODE]
ZULNR, -- BasisStdValCalc [DZULNR]
LOANZ, -- No.TimeTickets [LOHNANZ]
LOART, -- Wage type [LOHNART]
RSANZ, -- No. of Conf. Slips [CR_RS_ANZ]
QUALF, -- Suitability [QUALF]
ANZMA, -- No. employees [ANZMS]
RFGRP, -- Setup group cat [RUEFAGRP]
RFSCH, -- Setup group key [RUEFASCHLU]
RASCH, -- Setup Type Key [RUEARSCHLU]
AUFAK, -- Scrap [AUSCHUFAK]
LOGRP, -- Wage Group [LOHNGRP]
UEMUS, -- Req.Overlapping [UEMUSKZ]
UEKAN, -- Opt.Overlapping [UEKANKZ]
FLIES, -- Flow Manufact. [FLIESSKZ]
SPMUS, -- Splitting Reqd [SPLITTUNG]
SPLIM, -- No. of Splits [SPLITTANZ]
ABLIPKZ, -- Teardown/Wait Par. [ABLIPKZ]
RSTRA, -- Red. Strategy [RSTRA]
SUMNR, -- Sup. Op. Node [SUMKNTNR]
SORTL, -- Sort Term [SORTI]
LIFNR, -- Supplier [LIFNR]
PREIS, -- Price [PREIS]
PEINH, -- Price unit [PEINH]
SAKTO, -- Cost Element [KSTAR]
WAERS, -- Currency [WAERS]
INFNR, -- Info Record [INFNR]
ESOKZ, -- Infotype [ESOKZ]
EKORG, -- Purchasing Org. [EKORG]
EKGRP, -- Purch. Group [VG_EKGRP]
KZLGF, -- LSI Ext. Proc. [KZLGF]
KZWRTF, -- Fixed price [KZWRTF]
MATKL, -- Material Group [MATKL]
DDEHN, -- Flex. duration [DAUDEHN]
ANZZL, -- Number [ANZKAP]
PRZNT, -- Percent [APROZENT]
MLSTN, -- Usage [MILESTONE]
PPRIO, -- Priority [PRIORITAET]
BUKRS, -- Company Code [BUKRS]
ANFKO, -- Rqstg Cost Cntr [ANFKO]
ANFKOKRS, -- Controll. Area [ANFKOKRS]
INDET, -- Calculation key [INDET]
LARNT, -- Activity Type [LSTAR]
PRKST, -- Amount [PRKST]
APLFL, -- Sequence [PLNFOLGE]
RUECK, -- Confirmation [CO_RUECK]
RMZHL, -- Counter [CO_RMZHL]
PROJN, -- WBS Element [PS_PSP_ELE]
OBJNR, -- Object number [J_OBJNR]
SPANZ, -- No. of splits [SPLITTERM]
BEDID, -- Capacity Requirement [BEDID]
BEDZL, -- Counter [CIM_COUNT]
BANFN, -- Requisition [CO_BANFN]
BNFPO, -- Requisition Itm [CO_BNFPO]
LEK01, -- No Remain. Act. [CO_LEIKZ]
LEK02, -- No Remain. Act. [CO_LEIKZ]
LEK03, -- No Remain. Act. [CO_LEIKZ]
LEK04, -- No Remain. Act. [CO_LEIKZ]
LEK05, -- No Remain. Act. [CO_LEIKZ]
LEK06, -- No Remain. Act. [CO_LEIKZ]
SELKZ, -- Cost [CO_SELKZ]
KALID, -- Factory Cal. ID [WFCID]
FRSP, -- Early/Late [FRSP]
STDKN, -- Nodes [STDKN]
ANLZU, -- SystemCondition [ANLZU]
ISTRU, -- Assembly [ISTRU]
ISTTY, -- BOM category [STLTY]
ISTNR, -- BOM [STNUM]
ISTKN, -- Item node [STLKN]
ISTPO, -- Counter [CIM_COUNT]
IUPOZ, -- Subitem [UPOSZ]
EBORT, -- Install. Point [EBORT]
VERTL, -- Int. dist. key [CR_VERTN]
LEKNW, -- No Remain. Work [LEKNW]
NPRIO, -- Priority [NW_PRIO]
PVZKN, -- Counter [CO_APLZL]
PHFLG, -- Ind.: Phase [PHFLG]
PHSEQ, -- CtrlRec.Destin. [PHSEQ]
KNOBJ, -- Assgmt no. [KNOBJ]
ERFSICHT, -- Recording View [QERFSICHT]
QPPKTABS, -- InspPtComplete [QPPKTABS]
OTYPE, -- Object type [OTYPE]
OBJEKTID, -- Object ID [OBJEKTID]
QLKAPAR, -- Capacity cat. [QL_KAPART]
RSTUF, -- Reduction Level [RSTUF]
NPTXTKY, -- Text number [TXTKY]
SUBSYS, -- QDR System [QEIFSUBSYS]
PSPNR, -- Std.WBS element [PS_SPS_ELE]
PACKNO, -- Package number [PACKNO]
TXJCD, -- Tax Jur. [TXJCD]
SCOPE, -- Object Class [SCOPE_CV]
GSBER, -- Business Area [GSBER]
PRCTR, -- Profit Center [PRCTR]
NO_DISP, -- Eff. mat. plng [NO_DISP_PLUS]
QKZPRZEIT, -- Time-related [QKZPRZEIT]
QKZZTMG1, -- Quan. pt. lot [QKZZTMG1]
QKZPRMENG, -- Qty-related [QKZPRMENG]
QKZPRFREI, -- No Reference [QKZPRFREI]
KZFEAT, -- Indicator Is Not Used Currently [QKZFEAT]
QKZTLSBEST, -- Last part. lot [QKZTLSBEST]
AENNR, -- Change Number [AENNR]
CUOBJ_ARB, -- Int. object no. [CUOBJ]
EVGEW, -- POC weight [EV_WEIGHTD]
ARBII, -- Object ID [CR_OBJID_I]
WERKI, -- Plant [WERKS_I]
CY_SEQNRV, -- Sequence number [CY_SEQNRV]
KAPT_PUFFR, -- Operation floats after finite scheduling (in seconds) [KAPT_PUFFR]
EBELN, -- Purchasing Doc. [EBELN]
EBELP, -- Item [EBELP]
WEMPF, -- Recipient [WEMPF]
ABLAD, -- Unloading Point [ABLAD]
CLASF, -- Summarization [CLASF]
FRUNV, -- Ext.dat.incompl [FRUNV]
ZSCHL, -- Overhead key [AUFZSCHL]
KALSM, -- Costing Sheet [AUFKALSM]
SCHED_END, -- Purch.Req. fin. [SCEND_ACT]
NETZKONT, -- Account assgnt [NETZKONT]
OWAER, -- Object crcy [OWAERS]
AFNAM, -- Requisitioner [AFNAM]
BEDNR, -- Tracking Number [BEDNR]
KZFIX, -- Price_fixed [CN_KZFIX]
PERNR, -- Personnel no. [CO_PERNR]
FRDLB, -- Subcontracting [CO_FRDLB]
QPART, -- Inspection Type [QPART]
LOEKZ, -- Deletion Flag [AUFLOEKZ]
WKURS, -- Exchange Rate [WKURS]
PROD_ACT, -- Production activ. [PROD_ACT]
FPLNR, -- Bill. Plan No. [FPLNR]
OBJTYPE, -- ChangeInd [OCM_OBJ_TYPE]
CH_PROC, -- ChangeProcType [OCM_CH_PROC]
KLVAR, -- Costing Variant [CK_KLVAR]
KALNR, -- Cost EstimateNo [CK_KALNR]
FORDN, -- Framework Order [SFORDN]
FORDP, -- Frwrk. ord. item [FORDP]
MAT_PRKST, -- Mat.planning [MAT_PRKST_CHG]
PRZ01, -- Business Process [CO_PRZNR]
RFPNT, -- Reference point [CN_RFPNT]
FUNC_AREA, -- Functional Area [FKBER]
TECHS, -- StandardVariant [TECHS]
ADPSP, -- Ref. Element PM/PS [ADDCOMPARE_CORE]
RFIPPNT, -- Reference Point [CN_RPIP]
MES_OPERID, -- MES Operation [CO_MES_INT_OPERID]
MES_STEPID, -- Step ID [CO_MES_INT_STEPID]
OAN_INST_ID_SETUP, -- Instance ID [MPE_OAN_INSTANCE_ID]
OAN_INST_ID_PRODUCE, -- Instance ID [MPE_OAN_INSTANCE_ID]
OAN_INST_ID_TEARDOWN, -- Instance ID [MPE_OAN_INSTANCE_ID]
TL_VERSN, -- Routing Version [PLNVERSN]
VERSN_TRACK_GUID, -- Guid [CP_GUID]
SET_VERSN_TRACK_GUID, -- Guid [CP_GUID]
MAINTORDOPPROCESSPHASECODE, -- Process Phase [EAM_OSTAT_PHASE]
MAINTORDOPPROCESSSUBPHASECODE, -- Process Subphase [EAM_OSTAT_SPHASE]
CL_TYPE, -- Checklist Type [EAM_CL_TYPE]
ALLMAINTORDCOMPCMTDQTSAREKEPT, -- Keep Committed Qties [ALLMAINTORDCOMPCMTDQTSAREKEPT]
DUMMY_EAM_AFVC_INCL_EEW_PS, -- Dummy [CFD_DUMMY]
DUMMY_AFVC_INCL_EEW_PS, -- Dummy function in length 1 [DUMMY]
AFVC_STATUS, -- Status Comb [ACTCMB_DELE]
ADRNR, -- Address number [CADNR]
ADRN2, -- Address Number [AD_ADDRNUM]
KUNN2, -- Customer [QKUNUM]
IND_ADR, -- Checkbox [XFELD]
FLDLOGSDELIVISHELDONSHORE, -- Hold On-Shore [FLOG_HOLD]
SVOBJ_ID, -- Service obj. ID [SVOBJ_ID]
SVOBJ, -- Service object [SVOBJ]
KENNZ_INCL, -- Copy task list [KENNZ_INCL]
MILL_OC_AUFNR_MO, -- Combined Order [MILL_OC_AUFNR_MO]
PS_ADRNR, -- Address number [CADNR]
PS_ADRN2, -- Address Number [AD_ADDRNUM]
PS_KUNNR, -- Customer [EKUNNR]
PS_EMLIF, -- Supplier [EMLIF]
WTY_IND, -- Warranty [WTYSC_WTY_INDICATOR]
TPLNR, -- Functional loc. [TPLNR]
EQUNR, -- Equipment [EQUNR]
MAINTOPEXECUTIONPHASECODE, -- Execution Stage [EAM_PREMAINPOST]
MAINTORDOPHASLEANSERVICES, -- operation has srv [EAM_OPERATION_HAS_SERVICE]
CPD_UPDAT, -- Time Stamp [/CPD/PFP_SC_TSTMP]
PRIMARY KEY (MANDT, AUFPL, APLZL)
);
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