I_CustSlsAreaAddrDepdntInfo

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_CustSlsAreaAddrDepdntInfo.
-- 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: ICUSTSLSADDRDEP

CREATE VIEW I_CustSlsAreaAddrDepdntInfo AS
SELECT
  knvv_addr.kunnr AS Customer,
  knvv_addr.vkorg AS SalesOrganization,
  knvv_addr.vtweg AS DistributionChannel,
  knvv_addr.spart AS Division,
  knvv_addr.adrnr AS AddressID,
  knvv_addr.inco1 AS IncotermsClassification,
  knvv_addr.inco2_l AS IncotermsLocation1,
  knvv_addr.inco3_l AS IncotermsLocation2,
  knvv_addr.lifsd AS DeliveryIsBlocked,
  knvv_addr.vkbur AS SalesOffice,
  knvv_addr.vkgrp AS SalesGroup,
  knvv_addr.vsbed AS ShippingCondition,
  knvv_addr.vwerk AS SupplyingPlant,
  knvv_addr.incov AS IncotermsVersion,
  cast( inco2_key as /sapapo/location_uuid ) AS IncotermsSupChnLoc1AddlUUID,
  cast( inco3_key as /sapapo/location_uuid ) AS IncotermsSupChnLoc2AddlUUID,
  cast( inco4_key as /sapapo/location_uuid ) AS IncotermsSupChnDvtgLocAddlUUID
FROM knvv_addr
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [1..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [1..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [1..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryIsBlockedForCustomer ON DeliveryIsBlocked = _DeliveryIsBlockedForCustomer.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _AddressDefaultRepresentation ON AddressID = _AddressDefaultRepresentation.AddressID AND _AddressDefaultRepresentation.AddressRepresentationCode = ' '  -- association [1..1]
LEFT OUTER JOIN I_CustomerSalesArea AS _CustomerSalesArea ON Customer = _CustomerSalesArea.Customer AND SalesOrganization = _CustomerSalesArea.SalesOrganization AND DistributionChannel = _CustomerSalesArea.DistributionChannel AND Division = _CustomerSalesArea.Division  -- association [1..1]
LEFT OUTER JOIN E_CustSlsAreaAddrDepdntInfo AS _CustSlsAreaAddrDepdntInfoExt ON Customer = _CustSlsAreaAddrDepdntInfoExt.Customer AND SalesOrganization = _CustSlsAreaAddrDepdntInfoExt.SalesOrganization AND DistributionChannel = _CustSlsAreaAddrDepdntInfoExt.DistributionChannel AND Division = _CustSlsAreaAddrDepdntInfoExt.Division AND AddressID = _CustSlsAreaAddrDepdntInfoExt.AddressID  -- association [0..1]
LEFT OUTER JOIN I_TransportationLocation AS _IncotermsSupChnDvtgLoc ON IncotermsSupChnDvtgLocAddlUUID = _IncotermsSupChnDvtgLoc.LocationAdditionalUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportationLocation AS _IncotermsSupChnLoc2 ON IncotermsSupChnLoc2AddlUUID = _IncotermsSupChnLoc2.LocationAdditionalUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportationLocation AS _IncotermsSupChnLoc1 ON IncotermsSupChnLoc1AddlUUID = _IncotermsSupChnLoc1.LocationAdditionalUUID  -- association [1..1]
;