C_BPSuplrPurchasingDataGovTP
Projection for Supplier Purchasing Data - TP
C_BPSuplrPurchasingDataGovTP is a Consumption CDS View that provides data about "Projection for Supplier Purchasing Data - TP" in SAP S/4HANA. It reads from 1 data source (I_BPSuplrPurchasingDataGovTP) and exposes 73 fields with key fields BusinessPartnerUUID, SuplrPurchasingOrgUUID, SuplrPurchasingDataUUID, MasterDataChangeProcess, MDChgProcessSrceSystem.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_BPSuplrPurchasingDataGovTP | I_BPSuplrPurchasingDataGovTP | projection |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| EndUserText.label | Projection for Supplier Purchasing Data - TP | 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 (73)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BusinessPartnerUUID | BusinessPartnerUUID | UUID | |
| KEY | SuplrPurchasingOrgUUID | SuplrPurchasingOrgUUID | UUID | |
| KEY | SuplrPurchasingDataUUID | SuplrPurchasingDataUUID | UUID | |
| KEY | MasterDataChangeProcess | MasterDataChangeProcess | Process ID | |
| KEY | MDChgProcessSrceSystem | MDChgProcessSrceSystem | Source System | |
| KEY | MDChgProcessSrceObject | MDChgProcessSrceObject | Source ID | |
| KEY | PurchasingOrganization | PurchasingOrganization | Purchasing Organization | |
| KEY | SupplierSubrange | SupplierSubrange | Suppl. Subrange | |
| KEY | Plant | Plant | Valuation Area | |
| MDChgProcessStep | MDChgProcessStep | Step Number | ||
| BPAssignmentID | BPAssignmentID | Assignment ID | ||
| Supplier | Supplier | Supplier | ||
| PurchasingOrganizationForEdit | PurchasingOrganizationForEdit | Purchasing Organization | ||
| SupplierSubrangeForEdit | SupplierSubrangeForEdit | Suppl. Subrange | ||
| PlantForEdit | PlantForEdit | Plant ID | ||
| PurchasingIsBlockedForSupplier | PurchasingIsBlockedForSupplier | Pur. block POrg | ||
| DeletionIndicator | DeletionIndicator | Deletion Ind. | ||
| SupplierABCClassificationCode | SupplierABCClassificationCode | ABC indicator | ||
| PurchaseOrderCurrency | PurchaseOrderCurrency | Order currency | ||
| CurrencyNamelocalized | ||||
| SupplierRespSalesPersonName | SupplierRespSalesPersonName | Salesperson | ||
| MinimumOrderAmount | MinimumOrderAmount | Minimum value | ||
| MinimumOrderAmountCurrency | MinimumOrderAmountCurrency | Order currency | ||
| char1024 | ||||
| PaymentTerms | PaymentTerms | Pyt Terms | ||
| IncotermsClassification | IncotermsClassification | Incoterms | ||
| IncotermsClassificationNamelocalized | ||||
| InvoiceIsGoodsReceiptBased | InvoiceIsGoodsReceiptBased | GR-Based IV | ||
| IsOrderAcknRqd | IsOrderAcknRqd | Acknowl. Reqd. | ||
| CalculationSchemaGroupCode | CalculationSchemaGroupCode | Schema Grp Supp | ||
| PurOrdAutoGenerationIsAllowed | PurOrdAutoGenerationIsAllowed | Automatic PO | ||
| IntrastatCrsBorderTrMode | IntrastatCrsBorderTrMode | Mode of Trans. | ||
| PurgOutlineAgrmtCustomsOffice | PurgOutlineAgrmtCustomsOffice | Customs office | ||
| PricingDateControl | PricingDateControl | Pr. Date Cat. | ||
| PricingDateControlTextlocalized | ||||
| PurchasingGroup | PurchasingGroup | Purchasing Group | ||
| EvaldReceiptSettlementIsActive | EvaldReceiptSettlementIsActive | ERS | ||
| PlannedDeliveryDurationInDays | PlannedDeliveryDurationInDays | Plnd dely time | ||
| MRPPlanningCalendar | MRPPlanningCalendar | Planning cal. | ||
| PlanningCycle | PlanningCycle | Planning Cycle | ||
| OrderEntryIsBySupplier | OrderEntryIsBySupplier | PO entry: supp. | ||
| PriceMarkingAgreement | PriceMarkingAgreement | Price mkg. sup. | ||
| SupplierIsRackJobbing | SupplierIsRackJobbing | Rack jobbing | ||
| IncotermsVersion | IncotermsVersion | Inco. Version | ||
| IncotermsVersionNamelocalized | ||||
| IncotermsLocation1 | IncotermsLocation1 | Inco. Location1 | ||
| IncotermsLocation2 | IncotermsLocation2 | Inco. Location2 | ||
| MRPResponsible | MRPResponsible | MRP Controller | ||
| MRPControllerName | _MRPController | MRPControllerName | Controller name | |
| SupplierConfirmationControlKey | SupplierConfirmationControlKey | Conf. Control | ||
| RoundingProfile | RoundingProfile | Rnding Profile | ||
| ProductUnitGroup | ProductUnitGroup | UoM Group | ||
| AutomaticEvaluatedRcptSettlmt | AutomaticEvaluatedRcptSettlmt | Aut. GRSet Ret | ||
| ProdStockAndSlsDataTransfPrfl | ProdStockAndSlsDataTransfPrfl | PROACT control prof | ||
| SuplrInvcRevalIsAllowed | SuplrInvcRevalIsAllowed | Revaluation | ||
| InvoiceIsMMServiceEntryBased | InvoiceIsMMServiceEntryBased | Srv.-Based Inv. Ver. | ||
| SuplrIsSubjToSubsqntSettlement | SuplrIsSubjToSubsqntSettlement | Subseq. Settlmt | ||
| SuplrPurgOrgAgrmtOfBusVolIsRqd | SuplrPurgOrgAgrmtOfBusVolIsRqd | BVC | ||
| SupplierPhoneNumber | SupplierPhoneNumber | Telephone | ||
| MasterDataIsCurrent | MasterDataIsCurrent | Truth Value | ||
| Country | _PurchasingToCompanyCode | Country | Venue: Ctry/Reg | |
| char40 | ||||
| _Currency | _Currency | |||
| _IncotermsClassification | _IncotermsClassification | |||
| _IncotermsVersion | _IncotermsVersion | |||
| _LogisticalRoundingProfile | _LogisticalRoundingProfile | |||
| _MasterDataChangeProcess | _MasterDataChangeProcess | |||
| _PaymentTerms | _PaymentTerms | |||
| _PriceDateControl | _PriceDateControl | |||
| _PurchasingGroup | _PurchasingGroup | |||
| _SchemaGroupText | _SchemaGroupText | |||
| _TransportationMode | _TransportationMode | |||
| _SupplierredirectedtoC_BPSupplierGovTP |
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_BPSuplrPurchasingDataGovTP.
-- 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_BPSuplrPurchasingDataGovTP AS
SELECT
BusinessPartnerUUID,
SuplrPurchasingOrgUUID,
SuplrPurchasingDataUUID,
MasterDataChangeProcess,
MDChgProcessSrceSystem,
MDChgProcessSrceObject,
PurchasingOrganization,
SupplierSubrange,
Plant,
MDChgProcessStep,
BPAssignmentID,
Supplier,
PurchasingOrganizationForEdit,
SupplierSubrangeForEdit,
PlantForEdit,
PurchasingIsBlockedForSupplier,
DeletionIndicator,
SupplierABCClassificationCode,
PurchaseOrderCurrency,
_Currency._Text.CurrencyName : localized AS CurrencyNamelocalized,
SupplierRespSalesPersonName,
MinimumOrderAmount,
MinimumOrderAmountCurrency,
virtual PaymentTermsName : abap.char(1024) AS char1024,
PaymentTerms,
IncotermsClassification,
_IncotermsClassification._Text.IncotermsClassificationName : localized AS IncotermsClassificationNamelocalized,
InvoiceIsGoodsReceiptBased,
IsOrderAcknRqd,
CalculationSchemaGroupCode,
PurOrdAutoGenerationIsAllowed,
IntrastatCrsBorderTrMode,
PurgOutlineAgrmtCustomsOffice,
PricingDateControl,
_PriceDateControl._Text.PricingDateControlText : localized AS PricingDateControlTextlocalized,
PurchasingGroup,
EvaldReceiptSettlementIsActive,
PlannedDeliveryDurationInDays,
MRPPlanningCalendar,
PlanningCycle,
OrderEntryIsBySupplier,
PriceMarkingAgreement,
SupplierIsRackJobbing,
IncotermsVersion,
_IncotermsVersion._Text.IncotermsVersionName : localized AS IncotermsVersionNamelocalized,
IncotermsLocation1,
IncotermsLocation2,
MRPResponsible,
_MRPController.MRPControllerName AS MRPControllerName,
SupplierConfirmationControlKey,
RoundingProfile,
ProductUnitGroup,
AutomaticEvaluatedRcptSettlmt,
ProdStockAndSlsDataTransfPrfl,
SuplrInvcRevalIsAllowed,
InvoiceIsMMServiceEntryBased,
SuplrIsSubjToSubsqntSettlement,
SuplrPurgOrgAgrmtOfBusVolIsRqd,
SupplierPhoneNumber,
MasterDataIsCurrent,
_PurchasingToCompanyCode.Country AS Country,
virtual MDChgProcPurgOrganizationName : abap.char(40) AS char40
FROM I_BPSuplrPurchasingDataGovTP
;
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