R_SupplierConfirmation

DDL: R_SUPPLIERCONFIRMATION SQL: RSUPPLCONFH Type: view BASIC Package: RAP_MM_PUR_CONF
16 Fields 1 Data Sources 1 Associations

Supplier Confirmation Header

R_SupplierConfirmation is a Basic CDS View that provides data about "Supplier Confirmation Header" in SAP S/4HANA. It reads from 1 data source (mmpur_supconfh) and exposes 16 fields with key field SupplierConfirmation. It has 1 association to related views. Part of development package RAP_MM_PUR_CONF.

Data Sources (1)

SourceAliasJoin Type
mmpur_supconfh mmpur_supconfh from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_SupplierConfirmationItem _SupplierConfirmationItem

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName RSUPPLCONFH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Supplier Confirmation Header view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SupplierConfirmation confirmation_id Confirmation
SuplrConfRefPurchaseOrder ref_purchase_order Purchase Order
LastChangeDateTime last_changed_datetime Last Changed
CreationDate erdat Entered On
CreatedByUser ernam User Name
PurchasingDocumentType bsart Stnd purch.ord.
PurchasingOrganization ekorg Purchasing Org.
PurchasingGroup ekgrp Sub. purchasing grp
Supplier lifnr Vendor no.
IsEndOfPurposeBlocked iseopblocked Business Usage Comp.
SuplrConfProcessingStatus supplconfprocstate Processing Status
SuplrConfExternalReference ext_supplier_refid Supplier Reference
SuplrConfExtRefLastChgdDteTme ext_last_changed_datetime External Change
SuplrConfExternalSystemID ext_system_id External System ID
SuplrConfCreationType creation_type Document Source
_SupplierConfirmationItem _SupplierConfirmationItem

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_SupplierConfirmation.
-- 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: RSUPPLCONFH

CREATE VIEW R_SupplierConfirmation AS
SELECT
  confirmation_id AS SupplierConfirmation,
  ref_purchase_order AS SuplrConfRefPurchaseOrder,
  last_changed_datetime AS LastChangeDateTime,
  erdat AS CreationDate,
  ernam AS CreatedByUser,
  bsart AS PurchasingDocumentType,
  ekorg AS PurchasingOrganization,
  ekgrp AS PurchasingGroup,
  lifnr AS Supplier,
  iseopblocked AS IsEndOfPurposeBlocked,
  supplconfprocstate AS SuplrConfProcessingStatus,
  ext_supplier_refid AS SuplrConfExternalReference,
  ext_last_changed_datetime AS SuplrConfExtRefLastChgdDteTme,
  ext_system_id AS SuplrConfExternalSystemID,
  creation_type AS SuplrConfCreationType
FROM mmpur_supconfh
LEFT OUTER JOIN R_SupplierConfirmationItem AS _SupplierConfirmationItem ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More