I_TrdCmplncLicSelection

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_TrdCmplncLicSelection.
-- 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: ITRDCMPLSEL

CREATE VIEW I_TrdCmplncLicSelection AS
SELECT
  Header.TrdCmplncLicenseUUID AS TrdCmplncLicenseUUID,
  _TrdCmplncLicProduct.Product AS Product,
  _TrdCmplncLicControlClass.ControlClass AS ControlClass,
  _TrdCmplncLicCtrlGrouping.ControlGrouping AS ControlGrouping,
  _TrdCmplncLicCommodityCode.CommodityCode AS CommodityCode,
  _TrdCmplncLicCountry.Country AS Country,
  _TrdCmplncLicDocument.ReferenceDocumentCategory AS ReferenceDocumentCategory,
  _TrdCmplncLicDocument.ReferenceDocument AS ReferenceDocument,
  _TrdCmplncLicBusPart.IntlTrdPartnerRole AS IntlTrdPartnerRole,
  _TrdCmplncLicBusPart.BusinessPartner AS BusinessPartner,
  _TrdCmplncLicCompanyCode.CompanyCode AS CompanyCode,
  _TrdCmplncLicPlant.Plant AS Plant,
  _TrdCmplncLicTariffNumber.CustomsTariffNumber AS CustomsTariffNumber,
  Header.LegalRegulation AS LegalRegulation,
  Header.TrdCmplncLicenseType AS TrdCmplncLicenseType,
  Header.TrdCmplncLicenseStatus AS TrdCmplncLicenseStatus,
  Header.ValidityStartDate AS ValidityStartDate,
  Header.ValidityEndDate AS ValidityEndDate,
  _TrdCmplncLicType.TrdCmplncLicenseHasProduct AS TrdCmplncLicenseHasProduct,
  _TrdCmplncLicType.TrdCmplncLicenseHasCountry AS TrdCmplncLicenseHasCountry,
  Header._LegalRegulation AS _LegalRegulation,
  _TrdCmplncLicCountry._Country AS _Country,
  _TrdCmplncLicDocument._IntlTrdDocumentCategory AS _IntlTrdDocumentCategory,
  _TrdCmplncLicBusPart._IntlTrdPartnerRole AS _IntlTrdPartnerRole,
  _TrdCmplncLicBusPart._BusinessPartner AS _BusinessPartner,
  _TrdCmplncLicPlant._Plant AS _Plant
FROM I_TrdCmplncLicHeader AS Header
LEFT OUTER JOIN I_TrdCmplncLicProduct AS _TrdCmplncLicProduct ON _TrdCmplncLicProduct.TrdCmplncLicenseUUID = Header.TrdCmplncLicenseUUID  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncLicControlClass AS _TrdCmplncLicControlClass ON _TrdCmplncLicControlClass.TrdCmplncLicenseUUID = Header.TrdCmplncLicenseUUID  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncLicCtrlGrouping AS _TrdCmplncLicCtrlGrouping ON _TrdCmplncLicCtrlGrouping.TrdCmplncLicenseUUID = Header.TrdCmplncLicenseUUID  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncLicCommodityCode AS _TrdCmplncLicCommodityCode ON _TrdCmplncLicCommodityCode.TrdCmplncLicenseUUID = Header.TrdCmplncLicenseUUID  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncLicCountry AS _TrdCmplncLicCountry ON _TrdCmplncLicCountry.TrdCmplncLicenseUUID = Header.TrdCmplncLicenseUUID  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncLicDocument AS _TrdCmplncLicDocument ON _TrdCmplncLicDocument.TrdCmplncLicenseUUID = Header.TrdCmplncLicenseUUID  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncLicBusPart AS _TrdCmplncLicBusPart ON _TrdCmplncLicBusPart.TrdCmplncLicenseUUID = Header.TrdCmplncLicenseUUID  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncLicCompanyCode AS _TrdCmplncLicCompanyCode ON _TrdCmplncLicCompanyCode.TrdCmplncLicenseUUID = Header.TrdCmplncLicenseUUID  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncLicPlant AS _TrdCmplncLicPlant ON _TrdCmplncLicPlant.TrdCmplncLicenseUUID = Header.TrdCmplncLicenseUUID  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncLicTariffNumber AS _TrdCmplncLicTariffNumber ON _TrdCmplncLicTariffNumber.TrdCmplncLicenseUUID = Header.TrdCmplncLicenseUUID  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncLicType AS _TrdCmplncLicType ON LegalRegulation = _TrdCmplncLicType.LegalRegulation AND TrdCmplncLicenseType = _TrdCmplncLicType.TrdCmplncLicenseType  -- association [0..1]
;