I_ProductRetailTP

DDL: I_PRODUCTRETAILTP SQL: IPRDRETAILTP Type: view TRANSACTIONAL Package: VDM_MD_PRODUCT
22 Fields 1 Data Sources

Product Retail BO Node (draft)

I_ProductRetailTP is a Transactional CDS View that provides data about "Product Retail BO Node (draft)" in SAP S/4HANA. It reads from 1 data source (I_ProductRetail) and exposes 22 fields with key field Product. Part of development package VDM_MD_PRODUCT.

Data Sources (1)

SourceAliasJoin Type
I_ProductRetail ProductRetail from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPRDRETAILTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Product Retail BO Node (draft) view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductRetail Product Product Sold
CountryOfOrigin I_ProductRetail CountryOfOrigin Country/Region of Origin
ServiceAgreement I_ProductRetail ServiceAgreement Service agreemt
ConsumptionValueCategory I_ProductRetail ConsumptionValueCategory ABC Indicator
GoodsIssueUnit I_ProductRetail GoodsIssueUnit Unit of Issue
RegionOfOrigin I_ProductRetail RegionOfOrigin Reg. of Origin
SalesUnit I_ProductRetail SalesUnit Unit
ValuationClass I_ProductRetail ValuationClass Valuation Class
_ProductServiceAgreement _ProductServiceAgreement
_ProductServiceAgreementT _ProductServiceAgreementT
_CountryOfOrigin _CountryOfOrigin
_CountryText _CountryText
_ConsumptionValueCategory _ConsumptionValueCategory
_ConsumptionValueCategoryText _ConsumptionValueCategoryText
_GoodsIssueUnit _GoodsIssueUnit
_GoodsIssueText _GoodsIssueText
_RegionOfOrigin _RegionOfOrigin
_RegionText _RegionText
_SalesUnit _SalesUnit
_SalesUnitText _SalesUnitText
_ValuationClass _ValuationClass
_ValuationClassText _ValuationClassText

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ProductRetailTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPRDRETAILTP

CREATE VIEW I_ProductRetailTP AS
SELECT
  ProductRetail.Product AS Product,
  ProductRetail.CountryOfOrigin AS CountryOfOrigin,
  ProductRetail.ServiceAgreement AS ServiceAgreement,
  ProductRetail.ConsumptionValueCategory AS ConsumptionValueCategory,
  ProductRetail.GoodsIssueUnit AS GoodsIssueUnit,
  ProductRetail.RegionOfOrigin AS RegionOfOrigin,
  ProductRetail.SalesUnit AS SalesUnit,
  ProductRetail.ValuationClass AS ValuationClass
FROM I_ProductRetail AS ProductRetail
;

Learn More