_PRODUCTRETAIL

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

Fields (41)

KeyField CDS FieldsUsed in Views
_ConsumptionValueCategory _ConsumptionValueCategory 1
_ConsumptionValueCategoryText _ConsumptionValueCategoryText 3
_CountryOfOrigin _CountryOfOrigin 4
_CountryText _CountryText 2
_GoodsIssueText _GoodsIssueText 1
_GoodsIssueUnit _GoodsIssueUnit 3
_LoadingGroup _LoadingGroup 2
_LoadingGroupText _LoadingGroupText 2
_ProdExtAssortmentPriority _ProdExtAssortmentPriority 1
_ProdExtAssortmentPriorityText _ProdExtAssortmentPriorityText 3
_ProductServiceAgreement _ProductServiceAgreement 1
_ProductServiceAgreementT _ProductServiceAgreementT 1
_PurchasingGroup _PurchasingGroup 1
_RegionOfOrigin _RegionOfOrigin 2
_RegionText _RegionText 1
_SalesUnit _SalesUnit 3
_SalesUnitText _SalesUnitText 3
_ValuationClass _ValuationClass 3
_ValuationClassText _ValuationClassText 2
AssortmentGrade AssortmentGrade 2
ConsumptionValueCategory ConsumptionValueCategory 2
CountryOfOrigin CountryOfOrigin 3
DistrCntrListingEndDate DistrCenterListingEndDate 2
DistrCntrListingProcedure DistrCenterListingProcedure 2
DistrCntrListingStartDate DistrCenterListingStartDate 2
DistrCntrSaleEndDate DistributionCenterSaleEndDate 2
DistrCntrSaleStartDate DistrCenterSaleStartDate 2
GoodsIssueUnit GoodsIssueUnit 2
LoadingGroup LoadingGroup 3
ProdExtAssortmentPriority ProdExtAssortmentPriority 2
PurchasingGroup PurchasingGroup 3
RegionOfOrigin RegionOfOrigin 3
SalesUnit SalesUnit 2
ServiceAgreement ServiceAgreement 2
StoreListingEndDate StoreListingEndDate 2
StoreListingProcedure StoreListingProcedure 2
StoreListingStartDate StoreListingStartDate 2
StoreSaleEndDate StoreSaleEndDate 2
StoreSaleStartDate StoreSaleStartDate 2
ValuationClass ValuationClass 2
ValuationMargin ValuationMarginPercent 2

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,
    ASSORTMENTGRADE,
    CONSUMPTIONVALUECATEGORY,
    COUNTRYOFORIGIN,
    DISTRCNTRLISTINGENDDATE,
    DISTRCNTRLISTINGPROCEDURE,
    DISTRCNTRLISTINGSTARTDATE,
    DISTRCNTRSALEENDDATE,
    DISTRCNTRSALESTARTDATE,
    GOODSISSUEUNIT,
    LOADINGGROUP,
    PRODEXTASSORTMENTPRIORITY,
    PURCHASINGGROUP,
    REGIONOFORIGIN,
    SALESUNIT,
    SERVICEAGREEMENT,
    STORELISTINGENDDATE,
    STORELISTINGPROCEDURE,
    STORELISTINGSTARTDATE,
    STORESALEENDDATE,
    STORESALESTARTDATE,
    VALUATIONCLASS,
    VALUATIONMARGIN
);