I_SchedgagrmthdrWithDraft

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_SchedgagrmthdrWithDraft.
-- 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: ISCHEDGAGRM000WD

CREATE VIEW I_SchedgagrmthdrWithDraft AS
SELECT
  Document.SchedulingAgreement AS SchedulingAgreement,
  Document.SchedulingAgreement AS SchedulingAgreementForEdit,
  Document.CompanyCode AS CompanyCode,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.PurchasingDocumentType AS PurchasingDocumentType,
  Document.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  Document.CreatedByUser AS CreatedByUser,
  Document.CreationDate AS CreationDate,
  Document.Language AS Language,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.IncotermsClassification AS IncotermsClassification,
  Document.IncotermsTransferLocation AS IncotermsTransferLocation,
  Document.IncotermsLocation1Identifier AS IncotermsLocation1Identifier,
  Document.IncotermsLocation2Identifier AS IncotermsLocation2Identifier,
  Document.IncotermsDvtgLocIdentifier AS IncotermsDvtgLocIdentifier,
  Document.IncotermsDvtgLocDescription AS IncotermsDvtgLocDescription,
  Document.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  Document.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  Document.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  Document.PaymentTerms AS PaymentTerms,
  Document.CashDiscount1Days AS CashDiscount1Days,
  Document.CashDiscount2Days AS CashDiscount2Days,
  Document.CashDiscount1Percent AS CashDiscount1Percent,
  Document.CashDiscount2Percent AS CashDiscount2Percent,
  Document.NetPaymentDays AS NetPaymentDays,
  Document.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  Document.ScheduleAgreementHasReleaseDoc AS ScheduleAgreementHasReleaseDoc,
  Document.Supplier AS Supplier,
  Document.SupplierAddressID AS SupplierAddressID,
  Document.ValidityStartDate AS ValidityStartDate,
  Document.ValidityEndDate AS ValidityEndDate,
  Document.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  Document.PurgAggrgdProdCmplncSuplrSts AS PurgAggrgdProdCmplncSuplrSts,
  Document.TargetAmount AS TargetAmount,
  cast ( Document.ExchangeRate as wkurs) AS ExchangeRate,
  cast(Document.ExchangeRate as abap.char( 12 )) AS ExchangeRateForEdit,
  Document.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  Document.IncotermsLocation1 AS IncotermsLocation1,
  Document.IncotermsLocation2 AS IncotermsLocation2,
  Document.IncotermsVersion AS IncotermsVersion,
  _SchedgAgrmtTransientField.SchedgAgrmtOutpCtrlType AS SchedgAgrmtOutpCtrlType,
  _SchedgAgrmtTransientField.SchedgAgrmtOutpCtrlStatus AS SchedgAgrmtOutpCtrlStatus,
  _SchedgAgrmtTransientField.SchedgAgrmtOutpCtrlStatusText AS SchedgAgrmtOutpCtrlStatusText,
  _SchedgAgrmtTransientField.SchedgAgrmtOutpCtrlTime AS SchedgAgrmtOutpCtrlTime,
  Document.QuotationSubmissionDate AS QuotationSubmissionDate,
  Document.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  Document.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  Document.SupplierPhoneNumber AS SupplierPhoneNumber,
  Document.InvoicingParty AS InvoicingParty,
  Document.SupplyingSupplier AS SupplyingSupplier,
  Document.CorrespncExternalReference AS CorrespncExternalReference,
  Document.CorrespncInternalReference AS CorrespncInternalReference,
  Document.VATRegistrationCountry AS VATRegistrationCountry,
  Document.CompanyVATRegistration AS CompanyVATRegistration,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  Document.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  Document.SchedgAgrmtIsInPreparation AS SchedgAgrmtIsInPreparation,
  Document.OverallTrdCmplncEmbargoSts AS OverallTrdCmplncEmbargoSts,
  Document.OvrlTrdCmplncSnctndListChkSts AS OvrlTrdCmplncSnctndListChkSts,
  Document.OvrlTrdCmplncLegalCtrlChkSts AS OvrlTrdCmplncLegalCtrlChkSts
FROM I_Schedgagrmthdr AS Document
LEFT OUTER JOIN I_SchedgAgrmtItmWithDraft AS _SchedgAgrmtItmWithDraft ON _SchedgAgrmtItmWithDraft.SchedulingAgreement = SchedulingAgreement  -- association [1..*]
LEFT OUTER JOIN I_Schedgagrmthdrcndwithdraft AS _Schedgagrmthdrcndwithdraft ON _Schedgagrmthdrcndwithdraft.SchedulingAgreement = SchedulingAgreement  -- association [0..*]
LEFT OUTER JOIN I_SchedgAgrmtPartnWD AS _SchedgAgrmtPartnerWD ON _SchedgAgrmtPartnerWD.SchedulingAgreement = SchedulingAgreement  -- association [1..*]
LEFT OUTER JOIN E_PurchasingDocument AS _SchedulingAgreementExtension ON SchedulingAgreement = _SchedulingAgreementExtension.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplyingSupplier ON _SupplyingSupplier.Supplier = SupplyingSupplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InvoicingParty ON _InvoicingParty.Supplier = InvoicingParty  -- association [0..1]
LEFT OUTER JOIN I_Schedgagrmthdrtranfields AS _SchedgAgrmtTransientField ON SchedulingAgreement = _SchedgAgrmtTransientField.SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Schedgagrmttypevh AS _Schedgagrmttypevh ON PurchasingDocumentType = _Schedgagrmttypevh.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_SchedgAgrmtHeaderNotesTP AS _SchedgAgrmtHeaderNotesTP ON SchedulingAgreement = _SchedgAgrmtHeaderNotesTP.SchedulingAgreement  -- association [0..*]
;