I_BPSupplierTextProcessChanges
BP Supplier Description Process Changes
I_BPSupplierTextProcessChanges is a Transactional CDS View that provides data about "BP Supplier Description Process Changes" in SAP S/4HANA. It reads from 2 data sources (I_BPSupplierTextProcess, I_BPSupplierTextProcess) and exposes 43 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, ApplicationTextObjectType. It has 1 association to related views.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_BPSupplierTextProcess | _Current | from |
| I_BPSupplierTextProcess | _Current | union_all |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_BPSupplierProcess | _Supplier | $projection.MasterDataChangeProcess = _Supplier.MasterDataChangeProcess and $projection.MDChgProcessStep = _Supplier.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _Supplier.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _Supplier.MDChgProcessSrceObject |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | BP Supplier Description Process Changes | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| VDM.viewType | #TRANSACTIONAL | view |
Fields (43)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | MasterDataChangeProcess | I_BPSupplierTextProcess | MasterDataChangeProcess | Process ID |
| KEY | MDChgProcessStep | I_BPSupplierTextProcess | MDChgProcessStep | Step Number |
| KEY | MDChgProcessSrceSystem | I_BPSupplierTextProcess | MDChgProcessSrceSystem | Source System |
| KEY | MDChgProcessSrceObject | I_BPSupplierTextProcess | MDChgProcessSrceObject | Source ID |
| KEY | ApplicationTextObjectType | I_BPSupplierTextProcess | ApplicationTextObjectType | Text object |
| KEY | TextObjectKey | I_BPSupplierTextProcess | TextObjectKey | Text Name |
| KEY | LongTextID | I_BPSupplierTextProcess | LongTextID | Text ID |
| KEY | Language | I_BPSupplierTextProcess | Language | Report Text Language |
| KEY | MasterDataTextLineIdentifier | I_BPSupplierTextProcess | MasterDataTextLineIdentifier | Counter |
| KEY | MDChgProcessModelTableName | _ModelTable | MDChgProcessModelTableName | |
| KEY | MDChangeProcessModelFieldName | |||
| KEY | char1000asMDChgProcessRecordObjectID | |||
| MDChangeProcModelTableDesc | _ModelTable | MDChangeProcModelTableDesc | ||
| MDChangeProcessModelFieldDesc | ||||
| MDChgProcModelNodeExternalName | ||||
| MDChgProcModTableExternalName | ||||
| MDChgProcModFieldExternalName | ||||
| MDChgProcCurrentAttributeValue | ||||
| MDChgProcPrevAttributeValue | ||||
| MDChgProcessAttributeIsChanged | ||||
| MDChgProcessSourceModified | I_BPSupplierTextProcess | MDChgProcessSourceModified | Modified | |
| MasterDataChangeProcess | Process ID | |||
| KEY | MDChgProcessStep | I_BPSupplierTextProcess | MDChgProcessStep | Step Number |
| KEY | MDChgProcessSrceSystem | I_BPSupplierTextProcess | MDChgProcessSrceSystem | Source System |
| KEY | MDChgProcessSrceObject | I_BPSupplierTextProcess | MDChgProcessSrceObject | Source ID |
| KEY | ApplicationTextObjectType | I_BPSupplierTextProcess | ApplicationTextObjectType | Text object |
| KEY | TextObjectKey | I_BPSupplierTextProcess | TextObjectKey | Text Name |
| KEY | LongTextID | I_BPSupplierTextProcess | LongTextID | Text ID |
| KEY | Language | I_BPSupplierTextProcess | Language | Report Text Language |
| KEY | MasterDataTextLineIdentifier | I_BPSupplierTextProcess | MasterDataTextLineIdentifier | Counter |
| KEY | MDChgProcessModelTableName | _ModelField | MDChgProcessModelTableName | |
| KEY | MDChangeProcessModelFieldName | _ModelField | MDChangeProcessModelFieldName | |
| KEY | char1000asMDChgProcessRecordObjectID | |||
| MDChangeProcModelTableDesc | _ModelField | MDChangeProcModelTableDesc | ||
| MDChangeProcessModelFieldDesc | _ModelField | MDChangeProcessModelFieldDesc | ||
| MDChgProcModelNodeExternalName | ||||
| MDChgProcModTableExternalName | ||||
| MDChgProcModFieldExternalName | ||||
| MDChgProcCurrentAttributeValue | ||||
| MDChgProcPrevAttributeValue | ||||
| MDChgProcessAttributeIsChanged | ||||
| MDChgProcessSourceModified | I_BPSupplierTextProcess | MDChgProcessSourceModified | Modified | |
| _Supplier | _Supplier |
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 I_BPSupplierTextProcessChanges.
-- 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 I_BPSupplierTextProcessChanges AS
SELECT
_Current.MasterDataChangeProcess AS MasterDataChangeProcess,
_Current.MDChgProcessStep AS MDChgProcessStep,
_Current.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
_Current.MDChgProcessSrceObject AS MDChgProcessSrceObject,
_Current.ApplicationTextObjectType AS ApplicationTextObjectType,
_Current.TextObjectKey AS TextObjectKey,
_Current.LongTextID AS LongTextID,
_Current.Language AS Language,
_Current.MasterDataTextLineIdentifier AS MasterDataTextLineIdentifier,
_ModelTable.MDChgProcessModelTableName AS MDChgProcessModelTableName,
cast ( '' as fieldname ) AS MDChangeProcessModelFieldName,
cast( concat( concat( concat( concat( concat( concat( concat( _Current.MDChgProcessSrceSystem, concat( '%%', _Current.MDChgProcessSrceObject )), concat( '%%', _Current.ApplicationTextObjectType )), concat( '%%', _Current.TextObjectKey )), concat( '%%', _Current.LongTextID )), concat( '%%', _Current.Language )), concat( '%%', _Current.MasterDataTextLineIdentifier )), concat( '%%', _Current.BPAssignmentID )) as abap.char(1000) ) as MDChgProcessRecordObjectID AS char1000asMDChgProcessRecordObjectID,
_ModelTable.MDChangeProcModelTableDesc AS MDChangeProcModelTableDesc,
cast ('' as as4text ) AS MDChangeProcessModelFieldDesc,
cast( 'BusinessPartnerSupplierText' as fieldname ) AS MDChgProcModelNodeExternalName,
cast( 'I_BPSupplierTextProcessTP' as fieldname ) AS MDChgProcModTableExternalName,
cast( '' as fieldname ) AS MDChgProcModFieldExternalName,
cast( '' as abap.char( 260 ) ) AS MDChgProcCurrentAttributeValue,
cast( '' as abap.char( 260 ) ) AS MDChgProcPrevAttributeValue,
cast( '' as boolean ) AS MDChgProcessAttributeIsChanged,
_Current.MDChgProcessSourceModified AS MDChgProcessSourceModified
FROM I_BPSupplierTextProcess AS _Current
LEFT OUTER JOIN I_BPSupplierProcess AS _Supplier ON MasterDataChangeProcess = _Supplier.MasterDataChangeProcess AND MDChgProcessStep = _Supplier.MDChgProcessStep AND MDChgProcessSrceSystem = _Supplier.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _Supplier.MDChgProcessSrceObject -- association [1..1]
-- UNION ALL with additional select branch(es): I_BPSupplierTextProcess
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA