C_BPCustomerSalesAreaGovTP

DDL: C_BPCUSTOMERSALESAREAGOVTP Type: view_entity CONSUMPTION
71 Fields 1 Data Sources

Projection for BP Customer Sales Area Governance

C_BPCustomerSalesAreaGovTP is a Consumption CDS View that provides data about "Projection for BP Customer Sales Area Governance" in SAP S/4HANA. It reads from 1 data source (I_BPCustomerSalesAreaGovTP) and exposes 71 fields with key fields BusinessPartnerUUID, CustomerSalesAreaUUID, MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject.

Data Sources (1)

SourceAliasJoin Type
I_BPCustomerSalesAreaGovTP I_BPCustomerSalesAreaGovTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Projection for BP Customer Sales Area Governance view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (71)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID BusinessPartnerUUID UUID
KEY CustomerSalesAreaUUID CustomerSalesAreaUUID UUID
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
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
MDChgProcessStep MDChgProcessStep Step Number
BPAssignmentID BPAssignmentID Assignment ID
Customer Customer Sold-to Party
SalesOrganizationForEdit SalesOrganizationForEdit Sales Org.
DistributionChannelForEdit DistributionChannelForEdit RefDistCh-Cust/Mat.
DivisionForEdit DivisionForEdit Division
DivisionNameasDivisionNamelocalized
AuthorizationGroup AuthorizationGroup AuthorizGroup
DeletionIndicator DeletionIndicator Deletion Ind.
OrderIsBlockedForCustomer OrderIsBlockedForCustomer Order block
BPCustomerPricingProcedure BPCustomerPricingProcedure Cust.Pric.Proc.
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 Invoicing Dates
InvoiceListSchedule InvoiceListSchedule Inv.List Sched.
Currency Currency Valuation Crcy
CustomerABCClassification CustomerABCClassification ABC class
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup AccAssmtGrpCust
char1024
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
CustomerSalesAreaIsBlocked CustomerSalesAreaIsBlocked TRUE
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 MasterDataIsCurrent Truth Value
char81

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_BPCustomerSalesAreaGovTP.
-- 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 C_BPCustomerSalesAreaGovTP AS
SELECT
  BusinessPartnerUUID,
  CustomerSalesAreaUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  SalesOrganization,
  DistributionChannel,
  Division,
  MDChgProcessStep,
  BPAssignmentID,
  Customer,
  SalesOrganizationForEdit,
  DistributionChannelForEdit,
  DivisionForEdit,
  _DivisionText.DivisionName as DivisionName : localized AS DivisionNameasDivisionNamelocalized,
  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,
  virtual PaymentTermsName : abap.char(1024) AS char1024,
  CustomerPaymentTerms,
  SupplyingPlant,
  SalesGroup,
  SalesOffice,
  SalesItemProposal,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CustomerIsRebateRelevant,
  ExchangeRateType,
  InspSbstHasNoTimeOrQuantity,
  CustomerPaytGuarProced,
  CreditControlArea,
  CustomerSalesAreaIsBlocked,
  SuplrIsRlvtForSettlmtMgmt,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  SlsUnlmtdOvrdelivIsAllwd,
  SlsDocIsRlvtForProofOfDeliv,
  ProofOfDeliveryTimeValue,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  IsBusinessPurposeCompleted,
  MasterDataIsCurrent,
  virtual SalesAreaDesc : abap.char(81) AS char81
FROM I_BPCustomerSalesAreaGovTP
;

Learn More