I_BPCustomerSalesAreaGov

DDL: I_BPCUSTOMERSALESAREAGOV Type: view_entity BASIC Package: MDC_CUST_GOV_BO
127 Fields 2 Data Sources 3 Associations

BP Customer Sales Area Governance data

I_BPCustomerSalesAreaGov is a Basic CDS View that provides data about "BP Customer Sales Area Governance data" in SAP S/4HANA. It reads from 2 data sources (I_BPCustomerSalesAreaProcess, I_CustomerSalesArea) and exposes 127 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, SalesOrganization. It has 3 associations to related views. Part of development package MDC_CUST_GOV_BO.

Data Sources (2)

SourceAliasJoin Type
I_BPCustomerSalesAreaProcess I_BPCustomerSalesAreaProcess from
I_CustomerSalesArea I_CustomerSalesArea union_all

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MasterDataChangeProcess _MasterDataChangeProcess $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
[0..1] I_BPCustomerGov _Customer $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess and $projection.MDChgProcessStep = _Customer.MDChgProcessStep and $projection.MDChgProcessStep = _Customer.MDChgProcessStep and $projection.MDChgProcessStep = _Customer.MDChgProcessStep
[1..1] I_CustomerToBusinessPartner _CustomerToBusinessPartner $projection.Customer = _CustomerToBusinessPartner.Customer

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Sales Area Governance data view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (127)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY SalesOrganization SalesOrganization Sales Organization
KEY DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
KEY Division Division Internal Division ID
BPAssignmentID BPAssignmentID Assignment ID
Customer Customer Sold-to Party
AuthorizationGroup AuthorizationGroup AuthorizGroup
DeletionIndicator DeletionIndicator Deletion Ind.
OrderIsBlockedForCustomer OrderIsBlockedForCustomer Order block
BPCustomerPricingProcedure BPCustomerPricingProcedure CustPrcgProc.
CustomerGroup CustomerGroup Customer Group
SalesDistrict SalesDistrict Sales District
CustomerPriceGroup CustomerPriceGroup CustPrice Group
PriceListType PriceListType Price List Tp.
ItemOrderProbabilityInPercent ItemOrderProbabilityInPercent Order Probab.
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
DeliveryIsBlocked DeliveryIsBlocked Delivery block
CompleteDeliveryIsDefined CompleteDeliveryIsDefined Complete Dlv.
MaxNmbrOfPartialDelivery MaxNmbrOfPartialDelivery Max.Part.Deliv.
PartialDeliveryIsAllowed PartialDeliveryIsAllowed Partial Deliv.
OrderCombinationIsAllowed OrderCombinationIsAllowed Order Combinat.
DeliveryPriority DeliveryPriority Delivery Prior.
AccountByCustomer AccountByCustomer Acct at cust.
ShippingCondition ShippingCondition Shipping Conditions
ProductUnitGroup ProductUnitGroup UoM Group
BillingIsBlockedForCustomer BillingIsBlockedForCustomer Billing block
ManualInvoiceMaintIsRelevant ManualInvoiceMaintIsRelevant Man.Inv.Maint.
InvcCalendarDateIdentification InvcCalendarDateIdentification Run On
InvoiceListSchedule InvoiceListSchedule Inv.List Sched.
Currency Currency Valuation Crcy
CustomerABCClassification CustomerABCClassification ABC class
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup AccAssmtGrpCust
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
SupplyingPlant SupplyingPlant Supplying Plant
SalesGroup SalesGroup Sales Group
SalesOffice SalesOffice Sales Office
SalesItemProposal SalesItemProposal Item proposal
AdditionalCustomerGroup1 AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 AdditionalCustomerGroup5 Customer Grp 5
CustomerIsRebateRelevant CustomerIsRebateRelevant Rebate
ExchangeRateType ExchangeRateType Exch. Rate Type
InspSbstHasNoTimeOrQuantity InspSbstHasNoTimeOrQuantity Price determin.
CustomerPaytGuarProced CustomerPaytGuarProced Paym.guar.proc.
CreditControlArea CreditControlArea Credit Control Area
BlockingForCustomerSalesArea BlockingForCustomerSalesArea Sales Block
SuplrIsRlvtForSettlmtMgmt SuplrIsRlvtForSettlmtMgmt Settlem. Mgmt.
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct Overdeliv. Tol.
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct Underdel. Tol.
SlsUnlmtdOvrdelivIsAllwd SlsUnlmtdOvrdelivIsAllwd Unlimited Tol.
SlsDocIsRlvtForProofOfDeliv SlsDocIsRlvtForProofOfDeliv POD-relevant
ProofOfDeliveryTimeValue ProofOfDeliveryTimeValue POD timeframe
IncotermsVersion IncotermsVersion Inco. Version
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
Origin
KEY MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject Source ID
KEY SalesOrganization SalesOrganization Sales Organization
KEY DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
KEY Division Division Internal Division ID
BPAssignmentID Assignment ID
Customer Customer Sold-to Party
AuthorizationGroup AuthorizationGroup AuthorizGroup
DeletionIndicator DeletionIndicator Deletion Ind.
OrderIsBlockedForCustomer OrderIsBlockedForCustomer Order block
BPCustomerPricingProcedure CustomerPricingProcedure CustPrcgProc.
CustomerGroup CustomerGroup Customer Group
SalesDistrict SalesDistrict Sales District
CustomerPriceGroup CustomerPriceGroup CustPrice Group
PriceListType PriceListType Price List Tp.
ItemOrderProbabilityInPercent ItemOrderProbabilityInPercent Order Probab.
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
DeliveryIsBlocked DeliveryIsBlockedForCustomer Delivery block
CompleteDeliveryIsDefined CompleteDeliveryIsDefined Complete Dlv.
MaxNmbrOfPartialDelivery MaxNmbrOfPartialDelivery Max.Part.Deliv.
PartialDeliveryIsAllowed PartialDeliveryIsAllowed Partial Deliv.
OrderCombinationIsAllowed OrderCombinationIsAllowed Order Combinat.
DeliveryPriority DeliveryPriority Delivery Prior.
AccountByCustomer AccountByCustomer Acct at cust.
ShippingCondition ShippingCondition Shipping Conditions
ProductUnitGroup ProductUnitGroup UoM Group
BillingIsBlockedForCustomer BillingIsBlockedForCustomer Billing block
ManualInvoiceMaintIsRelevant ManualInvoiceMaintIsRelevant Man.Inv.Maint.
InvcCalendarDateIdentification InvoiceDate Run On
InvoiceListSchedule InvoiceListSchedule Inv.List Sched.
Currency Currency Valuation Crcy
CustomerABCClassification CustomerABCClassification ABC class
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup AccAssmtGrpCust
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
SupplyingPlant SupplyingPlant Supplying Plant
SalesGroup SalesGroup Sales Group
SalesOffice SalesOffice Sales Office
SalesItemProposal SalesItemProposal Item proposal
AdditionalCustomerGroup1 AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 AdditionalCustomerGroup5 Customer Grp 5
CustomerIsRebateRelevant CustomerIsRebateRelevant Rebate
ExchangeRateType ExchangeRateType Exch. Rate Type
InspSbstHasNoTimeOrQuantity InspSbstHasNoTimeOrQuantity Price determin.
CustomerPaytGuarProced PaymentGuaranteeProcedure Paym.guar.proc.
CreditControlArea CreditControlArea Credit Control Area
BlockingForCustomerSalesArea SalesBlockForCustomer Sales Block
SuplrIsRlvtForSettlmtMgmt SuplrIsRlvtForSettlmtMgmt Settlem. Mgmt.
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct Overdeliv. Tol.
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct Underdel. Tol.
SlsUnlmtdOvrdelivIsAllwd SlsUnlmtdOvrdelivIsAllwd Unlimited Tol.
SlsDocIsRlvtForProofOfDeliv SlsDocIsRlvtForProofOfDeliv POD-relevant
ProofOfDeliveryTimeValue ProofOfDeliveryTimeValue POD timeframe
IncotermsVersion IncotermsVersion Inco. Version
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
MasterDataIsCurrent
Origin
_Customer _Customer

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_BPCustomerSalesAreaGov.
-- 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_BPCustomerSalesAreaGov 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,
  ProductUnitGroup,
  BillingIsBlockedForCustomer,
  ManualInvoiceMaintIsRelevant,
  InvcCalendarDateIdentification,
  InvoiceListSchedule,
  Currency,
  CustomerABCClassification,
  CustomerAccountAssignmentGroup,
  CustomerPaymentTerms,
  SupplyingPlant,
  SalesGroup,
  SalesOffice,
  SalesItemProposal,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CustomerIsRebateRelevant,
  ExchangeRateType,
  InspSbstHasNoTimeOrQuantity,
  CustomerPaytGuarProced,
  CreditControlArea,
  BlockingForCustomerSalesArea,
  SuplrIsRlvtForSettlmtMgmt,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  SlsUnlmtdOvrdelivIsAllwd,
  SlsDocIsRlvtForProofOfDeliv,
  ProofOfDeliveryTimeValue,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  IsBusinessPurposeCompleted,
  cast( 'P' as abap.char(1) ) AS Origin,
  cast( 'X' as abap_boolean preserving type ) AS MasterDataIsCurrent
FROM I_BPCustomerSalesAreaProcess
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess  -- association [0..1]
LEFT OUTER JOIN I_BPCustomerGov AS _Customer ON MasterDataChangeProcess = _Customer.MasterDataChangeProcess AND MDChgProcessStep = _Customer.MDChgProcessStep AND MDChgProcessStep = _Customer.MDChgProcessStep AND MDChgProcessStep = _Customer.MDChgProcessStep  -- association [0..1]
LEFT OUTER JOIN I_CustomerToBusinessPartner AS _CustomerToBusinessPartner ON Customer = _CustomerToBusinessPartner.Customer  -- association [1..1]
-- UNION ALL with additional select branch(es): I_CustomerSalesArea
;

Learn More