R_MATLVALNINVTRYPERFSCLPERDBSC

CDS View
25 Fields 3 CDS Views

M EXTRACT with mocked references

R_MATLVALNINVTRYPERFSCLPERDBSC is a CDS View in S/4HANA. M EXTRACT with mocked references. It contains 25 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_Matval_Manage_Bal view from COMPOSITE Base View for Mat.Val., Balances
P_Matval_Manage_Bal view union_all COMPOSITE Base View for Mat.Val., Balances
R_MatlValnInvtryPerFsclPerd view_entity from COMPOSITE M EXTRACT with references

Fields (25)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 2
KEY CostEstimate CostEstimate 2
KEY FiscalYearPeriod FiscalYearPeriod 1
KEY GLAccountLineItem GLAccountLineItem 1
KEY Ledger Ledger 1
KEY Material Material 2
KEY ValuationArea ValuationArea 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 1
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 1
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 1
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 1
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 1
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 1
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 1
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 1
AmountInGlobalCurrency AmountInGlobalCurrency 1
InventoryValuationType InventoryValuationType 1
InvtryValnSpecialStockType InvtryValnSpecialStockType 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
Supplier Supplier 1
ValuationQuantity ValuationQuantity 1
WBSElementInternalID WBSElementInternalID 1

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.

-- M EXTRACT with mocked references
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_MATLVALNINVTRYPERFSCLPERDBSC (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    COSTESTIMATE,
    FISCALYEARPERIOD,
    GLACCOUNTLINEITEM,
    LEDGER,
    MATERIAL,
    VALUATIONAREA,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINGLOBALCURRENCY,
    INVENTORYVALUATIONTYPE,
    INVTRYVALNSPECIALSTOCKTYPE,
    SALESORDER,
    SALESORDERITEM,
    SUPPLIER,
    VALUATIONQUANTITY,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, COSTESTIMATE, FISCALYEARPERIOD, GLACCOUNTLINEITEM, LEDGER, MATERIAL, VALUATIONAREA)
);

Learn More