T001K
Valuation area
T001K is an SAP database table in S/4HANA. Valuation area. It contains 21 fields. 88 CDS views read from this table.
CDS Views using this table (88)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /dmbe/c_CrossStrategyLocation | view | inner | Cross Strategy Location Filter | |
| /dmbe/i_BusinessPartner_Vendor | view | inner | Vendor of a Business Partner | |
| Adk0_Dli_Wip_Detail_Vbl_View | view | inner | DLI WIP Detail View for SD Documents | |
| CIC_PLANT | view_entity | inner | Projection on Plant (Industry Cloud Solutions) | |
| CIC_PLANT_BASIC | view_entity | inner | Projection on Plant (Industry Cloud Solutions) | |
| e_mrp_currency | view | inner | ||
| F_Mmim_Bukrs_Plant | view | inner | Company Code for Plants | |
| F_Mmim_Mbew_Plant | view | inner | Inventory Valuation Type from MBEW | |
| FAC_AUDIT_Z3_Plant | view | inner | Plant | |
| FCML_ACT_PERDS_DDL | view | inner | CDS View for all relevant period (Actual Costing) | |
| FCML_FIND_MLDOC_WRONG_BUDAT_V | view | inner | CDS View to detect wrong BUDAT in MLDOC | |
| FCML_MAT_DDL | view | inner | CDS View with structure of table FCML_MAT | |
| FCML_MLDOC_EMPTY_BUDAT_DDL | view | inner | CDS View to detect empty BUDAT in MLDOC | |
| FCML_RLDNR | view | from | ML relevant currencies for SDM | |
| FINOC_RULE_MAT_BASE | view | inner | Orgl Change-Rule: Materials Base | |
| Fml_Curtp_Bukrs | view | inner | ML CURTP for BUKRS | |
| Fml_Relind_Bwkey | view | inner | ML Relevant Indicators per Bwkey | |
| fmlv_ckmlcr_compat | view | inner | Compatibility View for CKMLCR | |
| fmlv_ckmlct | view | inner | Replacement object for CKMLCT | |
| FMLV_CKMLKEV_UCT_UNION | view | inner | Material Ledger Cost Component Split w. cor CURTP | |
| FMLV_CKMLKEVLD_UNION | view | inner | ML Currency Table for CKMLKEVLD w. cor. EXT_CURTP & RLDNR | |
| FMLV_CKMLLACR_UCT_UNION | view | inner | ML Activity Type: Period Record/Currency Record | |
| fmlv_ckmlpr_compat | view | inner | Compatibility View for CKMLPR | |
| FMLV_CKMLPR_COMPAT_DB | view | inner | Compatibility View for CKMLPR | |
| FMLV_CKMLPRKEKO_UCT_UNION | view | inner | Material Ledger: Cost Component Split (Header) for Prices | |
| FMLV_CKMLPRKEPH_UCT_UNION | view | inner | Material Ledger: Cost Component Split (Elements) for Prices | |
| FMLV_F4_ML | view | inner | Select ML relevant currencies | |
| I_ACMApplDocData | view | left_outer | BASIC | Application Document Item |
| I_ACMPlantSearchVH | view | from | BASIC | Plant Search Help |
| I_MaterialLedgerInventory | view | inner | BASIC | select data from CKMLHD |
| I_MLPricePersistedPeriod | view | inner | COMPOSITE | Periods for ML Prices per Currency |
| I_PlndOrdCustCoByPlant | view_entity | inner | BASIC | Planned Order Customer Company By Plant |
| I_PlndOrdSupplierCoByPlant | view_entity | inner | BASIC | Planned Order Supplier Company By Plant |
| I_ProdSalesOrderStockValuation | view_entity | inner | BASIC | Product Sales Order Stock Valuation |
| I_ProductListPlant | view_entity | inner | BASIC | Product list Plant |
| I_ProductListValuation | view_entity | inner | BASIC | Product list Valuation |
| I_ProductPlantMRP | view | inner | BASIC | MRP area data of a Product |
| I_ProductPlantSupplyPlanning | view_entity | inner | BASIC | Product Plant Supply Planning |
| I_ProductProjectStockValuation | view_entity | inner | BASIC | Product Project Stock Valuation |
| I_ProductSupplyPlanning | view | inner | BASIC | Product SupPlanning active core entity |
| I_ProductValuation | view | inner | COMPOSITE | Product Valuation |
| I_ProductValuationAccounting_2 | view_entity | inner | BASIC | Product Valuation Account |
| I_ProductValuationAcct | view | inner | BASIC | Product Valuation Account |
| I_ProductValuationBasic | view | inner | BASIC | Product Valuation |
| I_ProductValuationCosting | view | inner | BASIC | Product Valuation Costing Core Entity |
| I_ProdVltdStockSubcontractor | view_entity | inner | BASIC | Prod Valuated Stock with Subcontractor |
| I_Purreqvaluationarea | view | from | BASIC | Valuation Area |
| I_SupDmndOvwPlant | view | left_outer | BASIC | Basic view for Plant |
| I_ValuationArea | view | from | BASIC | Valuation Area |
| M_V_EBAN_EOP | view | inner | Relevant fields with for setting the EOP-Flag in EBAN | |
| Mbv_J_1ambew | view | inner | Compatibility view for J_1AMBEW view (ML integration) | |
| ml4h_cds_mv003 | view | inner | Mapping MLDOC at MV003 | |
| ml4h_cds_mv004 | view | inner | Mapping MLDOC at MV004 | |
| ml4h_cds_wipred | view | inner | Read WIP Reduction | |
| NSDM_e_J_3RM_MARCMARA_B | view | inner | J_3RM_MARCMARA_B Compatibility View | |
| NSDM_E_MMBE_MARC_V | view | inner | MMBE_MARC_V Compatibility View | |
| P_CO_DIANInventoryGLAccount | view | inner | CONSUMPTION | |
| P_DGR_HLRFrwd_FillCompanyCode | view | left_outer | COMPOSITE | |
| P_FBV_PAR_SEL_MAT | view | inner | BASIC | |
| P_Matval_Manage_13_Periods | view | inner | BASIC | |
| P_Matval_Manage_Bal | view | inner | BASIC | |
| P_Matval_Manage_Bal_Split | view | inner | BASIC | |
| P_MATVAL_MANAGE_CKML | view | inner | BASIC | |
| P_Matval_Manage_Cost | view | inner | BASIC | |
| P_Matval_Manage_Max | view | union_all | BASIC | |
| P_Matval_Manage_Max | view | from | BASIC | |
| P_Matval_Manage_Md | view | inner | BASIC | |
| P_Matval_Manage_Pnv_Pre | view | inner | BASIC | |
| P_Matval_Manage_Val_Chart | view | inner | BASIC | |
| P_ML_Prices_Hdcr | view | inner | BASIC | |
| P_MLPricePersistedPeriod | view | inner | BASIC | |
| P_MRPPlantCurrency | view | inner | BASIC | |
| P_PhysIntryValuationArea | view | from | COMPOSITE | |
| P_PLANTCURRENCY | view | inner | BASIC | |
| P_WRNTYCNTRYPRICEPROCEDURE | view | from | BASIC | Pricing procedure view for Warranty |
| R_MatlPriceSpclStockValnStrgy | view | inner | COMPOSITE | Mat Price Spec Stock Valuation Strategy |
| V_MaterialLedgerPriceBasic1 | view | inner | Basic view 1 for material price | |
| v_ml_acc_delta_view | view | inner | LOCAL: Material Ledger Periods | |
| v_ml_account_l2_view | view | inner | LOCAL: Material Ledger Periods | |
| v_ml_invacc_l1_view | view | inner | Inventory stock - accounts | |
| v_ml_invacc_l2_view | view | inner | Inventory stock - accounts | |
| v_ml_mig_mlpack_view | view | inner | Migration: Material Ledger - Packages | |
| v_ml_mig_rc1a_l1_view | view | inner | Check if configuration for account determination is missing | |
| v_ml_mig_rc1a_l2_view | view | inner | Check if configuration for account determination is missing | |
| v_ml_p_gap_l2_view | view | inner | LOCAL: Material Ledger Gap in Periods | |
| v_ml_perio_l1_view | view | inner | LOCAL: Material Ledger Periods | |
| V_Mmim_DDL_Om_Param_PI | view | inner | Physical Inventory Parameters | |
| vfco_dll_va88_l1 | view | left_outer |
Fields (21)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | bwkey | BWKEY | Valuation Area | |||
| bukrs | BUKRS | Company Code | ||||
| bwmod | BWMOD | Val.Grpg Code | ||||
| xbkng | XBKNG | Negative stocks | ||||
| mlbwa | CK_ML_BWAC | ML Act. | ||||
| mlbwv | CK_ML_BWAV | ML Comp. | ||||
| xvkbw | XVKBW | SalesPr.valuat. | ||||
| erklaerkom | ERKLAERKOM | Explanation Facility | ||||
| uprof | UPROF_D | Rev.profile | ||||
| wbpro | WBPRO | Profile vIM | ||||
| mlast | CK_ML_ABST | Price Determ. | ||||
| mlasv | CK_ML_ABSV | Price.Determ.Binding | ||||
| bdifp | BDIFP | Stock corr. tol. | ||||
| xlbpd | XLBPD | PrDiff. GR SC | ||||
| xewrx | XEWRX | Post recpt val. | ||||
| x2fdo | X2FDO | Two documents | ||||
| prsfr | PRSFRG | Price Release | ||||
| mlccs | CK_MLCCS | ActCstCmpSplit | ||||
| xefre | XEFRE | Delivery costs | ||||
| efrej | EFREJ | From year |
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.
-- Valuation area
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T001K (
MANDT, -- Client [MANDT]
BWKEY, -- Valuation Area [BWKEY]
BUKRS, -- Company Code [BUKRS]
BWMOD, -- Val.Grpg Code [BWMOD]
XBKNG, -- Negative stocks [XBKNG]
MLBWA, -- ML Act. [CK_ML_BWAC]
MLBWV, -- ML Comp. [CK_ML_BWAV]
XVKBW, -- SalesPr.valuat. [XVKBW]
ERKLAERKOM, -- Explanation Facility [ERKLAERKOM]
UPROF, -- Rev.profile [UPROF_D]
WBPRO, -- Profile vIM [WBPRO]
MLAST, -- Price Determ. [CK_ML_ABST]
MLASV, -- Price.Determ.Binding [CK_ML_ABSV]
BDIFP, -- Stock corr. tol. [BDIFP]
XLBPD, -- PrDiff. GR SC [XLBPD]
XEWRX, -- Post recpt val. [XEWRX]
X2FDO, -- Two documents [X2FDO]
PRSFR, -- Price Release [PRSFRG]
MLCCS, -- ActCstCmpSplit [CK_MLCCS]
XEFRE, -- Delivery costs [XEFRE]
EFREJ, -- From year [EFREJ]
PRIMARY KEY (MANDT, BWKEY)
);
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