I_PRODUCTRETAIL

CDS View
8 Fields 5 CDS Views

Product Retail Basic Data

I_PRODUCTRETAIL is a CDS View in S/4HANA. Product Retail Basic Data. It contains 8 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_ProdAssgblToStoreVH view_entity inner CONSUMPTION Product Assignable to Store
I_ActiveLogisticalProduct view inner COMPOSITE Active Logistical Product composite view
I_AssortmentModuleProductTP view_entity inner TRANSACTIONAL Product Assignable to Distribution Center
I_ProdAssgblToExplctMdlVersTP view_entity inner TRANSACTIONAL Product Assignable to Assortment Module Version
I_ProductRetailTP view from TRANSACTIONAL Product Retail BO Node (draft)

Fields (8)

KeyField CDS FieldsUsed in Views
KEY Product Product 1
ConsumptionValueCategory ConsumptionValueCategory 1
CountryOfOrigin CountryOfOrigin 1
GoodsIssueUnit GoodsIssueUnit 1
RegionOfOrigin RegionOfOrigin 1
SalesUnit SalesUnit 1
ServiceAgreement ServiceAgreement 1
ValuationClass ValuationClass 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.

-- Product Retail Basic Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PRODUCTRETAIL (
    PRODUCT,
    CONSUMPTIONVALUECATEGORY,
    COUNTRYOFORIGIN,
    GOODSISSUEUNIT,
    REGIONOFORIGIN,
    SALESUNIT,
    SERVICEAGREEMENT,
    VALUATIONCLASS,
    PRIMARY KEY (PRODUCT)
);

Learn More