I_TrdCmplncLicHeader

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_TrdCmplncLicHeader.
-- 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: ITRDCMPLHDR

CREATE VIEW I_TrdCmplncLicHeader AS
SELECT
  db_key AS TrdCmplncLicenseUUID,
  lgreg AS LegalRegulation,
  licty AS TrdCmplncLicenseType,
  licno AS TrdCmplncLicense,
  extno AS ExtTrdCmplncLicense,
  licow AS TrdCmplncLicenseOwner,
  _TrdCmplncLicenseOwner.CompanyCodeName AS TrdCmplncLicenseOwnerName,
  custa AS TrdCmplncLicenseStatus,
  licat AS TrdCmplncLicenseCategory,
  datab AS ValidityStartDate,
  datbi AS ValidityEndDate,
  lmrmk AS TrdCmplncLicenseRemark,
  msval AS TrdCmplncIsMilitarySctr,
  nuval AS TrdCmplncIsNuclearSctr,
  mxamt AS TrdCmplncLicenseMaxAmount,
  liccu AS TrdCmplncLicenseDeprCurrency,
  vprza AS TrdCmplncLicenseAmtExcdPct,
  mxqua AS TrdCmplncLicenseMaxQuantity,
  licum AS TrdCmplncLicenseDeprUnit,
  qprza AS TrdCmplncLicenseQtyExcdPct,
  cast ( crea_uname as /sapsll/ernam_itr ) AS CreatedByUser,
  cast (crea_date_time as sll_creadatetime ) AS CreationDateTime,
  cast ( lchg_uname as /sapsll/aenam_itr ) AS LastChangedByUser,
  cast (lchg_date_time as sll_lchgdatetime) AS LastChangeDateTime,
  mxaml AS TrdCmplncLicenseAmtAssgmtLvl,
  mxqul AS TrdCmplncLicenseQtyAssgmtLvl,
  qubas AS TrdCmplncLicQtyUpdateBasis,
  matsp AS TrdCmplncLicenseHasProduct,
  cclsp AS TrdCmplncLicenseHasCtrlCl,
  cogsp AS TrdCmplncLicenseHasCtrlGrpg,
  stasp AS TrdCmplncLicenseHasCmmdtyCode,
  cousp AS TrdCmplncLicenseHasCountry,
  docsp AS TrdCmplncLicenseHasDocument,
  parsp AS TrdCmplncLicenseHasBP,
  ccosp AS TrdCmplncLicenseHasCompanyCode,
  pltsp AS TrdCmplncLicenseHasPlant,
  tnosp AS TrdCmplncLicenseHasTariffNo
LEFT OUTER JOIN P_TrdCmplncLicAssgmtExisting AS _TrdCmplncDocLicAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _TrdCmplncLicenseOwner ON TrdCmplncLicenseOwner = _TrdCmplncLicenseOwner.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_LegalControlLegalRegulation AS _LegalRegulation ON LegalRegulation = _LegalRegulation.LegalRegulation  -- association [0..1]
LEFT OUTER JOIN I_LegalRegulationText AS _LegalRegulationText ON LegalRegulation = _LegalRegulationText.LegalRegulation  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncLicType AS _TrdCmplncLicType ON LegalRegulation = _TrdCmplncLicType.LegalRegulation AND TrdCmplncLicenseType = _TrdCmplncLicType.TrdCmplncLicenseType  -- association [0..1]
LEFT OUTER JOIN I_TrdCmplncLicTypeText AS _TrdCmplncLicTypeText ON LegalRegulation = _TrdCmplncLicTypeText.LegalRegulation AND TrdCmplncLicenseType = _TrdCmplncLicTypeText.TrdCmplncLicenseType  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncLicStatus AS _TrdCmplncLicStatus ON TrdCmplncLicenseStatus = _TrdCmplncLicStatus.TrdCmplncLicenseStatus  -- association [0..1]
LEFT OUTER JOIN I_TrdCmplncLicStatusText AS _TrdCmplncLicStatusText ON TrdCmplncLicenseStatus = _TrdCmplncLicStatusText.TrdCmplncLicenseStatus  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncLicCategory AS _TrdCmplncLicCategory ON TrdCmplncLicenseCategory = _TrdCmplncLicCategory.TrdCmplncLicenseCategory  -- association [0..1]
LEFT OUTER JOIN I_TrdCmplncLicCategoryText AS _TrdCmplncLicCategoryText ON TrdCmplncLicenseCategory = _TrdCmplncLicCategoryText.TrdCmplncLicenseCategory  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TrdCmplncLicenseDeprCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON TrdCmplncLicenseDeprUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_TrdCmplncDocLicIsAssgd AS _TrdCmplncDocLicIsAssgd ON _TrdCmplncDocLicIsAssgd.TrdCmplncDocLicIsAssgd = TrdCmplncDocLicIsAssgd  -- association [0..1]
LEFT OUTER JOIN I_TrdCmplncDocLicIsAssgdText AS _TrdCmplncDocLicIsAssgdText ON _TrdCmplncDocLicIsAssgdText.TrdCmplncDocLicIsAssgd = TrdCmplncDocLicIsAssgd  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncIsMilitarySctr AS _TrdCmplncIsMilitarySctr ON _TrdCmplncIsMilitarySctr.TrdCmplncIsMilitarySctr = TrdCmplncIsMilitarySctr  -- association [0..1]
LEFT OUTER JOIN I_TrdCmplncIsMilitarySctrText AS _TrdCmplncIsMilitarySctrText ON _TrdCmplncIsMilitarySctrText.TrdCmplncIsMilitarySctr = TrdCmplncIsMilitarySctr  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncIsNuclearSctr AS _TrdCmplncIsNuclearSctr ON _TrdCmplncIsNuclearSctr.TrdCmplncIsNuclearSctr = TrdCmplncIsNuclearSctr  -- association [0..1]
LEFT OUTER JOIN I_TrdCmplncIsNuclearSctrText AS _TrdCmplncIsNuclearSctrText ON _TrdCmplncIsNuclearSctrText.TrdCmplncIsNuclearSctr = TrdCmplncIsNuclearSctr  -- association [0..*]
;