R_SupplierConfirmationLineTP

DDL: R_SUPPLIERCONFIRMATIONLINETP Type: view_entity TRANSACTIONAL Package: RAP_MM_PUR_CONF
28 Fields 1 Data Sources 3 Associations

Supplier Confirmation Line

R_SupplierConfirmationLineTP is a Transactional CDS View that provides data about "Supplier Confirmation Line" in SAP S/4HANA. It reads from 1 data source (R_SupplierConfirmationLine) and exposes 28 fields with key fields SupplierConfirmation, SupplierConfirmationItem, SupplierConfirmationLine. It has 3 associations to related views. Part of development package RAP_MM_PUR_CONF.

Data Sources (1)

SourceAliasJoin Type
R_SupplierConfirmationLine SupplierConfirmationLine from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_POSupplierConfirmationAPI01 _PurchaseOrderConfirmation _PurchaseOrderConfirmation.SupplierConfirmation = $projection.SupplierConfirmation and _PurchaseOrderConfirmation.SupplierConfirmationItem = $projection.SupplierConfirmationItem and _PurchaseOrderConfirmation.SequentialNmbrOfSuplrConf = $projection.SuplrConfRefSequenceNumber
[0..1] I_BusinessPartner _ServicePerformer $projection.ServicePerformer = _ServicePerformer.BusinessPartner
[0..1] I_Deliverydatecategory _DeliveryDateCategoryTxt _DeliveryDateCategoryTxt.DelivDateCategory = $projection.DelivDateCategory

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Supplier Confirmation Line 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

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY SupplierConfirmation SupplierConfirmation Confirmation
KEY SupplierConfirmationItem SupplierConfirmationItem Confirmation Item
KEY SupplierConfirmationLine SupplierConfirmationLine Confirmation Line
SuplrConfirmationLineUniqueID SuplrConfirmationLineUniqueID Schedule line
LastChangeDateTime LastChangeDateTime Timestamp
SuplrConfRefSequenceNumber SuplrConfRefSequenceNumber ReferenceSeqNo
SupplierConfirmationCategory SupplierConfirmationCategory Confirm. Cat.
DeliveryDate DeliveryDate Delivery Date
DelivDateCategory DelivDateCategory Delivery Date
DeliveryTime DeliveryTime TimeOfDelivery
ConfirmedQuantity ConfirmedQuantity Quantity in UnE
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
SupplierConfirmationExtNumber SupplierConfirmationExtNumber Reference
PerformancePeriodStartDate PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate PerformancePeriodEndDate End of Performance Period
ServicePerformer ServicePerformer Service Performer
ExpectedOverallLimitAmount ExpectedOverallLimitAmount Expected Value
DocumentCurrency DocumentCurrency Document Currency
ManufacturerMaterial ManufacturerMaterial MPN: Material
StockSegment StockSegment Stock Segment
HandoverDate HandoverDate Handover Date
HandoverTime HandoverTime Handover Time
SuplrConfExtRefLastChgdDteTme SuplrConfExtRefLastChgdDteTme External Change
_SupplierConfirmationItemTP _SupplierConfirmationItemTP
_SupplierConfirmationTP _SupplierConfirmationTP
_ServicePerformer _ServicePerformer
_PurchaseOrderConfirmation _PurchaseOrderConfirmation
_DeliveryDateCategoryTxt _DeliveryDateCategoryTxt

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_SupplierConfirmationLineTP.
-- 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_SupplierConfirmationLineTP AS
SELECT
  SupplierConfirmation,
  SupplierConfirmationItem,
  SupplierConfirmationLine,
  SuplrConfirmationLineUniqueID,
  LastChangeDateTime,
  SuplrConfRefSequenceNumber,
  SupplierConfirmationCategory,
  DeliveryDate,
  DelivDateCategory,
  DeliveryTime,
  ConfirmedQuantity,
  PurchaseOrderQuantityUnit,
  SupplierConfirmationExtNumber,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  ServicePerformer,
  ExpectedOverallLimitAmount,
  DocumentCurrency,
  ManufacturerMaterial,
  StockSegment,
  HandoverDate,
  HandoverTime,
  SuplrConfExtRefLastChgdDteTme
FROM R_SupplierConfirmationLine AS SupplierConfirmationLine
LEFT OUTER JOIN I_POSupplierConfirmationAPI01 AS _PurchaseOrderConfirmation ON _PurchaseOrderConfirmation.SupplierConfirmation = SupplierConfirmation AND _PurchaseOrderConfirmation.SupplierConfirmationItem = SupplierConfirmationItem AND _PurchaseOrderConfirmation.SequentialNmbrOfSuplrConf = SuplrConfRefSequenceNumber  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ServicePerformer ON ServicePerformer = _ServicePerformer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Deliverydatecategory AS _DeliveryDateCategoryTxt ON _DeliveryDateCategoryTxt.DelivDateCategory = DelivDateCategory  -- association [0..1]
;

Learn More