I_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_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: IMDCUSTSLSAREA

CREATE VIEW I_CustomerSalesArea AS
SELECT
  kunnr AS Customer,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  klabc AS CustomerABCClassification,
  vkbur AS SalesOffice,
  vkgrp AS SalesGroup,
  aufsd AS OrderIsBlockedForCustomer,
  waers AS Currency,
  konda AS CustomerPriceGroup,
  pltyp AS PriceListType,
  lprio AS DeliveryPriority,
  vsbed AS ShippingCondition,
  inco1 AS IncotermsClassification,
  vwerk AS SupplyingPlant,
  autlf AS CompleteDeliveryIsDefined,
  lifsd AS DeliveryIsBlockedForCustomer,
  faksd AS BillingIsBlockedForCustomer,
  zterm AS CustomerPaymentTerms,
  ktgrd AS CustomerAccountAssignmentGroup,
  eikto AS AccountByCustomer,
  kdgrp AS CustomerGroup,
  kalks AS CustomerPricingProcedure,
  kzazu AS OrderCombinationIsAllowed,
  kztlf AS PartialDeliveryIsAllowed,
  perfk AS InvoiceDate,
  zterm AS PaymentTerms,
  inco2 AS IncotermsTransferLocation,
  awahr AS ItemOrderProbabilityInPercent,
  inco3_l AS IncotermsLocation2,
  erdat AS RecordCreatedDate,
  begru AS AuthorizationGroup,
  bzirk AS SalesDistrict,
  incov AS IncotermsVersion,
  inco2_l AS IncotermsLocation1,
  loevm AS DeletionIndicator,
  cvp_xblck_v AS IsBusinessPurposeCompleted,
  vsort AS SalesItemProposal,
  pvksm AS CustProdProposalProcedure,
  cast( left( cast( div(podtg, 240000) as abap.char(13) ), 6 ) as abap.tims ) AS ProofOfDeliveryTime,
  cast( division(podtg, 240000, 2 ) as cust_pod ) AS ProofOfDeliveryTimeValue,
  antlf AS MaxNmbrOfPartialDelivery,
  untto AS UnderdelivTolrtdLmtRatioInPct,
  uebto AS OverdelivTolrtdLmtRatioInPct,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  kvgr1 AS AdditionalCustomerGroup1,
  kvgr2 AS AdditionalCustomerGroup2,
  kvgr3 AS AdditionalCustomerGroup3,
  kvgr4 AS AdditionalCustomerGroup4,
  kvgr5 AS AdditionalCustomerGroup5,
  perrl AS InvoiceListSchedule,
  kurst AS ExchangeRateType,
  kabss AS PaymentGuaranteeProcedure,
  agrel AS SuplrIsRlvtForSettlmtMgmt,
  agrel AS CustIsRlvtForSettlmtMgmt,
  megru AS ProductUnitGroup,
  podkz AS SlsDocIsRlvtForProofOfDeliv,
  uebtk AS SlsUnlmtdOvrdelivIsAllwd,
  kkber AS CreditControlArea,
  bokre AS CustomerIsRebateRelevant,
  prfre AS InspSbstHasNoTimeOrQuantity,
  mrnkz AS ManualInvoiceMaintIsRelevant,
  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,
  cassd AS SalesBlockForCustomer,
  versg AS CustomerStatisticsGroup
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_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- 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_Plant AS _SupplyingPlant ON SupplyingPlant = _SupplyingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryIsBlockedForCustomer ON DeliveryIsBlockedForCustomer = _DeliveryIsBlockedForCustomer.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _BillingIsBlockedForCustomer ON BillingIsBlockedForCustomer = _BillingIsBlockedForCustomer.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _CustomerPaymentTerms ON CustomerPaymentTerms = _CustomerPaymentTerms.CustomerPaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup ON CustomerAccountAssignmentGroup = _CustomerAccountAssgmtGroup.CustomerAccountAssignmentGroup  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON InvoiceListSchedule = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_ExchangeRateType AS _ExchangeRateType ON ExchangeRateType = _ExchangeRateType.ExchangeRateType  -- association [0..1]
LEFT OUTER JOIN I_CustProdProposalProcedure AS _CustProdProposalProcedure ON CustProdProposalProcedure = _CustProdProposalProcedure.CustProdProposalProcedure  -- association [0..1]
LEFT OUTER JOIN E_BPSALESAREA_D AS _SalesAreaExt ON SalesOrganization = _SalesAreaExt.SalesOrganization AND DistributionChannel = _SalesAreaExt.DistributionChannel AND Division = _SalesAreaExt.Division AND Customer = _SalesAreaExt.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaytGuarProced AS _PaytGuarProcedVH ON PaymentGuaranteeProcedure = _PaytGuarProcedVH.CustomerPaytGuarProced  -- association [0..1]
LEFT OUTER JOIN I_CustSlsAreaAddrDepdntInfo AS _SalesAreaAddr ON SalesOrganization = _SalesAreaAddr.SalesOrganization AND DistributionChannel = _SalesAreaAddr.DistributionChannel AND Division = _SalesAreaAddr.Division AND Customer = _SalesAreaAddr.Customer  -- association [1..*]
;