C_PrmtHbRpldPOSuplrConf

DDL: C_PRMTHBRPLDPOSUPLRCONF SQL: CRPLDPOSUPLCONF Type: view CONSUMPTION Package: APPL_PROC_HUB_CNTRLSUPLRCONF
26 Fields 1 Data Sources 2 Associations

Supplier Confirmation for Replicated PO

C_PrmtHbRpldPOSuplrConf is a Consumption CDS View that provides data about "Supplier Confirmation for Replicated PO" in SAP S/4HANA. It reads from 1 data source (I_PrmtHbRpldPOSuplrConf) and exposes 26 fields with key fields PurchaseOrder, PurchaseOrderItem, ExtSourceSystem, SequentialNmbrOfSuplrConf. It has 2 associations to related views. Part of development package APPL_PROC_HUB_CNTRLSUPLRCONF.

Data Sources (1)

SourceAliasJoin Type
I_PrmtHbRpldPOSuplrConf I_PrmtHbRpldPOSuplrConf from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_CentralPurchaseOrderTP _PurchaseOrderTP _PurchaseOrderTP.ProcurementHubPO = $projection.PurchaseOrder and _PurchaseOrderTP.ExtSourceSystem = $projection.ExtSourceSystem
[1..1] C_CentralPurchaseOrderItemTP _PurchaseOrderTPItem _PurchaseOrderTPItem.ProcurementHubPO = $projection.PurchaseOrder and _PurchaseOrderTPItem.PurchaseOrderItem = $projection.PurchaseOrderItem and _PurchaseOrderTPItem.ExtSourceSystem = $projection.ExtSourceSystem

Annotations (15)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CRPLDPOSUPLCONF view
AbapCatalog.preserveKey true view
EndUserText.label Supplier Confirmation for Replicated PO view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable false view
UI.headerInfo.typeName Confirmation view
UI.headerInfo.typeNamePlural Confirmations view
UI.headerInfo.title.value SupplierConfirmation view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchase Order Item
KEY ExtSourceSystem ExtSourceSystem Connected System ID
KEY SequentialNmbrOfSuplrConf SequentialNmbrOfSuplrConf Sequential No.
SupplierConfirmationCategory SupplierConfirmationCategory Confirm. Cat.
DeliveryDate DeliveryDate Delivery Date
DelivDateCategory DelivDateCategory Delivery Date
DeliveryTime DeliveryTime TimeOfDelivery
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
ConfirmedQuantity ConfirmedQuantity Quantity in UnE
MRPRelevantQuantity MRPRelevantQuantity Qty Reduced
OrderQuantityUnit _PurchaseOrderTPItem PurchaseOrderQuantityUnit Order Unit
SuplrConfCreationCategory SuplrConfCreationCategory Creation Ind.
IsDeleted IsDeleted TRUE
ConfIsRelevantToMRP ConfIsRelevantToMRP MRP-Relevant
SupplierConfirmationExtNumber SupplierConfirmationExtNumber Reference
DeliveryDocument DeliveryDocument Outbound Delivery
DeliveryDocumentItem DeliveryDocumentItem Delivery Document Item
ManufacturerPartProfile ManufacturerPartProfile Mfr Part Profile
ManufacturerMaterial ManufacturerMaterial MPN: Material
NumberOfReminders NumberOfReminders No. Rem./Exp.
Batch Batch Lot No.
DocumentCurrency _PurchaseOrderTPItem DocumentCurrency Document Currency
Associations_PurchaseOrderTP
_PurchaseOrderTPItem _PurchaseOrderTPItem

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_PrmtHbRpldPOSuplrConf.
-- 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.
-- SQL view name: CRPLDPOSUPLCONF

CREATE VIEW C_PrmtHbRpldPOSuplrConf AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  ExtSourceSystem,
  SequentialNmbrOfSuplrConf,
  SupplierConfirmationCategory,
  DeliveryDate,
  DelivDateCategory,
  DeliveryTime,
  CreationDate,
  CreationTime,
  ConfirmedQuantity,
  MRPRelevantQuantity,
  _PurchaseOrderTPItem.PurchaseOrderQuantityUnit AS OrderQuantityUnit,
  SuplrConfCreationCategory,
  IsDeleted,
  ConfIsRelevantToMRP,
  SupplierConfirmationExtNumber,
  DeliveryDocument,
  DeliveryDocumentItem,
  ManufacturerPartProfile,
  ManufacturerMaterial,
  NumberOfReminders,
  Batch,
  _PurchaseOrderTPItem.DocumentCurrency AS DocumentCurrency
FROM I_PrmtHbRpldPOSuplrConf
LEFT OUTER JOIN C_CentralPurchaseOrderTP AS _PurchaseOrderTP ON _PurchaseOrderTP.ProcurementHubPO = PurchaseOrder AND _PurchaseOrderTP.ExtSourceSystem = ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_CentralPurchaseOrderItemTP AS _PurchaseOrderTPItem ON _PurchaseOrderTPItem.ProcurementHubPO = PurchaseOrder AND _PurchaseOrderTPItem.PurchaseOrderItem = PurchaseOrderItem AND _PurchaseOrderTPItem.ExtSourceSystem = ExtSourceSystem  -- association [1..1]
;

Learn More