I_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 I_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 I_ProdCmplncLglEntityMappingTP AS
SELECT
  ProdCmplncLglEntyMappgUUID,
  ProdCmplncLegalEntityUUID,
  CmplRqUUID,
  ProductionCompanyCode,
  ReceivingCompanyCode,
  SellingCompanyCode,
  ProductionPlant,
  ReceivingPlant,
  SellingPlant,
  PCLglEntyMappgValidFromDate,
  PCLglEntyMappgValidToDate,
  SVTBusinessProcessScenario,
  PCLglEntyMappgIsDeleted,
  ComplianceRequirement,
  cast( ' ' as ehfnd_boolean ) AS PCLglEntyAuthznCheckHasFailed,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  _MappingUsed.PCLglEntyMappgIsUsedInSVT AS PCLglEntyMappgIsUsedInSVT
FROM I_ProdCmplncLegalEntityMapping AS _ProdCmplncLegalEntityMapping
LEFT OUTER JOIN I_ProdCmplncLegalEntity AS _ProdCmplncLegalEntity ON _ProdCmplncLegalEntityMapping.ProdCmplncLegalEntityUUID = _ProdCmplncLegalEntity.ProdCmplncLegalEntityUUID  -- association [1..1]
LEFT OUTER JOIN I_PlantVH AS _Plant ON _ProdCmplncLegalEntityMapping.ProductionPlant = _Plant.Plant OR _ProdCmplncLegalEntityMapping.ReceivingPlant = _Plant.Plant OR _ProdCmplncLegalEntityMapping.SellingPlant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_PlantVH AS _ProductionPlant ON _ProdCmplncLegalEntityMapping.ProductionPlant = _ProductionPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PlantVH AS _ReceivingPlant ON _ProdCmplncLegalEntityMapping.ReceivingPlant = _ReceivingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PlantVH AS _SellingPlant ON _ProdCmplncLegalEntityMapping.SellingPlant = _SellingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CompanyCodeVH AS _CompanyCode ON _ProdCmplncLegalEntityMapping.ProductionCompanyCode = _CompanyCode.CompanyCode OR _ProdCmplncLegalEntityMapping.ReceivingCompanyCode = _CompanyCode.CompanyCode OR _ProdCmplncLegalEntityMapping.SellingCompanyCode = _CompanyCode.CompanyCode AND _CompanyCode.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_CompanyCodeVH AS _ProductionCompany ON _ProdCmplncLegalEntityMapping.ProductionCompanyCode = _ProductionCompany.CompanyCode AND _ProductionCompany.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCodeVH AS _ReceivingCompany ON _ProdCmplncLegalEntityMapping.ReceivingCompanyCode = _ReceivingCompany.CompanyCode AND _ReceivingCompany.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCodeVH AS _SellingCompany ON _ProdCmplncLegalEntityMapping.SellingCompanyCode = _SellingCompany.CompanyCode AND _SellingCompany.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CmplRqSVTScenarioText AS _BPText ON _ProdCmplncLegalEntityMapping.SVTBusinessProcessScenario = _BPText.CmplRqSVTScenario AND _BPText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN P_ProdCmplncLglEntityMappgUsed AS _MappingUsed ON _ProdCmplncLegalEntityMapping.ProdCmplncLglEntyMappgUUID = _MappingUsed.ProdCmplncLglEntyMappgUUID  -- association [1..1]
LEFT OUTER JOIN I_CmplRq AS _CmplRq ON CmplRqUUID = _CmplRq.CmplRqUUID AND ComplianceRequirement = _CmplRq.ComplianceRequirement AND _CmplRq.CmplRqUUID is not null AND _CmplRq.ComplianceRequirement is not initial  -- association [0..1]
;