T459K
Control table for customer requirements
T459K is an SAP database table in S/4HANA. Control table for customer requirements. It contains 41 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_IndependentRqmtClass | view_entity | from | BASIC | Independent Requirement Class |
| I_PlndIndepRqmtRqmtType | view_entity | inner | BASIC | Planned Independent Requirement Type |
| I_PlndIndepRqmtType | view | inner | BASIC | Planned Independent Requirement Type |
| P_ABOPFieldCatalog | view | left_outer | BASIC | ABOP Field Catalog |
Fields (41)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | bedar | bedar | Reqmts Class | |||
| atppr | atppr | Availability | ||||
| bedsd | bedsd | Requirements | ||||
| nodis | nodis | No MRP | ||||
| vpzuo | vpzuo | Allocation Ind. | ||||
| knttp | knttp | Acct Assgmt Cat | ||||
| aprof | aprof | Settlmt Profile | ||||
| abgrs | abgr_schl | RA Key | ||||
| pabkz | pabkz | Ind.req.reductn | ||||
| plnkz | plnkz | Planning ind. | ||||
| zuvkz | dzuvkz | Consumption | ||||
| bdtyp | bdtyp | Reqmts category | ||||
| konfi | konfi | Configuration | ||||
| kalku | kalku_d | Costing | ||||
| kalsm_k | aufkalsm | Costing Sheet | ||||
| konfv | konfv | Cons.of config. | ||||
| mntga | mntga | Assembly Type | ||||
| auart | aufart | Order Type | ||||
| vkomp | vkomp | Avail.Components | ||||
| diagm | diagm | Online Assembly | ||||
| autpl | autpl | Automatic plnng | ||||
| vkapa | vkapa | Capacity check | ||||
| kalart | ck_kalart | Costing Method | ||||
| kalvar | ck_klvar | Costing Variant | ||||
| ksueb | ksueb | Copy Cstg Sheet | ||||
| dirkst | dirkst | DirCost recipient | ||||
| sdupd | sdupd | No update | ||||
| quota | quota | Prod.allocation | ||||
| kzakp | kzakp | TypeComp.chk | ||||
| kzbws | kzbws | Valuation | ||||
| aucost | aucost | Costing ID | ||||
| bwst3 | ck_bwst3 | W/o Val. Strat. | ||||
| mntkal | mntkal | Order costing | ||||
| kschl_ko | kschl_ko | CndTypLineItems | ||||
| kschl_kof | kschl_kof | CondTypLinItFix | ||||
| ocmact | co_flgocm | OrderChgMngmnt | ||||
| fkber | fkber | Functional Area | ||||
| slist | sr_slist | Strategy Seq. | ||||
| modfg | sr_modiflag | Changeable | ||||
| iconc | iconc | ICON Av. Check |
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.
-- Control table for customer requirements
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T459K (
MANDT, -- Client [mandt]
BEDAR, -- Reqmts Class [bedar]
ATPPR, -- Availability [atppr]
BEDSD, -- Requirements [bedsd]
NODIS, -- No MRP [nodis]
VPZUO, -- Allocation Ind. [vpzuo]
KNTTP, -- Acct Assgmt Cat [knttp]
APROF, -- Settlmt Profile [aprof]
ABGRS, -- RA Key [abgr_schl]
PABKZ, -- Ind.req.reductn [pabkz]
PLNKZ, -- Planning ind. [plnkz]
ZUVKZ, -- Consumption [dzuvkz]
BDTYP, -- Reqmts category [bdtyp]
KONFI, -- Configuration [konfi]
KALKU, -- Costing [kalku_d]
KALSM_K, -- Costing Sheet [aufkalsm]
KONFV, -- Cons.of config. [konfv]
MNTGA, -- Assembly Type [mntga]
AUART, -- Order Type [aufart]
VKOMP, -- Avail.Components [vkomp]
DIAGM, -- Online Assembly [diagm]
AUTPL, -- Automatic plnng [autpl]
VKAPA, -- Capacity check [vkapa]
KALART, -- Costing Method [ck_kalart]
KALVAR, -- Costing Variant [ck_klvar]
KSUEB, -- Copy Cstg Sheet [ksueb]
DIRKST, -- DirCost recipient [dirkst]
SDUPD, -- No update [sdupd]
QUOTA, -- Prod.allocation [quota]
KZAKP, -- TypeComp.chk [kzakp]
KZBWS, -- Valuation [kzbws]
AUCOST, -- Costing ID [aucost]
BWST3, -- W/o Val. Strat. [ck_bwst3]
MNTKAL, -- Order costing [mntkal]
KSCHL_KO, -- CndTypLineItems [kschl_ko]
KSCHL_KOF, -- CondTypLinItFix [kschl_kof]
OCMACT, -- OrderChgMngmnt [co_flgocm]
FKBER, -- Functional Area [fkber]
SLIST, -- Strategy Seq. [sr_slist]
MODFG, -- Changeable [sr_modiflag]
ICONC, -- ICON Av. Check [iconc]
PRIMARY KEY (MANDT, BEDAR)
);
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