I_Businesspartnersalesarea

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_Businesspartnersalesarea.
-- 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: IBUPASALESAREA

CREATE VIEW I_Businesspartnersalesarea AS
SELECT
  SalesOrganization,
  DistributionChannel,
  Division,
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartner AS BusinessPartner,
  _CustomerToBusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  Customer,
  CustomerGroup,
  SalesOffice,
  SalesGroup,
  AccountByCustomer,
  CustomerABCClassification,
  Currency,
  CustomerPriceGroup,
  CustomerPricingProcedure,
  DeliveryPriority,
  OrderCombinationIsAllowed,
  ShippingCondition,
  SupplyingPlant,
  DeliveryIsBlockedForCustomer,
  BillingIsBlockedForCustomer,
  CompleteDeliveryIsDefined,
  PartialDeliveryIsAllowed,
  InvoiceDate,
  IncotermsClassification,
  IncotermsTransferLocation,
  CustomerPaymentTerms,
  CustomerAccountAssignmentGroup,
  SalesDistrict,
  OrderIsBlockedForCustomer,
  PriceListType,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  AuthorizationGroup,
  PaymentGuaranteeProcedure,
  CustomerStatisticsGroup,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  IsBusinessPurposeCompleted,
  InvoiceListSchedule,
  ExchangeRateType,
  ItemOrderProbabilityInPercent,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  UnderdelivTolrtdLmtRatioInPct,
  OverdelivTolrtdLmtRatioInPct,
  MaxNmbrOfPartialDelivery,
  SuplrIsRlvtForSettlmtMgmt,
  ProductUnitGroup,
  SlsDocIsRlvtForProofOfDeliv,
  SlsUnlmtdOvrdelivIsAllwd,
  CreditControlArea,
  CustomerIsRebateRelevant,
  InspSbstHasNoTimeOrQuantity,
  ManualInvoiceMaintIsRelevant,
  SalesItemProposal,
  CustProdProposalProcedure,
  ProofOfDeliveryTime,
  ProofOfDeliveryTimeValue,
  IncotermsSupChnLoc2AddlUUID,
  IncotermsSupChnLoc1AddlUUID,
  IncotermsSupChnDvtgLocAddlUUID,
  SalesBlockForCustomer
FROM I_CustomerSalesArea
LEFT OUTER JOIN I_Customer_to_BusinessPartner AS _CustomerToBusinessPartner ON Customer = _CustomerToBusinessPartner.Customer  -- association [1..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_DeliveryBlockReason AS _DelivBlkRsnValueHelp ON DeliveryIsBlockedForCustomer = _DelivBlkRsnValueHelp.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReasonText AS _DeliveryBlockReasonText ON DeliveryIsBlockedForCustomer = _DeliveryBlockReasonText.DeliveryBlockReason  -- 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_SalesDistrict AS _SalesDistrictValueHelp ON SalesDistrict = _SalesDistrictValueHelp.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrictText AS _SalesDistrictText ON SalesDistrict = _SalesDistrictText.SalesDistrict  -- association [0..*]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroupValueHelp ON CustomerGroup = _CustomerGroupValueHelp.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroupText AS _CustomerGroupText ON CustomerGroup = _CustomerGroupText.CustomerGroup  -- association [0..*]
LEFT OUTER JOIN I_CustomerStatisticsGroupVH AS _CustStatisticsGroupValueHelp ON CustomerStatisticsGroup = _CustStatisticsGroupValueHelp.CustomerStatisticsGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerStatisticsGroupText AS _CustStatisticsGroupText ON CustomerStatisticsGroup = _CustStatisticsGroupText.CustomerStatisticsGroup  -- association [0..*]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingConditionValueHelp ON ShippingCondition = _ShippingConditionValueHelp.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_ShippingConditionText AS _ShippingConditionText ON ShippingCondition = _ShippingConditionText.ShippingCondition  -- association [0..*]
LEFT OUTER JOIN I_CustomerAccountAssgmtGroup AS _AccountAssgmtGroupValueHelp ON CustomerAccountAssignmentGroup = _AccountAssgmtGroupValueHelp.CustomerAccountAssignmentGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerAccountAssgmtGroupT AS _CustAccountAssgmtGroupText ON CustomerAccountAssignmentGroup = _CustAccountAssgmtGroupText.CustomerAccountAssignmentGroup  -- 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_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]
LEFT OUTER JOIN I_DeliveryPriority AS _DeliveryPriorityValueHelp ON DeliveryPriority = _DeliveryPriorityValueHelp.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN I_DeliveryPriorityText AS _DeliveryPriorityText ON DeliveryPriority = _DeliveryPriorityText.DeliveryPriority  -- association [0..*]
;