C_Schagritm

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 C_Schagritm.
-- 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: CSCHEDGAGRMTITEM

CREATE VIEW C_Schagritm AS
SELECT
  SchedulingAgreement,
  SchedulingAgreementItem,
  PurchasingDocumentItemCategory,
  PurchasingInfoRecord,
  PurgDocOrderAcknNumber,
  IncotermsClassification,
  IncotermsTransferLocation,
  ManufacturerMaterial,
  PurchasingDocumentItemText,
  SupplierMaterialNumber,
  QualityCertificateType,
  Plant,
  OrderQuantityUnit,
  Material,
  TargetQuantity,
  ManualDeliveryAddressID,
  ReferenceDeliveryAddressID,
  Customer,
  _SchDelivery.DeliveryAddressID AS ItemDeliveryAddressID,
  NetPriceQuantity,
  I_SchedgAgrmtItm.OrderPriceUnit AS OrderPriceUnit,
  InternationalArticleNumber,
  PurchaseContract,
  PurchaseContractItem,
  PurchasingParentItem,
  NetPriceAmount,
  GrossAmount,
  TargetAmount,
  DocumentCurrency,
  Manufacturer,
  ManufacturerPartNmbr,
  ServicePackage
FROM I_SchedgAgrmtItm
LEFT OUTER JOIN C_Schagrhdr AS _Schagrhdr ON SchedulingAgreement = _Schagrhdr.SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurOrdItem ON SchedulingAgreementItem = _PurOrdItem.PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN C_SchAgrAccount AS _SchAgrAccount ON SchedulingAgreement = _SchAgrAccount.SchedulingAgreement AND SchedulingAgreementItem = _SchAgrAccount.SchedulingAgreementItem  -- association [1..*]
LEFT OUTER JOIN C_Schdline AS _Schdline ON SchedulingAgreement = _Schdline.SchedulingAgreement AND SchedulingAgreementItem = _Schdline.SchedulingAgreementItem  -- association [1..*]
LEFT OUTER JOIN C_SchAgmtDelivery AS _SchDelivery ON SchedulingAgreement = _SchDelivery.SchedulingAgreement AND SchedulingAgreementItem = _SchDelivery.SchedulingAgreementItem  -- association [1..1]
LEFT OUTER JOIN I_Schedgagrmtitmcnd AS _ItemConditions ON SchedulingAgreement = _ItemConditions.SchedulingAgreement AND SchedulingAgreementItem = _ItemConditions.SchedulingAgreementItem  -- association [1..*]
;