C_ProdCmplncLglEntityMappingTP

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..*]
;