SAP table T459K (Control table for customer requirements)

SAP table T459K has 2 primary key fields being MANDT,BEDAR.

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
BEDAR Requirements class CHAR 3 0 BEDAR
ATPPR SD availability check CHAR 1 0 ATPPR
BEDSD Transfer of requirements / Begin assembly order from SD CHAR 1 0 BEDSD
NODIS Requirements record not relevant to MRP CHAR 1 0 NODIS
Requirement planned
1 Requirement not planned, but displayed
2 Requirements neither planned or displayed
VPZUO Allocation Indicator CHAR 1 0 VPZUO
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
APROF Settlement Profile CHAR 6 0 TKB1A APROF
ABGRS Results Analysis Key CHAR 6 0 TKKAA ABGR_SCHL
PABKZ Requirements reduction indicator CHAR 1 0 PABKZ
No reduction of ind. reqmts (only in withdrwl for sales ord)
S No reduction of ind. reqmts (safety requirements)
V Reduction of ind. reqmts only for potential consumption
X Although no allocation takes place, ind. reqmts are reduced
PLNKZ Planning Indicator CHAR 1 0 PLNKZ
1 Net requirements planning
2 Gross requirements planning
3 Single-item planning
ZUVKZ Consumption Indicator CHAR 1 0 DZUVKZ
BDTYP Requirements category CHAR 1 0 BDTYP
KONFI Configuration allowed or required CHAR 1 0 KONFI
* Configuration is allowed
+ Configuration is mandatory
- Configuration is not allowed
KALKU Calculation Control CHAR 1 0 KALKU_D
KALSM_K Costing Sheet CHAR 6 0 T683 AUFKALSM
KONFV Consumption of configuration CHAR 1 0 KONFV
1 Consumption of selected characteristics planning
2 Consumption of BOM characteristics planning
MNTGA Assembly type NUMC 1 0 MNTGA
0 No assembly order processing
1 Planned order ("static" processing)
2 Production order, network or service (static processing)
3 Production order (dynamic processing)
4 Planned order (dynamic processing)
AUART Order Type CHAR 4 0 T003O AUFART
VKOMP Availability check at component level in assembly order CHAR 1 0 VKOMP
DIAGM Assembly: display production/planned order or components CHAR 1 0 DIAGM
No
1 Display missing parts
2 Display missing parts, then process components
3 Display and process missing parts (only in prod.order)
AUTPL Automatic start of make-to-order in background mode CHAR 1 0 AUTPL
VKAPA Display Capacity Availability CHAR 1 0 VKAPA
1 Lead time scheduling
2 Lead time scheduling and capacity check
KALART Costing Method CHAR 1 0 CK_KALART
1 Product Costing
2 Unit Costing
KALVAR Costing Variant CHAR 4 0 TCK03 CK_KLVAR
KSUEB Copy Costing Sheet into Dependent Objects CHAR 1 0 KSUEB
DIRKST Direct cost recipient CHAR 1 0 DIRKST
SDUPD No update of confirmation in assembly CHAR 1 0 SDUPD
QUOTA Product allocation active CHAR 1 0 QUOTA
KZAKP Indicator for type of component check CHAR 1 0 KZAKP
ATP check
1 Check against preliminary planning
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
AUCOST Costing activities indicator CHAR 1 0 AUCOST
A Automatic costing
B Automatic costing and marking
BWST3 Valuation with Standard Price of Make-to-Stock Inventory CHAR 1 0 CK_BWST3
MNTKAL Generate Sales Order Cost Estimate CHAR 1 0 MNTKAL
Copy preliminary cost estimate from production order
X Do not copy preliminary cost estimate from production order
KSCHL_KO Condition type for copying costs from line items CHAR 4 0 T685 KSCHL_KO
KSCHL_KOF Condition type for fixed cost transfer from line items CHAR 4 0 T685 KSCHL_KOF
OCMACT Trigger order change management CHAR 1 0 CO_FLGOCM
FKBER Functional Area CHAR 16 0 TFKB FKBER
SLIST Strategy Sequences for Automatic Generation of SETC CHAR 6 0 TKB10SLA SR_SLIST
MODFG Change Behavior During Automatic Generation of SETC NUMC 1 0 SR_MODIFLAG
1 Only Overwrite Unused Rules
2 Always Overwrite
3 Do Not Overwrite
ICONC ICON Availability Check CHAR 1 0 ICONC
No ICON Check
A Doc. Creation: Full Conf. w/o Check - ICON Changes in Batch
B Doc. Creation: 0 Conf. w/o Check - ICON Changes in Batch
C Like A, But Availability Check for SD (ATP)
D Like B, But Availability Check for SD (ATP)
MILL_PLKNZ Planning type of object CHAR 1 0 PLKNZ
Normal
1 Planned order: planned order (not convertible)

T459K foreign key relationships

Table Field Check Table Check Field
0 T459K ABGRS TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
0 T459K ABGRS TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
1 T459K APROF TKB1A Settlement Profile MANDT
1 T459K APROF TKB1A Settlement Profile APROF
0 T459K AUART T003O Order Types AUART
1 T459K FKBER TFKB Functional areas FKBER
0 T459K KALSM_K T683 Pricing procedures KAPPL
0 T459K KALSM_K T683 Pricing procedures KALSM
1 T459K KALVAR TCK03 Costing Variants MANDT
0 T459K KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
0 T459K KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
1 T459K KSCHL_KO T685 Conditions: Types KAPPL
1 T459K KSCHL_KO T685 Conditions: Types KSCHL
0 T459K KSCHL_KOF T685 Conditions: Types KAPPL
0 T459K KSCHL_KOF T685 Conditions: Types KSCHL
1 T459K SLIST TKB10SLA Strategy Sequences for Automatic Generation of SETC - Header MANDT