SAP Table AFVC
Operation within an order
AFVC (Operation within an order) 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 AFVC to other SAP tables.
AFVC table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||||||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | 0 | |||||||||||||||||||||||||||
APLZL | General counter for order | CO_APLZL | NUMC | 8 | 0 | |||||||||||||||||||||||||||
PLNFL | Sequence | PLNFOLGE | CHAR | 6 | 0 | |||||||||||||||||||||||||||
PLNKN | Number of the task list node | PLNKN | NUMC | 8 | 0 | |||||||||||||||||||||||||||
PLNAL | Group Counter | PLNAL | CHAR | 2 | 0 | |||||||||||||||||||||||||||
PLNTY | Task List Type | PLNTY | TCA01 | CHAR | 1 | 0 | ||||||||||||||||||||||||||
VINTV | Increment between referenced operations | VINTV | DEC | 3 | 0 | |||||||||||||||||||||||||||
PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | 0 | |||||||||||||||||||||||||||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | 0 | |||||||||||||||||||||||||||
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | 0 | |||||||||||||||||||||||||||
STEUS | Control key | STEUS | T430 | CHAR | 4 | 0 | ||||||||||||||||||||||||||
ARBID | Object ID of the resource | CR_OBJID | CRID | NUMC | 8 | 0 | ||||||||||||||||||||||||||
PDEST | Printer for shop papers | CR_PDEST | TSP03 | CHAR | 4 | 0 | ||||||||||||||||||||||||||
WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||||||||||||||||||
KTSCH | Standard text key | KTSCH | T435 | CHAR | 7 | 0 | ||||||||||||||||||||||||||
LTXA1 | Operation short text | LTXA1 | CHAR | 40 | 0 | |||||||||||||||||||||||||||
LTXA2 | Second line of the description | LTXA2 | CHAR | 40 | 0 | |||||||||||||||||||||||||||
TXTSP | Language Key | SPRAS | T002 | LANG | 1 | 0 | ||||||||||||||||||||||||||
VPLTY | Type of the referenced task list | VPLNTY | TCA01 | CHAR | 1 | 0 | ||||||||||||||||||||||||||
VPLNR | Group of the referenced task list | VPLNNR | CHAR | 8 | 0 | |||||||||||||||||||||||||||
VPLAL | Group counter of the referenced task list | VPLNAL | CHAR | 2 | 0 | |||||||||||||||||||||||||||
VPLFL | Referenced sequence in routing | VPLBFL | CHAR | 6 | 0 | |||||||||||||||||||||||||||
VGWTS | Standard value key | VORGSCHL | TC21 | CHAR | 4 | 0 | ||||||||||||||||||||||||||
LAR01 | Activity Type | LSTAR | CSLA | CHAR | 6 | 0 | ||||||||||||||||||||||||||
LAR02 | Activity Type | LSTAR | CSLA | CHAR | 6 | 0 | ||||||||||||||||||||||||||
LAR03 | Activity Type | LSTAR | CSLA | CHAR | 6 | 0 | ||||||||||||||||||||||||||
LAR04 | Activity Type | LSTAR | CSLA | CHAR | 6 | 0 | ||||||||||||||||||||||||||
LAR05 | Activity Type | LSTAR | CSLA | CHAR | 6 | 0 | ||||||||||||||||||||||||||
LAR06 | Activity Type | LSTAR | CSLA | CHAR | 6 | 0 | ||||||||||||||||||||||||||
ZERMA | Type of standard value calculation | DZERMA | T429 | CHAR | 5 | 0 | ||||||||||||||||||||||||||
ZGDAT | Date when the standard value was calculated | DZGDAT | CHAR | 4 | 0 | |||||||||||||||||||||||||||
ZCODE | Reference number for standard value code | DZCODE | CHAR | 6 | 0 | |||||||||||||||||||||||||||
ZULNR | Basis for standard value calculation | DZULNR | CHAR | 5 | 0 | |||||||||||||||||||||||||||
LOANZ | Number of Time Tickets | LOHNANZ | DEC | 3 | 0 | |||||||||||||||||||||||||||
LOART | Wage Type | LOHNART | CHAR | 4 | 0 | |||||||||||||||||||||||||||
RSANZ | Number of confirmation slips | CR_RS_ANZ | NUMC | 3 | 0 | |||||||||||||||||||||||||||
QUALF | Suitability | QUALF | T423 | CHAR | 2 | 0 | ||||||||||||||||||||||||||
ANZMA | Number of employees | ANZMS | DEC | 5 | 2 | |||||||||||||||||||||||||||
RFGRP | Setup group category | RUEFAGRP | T426 | CHAR | 10 | 0 | ||||||||||||||||||||||||||
RFSCH | Setup group key | RUEFASCHLU | T425 | CHAR | 10 | 0 | ||||||||||||||||||||||||||
RASCH | Setup Type Key | RUEARSCHLU | T428 | CHAR | 2 | 0 | ||||||||||||||||||||||||||
AUFAK | Scrap factor | AUSCHUFAK | DEC | 5 | 3 | |||||||||||||||||||||||||||
LOGRP | Wage group | LOHNGRP | T421 | CHAR | 3 | 0 | ||||||||||||||||||||||||||
UEMUS | Required overlapping | UEMUSKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
UEKAN | Optional overlapping | UEKANKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
FLIES | Indicator: continuous flow production | FLIESSKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
SPMUS | Required splitting | SPLITTUNG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
SPLIM | Maximum number of splits | SPLITTANZ | DEC | 3 | 0 | |||||||||||||||||||||||||||
ABLIPKZ | Indicator: simultaneous teardown and wait | ABLIPKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
RSTRA | Reduction strategy per operation/activity | RSTRA | T499Q | CHAR | 2 | 0 | ||||||||||||||||||||||||||
SUMNR | Node number of the superior operation | SUMKNTNR | NUMC | 8 | 0 | |||||||||||||||||||||||||||
SORTL | Sort Term for Non-Stock Info Records | SORTI | CHAR | 10 | 0 | |||||||||||||||||||||||||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 | 0 | ||||||||||||||||||||||||||
PREIS | Price | PREIS | CURR | 11 | 2 | |||||||||||||||||||||||||||
PEINH | Price Unit | PEINH | DEC | 5 | 0 | |||||||||||||||||||||||||||
SAKTO | Cost Element | KSTAR | CSKA | CHAR | 10 | 0 | ||||||||||||||||||||||||||
WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||||||||||||||||||
INFNR | Number of Purchasing Info Record | INFNR | EINA | CHAR | 10 | 0 | ||||||||||||||||||||||||||
ESOKZ | Purchasing info record category | ESOKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
EKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||||||||||||||||||||||
EKGRP | Purchasing group for external processing | VG_EKGRP | T024 | CHAR | 3 | 0 | ||||||||||||||||||||||||||
KZLGF | Indicator: fixed lot external processing | KZLGF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
KZWRTF | Indicator: Fixed price for external processing | KZWRTF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
MATKL | Material Group | MATKL | T023 | CHAR | 9 | 0 | ||||||||||||||||||||||||||
DDEHN | Indicator: flexible duration | DAUDEHN | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
ANZZL | Number of capacities required | ANZKAP | INT1 | 3 | 0 | |||||||||||||||||||||||||||
PRZNT | Work percentage | APROZENT | INT1 | 3 | 0 | |||||||||||||||||||||||||||
MLSTN | Usage | MILESTONE | T433 | CHAR | 5 | 0 | ||||||||||||||||||||||||||
PPRIO | Priority | PRIORITAET | CHAR | 2 | 0 | |||||||||||||||||||||||||||
BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||||||||||||||||
ANFKO | Requesting cost center | ANFKO | CSKS | CHAR | 10 | 0 | ||||||||||||||||||||||||||
ANFKOKRS | Controlling area of the requesting cost center | ANFKOKRS | TKA01 | CHAR | 4 | 0 | ||||||||||||||||||||||||||
INDET | Key for calculation | INDET | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
LARNT | Activity Type | LSTAR | CSLA | CHAR | 6 | 0 | ||||||||||||||||||||||||||
PRKST | Costs in the activity | PRKST | CURR | 11 | 2 | |||||||||||||||||||||||||||
APLFL | Sequence | PLNFOLGE | CHAR | 6 | 0 | |||||||||||||||||||||||||||
RUECK | Completion confirmation number for the operation | CO_RUECK | NUMC | 10 | 0 | |||||||||||||||||||||||||||
RMZHL | Confirmation counter | CO_RMZHL | NUMC | 8 | 0 | |||||||||||||||||||||||||||
PROJN | Work breakdown structure element (WBS element) | PS_PSP_ELE | PRPS | NUMC | 8 | 0 | ||||||||||||||||||||||||||
OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 | 0 | ||||||||||||||||||||||||||
SPANZ | Actual number of splits | SPLITTERM | DEC | 3 | 0 | |||||||||||||||||||||||||||
BEDID | ID of the capacity requirements record | BEDID | NUMC | 12 | 0 | |||||||||||||||||||||||||||
BEDZL | Internal counter | CIM_COUNT | NUMC | 8 | 0 | |||||||||||||||||||||||||||
BANFN | Purchase requisition number | CO_BANFN | CHAR | 10 | 0 | |||||||||||||||||||||||||||
BNFPO | Item number of the purchase requisition in the order | CO_BNFPO | EBAN | NUMC | 5 | 0 | ||||||||||||||||||||||||||
LEK01 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
LEK02 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
LEK03 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
LEK04 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
LEK05 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
LEK06 | Indicator: No remaining activity expected | CO_LEIKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
SELKZ | Selection indicator for costing line items | CO_SELKZ | TCK08 | CHAR | 1 | 0 | ||||||||||||||||||||||||||
KALID | Factory Calendar | WFCID | TFACD | CHAR | 2 | 0 | ||||||||||||||||||||||||||
FRSP | Earliest possible activity / Latest possible activity | FRSP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
STDKN | Node of operation within reference operation set | STDKN | NUMC | 8 | 0 | |||||||||||||||||||||||||||
ANLZU | Syst.Condition | ANLZU | T357M | CHAR | 1 | 0 | ||||||||||||||||||||||||||
ISTRU | Assembly | ISTRU | MARA | CHAR | 18 | 0 | ||||||||||||||||||||||||||
ISTTY | BOM category | STLTY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
ISTNR | Bill of material | STNUM | CHAR | 8 | 0 | |||||||||||||||||||||||||||
ISTKN | BOM item node number | STLKN | NUMC | 8 | 0 | |||||||||||||||||||||||||||
ISTPO | Internal counter | CIM_COUNT | NUMC | 8 | 0 | |||||||||||||||||||||||||||
IUPOZ | Subitem Number | UPOSZ | CHAR | 4 | 0 | |||||||||||||||||||||||||||
EBORT | Installation Point for Subitem | EBORT | CHAR | 20 | 0 | |||||||||||||||||||||||||||
VERTL | Distr.cap.reqmts (plant maint.,process order, network) | CR_VERTN | TC29 | CHAR | 8 | 0 | ||||||||||||||||||||||||||
LEKNW | Indicator: No Remaining Work Expected | LEKNW | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
NPRIO | Priority | NW_PRIO | TCN07 | CHAR | 1 | 0 | ||||||||||||||||||||||||||
PVZKN | General counter for order | CO_APLZL | NUMC | 8 | 0 | |||||||||||||||||||||||||||
PHFLG | Indicator: Phase | PHFLG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
PHSEQ | Control Recipe Destination | PHSEQ | TC52 | CHAR | 2 | 0 | ||||||||||||||||||||||||||
KNOBJ | Number of Object with Assigned Dependencies | KNOBJ | NUMC | 18 | 0 | |||||||||||||||||||||||||||
ERFSICHT | Recording View | QERFSICHT | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||
QPPKTABS | Flow Variants for Inspection Point Completion | QPPKTABS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
OTYPE | Object Type | OTYPE | T778O | CHAR | 2 | 0 | ||||||||||||||||||||||||||
OBJEKTID | Object ID | OBJEKTID | NUMC | 8 | 0 | |||||||||||||||||||||||||||
QLKAPAR | Capacity category | QL_KAPART | TC26 | CHAR | 3 | 0 | ||||||||||||||||||||||||||
RSTUF | Reduction level which reduces operation lead time | RSTUF | NUMC | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
NPTXTKY | Internal text number (12-character) | TXTKY | CHAR | 12 | 0 | |||||||||||||||||||||||||||
SUBSYS | Subsystem Identifier for QM Subsystem Interface | QEIFSUBSYS | CHAR | 6 | 0 | |||||||||||||||||||||||||||
PSPNR | Standard WBS element | PS_SPS_ELE | NUMC | 8 | 0 | |||||||||||||||||||||||||||
PACKNO | Package number | PACKNO | NUMC | 10 | 0 | |||||||||||||||||||||||||||
TXJCD | Tax Jurisdiction | TXJCD | TTXJ | CHAR | 15 | 0 | ||||||||||||||||||||||||||
SCOPE | Object Class | SCOPE_CV | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||
GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||||||||||||||||||||||||||
PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 | 0 | ||||||||||||||||||||||||||
NO_DISP | Effective for Materials Planning | NO_DISP_PLUS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
QKZPRZEIT | Interval = Time (Time-Related) | QKZPRZEIT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
QKZZTMG1 | Quantity Confirmation for Each Partial Lot | QKZZTMG1 | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
QKZPRMENG | Creation Cycle = Quantity (Quantity-Reference) | QKZPRMENG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
QKZPRFREI | Interval Without Reference to Time or Quantity | QKZPRFREI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
KZFEAT | Indicator Is Not Used Currently | QKZFEAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
QKZTLSBEST | Operation with Stock-Related Partial Lot Assignment | QKZTLSBEST | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
AENNR | Change Number | AENNR | AENR | CHAR | 12 | 0 | ||||||||||||||||||||||||||
CUOBJ_ARB | Configuration (internal object number) | CUOBJ | NUMC | 18 | 0 | |||||||||||||||||||||||||||
EVGEW | Aggregation weight for POC (PS progress) | EV_WEIGHTD | DEC | 8 | 0 | |||||||||||||||||||||||||||
ARBII | Actual operating resources object identification | CR_OBJID_I | CRID | NUMC | 8 | 0 | ||||||||||||||||||||||||||
WERKI | Actual plant | WERKS_I | T001W | CHAR | 4 | 0 | ||||||||||||||||||||||||||
CY_SEQNRV | Sequence number operation | CY_SEQNRV | NUMC | 14 | 0 | |||||||||||||||||||||||||||
KAPT_PUFFR | Operation floats after finite scheduling (in seconds) | KAPT_PUFFR | INT4 | 10 | 0 | |||||||||||||||||||||||||||
EBELN | Purchasing Document Number | EBELN | EKKO | CHAR | 10 | 0 | ||||||||||||||||||||||||||
EBELP | Item Number of Purchasing Document | EBELP | EKPO | NUMC | 5 | 0 | ||||||||||||||||||||||||||
WEMPF | Goods Recipient/Ship-To Party | WEMPF | CHAR | 12 | 0 | |||||||||||||||||||||||||||
ABLAD | Unloading Point | ABLAD | CHAR | 25 | 0 | |||||||||||||||||||||||||||
CLASF | Ind.: Take Activity Into Account for Project Summarization | CLASF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
FRUNV | Indicator: External procurement data incomplete | FRUNV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
ZSCHL | Overhead key | AUFZSCHL | CHAR | 6 | 0 | |||||||||||||||||||||||||||
KALSM | Costing Sheet | AUFKALSM | CHAR | 6 | 0 | |||||||||||||||||||||||||||
SCHED_END | Ind.: Purchase requisition at activity finish date | SCEND_ACT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
NETZKONT | Indicator for the account assignment of a network(hdr/act.) | NETZKONT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
OWAER | Object currency for network activity | OWAERS | TCURC | CUKY | 5 | 0 | ||||||||||||||||||||||||||
AFNAM | Name of Requisitioner/Requester | AFNAM | CHAR | 12 | 0 | |||||||||||||||||||||||||||
BEDNR | Requirement Tracking Number | BEDNR | CHAR | 10 | 0 | |||||||||||||||||||||||||||
KZFIX | Indicator: Purchasing info record data are fixed | CN_KZFIX | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
PERNR | Personnel number | CO_PERNR | NUMC | 8 | 0 | |||||||||||||||||||||||||||
FRDLB | Indicator: Externally processed op. with subcontracting | CO_FRDLB | CHAR | 1 | 0 | |||||||||||||||||||||||||||
QPART | Inspection Type | QPART | TQ30 | CHAR | 8 | 0 | ||||||||||||||||||||||||||
LOEKZ | Deletion flag | AUFLOEKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
WKURS | Exchange Rate | WKURS | DEC | 9 | 5 | |||||||||||||||||||||||||||
PROD_ACT | Indicator: Activity is a production activity | PROD_ACT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10 | 0 | |||||||||||||||||||||||||||
OBJTYPE | Change indicator | OCM_OBJ_TYPE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
CH_PROC | Process that has lead to the change of an object | OCM_CH_PROC | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
KLVAR | Costing Variant | CK_KLVAR | CHAR | 4 | 0 | |||||||||||||||||||||||||||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | 0 | |||||||||||||||||||||||||||
FORDN | Framework Order | SFORDN | CHAR | 10 | 0 | |||||||||||||||||||||||||||
FORDP | Item of framework order | FORDP | NUMC | 5 | 0 | |||||||||||||||||||||||||||
MAT_PRKST | Material planning in networks: primary costs | MAT_PRKST | CURR | 11 | 2 | |||||||||||||||||||||||||||
PRZ01 | Business Process | CO_PRZNR | CHAR | 12 | 0 | |||||||||||||||||||||||||||
RFPNT | Reference point for BOM transfer | CN_RFPNT | TCNRFP | CHAR | 20 | 0 | ||||||||||||||||||||||||||
FUNC_AREA | Functional Area | FKBER | TFKB | CHAR | 16 | 0 | ||||||||||||||||||||||||||
TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | 0 | |||||||||||||||||||||||||||
ADPSP | Reference Element PM/PS | ADDCOMPARE_CORE | CHAR | 40 | 0 | |||||||||||||||||||||||||||
RFIPPNT | Reference Point for Relationship Between iPPE and PS | CN_RPIP | TCNRPIP | CHAR | 20 | 0 | ||||||||||||||||||||||||||
MES_OPERID | Key of an Operation from an ME System | CO_MES_INT_OPERID | CHAR | 48 | 0 | |||||||||||||||||||||||||||
MES_STEPID | Key of a Step in a Routing (SAP ME) | CO_MES_INT_STEPID | CHAR | 6 | 0 | |||||||||||||||||||||||||||
/CUM/CUGUID | UUID in X form (binary) | SYSUUID_X | /CUM/AFCU | RAW | 16 | 0 | ||||||||||||||||||||||||||
/ISDFPS/OBJNR | Object number | J_OBJNR | CHAR | 22 | 0 | |||||||||||||||||||||||||||
AFVC_STATUS | Status Combination | ACTCMB_DELE | ACTCMB_TAB | INT1 | 3 | 0 | ||||||||||||||||||||||||||
MILL_OC_AUFNR_MO | Number of Combined Order | MILL_OC_AUFNR_MO | CHAR | 12 | 0 | |||||||||||||||||||||||||||
OIO_HOLD | Indicator: Hold Delivery Onshore | OIO_HOLD | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
WTY_IND | Warranty indicator | WTYSC_WTY_INDICATOR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||
TPLNR | Functional Location | TPLNR | CHAR | 30 | 0 | |||||||||||||||||||||||||||
EQUNR | Equipment Number | EQUNR | CHAR | 18 | 0 | |||||||||||||||||||||||||||
CPD_UPDAT | Time Stamp | /CPD/PFP_TSTMP | DEC | 15 | 0 |
AFVC foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
AFVC | /CUM/CUGUID | SYST | MANDT | /CUM/AFCU | CU: CU Instances | MANDT |
AFVC | /CUM/CUGUID | AFVC | /CUM/CUGUID | /CUM/AFCU | CU: CU Instances | CUGUID |
AFVC | AENNR | AFVKI | MANDT | AENR | Change Master | MANDT |
AFVC | AENNR | AFVC | AENNR | AENR | Change Master | AENNR |
AFVC | AFVC_STATUS | AFVC | AFVC_STATUS | ACTCMB_TAB | table for status combination | ACTCMB |
AFVC | AFVC_STATUS | SYST | MANDT | ACTCMB_TAB | table for status combination | MANDT |
AFVC | ANFKO | AFVKI | MANDT | CSKS | Cost Center Master Data | MANDT |
AFVC | ANFKO | AFVC | ANFKOKRS | CSKS | Cost Center Master Data | KOKRS |
AFVC | ANFKO | AFVC | ANFKO | CSKS | Cost Center Master Data | KOSTL |
AFVC | ANFKO | CSKS | DATBI | CSKS | Cost Center Master Data | DATBI |
AFVC | ANFKOKRS | AFVKI | MANDT | TKA01 | Controlling Areas | MANDT |
AFVC | ANFKOKRS | AFVC | ANFKOKRS | TKA01 | Controlling Areas | KOKRS |
AFVC | ANLZU | CAUFVD | MANDT | T357M | Machine operating condition | MANDT |
AFVC | ANLZU | AFVC | ANLZU | T357M | Machine operating condition | ANLZU |
AFVC | ARBID | AFVKI | MANDT | CRID | CIM Resource - Entities | MANDT |
AFVC | ARBID | CRID | OBJTY | CRID | CIM Resource - Entities | OBJTY |
AFVC | ARBID | AFVC | ARBID | CRID | CIM Resource - Entities | OBJID |
AFVC | ARBII | CRID | OBJTY | CRID | CIM Resource - Entities | OBJTY |
AFVC | ARBII | AFVC | ARBII | CRID | CIM Resource - Entities | OBJID |
AFVC | ARBII | AFVKI | MANDT | CRID | CIM Resource - Entities | MANDT |
AFVC | BNFPO | AFVKI | MANDT | EBAN | Purchase Requisition | MANDT |
AFVC | BNFPO | AFVC | BANFN | EBAN | Purchase Requisition | BANFN |
AFVC | BNFPO | AFVC | BNFPO | EBAN | Purchase Requisition | BNFPO |
AFVC | BUKRS | AFVKI | MANDT | T001 | Company Codes | MANDT |
AFVC | BUKRS | AFVC | BUKRS | T001 | Company Codes | BUKRS |
AFVC | EBELN | AFVGD | MANDT | EKKO | Purchasing Document Header | MANDT |
AFVC | EBELN | AFVC | EBELN | EKKO | Purchasing Document Header | EBELN |
AFVC | EBELP | AFVGD | MANDT | EKPO | Purchasing Document Item | MANDT |
AFVC | EBELP | AFVC | EBELN | EKPO | Purchasing Document Item | EBELN |
AFVC | EBELP | AFVC | EBELP | EKPO | Purchasing Document Item | EBELP |
AFVC | EKGRP | AFVKI | MANDT | T024 | Purchasing Groups | MANDT |
AFVC | EKGRP | AFVC | EKGRP | T024 | Purchasing Groups | EKGRP |
AFVC | EKORG | AFVKI | MANDT | T024E | Purchasing Organizations | MANDT |
AFVC | EKORG | AFVC | EKORG | T024E | Purchasing Organizations | EKORG |
AFVC | FUNC_AREA | AFVC | FUNC_AREA | TFKB | Functional areas | FKBER |
AFVC | FUNC_AREA | SYST | MANDT | TFKB | Functional areas | MANDT |
AFVC | GSBER | AFVKI | MANDT | TGSB | Business Areas | MANDT |
AFVC | GSBER | AFVC | GSBER | TGSB | Business Areas | GSBER |
AFVC | INFNR | AFVKI | MANDT | EINA | Purchasing Info Record: General Data | MANDT |
AFVC | INFNR | AFVC | INFNR | EINA | Purchasing Info Record: General Data | INFNR |
AFVC | ISTRU | AFVGK | MANDT | MARA | General Material Data | MANDT |
AFVC | ISTRU | AFVC | ISTRU | MARA | General Material Data | MATNR |
AFVC | KALID | AFVC | KALID | TFACD | Factory calendar definition | IDENT |
AFVC | KTSCH | AFVC | KTSCH | T435 | Standard texts for routing/ref. op set items | VLSCH |
AFVC | KTSCH | AFVKI | MANDT | T435 | Standard texts for routing/ref. op set items | MANDT |
AFVC | LAR01 | AFVC | ANFKOKRS | CSLA | Activity master | KOKRS |
AFVC | LAR01 | AFVC | LAR01 | CSLA | Activity master | LSTAR |
AFVC | LAR01 | CSLA | DATBI | CSLA | Activity master | DATBI |
AFVC | LAR01 | AFVKI | MANDT | CSLA | Activity master | MANDT |
AFVC | LAR02 | CSLA | DATBI | CSLA | Activity master | DATBI |
AFVC | LAR02 | AFVKI | MANDT | CSLA | Activity master | MANDT |
AFVC | LAR02 | AFVC | ANFKOKRS | CSLA | Activity master | KOKRS |
AFVC | LAR02 | AFVC | LAR02 | CSLA | Activity master | LSTAR |
AFVC | LAR03 | AFVKI | MANDT | CSLA | Activity master | MANDT |
AFVC | LAR03 | AFVC | ANFKOKRS | CSLA | Activity master | KOKRS |
AFVC | LAR03 | AFVC | LAR03 | CSLA | Activity master | LSTAR |
AFVC | LAR03 | CSLA | DATBI | CSLA | Activity master | DATBI |
AFVC | LAR04 | AFVKI | MANDT | CSLA | Activity master | MANDT |
AFVC | LAR04 | AFVC | ANFKOKRS | CSLA | Activity master | KOKRS |
AFVC | LAR04 | AFVC | LAR04 | CSLA | Activity master | LSTAR |
AFVC | LAR04 | CSLA | DATBI | CSLA | Activity master | DATBI |
AFVC | LAR05 | AFVC | ANFKOKRS | CSLA | Activity master | KOKRS |
AFVC | LAR05 | AFVC | LAR05 | CSLA | Activity master | LSTAR |
AFVC | LAR05 | CSLA | DATBI | CSLA | Activity master | DATBI |
AFVC | LAR05 | AFVKI | MANDT | CSLA | Activity master | MANDT |
AFVC | LAR06 | CSLA | DATBI | CSLA | Activity master | DATBI |
AFVC | LAR06 | AFVKI | MANDT | CSLA | Activity master | MANDT |
AFVC | LAR06 | AFVC | ANFKOKRS | CSLA | Activity master | KOKRS |
AFVC | LAR06 | AFVC | LAR06 | CSLA | Activity master | LSTAR |
AFVC | LARNT | AFVGK | MANDT | CSLA | Activity master | MANDT |
AFVC | LARNT | AFVC | ANFKOKRS | CSLA | Activity master | KOKRS |
AFVC | LARNT | AFVC | LARNT | CSLA | Activity master | LSTAR |
AFVC | LARNT | CSLA | DATBI | CSLA | Activity master | DATBI |
AFVC | LIFNR | AFVC | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
AFVC | LIFNR | AFVKI | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
AFVC | LOGRP | AFVKI | MANDT | T421 | Wage groups | MANDT |
AFVC | LOGRP | AFVC | WERKS | T421 | Wage groups | WERKS |
AFVC | LOGRP | AFVC | LOGRP | T421 | Wage groups | LOGRP |
AFVC | MANDT | AFVC | MANDT | T000 | Clients | MANDT |
AFVC | MATKL | AFVC | MATKL | T023 | Material Groups | MATKL |
AFVC | MATKL | AFVKI | MANDT | T023 | Material Groups | MANDT |
AFVC | MLSTN | AFVKI | MANDT | T433 | Milestone Indicator | MANDT |
AFVC | MLSTN | AFVC | MLSTN | T433 | Milestone Indicator | MLSTN |
AFVC | NPRIO | AFVC | NPRIO | TCN07 | Priority | NPRIO |
AFVC | NPRIO | SYST | MANDT | TCN07 | Priority | MANDT |
AFVC | OBJNR | AFVKI | MANDT | ONR00 | General Object Number | MANDT |
AFVC | OBJNR | AFVC | OBJNR | ONR00 | General Object Number | OBJNR |
AFVC | OTYPE | AFVC | OTYPE | T778O | Object Types | OTYPE |
AFVC | OTYPE | AFVKI | MANDT | T778O | Object Types | MANDT |
AFVC | OWAER | AFVC | OWAER | TCURC | Currency Codes | WAERS |
AFVC | OWAER | SYST | MANDT | TCURC | Currency Codes | MANDT |
AFVC | PDEST | AFVC | PDEST | TSP03 | Spool: Printer declaration | PADEST |
AFVC | PHSEQ | MANDT | AFVC | TC52 | Control Recipe Destinations | MANDT |
AFVC | PHSEQ | AFVC | PHSEQ | TC52 | Control Recipe Destinations | PHSEQ |
AFVC | PHSEQ | AFVC | WERKS | TC52 | Control Recipe Destinations | WERKS |
AFVC | PLNTY | AFVKI | MANDT | TCA01 | Task list types | MANDT |
AFVC | PLNTY | AFVC | PLNTY | TCA01 | Task list types | PLNTY |
AFVC | PRCTR | * | CEPC | Profit Center Master Data Table | DATBI | |
AFVC | PRCTR | * | CEPC | Profit Center Master Data Table | KOKRS | |
AFVC | PRCTR | AFVKI | MANDT | CEPC | Profit Center Master Data Table | MANDT |
AFVC | PRCTR | AFVC | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
AFVC | PROJN | AFVKI | MANDT | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
AFVC | PROJN | AFVC | PROJN | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
AFVC | QLKAPAR | AFVKI | MANDT | TC26 | Capacity category | MANDT |
AFVC | QLKAPAR | AFVC | QLKAPAR | TC26 | Capacity category | KAPAR |
AFVC | QPART | AFVC | MANDT | TQ30 | Inspection types | MANDT |
AFVC | QPART | AFVC | QPART | TQ30 | Inspection types | ART |
AFVC | QUALF | AFVKI | MANDT | T423 | Wage group qualification | MANDT |
AFVC | QUALF | AFVC | WERKS | T423 | Wage group qualification | WERKS |
AFVC | QUALF | AFVC | QUALF | T423 | Wage group qualification | QUALF |
AFVC | RASCH | AFVC | WERKS | T428 | Setup Type Key | WERKS |
AFVC | RASCH | AFVC | RASCH | T428 | Setup Type Key | RASCH |
AFVC | RASCH | AFVKI | MANDT | T428 | Setup Type Key | MANDT |
AFVC | RFGRP | AFVKI | MANDT | T426 | Setup group categories | MANDT |
AFVC | RFGRP | AFVC | WERKS | T426 | Setup group categories | WERKS |
AFVC | RFGRP | AFVC | RFGRP | T426 | Setup group categories | RFGRP |
AFVC | RFIPPNT | SYST | MANDT | TCNRPIP | Reference point for relationship between IPPE & PS. | MANDT |
AFVC | RFIPPNT | AFVC | RFIPPNT | TCNRPIP | Reference point for relationship between IPPE & PS. | RFPNT |
AFVC | RFPNT | AFVC | MANDT | TCNRFP | Reference Point for BOM transfer | MANDT |
AFVC | RFPNT | AFVC | RFPNT | TCNRFP | Reference Point for BOM transfer | RFPNT |
AFVC | RFSCH | AFVC | RFSCH | T425 | Setup group keys | RFSCH |
AFVC | RFSCH | AFVKI | MANDT | T425 | Setup group keys | MANDT |
AFVC | RFSCH | AFVC | WERKS | T425 | Setup group keys | WERKS |
AFVC | RFSCH | AFVC | RFGRP | T425 | Setup group keys | RFGRP |
AFVC | RSTRA | AFVKI | MANDT | T499Q | Reduction strategies | MANDT |
AFVC | RSTRA | AFVC | WERKS | T499Q | Reduction strategies | WERKS |
AFVC | RSTRA | AFVC | RSTRA | T499Q | Reduction strategies | RSTRA |
AFVC | SAKTO | AFVKI | MANDT | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | MANDT |
AFVC | SAKTO | CSKA | KTOPL | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KTOPL |
AFVC | SAKTO | AFVC | SAKTO | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KSTAR |
AFVC | SELKZ | AFVKI | MANDT | TCK08 | Indicator for Relevancy to Costing | MANDT |
AFVC | SELKZ | AFVC | SELKZ | TCK08 | Indicator for Relevancy to Costing | SELKZ |
AFVC | STEUS | AFVKI | MANDT | T430 | Operation/Activity control key | MANDT |
AFVC | STEUS | CAUFVD | PLNAW | T430 | Operation/Activity control key | PLNAW |
AFVC | STEUS | AFVC | STEUS | T430 | Operation/Activity control key | STEUS |
AFVC | TXJCD | AFVKI | MANDT | TTXJ | Check Table for Tax Jurisdiction | MANDT |
AFVC | TXJCD | CAUFVD | KALSM | TTXJ | Check Table for Tax Jurisdiction | KALSM |
AFVC | TXJCD | AFVC | TXJCD | TTXJ | Check Table for Tax Jurisdiction | TXJCD |
AFVC | TXTSP | AFVC | TXTSP | T002 | Language Keys (Component BC-I18) | SPRAS |
AFVC | VERTL | AFVGK | MANDT | TC29 | Distribution key for capacity load | MANDT |
AFVC | VERTL | AFVC | VERTL | TC29 | Distribution key for capacity load | VERTL |
AFVC | VGWTS | AFVKI | MANDT | TC21 | Standard value key | MANDT |
AFVC | VGWTS | AFVC | VGWTS | TC21 | Standard value key | VGWTS |
AFVC | VPLTY | AFVKI | MANDT | TCA01 | Task list types | MANDT |
AFVC | VPLTY | AFVC | VPLTY | TCA01 | Task list types | PLNTY |
AFVC | WAERS | AFVKI | MANDT | TCURC | Currency Codes | MANDT |
AFVC | WAERS | AFVC | WAERS | TCURC | Currency Codes | WAERS |
AFVC | WERKI | AFVKI | MANDT | T001W | Plants/Branches | MANDT |
AFVC | WERKI | AFVC | WERKI | T001W | Plants/Branches | WERKS |
AFVC | WERKS | AFVKI | MANDT | T001W | Plants/Branches | MANDT |
AFVC | WERKS | AFVC | WERKS | T001W | Plants/Branches | WERKS |
AFVC | ZERMA | AFVKI | MANDT | T429 | Standard Times Calculation Type | MANDT |
AFVC | ZERMA | AFVC | WERKS | T429 | Standard Times Calculation Type | WERKS |
AFVC | ZERMA | AFVC | ZERMA | T429 | Standard Times Calculation Type | ZERMA |