I_US_EPCRAINVTRYVW

CDS View
11 Fields 1 CDS Views

EPCRA: Inventory Master Data View

I_US_EPCRAINVTRYVW is a CDS View in S/4HANA. EPCRA: Inventory Master Data View. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_US_EPCRAInvtryTierOneDimn view from COMPOSITE EPCRA: Inventory Reporting Tier 1

Fields (11)

KeyField CDS FieldsUsed in Views
KEY Plant Plant 1
KEY Product Product 1
KEY StockReportingDate StockReportingDate 1
KEY StockUnit StockUnit 1
KEY StorageLocation StorageLocation 1
AvailableStockQuantity AvailableStockQuantity 1
ChemicalUUID ChemicalUUID 1
CompanyCode CompanyCode 1
US_EPCRAContainerType US_EPCRAContainerType 1
US_EPCRAHasMultipleChmlAssgd US_EPCRAHasMultipleChmlAssgd 1
US_EPCRAStorageCondition US_EPCRAStorageCondition 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.

-- EPCRA: Inventory Master Data View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_US_EPCRAINVTRYVW (
    PLANT,
    PRODUCT,
    STOCKREPORTINGDATE,
    STOCKUNIT,
    STORAGELOCATION,
    AVAILABLESTOCKQUANTITY,
    CHEMICALUUID,
    COMPANYCODE,
    US_EPCRACONTAINERTYPE,
    US_EPCRAHASMULTIPLECHMLASSGD,
    US_EPCRASTORAGECONDITION,
    PRIMARY KEY (PLANT, PRODUCT, STOCKREPORTINGDATE, STOCKUNIT, STORAGELOCATION)
);

Learn More