C_Customer360SalesArea

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_Customer360SalesArea.
-- 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 C_Customer360SalesArea AS
SELECT
  SalesArea.Customer AS Customer,
  SalesArea.SalesOrganization AS SalesOrganization,
  SalesArea.DistributionChannel AS DistributionChannel,
  SalesArea.Division AS Division,
  _Customer.CustomerName AS CustomerName,
  _SalesOrganization._Text[1:Language=$session.system_language].SalesOrganizationName AS SalesOrganizationName,
  _DistributionChannel._Text[1:Language=$session.system_language].DistributionChannelName AS DistributionChannelName,
  _Division._Text[1:Language=$session.system_language].DivisionName AS DivisionName,
  SalesArea.CustomerGroup AS CustomerGroup,
  _CustomerGroupText[1:Language=$session.system_language].CustomerGroupName AS CustomerGroupName,
  SalesArea.SalesGroup AS SalesGroup,
  _SalesGroup._Text[1:Language=$session.system_language].SalesGroupName AS SalesGroupName,
  SalesArea.SalesOffice AS SalesOffice,
  _SalesOffice._Text[1:Language=$session.system_language].SalesOfficeName AS SalesOfficeName,
  SalesDistrict,
  _SalesDistrictText[1:Language=$session.system_language].SalesDistrictName AS SalesDistrictName,
  SalesArea.DeliveryPriority AS DeliveryPriority,
  _DeliveryPriority._Text[1:Language=$session.system_language].DeliveryPriorityDesc AS DeliveryPriorityDesc,
  SalesArea.PriceListType AS PriceListType,
  SalesArea.IncotermsClassification AS IncotermsClassification,
  _IncotermsClassificationText[1:Language=$session.system_language].IncotermsClassificationName AS IncotermsClassificationName,
  ItemOrderProbabilityInPercent,
  SalesItemProposal,
  OrderCombinationIsAllowed,
  IncotermsLocation1,
  IncotermsLocation2,
  CustomerPaymentTerms,
  _CustomerPaymentTerms._Text[1:Language=$session.system_language].CustomerPaymentTermsName AS CustomerPaymentTermsName,
  ShippingCondition,
  _ShippingConditionText[1:Language = $session.system_language].ShippingConditionName AS ShippingConditionName,
  SalesArea.OrderIsBlockedForCustomer AS OrderIsBlockedForCustomer,
  CustomerPriceGroup,
  _CustomerPriceGroupText[1:Language = $session.system_language].CustomerPriceGroupName AS CustomerPriceGroupName,
  DeliveryIsBlockedForCustomer AS DeliveryIsBlocked,
  _DeliveryBlockReasonText[1:Language=$session.system_language].DeliveryBlockReasonText AS DeliveryBlockReasonText,
  SalesArea.BillingIsBlockedForCustomer AS BillingIsBlockedForCustomer,
  _BillingBlockReasonText[1:Language=$session.system_language].BillingBlockReasonDescription AS BillingBlockReasonDescription,
  SalesArea.CustomerABCClassification AS CustomerABCClassification,
  SalesArea.AuthorizationGroup AS AuthorizationGroup,
  SalesArea.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_CustomerSalesArea AS SalesArea
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 [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrictText AS _SalesDistrictText ON SalesDistrict = _SalesDistrictText.SalesDistrict  -- association [0..*]
LEFT OUTER JOIN I_BillingBlockReason AS _BillingBlockReasonValueHelp ON BillingIsBlockedForCustomer = _BillingBlockReasonValueHelp.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReasonText AS _BillingBlockReasonText ON BillingIsBlockedForCustomer = _BillingBlockReasonText.BillingBlockReason  -- association [0..*]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DelivBlkRsnValueHelp ON DeliveryIsBlocked = _DelivBlkRsnValueHelp.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReasonText AS _DeliveryBlockReasonText ON DeliveryIsBlocked = _DeliveryBlockReasonText.DeliveryBlockReason  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON IncotermsClassification = _IncotermsClassificationText.IncotermsClassification  -- association [0..*]
LEFT OUTER JOIN I_CustomerPriceGroup AS _CustomerPriceGroupValueHelp ON CustomerPriceGroup = _CustomerPriceGroupValueHelp.CustomerPriceGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerPriceGroupText AS _CustomerPriceGroupText ON CustomerPriceGroup = _CustomerPriceGroupText.CustomerPriceGroup  -- association [0..*]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _CustomerPaymentTerms ON CustomerPaymentTerms = _CustomerPaymentTerms.CustomerPaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroupText AS _CustomerGroupText ON CustomerGroup = _CustomerGroupText.CustomerGroup  -- association [0..*]
LEFT OUTER JOIN I_DeliveryPriority AS _DeliveryPriority ON DeliveryPriority = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN I_ShippingConditionText AS _ShippingConditionText ON ShippingCondition = _ShippingConditionText.ShippingCondition  -- association [0..*]
LEFT OUTER JOIN C_Cust360BizPartnerAddress AS _Cust360BizPartnerAddress ON Customer = _Cust360BizPartnerAddress.Customer AND SalesOrganization = _Cust360BizPartnerAddress.SalesOrganization AND DistributionChannel = _Cust360BizPartnerAddress.DistributionChannel AND Division = _Cust360BizPartnerAddress.Division  -- association [1..*]
;