C_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 C_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: CBUPASALESAREA

CREATE VIEW C_BusinessPartnerSalesArea AS
SELECT
  BusinessPartnerSalesArea.BusinessPartner AS BusinessPartner,
  BusinessPartnerSalesArea.SalesOrganization AS SalesOrganization,
  BusinessPartnerSalesArea.DistributionChannel AS DistributionChannel,
  BusinessPartnerSalesArea.Division AS Division,
  BusinessPartnerSalesArea.Customer AS Customer,
  BusinessPartnerSalesArea.BusinessPartnerForEdit AS BusinessPartnerForEdit,
  BusinessPartnerSalesArea.BusinessPartnerUUID AS BusinessPartnerUUID,
  BusinessPartnerSalesArea.SalesOrganizationForEdit AS SalesOrganizationForEdit,
  BusinessPartnerSalesArea.SalesOrganizationName AS SalesOrganizationName,
  BusinessPartnerSalesArea.DistributionChannelForEdit AS DistributionChannelForEdit,
  BusinessPartnerSalesArea.DivisionForEdit AS DivisionForEdit,
  BusinessPartnerSalesArea.SalesDistrict AS SalesDistrict,
  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,
  BusinessPartnerSalesArea.PriceListType AS PriceListType,
  BusinessPartnerSalesArea.DeliveryPriority AS DeliveryPriority,
  BusinessPartnerSalesArea.OrderCombinationIsAllowed AS OrderCombinationIsAllowed,
  BusinessPartnerSalesArea.ShippingCondition AS ShippingCondition,
  BusinessPartnerSalesArea.SupplyingPlant AS SupplyingPlant,
  BusinessPartnerSalesArea.OrderIsBlockedForCustomer AS OrderIsBlockedForCustomer,
  BusinessPartnerSalesArea.DeliveryIsBlockedForCustomer AS DeliveryIsBlockedForCustomer,
  BusinessPartnerSalesArea.BillingIsBlockedForCustomer AS BillingIsBlockedForCustomer,
  BusinessPartnerSalesArea.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  BusinessPartnerSalesArea.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  BusinessPartnerSalesArea.InvoiceDate AS InvoiceDate,
  BusinessPartnerSalesArea.IncotermsVersion AS IncotermsVersion,
  BusinessPartnerSalesArea.IncotermsClassification AS IncotermsClassification,
  BusinessPartnerSalesArea.IncotermsTransferLocation AS IncotermsTransferLocation,
  BusinessPartnerSalesArea.IncotermsLocation1 AS IncotermsLocation1,
  BusinessPartnerSalesArea.IncotermsLocation2 AS IncotermsLocation2,
  BusinessPartnerSalesArea.CustomerPaymentTerms AS CustomerPaymentTerms,
  BusinessPartnerSalesArea.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  BusinessPartnerSalesArea.AuthorizationGroup AS AuthorizationGroup,
  BusinessPartnerSalesArea.PaymentGuaranteeProcedure AS PaymentGuaranteeProcedure,
  BusinessPartnerSalesArea.InvoiceListSchedule AS InvoiceListSchedule,
  BusinessPartnerSalesArea.ExchangeRateType AS ExchangeRateType,
  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.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.SalesItemProposal AS SalesItemProposal,
  BusinessPartnerSalesArea.CustProdProposalProcedure AS CustProdProposalProcedure,
  cast(' ' as abap_boolean preserving type) AS BPCustMultiAddrIsActive,
  BusinessPartnerSalesArea.IncotermsLocation1Identifier AS IncotermsLocation1Identifier,
  BusinessPartnerSalesArea.IncotermsLocation2Identifier AS IncotermsLocation2Identifier,
  _TransportLocationVHText.LocationDescription AS IncotermsDvtgLocDescription,
  BusinessPartnerSalesArea.IncotermsDvtgLocIdentifier AS IncotermsDvtgLocIdentifier,
  BusinessPartnerSalesArea.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  BusinessPartnerSalesArea.CustomerStatisticsGroup AS CustomerStatisticsGroup
FROM I_BusinessPartnerSalesAreaTP AS BusinessPartnerSalesArea
LEFT OUTER JOIN C_Businesspartnersalesareatax AS _BusinessPartnerSalesAreaTax ON BusinessPartner = _BusinessPartnerSalesAreaTax.BusinessPartner AND SalesOrganization = _BusinessPartnerSalesAreaTax.SalesOrganization AND DistributionChannel = _BusinessPartnerSalesAreaTax.DistributionChannel AND Division = _BusinessPartnerSalesAreaTax.Division  -- association [1..*]
LEFT OUTER JOIN C_BusinessPartnerPartFunc AS _BusinessPartnerPartFunc ON BusinessPartner = _BusinessPartnerPartFunc.BusinessPartner AND SalesOrganization = _BusinessPartnerPartFunc.SalesOrganization AND DistributionChannel = _BusinessPartnerPartFunc.DistributionChannel AND Division = _BusinessPartnerPartFunc.Division  -- association [1..*]
LEFT OUTER JOIN C_BPSalesAreaText AS _BPSalesAreaText ON BusinessPartner = _BPSalesAreaText.BusinessPartner AND SalesOrganization = _BPSalesAreaText.SalesOrganization AND DistributionChannel = _BPSalesAreaText.DistributionChannel AND Division = _BPSalesAreaText.Division  -- association [1..*]
LEFT OUTER JOIN C_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON BusinessPartner = _BusinessPartnerCustomer.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN C_SalesOrgVHTemp AS _SalesOrgValueHelp ON SalesOrganizationForEdit = _SalesOrgValueHelp.SalesOrganization AND DistributionChannelForEdit = _SalesOrgValueHelp.DistributionChannel AND DivisionForEdit = _SalesOrgValueHelp.Division  -- association [0..1]
LEFT OUTER JOIN C_SalesOrgVHTemp AS _DistrChnlValueHelp ON SalesOrganizationForEdit = _DistrChnlValueHelp.SalesOrganization AND DistributionChannelForEdit = _DistrChnlValueHelp.DistributionChannel AND DivisionForEdit = _DistrChnlValueHelp.Division  -- association [0..1]
LEFT OUTER JOIN C_SalesOrgVHTemp AS _DivisionValueHelp ON DivisionForEdit = _DivisionValueHelp.Division AND SalesOrganizationForEdit = _DivisionValueHelp.SalesOrganization AND DistributionChannelForEdit = _DivisionValueHelp.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaytGuarProcedT AS _PaymentGuaranteeProcedureText ON PaymentGuaranteeProcedure = _PaymentGuaranteeProcedureText.CustomerPaytGuarProced  -- association [0..*]
LEFT OUTER JOIN C_SalesOrgTextVHTemp AS _SalesOrgText ON SalesOrganization = _SalesOrgText.SalesOrganization  -- association [0..*]
LEFT OUTER JOIN C_Distrchnltextvhtemp AS _DistrChnlText ON DistributionChannel = _DistrChnlText.DistributionChannel  -- association [0..*]
LEFT OUTER JOIN C_Divisiontextvhtemp AS _DivisionText ON Division = _DivisionText.Division  -- association [0..*]
LEFT OUTER JOIN I_SalesOfficeText AS _SalesOfficeText ON SalesOffice = _SalesOfficeText.SalesOffice  -- association [0..*]
LEFT OUTER JOIN I_SalesGroupText AS _SalesGroupText ON SalesGroup = _SalesGroupText.SalesGroup  -- association [0..*]
LEFT OUTER JOIN C_Currencytextvhtemp AS _CurrencyText ON Currency = _CurrencyText.Currency  -- association [0..*]
LEFT OUTER JOIN C_InvoiceDatesTextVHTemp AS _InvoiceDatesText ON InvoiceDate = _InvoiceDatesText.FactoryCalendar  -- association [1..*]
LEFT OUTER JOIN C_IncotermsVersionTextVHTemp AS _IncotermsVersionText ON IncotermsVersion = _IncotermsVersionText.IncotermsVersion  -- association [0..*]
LEFT OUTER JOIN C_IncotermsClassfctnTextVHTemp AS _IncotermsText ON IncotermsClassification = _IncotermsText.IncotermsClassification  -- association [0..*]
LEFT OUTER JOIN C_CustPaymentTermsTextVHTemp AS _CustPaymentTermsText ON CustomerPaymentTerms = _CustPaymentTermsText.CustomerPaymentTerms  -- association [0..*]
LEFT OUTER JOIN C_Partialdeliperitemtextvhtemp AS _PartialDeliveryText ON PartialDeliveryIsAllowed = _PartialDeliveryText.PartialDeliveryIsAllowed  -- association [0..*]
LEFT OUTER JOIN C_CustPriceProcedureTextVHTemp AS _CustPriceProcedureText ON CustomerPricingProcedure = _CustPriceProcedureText.CustomerPricingProcedure  -- association [1..*]
LEFT OUTER JOIN I_PriceListType AS _PriceListType ON PriceListType = _PriceListType.PriceListType  -- association [0..1]
LEFT OUTER JOIN I_PriceListTypeText AS _PriceListTypeText ON PriceListType = _PriceListTypeText.PriceListType  -- association [0..*]
LEFT OUTER JOIN C_DeliveryPlantTextVHTEMP AS _DeliveryPlantText ON SupplyingPlant = _DeliveryPlantText.Plant AND SalesOrganization = _DeliveryPlantText.SalesOrganization AND DistributionChannel = _DeliveryPlantText.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_DeliveryPriorityText AS _DeliveryPriorityText ON DeliveryPriority = _DeliveryPriorityText.DeliveryPriority  -- association [0..*]
LEFT OUTER JOIN C_OrderIsBlockedTextVHTemp AS _OrderBlockValueHelp ON OrderIsBlockedForCustomer = _OrderBlockValueHelp.OrderIsBlockedForCustomer  -- association [0..1]
LEFT OUTER JOIN I_UOMGroup AS _ProductUnitGroup ON ProductUnitGroup = _ProductUnitGroup.ProductUnitGroup  -- association [0..*]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea  -- association [0..*]
LEFT OUTER JOIN I_AdditionalCustomerGroup1Text AS _AdditionalCustGroupOneText ON AdditionalCustomerGroup1 = _AdditionalCustGroupOneText.AdditionalCustomerGroup1  -- association [0..*]
LEFT OUTER JOIN I_AdditionalCustomerGroup2Text AS _AdditionalCustGroupTwoText ON AdditionalCustomerGroup2 = _AdditionalCustGroupTwoText.AdditionalCustomerGroup2  -- association [0..*]
LEFT OUTER JOIN I_AdditionalCustomerGroup3Text AS _AdditionalCustGroupThreeText ON AdditionalCustomerGroup3 = _AdditionalCustGroupThreeText.AdditionalCustomerGroup3  -- association [0..*]
LEFT OUTER JOIN I_AdditionalCustomerGroup4Text AS _AdditionalCustGroupFourText ON AdditionalCustomerGroup4 = _AdditionalCustGroupFourText.AdditionalCustomerGroup4  -- association [0..*]
LEFT OUTER JOIN I_AdditionalCustomerGroup5Text AS _AdditionalCustGroupFiveText ON AdditionalCustomerGroup5 = _AdditionalCustGroupFiveText.AdditionalCustomerGroup5  -- association [0..*]
LEFT OUTER JOIN I_BusPartAuthorizationGroupTxt AS _AuthorizationGrpText ON AuthorizationGroup = _AuthorizationGrpText.AuthorizationGroup AND _AuthorizationGrpText.AuthorizationObject = 'BUPA'  -- association [1..*]
LEFT OUTER JOIN C_BPCustSlsAreaAddrDepdntInfo AS _CustSlsAreaAddrDepdntInfo ON BusinessPartner = _CustSlsAreaAddrDepdntInfo.BusinessPartner AND SalesOrganization = _CustSlsAreaAddrDepdntInfo.SalesOrganization AND DistributionChannel = _CustSlsAreaAddrDepdntInfo.DistributionChannel AND Division = _CustSlsAreaAddrDepdntInfo.Division  -- association [1..*]
LEFT OUTER JOIN I_TransportationLocationVH AS _TransportLocationVHText ON IncotermsSupChnDvtgLocAddlUUID = _TransportLocationVHText.LocationAdditionalUUID  -- association [0..1]
;