R_SupplierConfirmationLine

DDL: R_SUPPLIERCONFIRMATIONLINE SQL: RSUPPLCONFL Type: view BASIC
25 Fields 1 Data Sources

Supplier Confirmation Line

R_SupplierConfirmationLine is a Basic CDS View that provides data about "Supplier Confirmation Line" in SAP S/4HANA. It reads from 1 data source (mmpur_supconfd) and exposes 25 fields with key fields SupplierConfirmation, SupplierConfirmationItem, SupplierConfirmationLine.

Data Sources (1)

SourceAliasJoin Type
mmpur_supconfd mmpur_supconfd from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName RSUPPLCONFL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Supplier Confirmation Line 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 (25)

KeyFieldSource TableSource FieldDescription
KEY SupplierConfirmation confirmation_id Confirmation
KEY SupplierConfirmationItem confirmation_item Confirmation Item
KEY SupplierConfirmationLine confirmation_line Confirmation Line
SuplrConfirmationLineUniqueID uniqueid Schedule line
LastChangeDateTime last_changed_datetime Last Changed
SuplrConfRefSequenceNumber ref_sequence_number ReferenceSeqNo
SupplierConfirmationCategory ebtyp Confirm. Cat.
DeliveryDate eindt Initial Entry
DelivDateCategory lpein Price Unit
DeliveryTime uzeit Time
ConfirmedQuantity menge WarrCountValue
PurchaseOrderQuantityUnit meins Valuation Unit
SupplierConfirmationExtNumber xblnr Reference
PerformancePeriodStartDate startdate Valid From
PerformancePeriodEndDate enddate Term to
ServicePerformer serviceperformer Service Performer
ExpectedOverallLimitAmount expected_value Expected Value
DocumentCurrency waers Transaction Currency
ManufacturerMaterial ematn MPN: Material
StockSegment sgt_scat Stock Segment
HandoverDate handoverdate Handover Date
HandoverTime handovertime Handover Time
SuplrConfExtRefLastChgdDteTme ext_last_changed_datetime External Change
_SupplierConfirmationItem _SupplierConfirmationItem
_SupplierConfirmation _SupplierConfirmation

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_SupplierConfirmationLine.
-- 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: RSUPPLCONFL

CREATE VIEW R_SupplierConfirmationLine AS
SELECT
  confirmation_id AS SupplierConfirmation,
  confirmation_item AS SupplierConfirmationItem,
  confirmation_line AS SupplierConfirmationLine,
  uniqueid AS SuplrConfirmationLineUniqueID,
  last_changed_datetime AS LastChangeDateTime,
  ref_sequence_number AS SuplrConfRefSequenceNumber,
  ebtyp AS SupplierConfirmationCategory,
  eindt AS DeliveryDate,
  lpein AS DelivDateCategory,
  uzeit AS DeliveryTime,
  menge AS ConfirmedQuantity,
  meins AS PurchaseOrderQuantityUnit,
  xblnr AS SupplierConfirmationExtNumber,
  startdate AS PerformancePeriodStartDate,
  enddate AS PerformancePeriodEndDate,
  ServicePerformer,
  expected_value AS ExpectedOverallLimitAmount,
  waers AS DocumentCurrency,
  ematn AS ManufacturerMaterial,
  sgt_scat AS StockSegment,
  HandoverDate,
  HandoverTime,
  ext_last_changed_datetime AS SuplrConfExtRefLastChgdDteTme
FROM mmpur_supconfd
;

Learn More