Fields (41)
| Key | Field | CDS Fields | Used 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
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA