C_BPCustAddrDepdntSlsProcChgs

DDL: C_BPCUSTADDRDEPDNTSLSPROCCHGS Type: view_entity CONSUMPTION Package: MDC_CUST_STAGING_BO
25 Fields 1 Data Sources 2 OData Services

Customer Address Dependant Sales Changes

C_BPCustAddrDepdntSlsProcChgs is a Consumption CDS View that provides data about "Customer Address Dependant Sales Changes" in SAP S/4HANA. It reads from 1 data source (I_BPCustAddrDepdntSlsProcChgs) and exposes 25 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It is exposed through 2 OData services (ASQL_F7205A, X_C_BPCUSTOMERPROCESSTP_SRV). Part of development package MDC_CUST_STAGING_BO.

Data Sources (1)

SourceAliasJoin Type
I_BPCustAddrDepdntSlsProcChgs I_BPCustAddrDepdntSlsProcChgs from

Annotations (8)

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

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7205A ASQL_F7205A C2 NOT_RELEASED
X_C_BPCUSTOMERPROCESSTP_SRV

Fields (25)

KeyFieldSource TableSource FieldDescription
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
KEY MDChgProcessModelTableName MDChgProcessModelTableName
KEY MDChangeProcessModelFieldName MDChangeProcessModelFieldName
KEY MDChgProcessRecordObjectID MDChgProcessRecordObjectID
MDChangeProcModelTableDesc MDChangeProcModelTableDesc
MDChangeProcessModelFieldDesc MDChangeProcessModelFieldDesc
MDChgProcModelNodeExternalName MDChgProcModelNodeExternalName
MDChgProcModTableExternalName MDChgProcModTableExternalName
MDChgProcModFieldExternalName MDChgProcModFieldExternalName
MDChgProcCurrentAttributeValue MDChgProcCurrentAttributeValue
MDChgProcPrevAttributeValue MDChgProcPrevAttributeValue
MDChgProcessAttributeIsChanged MDChgProcessAttributeIsChanged
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessRecordObjectText MDChgProcessRecordObjectText
_BPProtectedAddress _BPProtectedAddress
_Customer _Customer
_CustomerSales _CustomerSales

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_BPCustAddrDepdntSlsProcChgs.
-- 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_BPCustAddrDepdntSlsProcChgs AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  SalesOrganization,
  DistributionChannel,
  Division,
  BPAssignmentID,
  MDChgProcessModelTableName,
  MDChangeProcessModelFieldName,
  MDChgProcessRecordObjectID,
  MDChangeProcModelTableDesc,
  MDChangeProcessModelFieldDesc,
  MDChgProcModelNodeExternalName,
  MDChgProcModTableExternalName,
  MDChgProcModFieldExternalName,
  MDChgProcCurrentAttributeValue,
  MDChgProcPrevAttributeValue,
  MDChgProcessAttributeIsChanged,
  MDChgProcessSourceModified,
  MDChgProcessRecordObjectText
FROM I_BPCustAddrDepdntSlsProcChgs
;

Learn More