C_TrdCmplncLicDocItmAssgmt

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_TrdCmplncLicDocItmAssgmt.
-- 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: CTRDCMPLLCDCAS

CREATE VIEW C_TrdCmplncLicDocItmAssgmt AS
SELECT
  _License.TrdCmplncLicense AS TrdCmplncLicense,
  TrdCmplncDocLglRglnUUID,
  _License.LegalRegulation AS LegalRegulation,
  _License.TrdCmplncLicenseType AS TrdCmplncLicenseType,
  _TrdCmplncDocLicAssgmt.TrdCmplncLicenseUUID AS TrdCmplncLicenseUUID,
  _TrdCmplncDocLicAssgmt.TrdCmplncDocItemUUID AS TrdCmplncDocItemUUID,
  TrdCmplncDocLicAssgmtUUID,
  _DocLglRgln.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  _License.ExtTrdCmplncLicense AS ExtTrdCmplncLicense,
  _License.ValidityStartDate AS ValidityStartDate,
  _License.ValidityEndDate AS ValidityEndDate,
  _License.TrdCmplncLicenseOwner AS TrdCmplncLicenseOwner,
  _DocLglRgln.ControlClass AS ControlClass,
  _DocLglRgln.CommodityCode AS CommodityCode,
  _DocLglRgln.ControlGrouping AS ControlGrouping,
  _DocLglRgln.CustomsTariffNumber AS CustomsTariffNumber,
  _DocLglRgln.NetAmount AS NetAmount,
  _DocLglRgln.RequestedQuantity AS RequestedQuantity,
  _DocLglRgln.RequestedQuantityUnit AS RequestedQuantityUnit,
  _DocLglRgln.TransactionCurrency AS TransactionCurrency,
  _TrdCmplncDocItemBasicAlias.TradeComplianceDocument AS TradeComplianceDocument,
  _TrdCmplncDocItemBasicAlias.TrdCmplncDocCategory AS TrdCmplncDocCategory,
  _TrdCmplncDocItemBasicAlias.TrdCmplncDocItem AS TrdCmplncDocItem,
  _TrdCmplncDocItemBasicAlias.TrdCmplncCheckDrctn AS TrdCmplncCheckDrctn,
  _TrdCmplncDocItemBasic.Product AS Product,
  _TrdCmplncDocItemBasic.CompanyCode AS CompanyCode,
  _TrdCmplncDocItemBasicAlias.BusinessPartner AS BusinessPartner,
  cast (_BusinessPartner.BusinessPartnerName as /sapsll/tcpna preserving type ) AS BusinessPartnerName,
  _TrdCmplncDocItemBasic.Country AS Country,
  _TrdCmplncDocItemBasicAlias._TrdCmplncDocCategoryText AS _TrdCmplncDocCategoryText,
  _TrdCmplncDocItemBasicAlias._TrdCmplncCheckDrctnTxt AS _TrdCmplncCheckDrctnTxt,
  _TrdCmplncDocItemBasic._CountryText AS _CountryText,
  _DocLglRgln._TransactionCurrency AS _TransactionCurrency,
  _DocLglRgln._RequestedQuantityUnit AS _RequestedQuantityUnit
FROM I_TrdCmplncDocLicAssgmt AS _TrdCmplncDocLicAssgmt
LEFT OUTER JOIN I_Product AS _Product ON _Product.Product = product  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _BusinessPartner.BusinessPartner = BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_TrdCmplncDocLglRgln AS _DocLglRgln ON TrdCmplncDocLglRglnUUID = _DocLglRgln.TrdCmplncDocLglRglnUUID  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_TrdCmplncDocItem AS _TrdCmplncDocItemBasic ON TradeComplianceDocument = _TrdCmplncDocItemBasic.TradeComplianceDocument AND TrdCmplncDocCategory = _TrdCmplncDocItemBasic.TrdCmplncDocCategory AND TrdCmplncDocItem = _TrdCmplncDocItemBasic.TrdCmplncDocItem  -- association [0..1]
;