I_BPAddlCustSalesAreaTP

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_BPAddlCustSalesAreaTP.
-- 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: IBPADDCSATP

CREATE VIEW I_BPAddlCustSalesAreaTP AS
SELECT
  BPMultipleAssignment.BusinessPartner AS BusinessPartner,
  BusinessPartnerSalesArea.Customer AS Customer,
  BusinessPartnerSalesArea.SalesOrganization AS SalesOrganization,
  BusinessPartnerSalesArea.DistributionChannel AS DistributionChannel,
  BusinessPartnerSalesArea.Division AS Division,
  BPMultipleAssignment.BusinessPartner AS BusinessPartnerForEdit,
  BusinessPartnerSalesArea.SalesOrganization AS SalesOrganizationForEdit,
  BusinessPartnerSalesArea.DistributionChannel AS DistributionChannelForEdit,
  BusinessPartnerSalesArea.Division AS DivisionForEdit,
  BusinessPartnerSalesArea.Customer AS CustomerForEdit,
  BusinessPartnerSalesArea.CustomerGroup AS CustomerGroup,
  BusinessPartnerSalesArea.SalesOffice AS SalesOffice,
  BusinessPartnerSalesArea.SalesGroup AS SalesGroup,
  BusinessPartnerSalesArea.AccountByCustomer AS AccountByCustomer,
  BusinessPartnerSalesArea.CustomerABCClassification AS CustomerABCClassification,
  BusinessPartnerSalesArea.Currency AS Currency,
  BusinessPartnerSalesArea.CustomerPriceGroup AS CustomerPriceGroup,
  BusinessPartnerSalesArea.CustomerPricingProcedure AS CustomerPricingProcedure,
  case when BusinessPartnerSalesArea.DeliveryPriority = '00' then '' else BusinessPartnerSalesArea.DeliveryPriority end as DeliveryPriority AS DeliveryPriorityendasDeliveryPriority,
  BusinessPartnerSalesArea.OrderCombinationIsAllowed AS OrderCombinationIsAllowed,
  BusinessPartnerSalesArea.ShippingCondition AS ShippingCondition,
  BusinessPartnerSalesArea.SupplyingPlant AS SupplyingPlant,
  BusinessPartnerSalesArea.DeliveryIsBlockedForCustomer AS DeliveryIsBlockedForCustomer,
  BusinessPartnerSalesArea.BillingIsBlockedForCustomer AS BillingIsBlockedForCustomer,
  BusinessPartnerSalesArea.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  BusinessPartnerSalesArea.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  BusinessPartnerSalesArea.InvoiceDate AS InvoiceDate,
  BusinessPartnerSalesArea.IncotermsClassification AS IncotermsClassification,
  BusinessPartnerSalesArea.IncotermsTransferLocation AS IncotermsTransferLocation,
  BusinessPartnerSalesArea.IncotermsVersion AS IncotermsVersion,
  BusinessPartnerSalesArea.IncotermsLocation1 AS IncotermsLocation1,
  BusinessPartnerSalesArea.IncotermsLocation2 AS IncotermsLocation2,
  BusinessPartnerSalesArea.CustomerPaymentTerms AS CustomerPaymentTerms,
  BusinessPartnerSalesArea.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  BusinessPartnerSalesArea.OrderIsBlockedForCustomer AS OrderIsBlockedForCustomer,
  BusinessPartnerSalesArea.PriceListType AS PriceListType,
  BusinessPartnerSalesArea.SalesDistrict AS SalesDistrict,
  BusinessPartnerSalesArea.InvoiceListSchedule AS InvoiceListSchedule,
  BusinessPartnerSalesArea.ExchangeRateType AS ExchangeRateType,
  BusinessPartnerSalesArea.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartnerSalesArea.ItemOrderProbabilityInPercent AS ItemOrderProbabilityInPercent,
  BusinessPartnerSalesArea.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  BusinessPartnerSalesArea.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  BusinessPartnerSalesArea.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  BusinessPartnerSalesArea.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  BusinessPartnerSalesArea.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  BusinessPartnerSalesArea.PaymentGuaranteeProcedure AS PaymentGuaranteeProcedure,
  BusinessPartnerSalesArea.SalesItemProposal AS SalesItemProposal,
  BusinessPartnerSalesArea.CustProdProposalProcedure AS CustProdProposalProcedure
FROM I_CustomerSalesArea AS BusinessPartnerSalesArea
INNER JOIN I_BPMultipleAssignment AS BPMultipleAssignment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BPAdditionalCustomerTP AS _BPAdditionalCustomer ON BusinessPartner = _BPAdditionalCustomer.BusinessPartner AND Customer = _BPAdditionalCustomer.Customer  -- association [1..1]
LEFT OUTER JOIN I_BPAddlCustSalesAreaTaxTP AS _BPAddlCustSalesAreaTax ON BusinessPartner = _BPAddlCustSalesAreaTax.BusinessPartner AND Customer = _BPAddlCustSalesAreaTax.Customer AND SalesOrganization = _BPAddlCustSalesAreaTax.SalesOrganization AND DistributionChannel = _BPAddlCustSalesAreaTax.DistributionChannel AND Division = _BPAddlCustSalesAreaTax.Division  -- association [1..*]
LEFT OUTER JOIN I_BPAddlCustPartFuncTP AS _BPAddlCustPartFunc ON BusinessPartner = _BPAddlCustPartFunc.BusinessPartner AND Customer = _BPAddlCustPartFunc.Customer AND SalesOrganization = _BPAddlCustPartFunc.SalesOrganization AND DistributionChannel = _BPAddlCustPartFunc.DistributionChannel AND Division = _BPAddlCustPartFunc.Division  -- association [1..*]
;