C_ProdCmplncLglEntityMappingTP

DDL: C_PRODCMPLNCLGLENTITYMAPPINGTP Type: view_entity CONSUMPTION
35 Fields 1 Data Sources 1 Associations

Product Compliance Legal Entity Mapping

C_ProdCmplncLglEntityMappingTP is a Consumption CDS View that provides data about "Product Compliance Legal Entity Mapping" in SAP S/4HANA. It reads from 1 data source (I_ProdCmplncLglEntityMappingTP) and exposes 35 fields with key field ProdCmplncLglEntyMappgUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProdCmplncLglEntityMappingTP I_ProdCmplncLglEntityMappingTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_ProdCmplncLglEntityMappgHist _LegalEntityMappingHistory $projection.CmplRqUUID = _LegalEntityMappingHistory.CmplRqUUID and $projection.SVTBusinessProcessScenario = _LegalEntityMappingHistory.SVTBusinessProcessScenario and $projection.ProductionCompanyCode = _LegalEntityMappingHistory.ProductionCompanyCode and $projection.ReceivingCompanyCode = _LegalEntityMappingHistory.ReceivingCompanyCode and $projection.SellingCompanyCode = _LegalEntityMappingHistory.SellingCompanyCode and $projection.ProductionPlant = _LegalEntityMappingHistory.ProductionPlant and $projection.ReceivingPlant = _LegalEntityMappingHistory.ReceivingPlant and $projection.SellingPlant = _LegalEntityMappingHistory.SellingPlant

Annotations (10)

NameValueLevelField
EndUserText.label Product Compliance Legal Entity Mapping view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
ObjectModel.representativeKey ProdCmplncLglEntyMappgUUID view
ObjectModel.modelingPattern #TRANSACTIONAL_ENTITY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY ProdCmplncLglEntyMappgUUID ProdCmplncLglEntyMappgUUID LE Mapping UUID
ProdCmplncLegalEntityUUID ProdCmplncLegalEntityUUID Legal Entity UUID
CmplRqUUID CmplRqUUID Compl Req.
ComplianceRequirement ComplianceRequirement Compliance Requirement
CmplRqApplicationComponent _CmplRq CmplRqApplicationComponent Solution Area
CmplRqApplicationComponentNamelocalized
ProductionCompanyCode ProductionCompanyCode Prodn Co Code
ProductionCompanyCodeName _ProductionCompany CompanyCodeName Company Name
ReceivingCompanyCode ReceivingCompanyCode Rcvg Co Code
ReceivingCompanyCodeName _ReceivingCompany CompanyCodeName Company Name
SellingCompanyCode SellingCompanyCode Selling Company Code
SellingCompanyCodeName _SellingCompany CompanyCodeName Company Name
ProductionPlant ProductionPlant Prod plnt
ProductionPlantName _ProductionPlant PlantName Plant Name
ReceivingPlant ReceivingPlant Receiving Plant
ReceivingPlantName _ReceivingPlant PlantName Plant Name
SellingPlant SellingPlant Selling Plant
SellingPlantName _SellingPlant PlantName Plant Name
PCLglEntyMappgValidFromDate PCLglEntyMappgValidFromDate
PCLglEntyMappgValidToDate PCLglEntyMappgValidToDate
ProdCmplncLegalEntity _ProdCmplncLegalEntity ProdCmplncLegalEntity
ProdCmplncLegalEntityDesc _ProdCmplncLegalEntity ProdCmplncLegalEntityDesc
SVTBusinessProcessScenario SVTBusinessProcessScenario Scenario
Plant _Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
CompanyCode _CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
SVTBusinessProcessText _BPText CmplRqSVTScenarioText
PCLglEntyMappgIsUsedInSVT PCLglEntyMappgIsUsedInSVT
PCLglEntyMappgIsDeleted PCLglEntyMappgIsDeleted
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_LegalEntityMappingHistory _LegalEntityMappingHistory

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 C_ProdCmplncLglEntityMappingTP.
-- 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 C_ProdCmplncLglEntityMappingTP AS
SELECT
  ProdCmplncLglEntyMappgUUID,
  ProdCmplncLegalEntityUUID,
  CmplRqUUID,
  ComplianceRequirement,
  _CmplRq.CmplRqApplicationComponent AS CmplRqApplicationComponent,
  _CmplRq._CmplRqApplComp._Text.CmplRqApplicationComponentName : localized AS CmplRqApplicationComponentNamelocalized,
  ProductionCompanyCode,
  _ProductionCompany.CompanyCodeName AS ProductionCompanyCodeName,
  ReceivingCompanyCode,
  _ReceivingCompany.CompanyCodeName AS ReceivingCompanyCodeName,
  SellingCompanyCode,
  _SellingCompany.CompanyCodeName AS SellingCompanyCodeName,
  ProductionPlant,
  _ProductionPlant.PlantName AS ProductionPlantName,
  ReceivingPlant,
  _ReceivingPlant.PlantName AS ReceivingPlantName,
  SellingPlant,
  _SellingPlant.PlantName AS SellingPlantName,
  PCLglEntyMappgValidFromDate,
  PCLglEntyMappgValidToDate,
  _ProdCmplncLegalEntity.ProdCmplncLegalEntity AS ProdCmplncLegalEntity,
  _ProdCmplncLegalEntity.ProdCmplncLegalEntityDesc AS ProdCmplncLegalEntityDesc,
  SVTBusinessProcessScenario,
  _Plant.Plant AS Plant,
  _Plant.PlantName AS PlantName,
  _CompanyCode.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _BPText.CmplRqSVTScenarioText AS SVTBusinessProcessText,
  PCLglEntyMappgIsUsedInSVT,
  PCLglEntyMappgIsDeleted,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_ProdCmplncLglEntityMappingTP
LEFT OUTER JOIN C_ProdCmplncLglEntityMappgHist AS _LegalEntityMappingHistory ON CmplRqUUID = _LegalEntityMappingHistory.CmplRqUUID AND SVTBusinessProcessScenario = _LegalEntityMappingHistory.SVTBusinessProcessScenario AND ProductionCompanyCode = _LegalEntityMappingHistory.ProductionCompanyCode AND ReceivingCompanyCode = _LegalEntityMappingHistory.ReceivingCompanyCode AND SellingCompanyCode = _LegalEntityMappingHistory.SellingCompanyCode AND ProductionPlant = _LegalEntityMappingHistory.ProductionPlant AND ReceivingPlant = _LegalEntityMappingHistory.ReceivingPlant AND SellingPlant = _LegalEntityMappingHistory.SellingPlant  -- association [0..*]
;

Learn More