R_SupplierConfirmationTP

DDL: R_SUPPLIERCONFIRMATIONTP Type: view_entity TRANSACTIONAL
21 Fields 1 Data Sources 6 Associations

Supplier Confirmation Header

R_SupplierConfirmationTP is a Transactional CDS View that provides data about "Supplier Confirmation Header" in SAP S/4HANA. It reads from 1 data source (R_SupplierConfirmation) and exposes 21 fields with key field SupplierConfirmation. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SupplierConfirmation Confirmation from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_SuplrConfProcessingStatus _ConfStatus _ConfStatus.SuplrConfProcessingStatus = $projection.SuplrConfProcessingStatus
[0..1] I_PurchaseOrderAPI01 _PurchaseOrder _PurchaseOrder.PurchaseOrder = $projection.SuplrConfRefPurchaseOrder
[0..1] I_User _User _User.UserID = $projection.CreatedByUser
[0..1] I_Supplier _Supplier _Supplier.Supplier = $projection.Supplier
[0..1] I_PurchaseOrderSupplierAddress _SupplierAddress $projection.SuplrConfRefPurchaseOrder = _SupplierAddress.PurchaseOrder
[0..*] R_SupplierConfirmationItemTP _SupplierConfirmationItemTP

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Supplier Confirmation Header view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name SupplierConfirmation view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SupplierConfirmation SupplierConfirmation Confirmation
SuplrConfRefPurchaseOrder SuplrConfRefPurchaseOrder Purchase Order
LastChangeDateTime LastChangeDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
PurchasingDocumentType PurchasingDocumentType RFQ Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
SuplrConfProcessingStatus SuplrConfProcessingStatus Processing Status
Supplier Supplier Supplier
SuplrConfExternalReference SuplrConfExternalReference Supplier Reference
SuplrConfExtRefLastChgdDteTme SuplrConfExtRefLastChgdDteTme External Change
SuplrConfExternalSystemID SuplrConfExternalSystemID External System ID
SuplrConfCreationType SuplrConfCreationType Document Source
_SupplierConfirmationItemTP _SupplierConfirmationItemTP
_ConfStatus _ConfStatus
_PurchaseOrder _PurchaseOrder
_SupplierAddress _SupplierAddress
_Supplier _Supplier
_User _User

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_SupplierConfirmationTP.
-- 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 R_SupplierConfirmationTP AS
SELECT
  SupplierConfirmation,
  SuplrConfRefPurchaseOrder,
  LastChangeDateTime,
  CreatedByUser,
  CreationDate,
  PurchasingDocumentType,
  PurchasingOrganization,
  PurchasingGroup,
  IsEndOfPurposeBlocked,
  SuplrConfProcessingStatus,
  Supplier,
  SuplrConfExternalReference,
  SuplrConfExtRefLastChgdDteTme,
  SuplrConfExternalSystemID,
  SuplrConfCreationType
FROM R_SupplierConfirmation AS Confirmation
LEFT OUTER JOIN I_SuplrConfProcessingStatus AS _ConfStatus ON _ConfStatus.SuplrConfProcessingStatus = SuplrConfProcessingStatus  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderAPI01 AS _PurchaseOrder ON _PurchaseOrder.PurchaseOrder = SuplrConfRefPurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON _User.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderSupplierAddress AS _SupplierAddress ON SuplrConfRefPurchaseOrder = _SupplierAddress.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN R_SupplierConfirmationItemTP AS _SupplierConfirmationItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More