R_SrvcPartsDealerProdClusterTP

DDL: R_SRVCPARTSDEALERPRODCLUSTERTP Type: view_entity TRANSACTIONAL
14 Fields 1 Data Sources

Dealer Product Cluster - TP

R_SrvcPartsDealerProdClusterTP is a Transactional CDS View that provides data about "Dealer Product Cluster - TP" in SAP S/4HANA. It reads from 1 data source (I_SrvcPartsDealerProdCluster) and exposes 14 fields with key fields PlanningVersionExternal, Product, Location, SrvcPartsClusterType.

Data Sources (1)

SourceAliasJoin Type
I_SrvcPartsDealerProdCluster I_SrvcPartsDealerProdCluster from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Dealer Product Cluster - TP view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PlanningVersionExternal PlanningVersionExternal
KEY Product Product Product Sold
KEY Location Location Text
KEY SrvcPartsClusterType SrvcPartsClusterType
SrvcPartsClusterValueCode SrvcPartsClusterValueCode
ProductInternalUUID ProductInternalUUID
LocationUUID LocationUUID UUID
PlanningVersionUUID
SrvcPartsPlanningVersionUUID SrvcPartsPlanningVersionUUID
BusinessPartner BusinessPartner Issuing Authority
_Location _Location
_Product _Product
_DealerProduct _DealerProduct
_LocationBasic _LocationBasic

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 R_SrvcPartsDealerProdClusterTP.
-- 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.

CREATE VIEW R_SrvcPartsDealerProdClusterTP AS
SELECT
  PlanningVersionExternal,
  Product,
  Location,
  SrvcPartsClusterType,
  SrvcPartsClusterValueCode,
  ProductInternalUUID,
  LocationUUID,
  cast( SrvcPartsPlanningVersionUUID as lca_planversion preserving type ) AS PlanningVersionUUID,
  SrvcPartsPlanningVersionUUID,
  BusinessPartner
FROM I_SrvcPartsDealerProdCluster
;

Learn More