I_SupplierConfirmationLineTP

DDL: I_SUPPLIERCONFIRMATIONLINETP Type: view_entity TRANSACTIONAL Package: RAP_MM_PUR_CONF_API
22 Fields 1 Data Sources

Supplier Confirmation Line - TP

I_SupplierConfirmationLineTP is a Transactional CDS View that provides data about "Supplier Confirmation Line - TP" in SAP S/4HANA. It reads from 1 data source (R_SupplierConfirmationLineTP) and exposes 22 fields with key fields SupplierConfirmation, SupplierConfirmationItem, SupplierConfirmationLine. Part of development package RAP_MM_PUR_CONF_API.

Data Sources (1)

SourceAliasJoin Type
R_SupplierConfirmationLineTP R_SupplierConfirmationLineTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Supplier Confirmation Line - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY SupplierConfirmation SupplierConfirmation
KEY SupplierConfirmationItem SupplierConfirmationItem
KEY SupplierConfirmationLine SupplierConfirmationLine
SuplrConfirmationLineUniqueID SuplrConfirmationLineUniqueID
SuplrConfRefSequenceNumber SuplrConfRefSequenceNumber ReferenceSeqNo
SupplierConfirmationCategory SupplierConfirmationCategory Confirm. Cat.
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

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 I_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 I_SupplierConfirmationLineTP AS
SELECT
  SupplierConfirmation,
  SupplierConfirmationItem,
  SupplierConfirmationLine,
  SuplrConfirmationLineUniqueID,
  SuplrConfRefSequenceNumber,
  SupplierConfirmationCategory,
  cast (DeliveryDate as eindt_ll preserving type) AS DeliveryDate,
  DelivDateCategory,
  DeliveryTime,
  ConfirmedQuantity,
  PurchaseOrderQuantityUnit,
  SupplierConfirmationExtNumber,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  ServicePerformer,
  ExpectedOverallLimitAmount,
  DocumentCurrency,
  ManufacturerMaterial,
  StockSegment,
  HandoverDate,
  HandoverTime,
  SuplrConfExtRefLastChgdDteTme
FROM R_SupplierConfirmationLineTP
;

Learn More