SAP table T399X (Parameters dependent on order type)

SAP table T399X has 3 primary key fields being MANDT,WERKS,AUART.

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
PLNTY Task List Type CHAR 1 0 TCA01 PLNTY
PRF_GROUPE Profile group (sort graphics profiles) CHAR 4 0 TCNG NETPRFGRUP
PRF_NAME Name of graphic profile in Network/Hierarchy Graphics CHAR 12 0 NETPRFNAME
PRF_INDEX Profile index for graphics profiles CHAR 1 0 NETPRFINDX
OBJNR_VORG Indicator: Account assignment on activity level CHAR 1 0 OBJNR_VORG
DFREG Default Rule CHAR 3 0 TKB2A DFREG
ARBPA -INVALID FOR S/4- Routing selection CHAR 1 0 CO_PLAUL
0 No routings or reference operation sets to be used
1 Always reference operation set (no routings selected)
2 Routing/ref. op. set mandatory (automatic selection)
3 Routing/ref. op. set optional (automatic selection)
4 Routing/ref. op. set optional (manual selection)
5 Routing/ref. op. set mandatory (manual selection)
6 Routing mandatory (automatic selection)
7 Routing mandatory (manual selection)
8 Routing optional (manual selection)
9 Routing optional (automatic selection)
CAPID Application CHAR 4 0 TC04 CAPID
CPSLID Selection ID for routings CHAR 2 0 TCA43 CPSID
AUTYP Order category NUMC 2 0 AUFTYP
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
99 Master Planned order
KLVARP Costing Variant for Planned Costs CHAR 4 0 TCK03 KALKVARPLN
KLVARI Costing Variant For Actual Costs CHAR 4 0 TCK03 KALKVARIST
DPROBO Indicator: Check of op. dtl screens during routing transfer CHAR 1 0 CO_DPROBO
DPROBC Indicator: Detail screen check of comp. during BOM explosion CHAR 1 0 CO_DPROBC
FLG_DOC Indicator: creation of change documents active CHAR 1 0 CO_FLG_DOC
AWSLS Variance Key CHAR 6 0 TKV01 AWSLS
ABGSL Results Analysis Key CHAR 6 0 TKKAA ABGR_SCHL_APPL
ALTSEQ Indicator: Alternative sequences copied into the order CHAR 1 0 CO_ALT_SEQ
FLG_STAT Indicator: Statistical order CHAR 1 0 CO_FLGSTAT
VORNR_DEL Increment for automatic operation/activity numbering CHAR 4 0 DEL_VORNR
FLG_ERF_H Activate/deactivate entry tool CHAR 1 0 FLG_ERF_H
RSTRA Reduction Strategy per Operation CHAR 2 0 T499Q RSTRA
STATISTIK Indicator: LIS statistics are active CHAR 1 0 CO_STATIS
SEQ_CHANGE Sequence exchange manual/auto CHAR 1 0 CO_SEQ_CHG
No selection
0 No selection
1 Always automatic selection by lot size of alt. sequence
2 Manual selection
CHGKZ_HEAD Status change document for header order/network CHAR 1 0 CO_CHGKZ_H
CHGKZ_OPR Indicator: Status change document active for operations CHAR 1 0 CO_CHGKZ_O
CHGKZ_CMP Indicator: Status change document active for materials CHAR 1 0 CO_CHGKZ_C
CHGKZ_PRT Indicator: Status change document active for PRTs CHAR 1 0 CO_CHGKZ_P
PLTRM Indicator: Copy planned order scheduling CHAR 1 0 CO_PLTRM
AOB_KEY Key: View of relationships CHAR 1 0 AOB_KEY
1 Predecessor
2 Successor
3 Mixed
4 As created
PROFIDGRAF Order profile CHAR 7 0 PROFID_GRF
AOB_DARST Relationship display CHAR 1 0 AOB_DARST
1 As a finish/start relationship
2 By relationship type
VRG_DARST Operation display in graphic CHAR 1 0 VRG_DARST
0 Operation is displayed as large node in graphics
1 Operation is displayed as medium node in graphics
2 Operation is displayed as small node in graphics
PHS_DARST Display of phase in graphics CHAR 1 0 PHS_DARST
5 Phase is displayed as large node in graphics
6 Phase is displayed as medium node in graphics
7 Phase is displayed as small node in graphics
E_DISPO Substitute MRP controller CHAR 3 0 T024D CO_EDISPO
E_FEVOR Substitute Production Supervisor CHAR 3 0 T024F CO_EFEVOR
NAUCOST Indicator: Do not cost automatically CHAR 1 0 CO_NAUCOST
STRAT Strategy for determining a settlement rule CHAR 2 0 TCN08 CN_STRAT
EBR_ERF Indicator: Process data documentation required CHAR 1 0 EBR_ERF
CHSCH Search Procedure for Batch Determination CHAR 6 0 T683 KALSMA_CH
MC_VHEAD Release version for production order header = active CHAR 1 0 MC_VHEAD
MC_VITEM Release version for production order item = active CHAR 1 0 MC_VITEM
MC_VOPER Release version for production order operation = active CHAR 1 0 MC_VOPER
CO_STAUF BOM selection key CHAR 1 0 CO_STAUF
PRUEB Ind.: Copy Net Price from Requisition into Purchase Order CHAR 1 0 CO_PRUEB
ALT_PLANW Alternative task list application CHAR 1 0 ALT_PLNAW
WF_MAT_CHG Indicator: Workflow for purchase order change CHAR 1 0 WF_MAT_CHG
PDC_ACTIVE Indicator: PDC active CHAR 1 0 PDC_ACTIVE
NO_DISP Effective for Materials Planning CHAR 1 0 NO_DISP_PLUS
Relevant to materials planning
1 Not relevant to materials planning
B Immediately with blocking indicator
X Relevant to materials planning at a defined time
PROF_GR Graphics profile for collective order CHAR 6 0 TCOP CO_PROF_GR
PRUEFART Inspection Type CHAR 8 0 TQ30 QPART
ORD_BANF Indicator: One collective purchase requisition per order CHAR 1 0 ORD_BANF
MBWEB Goods receipt for purchase order CHAR 1 0 MBWEB
MBWEF Goods receipt for production order CHAR 1 0 MBWEF
MBWAP Planned goods issue (for reservation) CHAR 1 0 MBWAP
MBWAU Unplanned goods issue CHAR 1 0 MBWAU
NOPCOST Do not calculate planned costs for order CHAR 1 0 CO_NOPCOST
FLG_SCRAP Indicator: Planning and recording of scrap CHAR 1 0 FLG_SCRAP
VAL_REC Indicator: Order requires approval CHAR 1 0 FLG_RECIPE
KZCHP Indicator: Check of the batch entered is active CHAR 1 0 KZCHP
CHP_ERF Indicator: Batch record is required CHAR 1 0 CHP_ERF
CHP_DAUER Availability period of batch record in years NUMC 2 0 CHP_DAUER
PKOSA Use Product Cost Collector as Cost Object CHAR 1 0 CO_PKOSA
PVSEL Indicator: Selection of production version CHAR 1 0 PVSEL_KZ
0 Automatic selection of production version
1 Manual selection of production version
FTLPROF Profile display missing parts list CHAR 6 0 T441C CO_FTL_PROF
FTLPROFNET Profile display missing parts list collective orders CHAR 6 0 T441C CO_FTL_PROF_NETZ
DWBPROF Profile documentation goods movements for order (AUFM) CHAR 6 0 TCOAD CO_PROF_MM
KZFORT Indicator: Determine progress values for production order CHAR 1 0 KZFORT
OCM_PROF Profile for OCM PP / PS CHAR 6 0 TCO47 OCM_PROFILE
ROUT_TEXT Indicator: Copy text from routing header CHAR 1 0 CO_ROUT_TEXT
UPD_ONLY Costs are only updated CHAR 1 0 CN_UPD_ONLY
MBWEW Material Documents: Goods Receipt for WIP Batch CHAR 1 0 MBWEW
WIPBATCH_GM Indicator: Goods Movement for a WIP Batch CHAR 1 0 CO_WIPB_FLG_GM
LFE_DEF_RULE Linear Data - Order Operation Default Rules CHAR 1 0 EAML_LFE_DEF_RULE_ORD
No defaulting of linear data in order operation
1 Default from reference object in order header
2 Default from order header
3 Default from technical object in operation only
4 Default from tech. obj. in op. (preferably) or header
FLG_READ Read BOM when Converting Planned Order CHAR 1 0 READ_MAS
Do Not Read
1 Read with Explosion Date from Planned Order
2 Read with Newly Determined Explosion Date
EAMCC4_CONT_DET Enabling the Determination of Contracts for Orders CHAR 1 0 EAMCC4_CONTRACT_DET
Disabled
X Enabled
PROCMTINTEGRATIONSCENARIO Procurement Mode Indicator for Customizing CHAR 1 0 PROCMTINTEGRATIONSCENARIO
/CUM/INDCU CU: Order is Used for Compatible Units CHAR 1 0 /CUM/INDCU
/CUM/AUEST CU: Automatic Copy of Estimated Costs CHAR 1 0 /CUM/AUEST
OIHANTYP Excise Duty Handling Type CHAR 2 0 OIH5 OIH_HANTYP
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D

T399X foreign key relationships

Table Field Check Table Check Field
0 T399X ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
0 T399X ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
1 T399X AUART T003O Order Types AUART
0 T399X AWSLS TKV01 Variance Keys: Cost Centers/Costing MANDT
0 T399X AWSLS TKV01 Variance Keys: Cost Centers/Costing AWOBA
0 T399X AWSLS TKV01 Variance Keys: Cost Centers/Costing AWSLS
1 T399X BWTAR T149D Global Valuation Types MANDT
1 T399X BWTAR T149D Global Valuation Types BWTAR
0 T399X CAPID TC04 Applic-Specific Criteria for Alternative Determination MANDT
0 T399X CAPID TC04 Applic-Specific Criteria for Alternative Determination CAPID
1 T399X CHSCH T683 Pricing procedures KAPPL
1 T399X CHSCH T683 Pricing procedures KALSM
0 T399X CPSLID TCA43 Automatic selection of task lists (alternatives) MANDT
0 T399X CPSLID TCA43 Automatic selection of task lists (alternatives) SEL_ID
0 T399X CPSLID TCA43 Automatic selection of task lists (alternatives) SEL_PR
1 T399X DFREG TKB2A Default Rules for Posting Rules MANDT
0 T399X DWBPROF TCOAD Object profile - detail list - order information system MANDT
0 T399X DWBPROF TCOAD Object profile - detail list - order information system TABNAME
0 T399X DWBPROF TCOAD Object profile - detail list - order information system PROFID
0 T399X DWBPROF TCOAD Object profile - detail list - order information system PRF_ORIGIN
1 T399X E_DISPO T024D MRP Controllers MANDT
1 T399X E_DISPO T024D MRP Controllers WERKS
1 T399X E_DISPO T024D MRP Controllers DISPO
0 T399X E_FEVOR T024F Production scheduler WERKS
1 T399X FTLPROF T441C Profile - availability check MANDT
1 T399X FTLPROF T441C Profile - availability check TABNAME
1 T399X FTLPROF T441C Profile - availability check PROFID
0 T399X FTLPROFNET T441C Profile - availability check MANDT
0 T399X FTLPROFNET T441C Profile - availability check TABNAME
0 T399X FTLPROFNET T441C Profile - availability check PROFID
1 T399X KLVARI TCK03 Costing Variants MANDT
0 T399X KLVARP TCK03 Costing Variants MANDT
1 T399X MANDT T000 Clients MANDT
0 T399X OCM_PROF TCO47 Change profile for Order Change Management MANDT
0 T399X OCM_PROF TCO47 Change profile for Order Change Management PROFILE
1 T399X OIHANTYP OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) MANDT
1 T399X OIHANTYP OIH5 Definition of Excise Duty Handling Type (IS-OIL-TDP) HANTYP
0 T399X PLNTY TCA01 Task list types MANDT
1 T399X PRF_GROUPE TCNG Network/hierarchy graphics: graphics profile MANDT
1 T399X PRF_GROUPE TCNG Network/hierarchy graphics: graphics profile PRF_GRUPPE
1 T399X PRF_GROUPE TCNG Network/hierarchy graphics: graphics profile PRF_NAME
1 T399X PRF_GROUPE TCNG Network/hierarchy graphics: graphics profile PRF_INDEX
0 T399X PROF_GR TCOP Field selection profile MANDT
0 T399X PROF_GR TCOP Field selection profile TABNAME
0 T399X PROF_GR TCOP Field selection profile PROFID
1 T399X PRUEFART TQ30 Inspection types MANDT
1 T399X PRUEFART TQ30 Inspection types ART
0 T399X RSTRA T499Q Reduction strategies MANDT
1 T399X STRAT TCN08 Strategies for determining a settlement rule MANDT
0 T399X WERKS T001W Plants/Branches WERKS