_PRODUCTRETAIL

24 Fields

_PRODUCTRETAIL is an SAP database table in S/4HANA. It contains 24 fields.

Fields (24)

KeyField CDS FieldsUsed in Views
_ConsumptionValueCategory _ConsumptionValueCategory 1
_ConsumptionValueCategoryText _ConsumptionValueCategoryText 1
_CountryOfOrigin _CountryOfOrigin 2
_CountryText _CountryText 2
_GoodsIssueText _GoodsIssueText 1
_GoodsIssueUnit _GoodsIssueUnit 1
_LoadingGroup _LoadingGroup 2
_LoadingGroupText _LoadingGroupText 2
_ProdExtAssortmentPriority _ProdExtAssortmentPriority 1
_ProdExtAssortmentPriorityText _ProdExtAssortmentPriorityText 1
_ProductServiceAgreement _ProductServiceAgreement 1
_ProductServiceAgreementT _ProductServiceAgreementT 1
_PurchasingGroup _PurchasingGroup 1
_RegionOfOrigin _RegionOfOrigin 2
_RegionText _RegionText 1
_SalesUnit _SalesUnit 1
_SalesUnitText _SalesUnitText 1
_ValuationClass _ValuationClass 1
_ValuationClassText _ValuationClassText 1
CountryOfOrigin CountryOfOrigin 1
LoadingGroup LoadingGroup 1
PurchasingGroup PurchasingGroup 1
RegionOfOrigin RegionOfOrigin 1
StoreListingProcedure StoreListingProcedure 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _PRODUCTRETAIL (
    _CONSUMPTIONVALUECATEGORY,
    _CONSUMPTIONVALUECATEGORYTEXT,
    _COUNTRYOFORIGIN,
    _COUNTRYTEXT,
    _GOODSISSUETEXT,
    _GOODSISSUEUNIT,
    _LOADINGGROUP,
    _LOADINGGROUPTEXT,
    _PRODEXTASSORTMENTPRIORITY,
    _PRODEXTASSORTMENTPRIORITYTEXT,
    _PRODUCTSERVICEAGREEMENT,
    _PRODUCTSERVICEAGREEMENTT,
    _PURCHASINGGROUP,
    _REGIONOFORIGIN,
    _REGIONTEXT,
    _SALESUNIT,
    _SALESUNITTEXT,
    _VALUATIONCLASS,
    _VALUATIONCLASSTEXT,
    COUNTRYOFORIGIN,
    LOADINGGROUP,
    PURCHASINGGROUP,
    REGIONOFORIGIN,
    STORELISTINGPROCEDURE
);

Learn More