C_BPCustomerGovTP

DDL: C_BPCUSTOMERGOVTP Type: view_entity CONSUMPTION Package: MDC_CUST_GOV_BO
72 Fields 1 Data Sources 1 Associations

BP Customer Data Governance

C_BPCustomerGovTP is a Consumption CDS View that provides data about "BP Customer Data Governance" in SAP S/4HANA. It reads from 1 data source (I_BPCustomerGovTP) and exposes 72 fields with key fields BusinessPartnerUUID, MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 1 association to related views. Part of development package MDC_CUST_GOV_BO.

Data Sources (1)

SourceAliasJoin Type
I_BPCustomerGovTP I_BPCustomerGovTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_BPCustProcessChangesUnion _CustomerChanges $projection.MasterDataChangeProcess = _CustomerChanges.MasterDataChangeProcess and $projection.MDChgProcessStep = _CustomerChanges.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _CustomerChanges.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _CustomerChanges.MDChgProcessSrceObject

Annotations (9)

NameValueLevelField
EndUserText.label BP Customer Data Governance view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (72)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID BusinessPartnerUUID UUID
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
MDChgProcessStep MDChgProcessStep Step Number
BPAssignmentID BPAssignmentID Assignment ID
Customer Customer Sold-to Party
OrderIsBlockedForCustomer OrderIsBlockedForCustomer Order block
ExpressTrainStationName ExpressTrainStationName Express station
TrainStationName TrainStationName Train station
AuthorizationGroup AuthorizationGroup AuthorizGroup
BillingIsBlockedForCustomer BillingIsBlockedForCustomer Billing block
FiscalAddress FiscalAddress Fiscal address
AlternativePayerAccount AlternativePayerAccount Alternat.payer
CustomerCorporateGroup CustomerCorporateGroup Group
CustomerAccountGroup CustomerAccountGroup Account group
CustomerClassification CustomerClassification Customer Class.
Supplier Supplier Supplier
DeliveryIsBlocked DeliveryIsBlocked Delivery block
DeletionIndicator DeletionIndicator Deletion Ind.
NielsenRegion NielsenRegion Nielsen ID
County County Wyoming County
CityCode CityCode IATA: City
PostingIsBlocked PostingIsBlocked Posting Block
VATLiability VATLiability Liable for VAT
AlternativePayeeIsAllowed AlternativePayeeIsAllowed Payee in doc.
IndustryCode1 IndustryCode1 Industry code 1
IndustryCode2 IndustryCode2 Industry code 2
IndustryCode3 IndustryCode3 Industry code 3
IndustryCode4 IndustryCode4 Industry code 4
IndustryCode5 IndustryCode5 Industry code 5
FreeDefinedAttribute01 FreeDefinedAttribute01 Attribute 1
FreeDefinedAttribute02 FreeDefinedAttribute02 Attribute 2
FreeDefinedAttribute03 FreeDefinedAttribute03 Attribute 3
FreeDefinedAttribute04 FreeDefinedAttribute04 Attribute 4
FreeDefinedAttribute05 FreeDefinedAttribute05 Attribute 5
FreeDefinedAttribute06 FreeDefinedAttribute06 Attribute 6
FreeDefinedAttribute07 FreeDefinedAttribute07 Attribute 7
FreeDefinedAttribute08 FreeDefinedAttribute08 Attribute 8
FreeDefinedAttribute09 FreeDefinedAttribute09 Attribute 9
FreeDefinedAttribute10 FreeDefinedAttribute10 Attribute 10
DataMediumExchangeIndicator DataMediumExchangeIndicator DME Rec. Code
CustomerConditionGroup1 CustomerConditionGroup1 Condition grp 1
CustomerConditionGroup2 CustomerConditionGroup2 Condition grp 2
CustomerConditionGroup3 CustomerConditionGroup3 Condition grp 3
CustomerConditionGroup4 CustomerConditionGroup4 Condition grp 4
CustomerConditionGroup5 CustomerConditionGroup5 Condition grp 5
ResponsibleType ResponsibleType Tax Type
TaxInvoiceRepresentativeName TaxInvoiceRepresentativeName Rep's Name
BusinessType BusinessType Type of Business
IndustryType IndustryType Type of Industry
DataControllerSet DataControllerSet Data Ctrlr. Set
DataController1 DataController1 Data Controller
DataController2 DataController2 Data Controller
DataController3 DataController3 Data Controller
DataController4 DataController4 Data Controller
DataController5 DataController5 Data Controller
DataController6 DataController6 Data Controller
DataController7 DataController7 Data Controller
DataController8 DataController8 Data Controller
DataController9 DataController9 Data Controller
DataController10 DataController10 Data Controller
BusinessPartnerFullName _BusinessPartnerGov BusinessPartnerFullName Broker Name
Country
Region
MDChgProcessStepWrkflwSts
MDChgProcessStepWrkflwOvrlDcsn
sstring260
sstring241
char81
char81
_CustomerChanges _CustomerChanges

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_BPCustomerGovTP.
-- 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_BPCustomerGovTP AS
SELECT
  BusinessPartnerUUID,
  MasterDataChangeProcess,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  MDChgProcessStep,
  BPAssignmentID,
  Customer,
  OrderIsBlockedForCustomer,
  ExpressTrainStationName,
  TrainStationName,
  AuthorizationGroup,
  BillingIsBlockedForCustomer,
  FiscalAddress,
  AlternativePayerAccount,
  CustomerCorporateGroup,
  CustomerAccountGroup,
  CustomerClassification,
  Supplier,
  DeliveryIsBlocked,
  DeletionIndicator,
  NielsenRegion,
  County,
  CityCode,
  PostingIsBlocked,
  VATLiability,
  AlternativePayeeIsAllowed,
  IndustryCode1,
  IndustryCode2,
  IndustryCode3,
  IndustryCode4,
  IndustryCode5,
  FreeDefinedAttribute01,
  FreeDefinedAttribute02,
  FreeDefinedAttribute03,
  FreeDefinedAttribute04,
  FreeDefinedAttribute05,
  FreeDefinedAttribute06,
  FreeDefinedAttribute07,
  FreeDefinedAttribute08,
  FreeDefinedAttribute09,
  FreeDefinedAttribute10,
  DataMediumExchangeIndicator,
  CustomerConditionGroup1,
  CustomerConditionGroup2,
  CustomerConditionGroup3,
  CustomerConditionGroup4,
  CustomerConditionGroup5,
  ResponsibleType,
  TaxInvoiceRepresentativeName,
  BusinessType,
  IndustryType,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10,
  _BusinessPartnerGov.BusinessPartnerFullName AS BusinessPartnerFullName,
  _BusinessPartnerGov._BusinessPartnerStandardAddr.Country AS Country,
  _BusinessPartnerGov._BusinessPartnerStandardAddr.Region AS Region,
  _Process._CurrentStep.MDChgProcessStepWrkflwSts AS MDChgProcessStepWrkflwSts,
  _Process._CurrentStep.MDChgProcessStepWrkflwOvrlDcsn AS MDChgProcessStepWrkflwOvrlDcsn,
  virtual AddressLine1Text : abap.sstring( 260 ) AS sstring260,
  virtual AddressLine2Text : abap.sstring( 241 ) AS sstring241,
  virtual MDChgProcCustomerDescription : abap.char(81) AS char81
FROM I_BPCustomerGovTP
LEFT OUTER JOIN C_BPCustProcessChangesUnion AS _CustomerChanges ON MasterDataChangeProcess = _CustomerChanges.MasterDataChangeProcess AND MDChgProcessStep = _CustomerChanges.MDChgProcessStep AND MDChgProcessSrceSystem = _CustomerChanges.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _CustomerChanges.MDChgProcessSrceObject  -- association [0..*]
;

Learn More