What is C_BPCustAddrDepdntSlsDtaProcTP in SAP S/4HANA?

C_BPCustAddrDepdntSlsDtaProcTP is a consumption CDS view in SAP S/4HANA. Customer Address Dependant Sales Data It contains 63 fields.

Which tables does C_BPCustAddrDepdntSlsDtaProcTP read from?

C_BPCustAddrDepdntSlsDtaProcTP reads data from: I_BPCustAddrDepdntSlsDtaProcTP.

What VDM layer is C_BPCustAddrDepdntSlsDtaProcTP?

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

C_BPCustAddrDepdntSlsDtaProcTP

DDL: C_BPCUSTADDRDEPDNTSLSDTAPROCTP Type: view_entity CONSUMPTION Package: MDC_CUST_STAGING_BO

63 Fields 1 Data Sources 2 Associations 2 OData Services

Customer Address Dependant Sales Data

C_BPCustAddrDepdntSlsDtaProcTP is a Consumption CDS View that provides data about "Customer Address Dependant Sales Data" in SAP S/4HANA. It reads from 1 data source (I_BPCustAddrDepdntSlsDtaProcTP) and exposes 63 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. 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_BPCustAddrDepdntSlsDtaProcTP	I_BPCustAddrDepdntSlsDtaProcTP	projection

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	C_BPCustAddrDepdntSlsProcChgs	_Changes	$projection.MasterDataChangeProcess = _Changes.MasterDataChangeProcess and $projection.MDChgProcessStep = _Changes.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject and $projection.AddressNumber = _Changes.AddressNumber and $projection.SalesOrganization = _Changes.SalesOrganization and $projection.DistributionChannel = _Changes.DistributionChannel and $projection.Division = _Changes.Division and $projection.BPAssignmentID = _Changes.BPAssignmentID 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 (9)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
EndUserText.label	Customer Address Dependant Sales Data	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#CONSUMPTION	view
Metadata.allowExtensions	true	view

OData Services (2)

Service	Binding	Version	Contract	Release
ASQL_F7205A	ASQL_F7205A		C2	NOT_RELEASED
X_C_BPCUSTOMERPROCESSTP_SRV

Fields (63)

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	AddressNumber		AddressNumber	Src Address No
KEY	SalesOrganization		SalesOrganization	Sales Organization
KEY	DistributionChannel		DistributionChannel	RefDistCh-Cust/Mat.
KEY	Division		Division	Internal Division ID
KEY	BPAssignmentID		BPAssignmentID	Assignment ID
	SalesOrganizationNamelocalized
	DistributionChannelNamelocalized
	DivisionNamelocalized
	Customer		Customer	Sold-to Party
	IncotermsClassification		IncotermsClassification	Incoterms
	IncotermsClassificationNamelocalized
	DeliveryIsBlocked		DeliveryIsBlocked	Delivery block
	DeliveryBlockReasonTextlocalized
	SalesOffice		SalesOffice	Sales Office
	SalesOfficeNamelocalized
	SalesGroup		SalesGroup	Sales Group
	SalesGroupNamelocalized
	ShippingCondition		ShippingCondition	Shipping Conditions
	ShippingConditionNamelocalized
	SupplyingPlant		SupplyingPlant	Supplying Plant
	PlantName
	IncotermsVersion		IncotermsVersion	Inco. Version
	IncotermsVersionNamelocalized
	IncotermsLocation1		IncotermsLocation1	Inco. Location1
	IncotermsLocation2		IncotermsLocation2	Inco. Location2
	MDChgProcSrceLastChgdDateTime		MDChgProcSrceLastChgdDateTime
	MDChgProcessSourceModified		MDChgProcessSourceModified	Modified
	MDChgProcessSourceModifBinary		MDChgProcessSourceModifBinary
	sstring255
	sstring260
	sstring260
	virtualCustomerNumberDisplaykunnr
	MDChgProcKPIRecordTypeText
	MDChgProcKPIRecordType	_RecordType	MDChgProcKPIRecordType
	MDChgProcKPIRecordStatusText
	MDChgProcessValidationStatus	_BusinessPartner	MDChgProcessValidationStatus
	MDChgProcKPIUpdateStatusText	_KPIUpdateStatusText	MDChangeProcKPIValueKeyDesc
	MDChgProcKPIUpdateStatus		MDChgProcKPIUpdateStatus
	virtualMDChangeProcessMessageTypesymsgty
	virtualMDChangeProcessMessageIDmsgid
	virtualMDChangeProcessMessageNumbermsgno
	MDChgProcessActivationTarget	_BusinessPartner	MDChgProcessActivationTarget
	MDChgProcKPIRecordTargetText
	MDChgProcessReplicationStatus	_BusinessPartner	MDChgProcessReplicationStatus
	MDChgProcReplicationStatusText
	_BPProtectedAddress		_BPProtectedAddress
	_DeliveryBlockReason		_DeliveryBlockReason
	_IncotermsClassification		_IncotermsClassification
	_IncotermsVersion		_IncotermsVersion
	_KPIUpdateStatusText		_KPIUpdateStatusText
	_Plant		_Plant
	_RecordMessages		_RecordMessages
	_RecordType		_RecordType
	_SalesArea		_SalesArea
	_SalesOffice		_SalesOffice
	_SalesOfficeSalesGroup		_SalesOfficeSalesGroup
	_ShippingCondition		_ShippingCondition
	_RecordTarget		_RecordTarget
	_Changes		_Changes

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_BPCustAddrDepdntSlsDtaProcTP.
-- 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_BPCustAddrDepdntSlsDtaProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  SalesOrganization,
  DistributionChannel,
  Division,
  BPAssignmentID,
  _SalesArea._SalesOrganization._Text.SalesOrganizationName : localized AS SalesOrganizationNamelocalized,
  _SalesArea._DistributionChannel._Text.DistributionChannelName : localized AS DistributionChannelNamelocalized,
  _SalesArea._Division._Text.DivisionName : localized AS DivisionNamelocalized,
  Customer,
  IncotermsClassification,
  _IncotermsClassification._Text.IncotermsClassificationName : localized AS IncotermsClassificationNamelocalized,
  DeliveryIsBlocked,
  _DeliveryBlockReason._Text.DeliveryBlockReasonText : localized AS DeliveryBlockReasonTextlocalized,
  SalesOffice,
  _SalesOffice._SalesOffice._Text.SalesOfficeName : localized AS SalesOfficeNamelocalized,
  SalesGroup,
  _SalesOfficeSalesGroup._SalesGroup._Text.SalesGroupName : localized AS SalesGroupNamelocalized,
  ShippingCondition,
  _ShippingCondition._Text.ShippingConditionName : localized AS ShippingConditionNamelocalized,
  SupplyingPlant,
  _Plant._Plant.PlantName AS PlantName,
  IncotermsVersion,
  _IncotermsVersion._Text.IncotermsVersionName : localized AS IncotermsVersionNamelocalized,
  IncotermsLocation1,
  IncotermsLocation2,
  MDChgProcSrceLastChgdDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  virtual SourceSystem : abap.sstring( 255 ) AS sstring255,
  virtual MDChgProcModifdObjectsCount : abap.sstring( 260 ) AS sstring260,
  virtual CustomerNumberDisplay : kunnr AS virtualCustomerNumberDisplaykunnr,
  _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
FROM I_BPCustAddrDepdntSlsDtaProcTP
LEFT OUTER JOIN C_BPCustAddrDepdntSlsProcChgs AS _Changes ON MasterDataChangeProcess = _Changes.MasterDataChangeProcess AND MDChgProcessStep = _Changes.MDChgProcessStep AND MDChgProcessSrceSystem = _Changes.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Changes.MDChgProcessSrceObject AND AddressNumber = _Changes.AddressNumber AND SalesOrganization = _Changes.SalesOrganization AND DistributionChannel = _Changes.DistributionChannel AND Division = _Changes.Division AND BPAssignmentID = _Changes.BPAssignmentID 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_BPCustAddrDepdntSlsDtaProcTP view_entity

I_BPCustAddrDepdntSlsDtaProcTP view_entity