I_BusinessPartnerSalesAreaTP

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_BusinessPartnerSalesAreaTP.
-- 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: IBUPASALESAREATP

CREATE VIEW I_BusinessPartnerSalesAreaTP AS
SELECT
  BusinessPartnerSalesArea.BusinessPartner AS BusinessPartner,
  BusinessPartnerSalesArea.SalesOrganization AS SalesOrganization,
  BusinessPartnerSalesArea.DistributionChannel AS DistributionChannel,
  BusinessPartnerSalesArea.Division AS Division,
  BusinessPartnerSalesArea.BusinessPartner AS BusinessPartnerForEdit,
  BusinessPartnerSalesArea.SalesOrganization AS SalesOrganizationForEdit,
  BusinessPartnerSalesArea.DistributionChannel AS DistributionChannelForEdit,
  BusinessPartnerSalesArea.Division AS DivisionForEdit,
  BusinessPartnerSalesArea.BusinessPartnerUUID AS BusinessPartnerUUID,
  BusinessPartnerSalesArea.Customer AS Customer,
  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.PaymentGuaranteeProcedure AS PaymentGuaranteeProcedure,
  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.CustomerStatisticsGroup AS CustomerStatisticsGroup,
  BusinessPartnerSalesArea.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  BusinessPartnerSalesArea.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  BusinessPartnerSalesArea.MaxNmbrOfPartialDelivery AS MaxNmbrOfPartialDelivery,
  BusinessPartnerSalesArea.SuplrIsRlvtForSettlmtMgmt AS SuplrIsRlvtForSettlmtMgmt,
  BusinessPartnerSalesArea.ProductUnitGroup AS ProductUnitGroup,
  BusinessPartnerSalesArea.SlsDocIsRlvtForProofOfDeliv AS SlsDocIsRlvtForProofOfDeliv,
  BusinessPartnerSalesArea.SlsUnlmtdOvrdelivIsAllwd AS SlsUnlmtdOvrdelivIsAllwd,
  BusinessPartnerSalesArea.CreditControlArea AS CreditControlArea,
  BusinessPartnerSalesArea.CustomerIsRebateRelevant AS CustomerIsRebateRelevant,
  BusinessPartnerSalesArea.InspSbstHasNoTimeOrQuantity AS InspSbstHasNoTimeOrQuantity,
  BusinessPartnerSalesArea.ManualInvoiceMaintIsRelevant AS ManualInvoiceMaintIsRelevant,
  BusinessPartnerSalesArea.ProofOfDeliveryTime AS ProofOfDeliveryTime,
  BusinessPartnerSalesArea.ProofOfDeliveryTimeValue AS ProofOfDeliveryTimeValue,
  BusinessPartnerSalesArea.SalesItemProposal AS SalesItemProposal,
  BusinessPartnerSalesArea.CustProdProposalProcedure AS CustProdProposalProcedure,
  BusinessPartnerSalesArea.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  BusinessPartnerSalesArea.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  BusinessPartnerSalesArea.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  BusinessPartnerSalesArea._IncotermsSupChnLoc1.Location AS IncotermsLocation1Identifier,
  BusinessPartnerSalesArea._IncotermsSupChnLoc2.Location AS IncotermsLocation2Identifier,
  BusinessPartnerSalesArea._IncotermsSupChnDvtgLoc.Location AS IncotermsDvtgLocIdentifier,
  _SalesOrgText.SalesOrganizationName AS SalesOrganizationName
FROM I_Businesspartnersalesarea AS BusinessPartnerSalesArea
LEFT OUTER JOIN E_BPSALESAREA_D AS _DraftExtension ON SalesOrganization = _DraftExtension.SalesOrganization AND DistributionChannel = _DraftExtension.DistributionChannel AND Division = _DraftExtension.Division AND Customer = _DraftExtension.Customer  -- association [0..1]
LEFT OUTER JOIN E_BPSALESAREA_D AS _ActiveExtension ON SalesOrganization = _ActiveExtension.SalesOrganization AND DistributionChannel = _ActiveExtension.DistributionChannel AND Division = _ActiveExtension.Division AND Customer = _ActiveExtension.Customer  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartnerTP AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartnerSlsAreaTaxTP AS _BusinessPartnerSalesAreaTax ON BusinessPartner = _BusinessPartnerSalesAreaTax.BusinessPartner AND SalesOrganization = _BusinessPartnerSalesAreaTax.SalesOrganization AND DistributionChannel = _BusinessPartnerSalesAreaTax.DistributionChannel AND Division = _BusinessPartnerSalesAreaTax.Division  -- association [1..*]
LEFT OUTER JOIN I_BusinessPartnerPartFuncTP AS _BusinessPartnerPartFunc ON BusinessPartner = _BusinessPartnerPartFunc.BusinessPartner AND SalesOrganization = _BusinessPartnerPartFunc.SalesOrganization AND DistributionChannel = _BusinessPartnerPartFunc.DistributionChannel AND Division = _BusinessPartnerPartFunc.Division  -- association [1..*]
LEFT OUTER JOIN I_BPSalesAreaTextTP AS _BPSalesAreaText ON BusinessPartner = _BPSalesAreaText.BusinessPartner AND SalesOrganization = _BPSalesAreaText.SalesOrganization AND DistributionChannel = _BPSalesAreaText.DistributionChannel AND Division = _BPSalesAreaText.Division  -- association [1..*]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrgText ON SalesOrganizationForEdit = _SalesOrgText.SalesOrganization AND _SalesOrgText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BPCustSalesAreaAddrDepdntTP AS _CustSlsAreaAddrDepdntInfo ON BusinessPartner = _CustSlsAreaAddrDepdntInfo.BusinessPartner AND SalesOrganization = _CustSlsAreaAddrDepdntInfo.SalesOrganization AND DistributionChannel = _CustSlsAreaAddrDepdntInfo.DistributionChannel AND Division = _CustSlsAreaAddrDepdntInfo.Division  -- association [1..*]
;