What is R_BPCustomerGovernanceDraft in SAP S/4HANA?

R_BPCustomerGovernanceDraft is a basic CDS view in SAP S/4HANA. Access BP Customer It contains 72 fields.

Which tables does R_BPCustomerGovernanceDraft read from?

R_BPCustomerGovernanceDraft reads data from: kna1_dft.

What VDM layer is R_BPCustomerGovernanceDraft?

R_BPCustomerGovernanceDraft is classified as a Basic (interface) view providing a 1:1 representation of a database table.

R_BPCustomerGovernanceDraft

DDL: R_BPCUSTOMERGOVERNANCEDRAFT Type: view_entity BASIC

72 Fields 1 Data Sources 2 Associations

Access BP Customer

R_BPCustomerGovernanceDraft is a Basic CDS View that provides data about "Access BP Customer" in SAP S/4HANA. It reads from 1 data source (kna1_dft) and exposes 72 fields with key fields BusinessPartnerUUID, MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
kna1_dft	kna1_dft	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_BusinessPartnerGov	_BusinessPartnerGov	`$projection.MDChgProcessStep = _BusinessPartnerGov.MDChgProcessStep and $projection.MasterDataChangeProcess = _BusinessPartnerGov.MasterDataChangeProcess and $projection.MDChgProcessSrceSystem = _BusinessPartnerGov.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartnerGov.MDChgProcessSrceObject and _BusinessPartnerGov.MasterDataIsCurrent = 'X'`
[0..1]	E_BPCustomerGovernanceDraft	_ExtCustomerDraft	`$projection.BusinessPartnerUUID = _ExtCustomerDraft.BusinessPartnerUUID and $projection.MasterDataChangeProcess = _ExtCustomerDraft.MasterDataChangeProcess and $projection.MDChgProcessSrceSystem = _ExtCustomerDraft.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _ExtCustomerDraft.MDChgProcessSrceObject`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Access BP Customer	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
VDM.viewType	#BASIC	view

Fields (72)

Key	Field	Source Field	Description
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
	ETag	etag	Update Token
	MDChgProcessSourceModified	mdchgprocesssourcemodified	Modified
	Origin	origin	Task Origin
	DraftEntityCreationDateTime	draftentitycreationdatetime	Draft Created On
	DraftEntityLastChangeDateTime	draftentitylastchangedatetime	Draft Last Changed On
	DraftAdministrativeDataUUID	draftadministrativedatauuid	UUID
	DraftEntityOperationCode	draftentityoperationcode	Draft - Operation Code
	HasActiveEntity	hasactiveentity	TRUE
	DraftFieldChanges	draftfieldchanges	Field Changes
	_BusinessPartnerGov	_BusinessPartnerGov

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 R_BPCustomerGovernanceDraft.
-- 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 R_BPCustomerGovernanceDraft 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,
  ETag,
  MDChgProcessSourceModified,
  Origin,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM kna1_dft
LEFT OUTER JOIN I_BusinessPartnerGov AS _BusinessPartnerGov ON MDChgProcessStep = _BusinessPartnerGov.MDChgProcessStep AND MasterDataChangeProcess = _BusinessPartnerGov.MasterDataChangeProcess AND MDChgProcessSrceSystem = _BusinessPartnerGov.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartnerGov.MDChgProcessSrceObject AND _BusinessPartnerGov.MasterDataIsCurrent = 'X'  -- association [0..1]
LEFT OUTER JOIN E_BPCustomerGovernanceDraft AS _ExtCustomerDraft ON BusinessPartnerUUID = _ExtCustomerDraft.BusinessPartnerUUID AND MasterDataChangeProcess = _ExtCustomerDraft.MasterDataChangeProcess AND MDChgProcessSrceSystem = _ExtCustomerDraft.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _ExtCustomerDraft.MDChgProcessSrceObject  -- association [0..1]
;

Depth:

R_BPCustomerGovernanceDraft view_entity

kna1_dft