C_BPSupplierGovTP
BP Supplier Data Governance
C_BPSupplierGovTP is a Consumption CDS View that provides data about "BP Supplier Data Governance" in SAP S/4HANA. It reads from 1 data source (I_BPSupplierGovTP) and exposes 81 fields with key fields BusinessPartnerUUID, MasterDataChangeProcess, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_BPSupplierGovTP | I_BPSupplierGovTP | projection |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | C_BPSuplrProcessChangesUnion | _SupplierChanges | $projection.MasterDataChangeProcess = _SupplierChanges.MasterDataChangeProcess and $projection.MDChgProcessStep = _SupplierChanges.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _SupplierChanges.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _SupplierChanges.MDChgProcessSrceObject |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | BP Supplier Data Governance | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Search.searchable | true | view | |
| VDM.viewType | #CONSUMPTION | view |
Fields (81)
| Key | Field | Source Table | 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 | ||
| Supplier | Supplier | Supplier | ||
| TrainStationName | TrainStationName | Train station | ||
| AuthorizationGroup | AuthorizationGroup | AuthorizGroup | ||
| AuthorizationGroupNamelocalized | ||||
| DataMediumExchangeIndicator | DataMediumExchangeIndicator | DME Rec. Code | ||
| ExchangeIndicatorTextlocalized | ||||
| DataExchangeInstructionKey | DataExchangeInstructionKey | Instruction Key | ||
| PaytSlipWthRefSubscriber | PaytSlipWthRefSubscriber | PBC/POR Number | ||
| SupplierCorporateGroup | SupplierCorporateGroup | Group | ||
| SupplierAccountGroup | SupplierAccountGroup | Account group | ||
| Customer | Customer | Sold-to Party | ||
| CustomerName | _Customer | BPCustomerName | Name of Customer | |
| AlternativePayeeAccountNumber | AlternativePayeeAccountNumber | Alternat. Payee | ||
| AlternativePayeeName | _AlternativePayeeAccountNumber | SupplierName | Supplier Name | |
| DeletionIndicator | DeletionIndicator | Deletion Ind. | ||
| AccountIsBlockedForPosting | AccountIsBlockedForPosting | Posting Block | ||
| PurchasingIsBlocked | PurchasingIsBlocked | Purch. block | ||
| BPIsEqualizationTaxSubject | BPIsEqualizationTaxSubject | Equalizatn tax | ||
| VATLiability | VATLiability | Liable for VAT | ||
| AlternativePayeeIsAllowed | AlternativePayeeIsAllowed | Payee in doc. | ||
| TradingPartner | TradingPartner | Trading Partner | ||
| FiscalAddress | FiscalAddress | Fiscal address | ||
| SupplierName | _FiscalAddress | SupplierName | Supplier Name | |
| SupplierProcurementBlock | SupplierProcurementBlock | Block Function | ||
| ProcurementBlockTextlocalized | ||||
| SuplrQualityManagementSystem | SuplrQualityManagementSystem | Target QM Sys. | ||
| QualityManagementSystemTextlocalized | ||||
| SupplierPlant | SupplierPlant | Plant | ||
| PlantName | _Plant | PlantName | Plant Name | |
| SupplierIsSubRangeRelevant | SupplierIsSubRangeRelevant | VSR relevant | ||
| SupplierIsPlantRelevant | SupplierIsPlantRelevant | Plant relevant | ||
| FactoryCalendar | FactoryCalendar | Factory Calendar | ||
| FactoryCalendarNamelocalized | ||||
| ResponsibleType | ResponsibleType | Tax Type | ||
| AccountTaxTypeDescriptionlocalized | ||||
| BR_TaxIsSplit | BR_TaxIsSplit | Tax split | ||
| BRSpcfcTaxBasePercentageCode | BRSpcfcTaxBasePercentageCode | Tax Base | ||
| TaxCategoryTextlocalized | ||||
| TranspServiceAgentStstcGrp | TranspServiceAgentStstcGrp | Stat.grp, agent | ||
| TranspServiceAgentStstcGrpNamelocalized | ||||
| TaxInvoiceRepresentativeName | TaxInvoiceRepresentativeName | Rep's Name | ||
| BusinessType | BusinessType | Type of Business | ||
| IndustryType | IndustryType | Type of Industry | ||
| SupplierCentralDeletionIsBlock | SupplierCentralDeletionIsBlock | Deletion block | ||
| SuplrQltyInProcmtCertfnValidTo | SuplrQltyInProcmtCertfnValidTo | QM System To | ||
| SuplrProofOfDelivRlvtCode | SuplrProofOfDelivRlvtCode | POD-Relevant | ||
| SuplrProofOfDelivRlvtCodeTxtlocalized | ||||
| SuplrTaxAuthorityAccountNumber | SuplrTaxAuthorityAccountNumber | Tax Office | ||
| SuplrTaxAuthorityAccountName | _SuplrTaxAuthority | SupplierName | Supplier Name | |
| IsToBeAcceptedAtOrigin | IsToBeAcceptedAtOrigin | Origin Accept. | ||
| ReferenceAccountGroup | ReferenceAccountGroup | Ref.Acct Group | ||
| PaymentReason | PaymentReason | Payment Reason | ||
| PaymentReasonTextlocalized | ||||
| PaymentIsBlockedForSupplier | PaymentIsBlockedForSupplier | Payment block | ||
| MasterDataIsCurrent | MasterDataIsCurrent | Truth Value | ||
| 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 | ||
| MDChgProcessSourceModified | MDChgProcessSourceModified | Modified | ||
| MDChgProcessStepWrkflwSts | ||||
| MDChgProcessStepWrkflwOvrlDcsn | ||||
| sstring260 | ||||
| sstring241 | ||||
| BusinessPartnerFullName | _BusinessPartnerGov | BusinessPartnerFullName | Broker Name | |
| char81 | ||||
| char81 | ||||
| _SupplierChanges | _SupplierChanges | |||
| _SupplierToBusinessPartner | _SupplierToBusinessPartner |
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_BPSupplierGovTP.
-- 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_BPSupplierGovTP AS
SELECT
BusinessPartnerUUID,
MasterDataChangeProcess,
MDChgProcessSrceSystem,
MDChgProcessSrceObject,
MDChgProcessStep,
Supplier,
TrainStationName,
AuthorizationGroup,
_AuthorizationGroup._Text.AuthorizationGroupName : localized AS AuthorizationGroupNamelocalized,
DataMediumExchangeIndicator,
_DataMediumExchangeIndicator._Text.ExchangeIndicatorText : localized AS ExchangeIndicatorTextlocalized,
DataExchangeInstructionKey,
PaytSlipWthRefSubscriber,
SupplierCorporateGroup,
SupplierAccountGroup,
Customer,
_Customer.BPCustomerName AS CustomerName,
AlternativePayeeAccountNumber,
_AlternativePayeeAccountNumber.SupplierName AS AlternativePayeeName,
DeletionIndicator,
AccountIsBlockedForPosting,
PurchasingIsBlocked,
BPIsEqualizationTaxSubject,
VATLiability,
AlternativePayeeIsAllowed,
TradingPartner,
FiscalAddress,
_FiscalAddress.SupplierName AS SupplierName,
SupplierProcurementBlock,
_ProcurementBlock._ProcurementBlockText.ProcurementBlockText : localized AS ProcurementBlockTextlocalized,
SuplrQualityManagementSystem,
_QualityManagementSystem._QltyMgmtSystemText.QualityManagementSystemText : localized AS QualityManagementSystemTextlocalized,
SupplierPlant,
_Plant.PlantName AS PlantName,
SupplierIsSubRangeRelevant,
SupplierIsPlantRelevant,
FactoryCalendar,
_FactoryCalendar._Text.FactoryCalendarName : localized AS FactoryCalendarNamelocalized,
ResponsibleType,
_ResponsibleType._Text.AccountTaxTypeDescription : localized AS AccountTaxTypeDescriptionlocalized,
BR_TaxIsSplit,
BRSpcfcTaxBasePercentageCode,
_BRSpcfcTaxBasePercentage._Text.TaxCategoryText : localized AS TaxCategoryTextlocalized,
TranspServiceAgentStstcGrp,
_TranspSrvcAgentStatisticGrp._Text.TranspServiceAgentStstcGrpName : localized AS TranspServiceAgentStstcGrpNamelocalized,
TaxInvoiceRepresentativeName,
BusinessType,
IndustryType,
SupplierCentralDeletionIsBlock,
SuplrQltyInProcmtCertfnValidTo,
SuplrProofOfDelivRlvtCode,
_SuplrProofOfDelivRlvtCode._Text.SuplrProofOfDelivRlvtCodeTxt : localized AS SuplrProofOfDelivRlvtCodeTxtlocalized,
SuplrTaxAuthorityAccountNumber,
_SuplrTaxAuthority.SupplierName AS SuplrTaxAuthorityAccountName,
IsToBeAcceptedAtOrigin,
ReferenceAccountGroup,
PaymentReason,
_PaymentReason._Text.PaymentReasonText : localized AS PaymentReasonTextlocalized,
PaymentIsBlockedForSupplier,
MasterDataIsCurrent,
DataControllerSet,
DataController1,
DataController2,
DataController3,
DataController4,
DataController5,
DataController6,
DataController7,
DataController8,
DataController9,
DataController10,
MDChgProcessSourceModified,
_Process._CurrentStep.MDChgProcessStepWrkflwSts AS MDChgProcessStepWrkflwSts,
_Process._CurrentStep.MDChgProcessStepWrkflwOvrlDcsn AS MDChgProcessStepWrkflwOvrlDcsn,
virtual AddressLine1Text : abap.sstring( 260 ) AS sstring260,
virtual AddressLine2Text : abap.sstring( 241 ) AS sstring241,
_BusinessPartnerGov.BusinessPartnerFullName AS BusinessPartnerFullName,
virtual MDChgProcSupplierDescription : abap.char(81) AS char81
FROM I_BPSupplierGovTP
LEFT OUTER JOIN C_BPSuplrProcessChangesUnion AS _SupplierChanges ON MasterDataChangeProcess = _SupplierChanges.MasterDataChangeProcess AND MDChgProcessStep = _SupplierChanges.MDChgProcessStep AND MDChgProcessSrceSystem = _SupplierChanges.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _SupplierChanges.MDChgProcessSrceObject -- association [0..*]
;
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