I_BPCustomerSalesAreaProcessTP

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_BPCustomerSalesAreaProcessTP.
-- 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_BPCustomerSalesAreaProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  SalesOrganization,
  DistributionChannel,
  Division,
  BPAssignmentID,
  Customer,
  AuthorizationGroup,
  DeletionIndicator,
  OrderIsBlockedForCustomer,
  BPCustomerPricingProcedure,
  CustomerGroup,
  SalesDistrict,
  CustomerPriceGroup,
  PriceListType,
  ItemOrderProbabilityInPercent,
  IncotermsClassification,
  IncotermsTransferLocation,
  DeliveryIsBlocked,
  CompleteDeliveryIsDefined,
  MaxNmbrOfPartialDelivery,
  PartialDeliveryIsAllowed,
  OrderCombinationIsAllowed,
  DeliveryPriority,
  AccountByCustomer,
  ShippingCondition,
  BillingIsBlockedForCustomer,
  ManualInvoiceMaintIsRelevant,
  InvcCalendarDateIdentification,
  InvoiceListSchedule,
  Currency,
  CustomerABCClassification,
  CustomerAccountAssignmentGroup,
  CustomerPaymentTerms,
  SupplyingPlant,
  SalesGroup,
  SalesOffice,
  SalesItemProposal,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CustomerIsRebateRelevant,
  ExchangeRateType,
  InspSbstHasNoTimeOrQuantity,
  CustomerPaytGuarProced,
  CreditControlArea,
  cast( case when BlockingForCustomerSalesArea = 'X ' then 'X' else '' end as boole_d ) AS CustomerSalesAreaIsBlocked,
  SuplrIsRlvtForSettlmtMgmt,
  ProductUnitGroup,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  SlsUnlmtdOvrdelivIsAllwd,
  CustProdProposalProcedure,
  SlsDocIsRlvtForProofOfDeliv,
  ProofOfDeliveryTimeValue,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  IsBusinessPurposeCompleted,
  MDChgProcSrceLastChgdDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary
FROM I_BPCustomerSalesAreaProcess
LEFT OUTER JOIN I_BPProcessKPIRecordType AS _RecordType ON MasterDataChangeProcess = _RecordType.MasterDataChangeProcess AND MDChgProcessStep = _RecordType.MDChgProcessStep AND MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject  -- association [0..1]
LEFT OUTER JOIN I_MDChangeProcessKPIRowVH AS _KPIUpdateStatusText ON MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus  -- association [0..1]
LEFT OUTER JOIN I_SalesArea AS _SalesArea ON SalesOrganization = _SalesArea.SalesOrganization AND DistributionChannel = _SalesArea.DistributionChannel AND Division = _SalesArea.Division  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_SalesAreaSalesOffice AS _SalesOffice ON SalesOrganization = _SalesOffice.SalesOrganization AND DistributionChannel = _SalesOffice.DistributionChannel AND Division = _SalesOffice.OrganizationDivision AND SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_SalesOfficeSalesGroup AS _SalesOfficeSalesGroup ON SalesOffice = _SalesOfficeSalesGroup.SalesOffice AND SalesGroup = _SalesOfficeSalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_BusPartAuthorizationGroup AS _AuthorizationGroup ON AuthorizationGroup = _AuthorizationGroup.AuthorizationGroup AND _AuthorizationGroup.AuthorizationObject = 'BUPA'  -- association [0..1]
LEFT OUTER JOIN I_PriceListType AS _PriceListType ON PriceListType = _PriceListType.PriceListType  -- association [0..1]
LEFT OUTER JOIN I_PartialDeliveryItem AS _PartialDeliveryItem ON PartialDeliveryIsAllowed = _PartialDeliveryItem.PartialDeliveryIsAllowed  -- association [0..1]
LEFT OUTER JOIN I_DeliveryPriority AS _DeliveryPriority ON DeliveryPriority = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _InvoiceCalendar ON InvcCalendarDateIdentification = _InvoiceCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _InvoiceListSchedule ON InvoiceListSchedule = _InvoiceListSchedule.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaymentTerms AS _PaymentTerms ON CustomerPaymentTerms = _PaymentTerms.CustomerPaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_Allwdplantsperslsorg AS _Plant ON SalesOrganization = _Plant.SalesOrganization AND DistributionChannel = _Plant.DistributionChannel AND SupplyingPlant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1 ON AdditionalCustomerGroup1 = _AdditionalCustomerGroup1.AdditionalCustomerGroup1  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2 ON AdditionalCustomerGroup2 = _AdditionalCustomerGroup2.AdditionalCustomerGroup2  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3 ON AdditionalCustomerGroup3 = _AdditionalCustomerGroup3.AdditionalCustomerGroup3  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4 ON AdditionalCustomerGroup4 = _AdditionalCustomerGroup4.AdditionalCustomerGroup4  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5 ON AdditionalCustomerGroup5 = _AdditionalCustomerGroup5.AdditionalCustomerGroup5  -- association [0..1]
LEFT OUTER JOIN I_CustomerPaytGuarProced AS _CustomerPaytGuarProced ON CustomerPaytGuarProced = _CustomerPaytGuarProced.CustomerPaytGuarProced  -- association [0..1]
LEFT OUTER JOIN I_CreditControlArea AS _CreditControlArea ON CreditControlArea = _CreditControlArea.CreditControlArea  -- association [0..1]
LEFT OUTER JOIN I_UOMGroup AS _ProductUnitGroup ON ProductUnitGroup = _ProductUnitGroup.ProductUnitGroup  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _IncotermsVersion ON IncotermsVersion = _IncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryBlockReason ON DeliveryIsBlocked = _DeliveryBlockReason.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_CustomerAccountAssgmtGroup AS _AccountAssgmtGroup ON CustomerAccountAssignmentGroup = _AccountAssgmtGroup.CustomerAccountAssignmentGroup  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _BillingBlockReason ON BillingIsBlockedForCustomer = _BillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_CustomerPriceGroup AS _PriceGroup ON CustomerPriceGroup = _PriceGroup.CustomerPriceGroup  -- association [0..1]
LEFT OUTER JOIN I_ExchangeRateType AS _ExchangeRateType ON ExchangeRateType = _ExchangeRateType.ExchangeRateType  -- association [0..1]
LEFT OUTER JOIN E_BPCustomerSalesAreaProcess AS _ExtBPCustomerSalesAreaProcess ON MasterDataChangeProcess = _ExtBPCustomerSalesAreaProcess.MasterDataChangeProcess AND MDChgProcessStep = _ExtBPCustomerSalesAreaProcess.MDChgProcessStep AND MDChgProcessSrceSystem = _ExtBPCustomerSalesAreaProcess.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ExtBPCustomerSalesAreaProcess.MDChgProcessSrceObject AND BPAssignmentID = _ExtBPCustomerSalesAreaProcess.BPAssignmentID AND SalesOrganization = _ExtBPCustomerSalesAreaProcess.SalesOrganization AND DistributionChannel = _ExtBPCustomerSalesAreaProcess.DistributionChannel AND Division = _ExtBPCustomerSalesAreaProcess.Division  -- association [0..1]
LEFT OUTER JOIN I_BPCustPartnerFunctionsProcTP AS _CustomerPartnerFunctions ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_BPCustSalesTextGeneralProcTP AS _CustomerSalesTextGeneral ON /* condition not available in parsed metadata */  -- association [0..*]
;