A_SupplierConfirmationLine

DDL: A_SUPPLIERCONFIRMATIONLINE Type: view_entity CONSUMPTION Package: ODATA_MM_PUR_SUPPLIER_CONF_API
22 Fields 1 Data Sources 1 OData Services

Supplier Confirmation Line

A_SupplierConfirmationLine is a Consumption CDS View that provides data about "Supplier Confirmation Line" in SAP S/4HANA. It reads from 1 data source (R_SupplierConfirmationLineTP) and exposes 22 fields with key fields SupplierConfirmation, SupplierConfirmationItem, SupplierConfirmationLine. It is exposed through 1 OData service (API_SUPPLIERCONFIRMATION). Part of development package ODATA_MM_PUR_SUPPLIER_CONF_API.

Data Sources (1)

SourceAliasJoin Type
R_SupplierConfirmationLineTP R_SupplierConfirmationLineTP projection

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Supplier Confirmation Line view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
OData.entityType.name A_SupplierConfirmationLine_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_SUPPLIERCONFIRMATION API_SUPPLIERCONFIRMATION V4 C2 C1

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 A_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.

CREATE VIEW A_SupplierConfirmationLine 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