I_TransBsdMatlValueChainItem

Purpose
This CDS view displays material inventory values for the materials with price determination control 2 within a selected range of periods. This CDS view provides the data to answer the following business questions: What were the inventory amounts and valuation quantities grouped at the MaterialLedgerCategory / Process Category ProcurementAlternative / ProductionProcess / MovementType / GLAccount level within the selected range of periods? Note When using this CDS view, note that: It only contains materials with Material Price Determination Control: 2 (Transaction-Based) . Signs are reversed in columns ( TotalVltdStockQuantity , InventoryAmtInDspCrcy , InvtryTransacAmtInDisplayCrcy , PriceDiffAmtInDisplayCrcy , ExchRateDiffAmtInDspCurrency ) of Consumption records ( MaterialLedgerCategory = VN ). Signs are reversed in the InvtryTransacAmtInDisplayCrcy column in Ending Inventory records ( MaterialLedgerCategory = EB ). To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: BUKRS_GLRLDNR_GLRRCTY_GLRVERS ( Company Code / Ledger / Record Type / Version ) BWKEY (Valuation Area) MTART (Material Type) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included. The CDS View is included in the business catalog SAP_A4C_BC_DEV_TST_FIN_IA0_PC .

Structure
Parameters The parameters of the CDS view are as follows: P_FromFiscalYearPeriod P_ToFiscalYearPeriod These parameters are used to define the fiscal period range. Example P_FromFiscalYearPeriod = 2024001 P_ToFiscalYearPeriod = 2024006 Important Fields Important fields in this view include the following: Field Attribute Field Name Description Key CostEstimate Cost Estimate Number Key CurrencyRole Currency/Valuation Key Ledger Ledger Key FiscalYearPeriod Fiscal Year Period Key MaterialLedgerCategory Material Ledger Category Key ProcessCategory Process Category Key MatlLdgrDocIsCostingRelevant Material Ledger Document Is Costing Relevant Key ProcurementAlternative Procurement Alternative/Process Key ProductionProcess Production Process Key MovementType Movement Type Key GLAccount General Ledger Account Attribute PriceDeterminationControl Material Price Determination: Control Attribute ValuationArea Valuation Area Attribute Material Material Attribute InventoryValuationType Valuation Type Attribute SalesOrder SD Document Attribute SalesOrderItem Item (SD) Attribute InventorySpecialStockType Special Stock Attribute Supplier Supplier Attribute WBSElementExternalID WBS Element Text MaterialLedgerCategoryText Material Ledger Category Text Text ProcessCategoryName Process Category Text Text MovementTypeName Movement Type Text Text GLAccountName General Ledger Account Name Text InventorySpecialStockTypeName Special Stock Description Value TotalVltdStockQuantity Quantity Unit ValuationQuantityUnit Quantity Unit Value InventoryAmtInDspCrcy Actual Value Value InvtryTransacAmtInDisplayCrcy Preliminary Value Value PriceDiffAmtInDisplayCrcy Price Difference Value ExchRateDiffAmtInDspCurrency Exch.Rate Diff. Unit Currency Currency Attribute ControllingArea Controlling Area Attribute ControllingValuationType Valuation View