I_CustomerSalesAreaTP

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_CustomerSalesAreaTP.
-- 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.

CREATE VIEW I_CustomerSalesAreaTP AS
SELECT
  CustomerSalesArea.BusinessPartner AS BusinessPartner,
  CustomerSalesArea.Customer AS Customer,
  CustomerSalesArea.SalesOrganization AS SalesOrganization,
  CustomerSalesArea.DistributionChannel AS DistributionChannel,
  CustomerSalesArea.Division AS Division,
  CustomerSalesArea.BusinessPartner AS BusinessPartnerForEdit,
  CustomerSalesArea.SalesOrganization AS SalesOrganizationForEdit,
  CustomerSalesArea.DistributionChannel AS DistributionChannelForEdit,
  CustomerSalesArea.Division AS DivisionForEdit,
  CustomerSalesArea.BusinessPartnerUUID AS BusinessPartnerUUID,
  CustomerSalesArea.CustomerGroup AS CustomerGroup,
  CustomerSalesArea.SalesOffice AS SalesOffice,
  CustomerSalesArea.SalesGroup AS SalesGroup,
  CustomerSalesArea.AccountByCustomer AS AccountByCustomer,
  CustomerSalesArea.CustomerABCClassification AS CustomerABCClassification,
  CustomerSalesArea.Currency AS Currency,
  CustomerSalesArea.CustomerPriceGroup AS CustomerPriceGroup,
  CustomerPricingProcedure AS BPCustomerPricingProcedure,
  CustomerSalesArea.DeliveryPriority AS DeliveryPriority,
  CustomerSalesArea.OrderCombinationIsAllowed AS OrderCombinationIsAllowed,
  CustomerSalesArea.ShippingCondition AS ShippingCondition,
  CustomerSalesArea.SupplyingPlant AS SupplyingPlant,
  CustomerSalesArea.DeliveryIsBlockedForCustomer AS DelivBlkdForCustSlsArea,
  CustomerSalesArea.BillingIsBlockedForCustomer AS BillingIsBlockedForCustomer,
  CustomerSalesArea.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  CustomerSalesArea.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  CustomerSalesArea.InvoiceDate AS BPFactoryCalendarID,
  CustomerSalesArea.IncotermsClassification AS IncotermsClassification,
  CustomerSalesArea.IncotermsTransferLocation AS IncotermsTransferLocation,
  CustomerSalesArea.CustomerPaymentTerms AS CustomerPaymentTerms,
  CustomerSalesArea.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  CustomerSalesArea.SalesDistrict AS SalesDistrict,
  CustomerSalesArea.OrderIsBlockedForCustomer AS OrderIsBlockedForCustomer,
  CustomerSalesArea.PriceListType AS PriceListType,
  CustomerSalesArea.IncotermsVersion AS IncotermsVersion,
  CustomerSalesArea.IncotermsLocation1 AS IncotermsLocation1,
  CustomerSalesArea.IncotermsLocation2 AS IncotermsLocation2,
  CustomerSalesArea.AuthorizationGroup AS AuthorizationGroup,
  CustomerSalesArea.PaymentGuaranteeProcedure AS CustomerPaytGuarProced,
  CustomerSalesArea.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  CustomerSalesArea.InvoiceListSchedule AS InvoiceListSchedule,
  CustomerSalesArea.ExchangeRateType AS ExchangeRateType,
  CustomerSalesArea.ItemOrderProbabilityInPercent AS ItemOrderProbabilityInPercent,
  CustomerSalesArea.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  CustomerSalesArea.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  CustomerSalesArea.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  CustomerSalesArea.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  CustomerSalesArea.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  CustomerSalesArea.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  CustomerSalesArea.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  CustomerSalesArea.MaxNmbrOfPartialDelivery AS MaxNmbrOfPartialDelivery,
  CustomerSalesArea.SuplrIsRlvtForSettlmtMgmt AS SuplrIsRlvtForSettlmtMgmt,
  CustomerSalesArea.ProductUnitGroup AS ProductUnitGroup,
  CustomerSalesArea.SlsDocIsRlvtForProofOfDeliv AS SlsDocIsRlvtForProofOfDeliv,
  CustomerSalesArea.SlsUnlmtdOvrdelivIsAllwd AS SlsUnlmtdOvrdelivIsAllwd,
  CustomerSalesArea.CreditControlArea AS CreditControlArea,
  CustomerSalesArea.CustomerIsRebateRelevant AS CustomerIsRebateRelevant,
  CustomerSalesArea.InspSbstHasNoTimeOrQuantity AS InspSbstHasNoTimeOrQuantity,
  CustomerSalesArea.ManualInvoiceMaintIsRelevant AS ManualInvoiceMaintIsRelevant,
  CustomerSalesArea.SalesItemProposal AS SalesItemProposal,
  CustomerSalesArea.CustProdProposalProcedure AS CustProdProposalProcedure,
  CustomerSalesArea.ProofOfDeliveryTimeValue AS ProofOfDeliveryTimeValue,
  CustomerSalesArea.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  CustomerSalesArea.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  CustomerSalesArea.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  CustomerSalesArea.SalesBlockForCustomer AS SalesBlockForCustomer,
  CustomerSalesArea._IncotermsSupChnLoc1.Location AS IncotermsLocation1Identifier,
  CustomerSalesArea._IncotermsSupChnLoc2.Location AS IncotermsLocation2Identifier,
  CustomerSalesArea._IncotermsSupChnDvtgLoc.Location AS IncotermsDvtgLocIdentifier,
  cast( 'X' as sdraft_is_active preserving type ) AS BPHasActiveEntity,
  _TransportLocationText.LocationDescription AS IncotermsDvtgLocDescription,
  _DeliveryPlantText.PlantName AS PlantName,
  _SalesOrgText.SalesOrganizationName AS SalesOrganizationName
FROM I_Businesspartnersalesarea AS CustomerSalesArea
LEFT OUTER JOIN I_BusinessPartnerTP_2 AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..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_TransportationLocationVH AS _TransportLocationText ON IncotermsSupChnDvtgLocAddlUUID = _TransportLocationText.LocationAdditionalUUID  -- 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 I_DeliveryPriorityText AS _DeliveryPriorityText ON DeliveryPriority = _DeliveryPriorityText.DeliveryPriority  -- association [0..*]
LEFT OUTER JOIN I_PriceListTypeText AS _PriceListTypeText ON PriceListType = _PriceListTypeText.PriceListType  -- 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 I_CustomerPaytGuarProcedT AS _PaymentGuaranteeProcedureText ON CustomerPaytGuarProced = _PaymentGuaranteeProcedureText.CustomerPaytGuarProced  -- association [0..*]
LEFT OUTER JOIN I_PriceListType AS _PriceListType ON PriceListType = _PriceListType.PriceListType  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _DeliveryPlantText ON SupplyingPlant = _DeliveryPlantText.Plant  -- association [0..1 ]
;