SAP table TCO11 (Control table for production orders - availability check)

SAP table TCO11 has 4 primary key fields being MANDT,WERKS,AUART,VORGANG.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
WERKS Plant CHAR 4 0 T001W WERKS_D
AUART Order Type CHAR 4 0 T003O AUFART
VORGANG Business function (for availability check) CHAR 1 0 CO_VFVG
1 Check availability during order creation
2 Check availability during order release
PRUEFKZ Indicator: No material availability check CHAR 1 0 CO_PRUEFKZ
PRREG Checking Rule for Availability Check CHAR 2 0 T441R PRREG_APPL
FRMAT Release control for material CHAR 1 0 CO_FRMAT
CF_VPRKZ Indicator: Do not check PRT availability CHAR 1 0 CF_VPRKZ
CF_PRREG Checking rule for PRT availability check CHAR 2 0 CF_PRREG
01 Status check
02 Status check and inventory audit
CF_PRFRS Release control based on the PRT availability check CHAR 1 0 CF_PRFRS
1 User decides to release when there's no PRT
2 Release despite PRT shortage
3 If there is a PRT shortage, there is no release
PRART Indicator: Check status only for material availability CHAR 1 0 CO_PRART
VPKAPKZ Indicator check capacity availability CHAR 1 0 CO_VPKAPA
VPKAPPROF ID of an overall profile for capacity availability check CHAR 10 0 TCY30 CY_KAPPROF
VPKAPFR Release control availability check capacities CHAR 1 0 CO_FRKAPA
EROMAT Creation control for availability check material CHAR 1 0 CO_EROMAT
1 User decides on creation if material is missing
2 Creation even though no material is available
3 No creation if material is missing
VPKAPERO Creation control if capacity is missing CHAR 1 0 CO_EROKAPA
1 User decides on creation if capacity is missing
2 Creation even though no capacity is available
3 No creation if there is insufficient capacity
CF_EROFHM Creation control when PRTs are not available CHAR 1 0 CO_EROFHM
1 User decides on creation if PRT is missing
2 Creation even though no PRT available
3 No creation if PRT is missing
KZAKP Indicator for type of component check CHAR 1 0 KZAKP
ATP check
1 Check against preliminary planning
ATPSAVEKZ Check material availability when saving order (network) CHAR 1 0 CO_ATPSAVEKZ
FHMSAVEKZ Indicator: Check PRT availability when saving order CHAR 1 0 CO_FHMSAVEKZ
KAPSAVEKZ Indicator: Check capacity availability when saving CHAR 1 0 CO_KAPSAVEKZ
FRBATCH Release Control for Materials Handled in Batches CHAR 1 0 CO_FRBATCH

TCO11 foreign key relationships

Table Field Check Table Check Field
0 TCO11 AUART T003O Order Types AUART
1 TCO11 PRREG T441R Values Table for Checking Rule MANDT
1 TCO11 PRREG T441R Values Table for Checking Rule PRREG
0 TCO11 VPKAPPROF TCY30 Overall profile for capacity leveling MANDT
0 TCO11 VPKAPPROF TCY30 Overall profile for capacity leveling PROFILE_ID
1 TCO11 WERKS T001W Plants/Branches WERKS