I_RFM_CustomerSalesArea

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_RFM_CustomerSalesArea.
-- 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: IRFMCSTMRSLSAREA

CREATE VIEW I_RFM_CustomerSalesArea AS
SELECT
  kunnr AS Customer,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  bzirk AS SalesDistrict,
  zterm AS CustomerPaymentTerms,
  inco1 AS IncotermsClassification,
  inco2_l AS IncotermsLocation1,
  vsbed AS ShippingCondition,
  vkbur AS SalesOffice,
  lprio AS DeliveryPriority,
  kkber AS CreditControlArea,
  kdgrp AS CustomerGroup,
  konda AS CustomerPriceGroup,
  kvgr1 AS AdditionalCustomerGroup1,
  kvgr2 AS AdditionalCustomerGroup2,
  kvgr3 AS AdditionalCustomerGroup3,
  kvgr4 AS AdditionalCustomerGroup4,
  kvgr5 AS AdditionalCustomerGroup5,
  fsh_kvgr6 AS RetailAdditionalCustomerGrp6,
  fsh_kvgr7 AS RetailAdditionalCustomerGrp7,
  fsh_kvgr8 AS RetailAdditionalCustomerGrp8,
  fsh_kvgr9 AS RetailAdditionalCustomerGrp9,
  fsh_kvgr10 AS RetailAdditionalCustomerGrp10,
  begru AS AuthorizationGroup,
  _Customer.CustomerAccountGroup AS CustomerAccountGroup,
  cvp_xblck_v AS IsBusinessPurposeCompleted
FROM knvv
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_DeliveryPriority AS _DeliveryPriority ON DeliveryPriority = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _CustomerPaymentTerms ON CustomerPaymentTerms = _CustomerPaymentTerms.CustomerPaymentTerms  -- association [0..1]
;