What is C_BPCustomerProcessTP in SAP S/4HANA?

C_BPCustomerProcessTP is a consumption CDS view in SAP S/4HANA. BP Customer Process Data It contains 109 fields.

Which tables does C_BPCustomerProcessTP read from?

C_BPCustomerProcessTP reads data from: I_BPCustomerProcessTP.

What VDM layer is C_BPCustomerProcessTP?

C_BPCustomerProcessTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_BPCustomerProcessTP

DDL: C_BPCUSTOMERPROCESSTP Type: view_entity CONSUMPTION Package: MDC_CUST_STAGING_BO

109 Fields 1 Data Sources 2 Associations 2 OData Services

BP Customer Process Data

C_BPCustomerProcessTP is a Consumption CDS View that provides data about "BP Customer Process Data" in SAP S/4HANA. It reads from 1 data source (I_BPCustomerProcessTP) and exposes 109 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, BPAssignmentID. It has 2 associations to related views. It is exposed through 2 OData services (ASQL_F7205A, X_C_BPCUSTOMERPROCESSTP_SRV). Part of development package MDC_CUST_STAGING_BO.

Data Sources (1)

Source	Alias	Join Type
I_BPCustomerProcessTP	I_BPCustomerProcessTP	projection

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	C_BPCustomerProcessChanges	_Changes	`$projection.MasterDataChangeProcess = _Changes.MasterDataChangeProcess and $projection.MDChgProcessStep = _Changes.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject and _Changes.MDChgProcessSourceModified = 'X'`
[0..1]	I_MDChangeProcessRecordTarget	_RecordTarget	`$projection.MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess and $projection.MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject and _RecordTarget.MDChgProcessSrceObjectTypeCode = '147'`

Annotations (7)

Name	Value	Level
EndUserText.label	BP Customer Process Data	view
AccessControl.authorizationCheck	#MANDATORY	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XXL	view
VDM.viewType	#CONSUMPTION	view

OData Services (2)

Service	Binding	Version	Contract	Release
ASQL_F7205A	ASQL_F7205A		C2	NOT_RELEASED
X_C_BPCUSTOMERPROCESSTP_SRV

Fields (109)

Key	Field	Source Table	Source Field	Description
KEY	MasterDataChangeProcess		MasterDataChangeProcess	Process ID
KEY	MDChgProcessStep		MDChgProcessStep	Step Number
KEY	MDChgProcessSrceSystem		MDChgProcessSrceSystem	Source System
KEY	MDChgProcessSrceObject		MDChgProcessSrceObject	Source ID
KEY	BPAssignmentID		BPAssignmentID	Assignment ID
	Customer		Customer	Sold-to Party
	OrderIsBlockedForCustomer		OrderIsBlockedForCustomer	Order block
	ExpressTrainStationName		ExpressTrainStationName	Express station
	TrainStationName		TrainStationName	Train station
	AuthorizationGroup		AuthorizationGroup	AuthorizGroup
	AuthorizationGroupName	_AuthorizationGroupText	AuthorizationGroupName
	BillingIsBlockedForCustomer		BillingIsBlockedForCustomer	Billing block
	BillingBlockReasonDescriptionlocalized
	FiscalAddress		FiscalAddress	Fiscal address
	CustomerName	_FiscalAddress	BPCustomerName	Name of Customer
	AlternativePayerAccount		AlternativePayerAccount	Alternat.payer
	AlternativePayerName	_AlternativePayerAccount	BPCustomerName	Name of Customer
	CustomerCorporateGroup		CustomerCorporateGroup	Group
	CustomerAccountGroup		CustomerAccountGroup	Account group
	AccountGroupNamelocalized
	CustomerClassification		CustomerClassification	Customer Class.
	Supplier		Supplier	Supplier
	SupplierName	_Supplier	BPSupplierName	Supplier Name
	DeliveryIsBlocked		DeliveryIsBlocked	Delivery block
	DeliveryBlockReasonTextlocalized
	DeletionIndicator		DeletionIndicator	Deletion Ind.
	NielsenRegion		NielsenRegion	Nielsen ID
	NielsenRegionDescription
	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
	CustFreeDefinedAttribute01Text
	FreeDefinedAttribute02		FreeDefinedAttribute02	Attribute 2
	CustFreeDefinedAttribute02Text
	FreeDefinedAttribute03		FreeDefinedAttribute03	Attribute 3
	CustFreeDefinedAttribute03Text
	FreeDefinedAttribute04		FreeDefinedAttribute04	Attribute 4
	CustFreeDefinedAttribute04Text
	FreeDefinedAttribute05		FreeDefinedAttribute05	Attribute 5
	CustFreeDefinedAttribute05Text
	FreeDefinedAttribute06		FreeDefinedAttribute06	Attribute 6
	CustFreeDefinedAttribute06Text
	FreeDefinedAttribute07		FreeDefinedAttribute07	Attribute 7
	CustFreeDefinedAttribute07Text
	FreeDefinedAttribute08		FreeDefinedAttribute08	Attribute 8
	CustFreeDefinedAttribute08Text
	FreeDefinedAttribute09		FreeDefinedAttribute09	Attribute 9
	CustFreeDefinedAttribute09Text
	FreeDefinedAttribute10		FreeDefinedAttribute10	Attribute 10
	CustFreeDefinedAttributeText
	DataMediumExchangeIndicator		DataMediumExchangeIndicator	DME Rec. Code
	ExchangeIndicatorTextlocalized
	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
	AccountTaxTypeDescription	_AccountTypeText	AccountTaxTypeDescription
	TaxInvoiceRepresentativeName		TaxInvoiceRepresentativeName	Rep's Name
	BusinessType		BusinessType	Type of Business
	IndustryType		IndustryType	Type of Industry
	MDChgProcessSourceModified		MDChgProcessSourceModified	Modified
	MDChgProcessSourceModifBinary		MDChgProcessSourceModifBinary
	MDChgProcSrceLastChgdDateTime		MDChgProcSrceLastChgdDateTime
	Country
	Region
	virtualCustomerNumberDisplaykunnr
	char81
	sstring255
	sstring260
	sstring260
	MDChgProcKPIRecordTypeText
	MDChgProcKPIRecordType	_RecordType	MDChgProcKPIRecordType
	MDChgProcKPIRecordStatusText
	MDChgProcessValidationStatus	_BusinessPartner	MDChgProcessValidationStatus
	MDChgProcKPIUpdateStatusText	_KPIUpdateStatusText	MDChangeProcKPIValueKeyDesc
	MDChgProcKPIUpdateStatus		MDChgProcKPIUpdateStatus
	virtualMDChangeProcessMessageTypesymsgty
	virtualMDChangeProcessMessageIDmsgid
	virtualMDChangeProcessMessageNumbermsgno
	MDChgProcessActivationTarget	_BusinessPartner	MDChgProcessActivationTarget
	MDChgProcKPIRecordTargetText
	MDChgProcessReplicationStatus	_BusinessPartner	MDChgProcessReplicationStatus
	MDChgProcReplicationStatusText
	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
	_KPIUpdateStatusText		_KPIUpdateStatusText
	_RecordMessages		_RecordMessages
	_RecordType		_RecordType
	_Changes		_Changes
	_RecordTarget		_RecordTarget

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_BPCustomerProcessTP.
-- 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_BPCustomerProcessTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  BPAssignmentID,
  Customer,
  OrderIsBlockedForCustomer,
  ExpressTrainStationName,
  TrainStationName,
  AuthorizationGroup,
  _AuthorizationGroupText.AuthorizationGroupName AS AuthorizationGroupName,
  BillingIsBlockedForCustomer,
  _BillingBlockReason._Text.BillingBlockReasonDescription : localized AS BillingBlockReasonDescriptionlocalized,
  FiscalAddress,
  _FiscalAddress.BPCustomerName AS CustomerName,
  AlternativePayerAccount,
  _AlternativePayerAccount.BPCustomerName AS AlternativePayerName,
  CustomerCorporateGroup,
  CustomerAccountGroup,
  _CustomerAccountGroup._CustomerAccountGroupText.AccountGroupName : localized AS AccountGroupNamelocalized,
  CustomerClassification,
  Supplier,
  _Supplier.BPSupplierName AS SupplierName,
  DeliveryIsBlocked,
  _DeliveryBlockReason._Text.DeliveryBlockReasonText : localized AS DeliveryBlockReasonTextlocalized,
  DeletionIndicator,
  NielsenRegion,
  _NielsenRegion._Text.NielsenRegionDescription AS NielsenRegionDescription,
  County,
  CityCode,
  PostingIsBlocked,
  VATLiability,
  AlternativePayeeIsAllowed,
  IndustryCode1,
  IndustryCode2,
  IndustryCode3,
  IndustryCode4,
  IndustryCode5,
  FreeDefinedAttribute01,
  _Attribute01._Text.CustFreeDefinedAttributeText AS CustFreeDefinedAttribute01Text,
  FreeDefinedAttribute02,
  _Attribute02._Text.CustFreeDefinedAttributeText AS CustFreeDefinedAttribute02Text,
  FreeDefinedAttribute03,
  _Attribute03._Text.CustFreeDefinedAttributeText AS CustFreeDefinedAttribute03Text,
  FreeDefinedAttribute04,
  _Attribute04._Text.CustFreeDefinedAttributeText AS CustFreeDefinedAttribute04Text,
  FreeDefinedAttribute05,
  _Attribute05._Text.CustFreeDefinedAttributeText AS CustFreeDefinedAttribute05Text,
  FreeDefinedAttribute06,
  _Attribute06._Text.CustFreeDefinedAttributeText AS CustFreeDefinedAttribute06Text,
  FreeDefinedAttribute07,
  _Attribute07._Text.CustFreeDefinedAttributeText AS CustFreeDefinedAttribute07Text,
  FreeDefinedAttribute08,
  _Attribute08._Text.CustFreeDefinedAttributeText AS CustFreeDefinedAttribute08Text,
  FreeDefinedAttribute09,
  _Attribute09._Text.CustFreeDefinedAttributeText AS CustFreeDefinedAttribute09Text,
  FreeDefinedAttribute10,
  _Attribute10._Text.CustFreeDefinedAttributeText AS CustFreeDefinedAttributeText,
  DataMediumExchangeIndicator,
  _DataMediumExchange._Text.ExchangeIndicatorText : localized AS ExchangeIndicatorTextlocalized,
  CustomerConditionGroup1,
  CustomerConditionGroup2,
  CustomerConditionGroup3,
  CustomerConditionGroup4,
  CustomerConditionGroup5,
  ResponsibleType,
  _AccountTypeText.AccountTaxTypeDescription AS AccountTaxTypeDescription,
  TaxInvoiceRepresentativeName,
  BusinessType,
  IndustryType,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  MDChgProcSrceLastChgdDateTime,
  _BusinessPartner._BusinessPartnerStandardAddr.Country AS Country,
  _BusinessPartner._BusinessPartnerStandardAddr.Region AS Region,
  virtual CustomerNumberDisplay : kunnr AS virtualCustomerNumberDisplaykunnr,
  virtual MDChgProcCustomerDescription : abap.char(81) AS char81,
  virtual SourceSystem : abap.sstring( 255 ) AS sstring255,
  virtual AddressLine1Text : abap.sstring( 260 ) AS sstring260,
  _RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType,
  _BusinessPartner._KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  _BusinessPartner.MDChgProcessValidationStatus AS MDChgProcessValidationStatus,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  MDChgProcKPIUpdateStatus,
  virtual MDChangeProcessMessageType : symsgty AS virtualMDChangeProcessMessageTypesymsgty,
  virtual MDChangeProcessMessageID : msgid AS virtualMDChangeProcessMessageIDmsgid,
  virtual MDChangeProcessMessageNumber : msgno AS virtualMDChangeProcessMessageNumbermsgno,
  _BusinessPartner.MDChgProcessActivationTarget AS MDChgProcessActivationTarget,
  _BusinessPartner._RecordTargetText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTargetText,
  _BusinessPartner.MDChgProcessReplicationStatus AS MDChgProcessReplicationStatus,
  _BusinessPartner._ReplicationStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcReplicationStatusText,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10
FROM I_BPCustomerProcessTP
LEFT OUTER JOIN C_BPCustomerProcessChanges AS _Changes ON MasterDataChangeProcess = _Changes.MasterDataChangeProcess AND MDChgProcessStep = _Changes.MDChgProcessStep AND MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject AND _Changes.MDChgProcessSourceModified = 'X'  -- association [0..*]
LEFT OUTER JOIN I_MDChangeProcessRecordTarget AS _RecordTarget ON MasterDataChangeProcess = _RecordTarget.MasterDataChangeProcess AND MDChgProcessSrceSystem = _RecordTarget.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _RecordTarget.MDChgProcessSrceObject AND _RecordTarget.MDChgProcessSrceObjectTypeCode = '147'  -- association [0..1]
;

Depth:

C_BPCustomerProcessTP view_entity

I_BPCustomerProcessTP view_entity