R_PurOrdSupplierConfirmation

DDL: R_PURORDSUPPLIERCONFIRMATION SQL: RPURORDSUPLCONF Type: view BASIC Package: VDM_MM_PUR_PO
33 Fields 1 Data Sources 2 Associations

Supplier Confirmation for Purchase Order

R_PurOrdSupplierConfirmation is a Basic CDS View that provides data about "Supplier Confirmation for Purchase Order" in SAP S/4HANA. It reads from 1 data source (I_PurgDocSupplierConfirmation) and exposes 33 fields with key fields PurchaseOrder, PurchaseOrderItem, SequentialNmbrOfSuplrConf. It has 2 associations to related views. Part of development package VDM_MM_PUR_PO.

Data Sources (1)

SourceAliasJoin Type
I_PurgDocSupplierConfirmation I_PurgDocSupplierConfirmation from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] R_PurchaseOrderItem _PurchaseOrderItem $projection.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (13)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName RPURORDSUPLCONF view
EndUserText.label Supplier Confirmation for Purchase Order view
ObjectModel.representativeKey SequentialNmbrOfSuplrConf view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder Purchasing Document
KEY PurchaseOrderItem Purchasing Doc. Item
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
SuplrConfCreationCategory SuplrConfCreationCategory Creation Ind.
IsDeleted IsDeleted TRUE
ConfIsRelevantToMRP ConfIsRelevantToMRP MRP-Relevant
ExternalReferenceDocumentID ExternalReferenceDocumentID Reference
DeliveryDocument DeliveryDocument Outbound Delivery
DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
ManufacturerPartProfile ManufacturerPartProfile Mfr Part Profile
ManufacturerMaterial ManufacturerMaterial MPN: Material
NumberOfReminders NumberOfReminders No. Rem./Exp.
Batch Batch Lot No.
DeliveryIsInPlant DeliveryIsInPlant In Plant
HandoverDate HandoverDate Handover Date
HandoverTime HandoverTime Handover Time
PerformancePeriodStartDate PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate PerformancePeriodEndDate End of Performance Period
ServicePerformer ServicePerformer Service Performer
OrderQuantityUnit OrderQuantityUnit Sales Unit
ExpectedOverallLimitAmount ExpectedOverallLimitAmount Expected Value
SupplierConfirmation SupplierConfirmation Confirmation
SupplierConfirmationItem SupplierConfirmationItem Confirmation Item
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem

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 R_PurOrdSupplierConfirmation.
-- 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: RPURORDSUPLCONF

CREATE VIEW R_PurOrdSupplierConfirmation AS
SELECT
  cast (PurchasingDocument as vdm_purchaseorder preserving type) AS PurchaseOrder,
  cast (PurchasingDocumentItem as vdm_purchaseorderitem preserving type) AS PurchaseOrderItem,
  SequentialNmbrOfSuplrConf,
  SupplierConfirmationCategory,
  DeliveryDate,
  DelivDateCategory,
  DeliveryTime,
  CreationDate,
  CreationTime,
  ConfirmedQuantity,
  MRPRelevantQuantity,
  SuplrConfCreationCategory,
  IsDeleted,
  ConfIsRelevantToMRP,
  ExternalReferenceDocumentID,
  DeliveryDocument,
  DeliveryDocumentItem,
  ManufacturerPartProfile,
  ManufacturerMaterial,
  NumberOfReminders,
  Batch,
  DeliveryIsInPlant,
  HandoverDate,
  HandoverTime,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  ServicePerformer,
  OrderQuantityUnit,
  ExpectedOverallLimitAmount,
  SupplierConfirmation,
  SupplierConfirmationItem
FROM I_PurgDocSupplierConfirmation
LEFT OUTER JOIN R_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN R_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
;

Learn More