C_Schedgagrmthdr

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_Schedgagrmthdr.
-- 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: CSCHEDGAGRMTHDR

CREATE VIEW C_Schedgagrmthdr AS
SELECT
  I_SchedgagrmthdrWithDraft.SchedulingAgreement AS SchedulingAgreement,
  I_SchedgagrmthdrWithDraft.SchedulingAgreementForEdit AS SchedulingAgreementForEdit,
  I_SchedgagrmthdrWithDraft.CompanyCode AS CompanyCode,
  I_SchedgagrmthdrWithDraft.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_SchedgagrmthdrWithDraft.PurchasingDocumentType AS PurchasingDocumentType,
  I_SchedgagrmthdrWithDraft.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  I_SchedgagrmthdrWithDraft.CreatedByUser AS CreatedByUser,
  I_SchedgagrmthdrWithDraft.CreationDate AS CreationDate,
  I_SchedgagrmthdrWithDraft.Language AS Language,
  I_SchedgagrmthdrWithDraft.PurchasingOrganization AS PurchasingOrganization,
  I_SchedgagrmthdrWithDraft.PurchasingGroup AS PurchasingGroup,
  I_SchedgagrmthdrWithDraft.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_SchedgagrmthdrWithDraft.PaymentTerms AS PaymentTerms,
  I_SchedgagrmthdrWithDraft.CashDiscount1Days AS CashDiscount1Days,
  I_SchedgagrmthdrWithDraft.CashDiscount1Percent AS CashDiscount1Percent,
  I_SchedgagrmthdrWithDraft.CashDiscount2Days AS CashDiscount2Days,
  I_SchedgagrmthdrWithDraft.CashDiscount2Percent AS CashDiscount2Percent,
  I_SchedgagrmthdrWithDraft.NetPaymentDays AS NetPaymentDays,
  I_SchedgagrmthdrWithDraft.TargetAmount AS TargetAmount,
  I_SchedgagrmthdrWithDraft.DocumentCurrency AS DocumentCurrency,
  I_SchedgagrmthdrWithDraft.ExchangeRateForEdit AS ExchangeRateForEdit,
  I_SchedgagrmthdrWithDraft.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  I_SchedgagrmthdrWithDraft.IncotermsClassification AS IncotermsClassification,
  I_SchedgagrmthdrWithDraft.IncotermsLocation1 AS IncotermsLocation1,
  I_SchedgagrmthdrWithDraft.IncotermsLocation2 AS IncotermsLocation2,
  I_SchedgagrmthdrWithDraft.IncotermsVersion AS IncotermsVersion,
  I_SchedgagrmthdrWithDraft.IncotermsLocation1Identifier AS IncotermsLocation1Identifier,
  I_SchedgagrmthdrWithDraft.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  I_SchedgagrmthdrWithDraft.IncotermsLocation2Identifier AS IncotermsLocation2Identifier,
  I_SchedgagrmthdrWithDraft.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  I_SchedgagrmthdrWithDraft.IncotermsDvtgLocIdentifier AS IncotermsDvtgLocIdentifier,
  I_SchedgagrmthdrWithDraft.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  I_SchedgagrmthdrWithDraft.IncotermsDvtgLocDescription AS IncotermsDvtgLocDescription,
  I_SchedgagrmthdrWithDraft.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  I_SchedgagrmthdrWithDraft.ScheduleAgreementHasReleaseDoc AS ScheduleAgreementHasReleaseDoc,
  I_SchedgagrmthdrWithDraft.Supplier AS Supplier,
  I_SchedgagrmthdrWithDraft.SupplierAddressID AS SupplierAddressID,
  I_SchedgagrmthdrWithDraft.ValidityStartDate AS ValidityStartDate,
  I_SchedgagrmthdrWithDraft.ValidityEndDate AS ValidityEndDate,
  I_SchedgagrmthdrWithDraft.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  I_SchedgagrmthdrWithDraft.SchedgAgrmtOutpCtrlType AS SchedgAgrmtOutpCtrlType,
  I_SchedgagrmthdrWithDraft.SchedgAgrmtOutpCtrlStatus AS SchedgAgrmtOutpCtrlStatus,
  I_SchedgagrmthdrWithDraft.SchedgAgrmtOutpCtrlStatusText AS SchedgAgrmtOutpCtrlStatusText,
  I_SchedgagrmthdrWithDraft.SchedgAgrmtOutpCtrlTime AS SchedgAgrmtOutpCtrlTime,
  I_SchedgagrmthdrWithDraft.PurgAggrgdProdCmplncSuplrSts AS PurgAggrgdProdCmplncSuplrSts,
  _PurgTotProdCmplncSuplrStsT.PurgTotProdCmplncSuplrStsName AS PurgTotProdCmplncSuplrStsName,
  cast ('' as abap.char( 1 ) ) AS UICT_PurgAggrgdCmplncSuplrSts,
  cast ('' as ehfnd_boolean) AS ProductComplianceIsActive,
  cast ('' as ehfnd_bf_pcs_is_active) AS BusFtreProdCmplncSuplrIsActive,
  cast( '' as mm_approver_name ) AS ApproverName,
  cast( '' as mmpur_doc_status ) AS ApprovalStatus,
  cast( '' as mm_pur_schdgagrmtappstscrit ) AS SchedgAgrmtApprvlStsCritlty,
  cast( '' as mm_approval_status ) AS ApprovalStatusName,
  cast( '' as sww_aagent ) AS ApproverUser,
  cast ( '' as abap.char(2)) AS SchedulingAgreementStatus,
  cast( '' as mm_pur_schedgagrmtstscrit ) AS SchedgAgrmtStsCritlty,
  cast ( '' as mmpur_ord_status ) AS SchedulingAgreementStatusName,
  _SchedgAgrmtStatus.SchedulingAgreementStatus AS SchedulingAgreementStatus_H,
  I_SchedgagrmthdrWithDraft.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  I_SchedgagrmthdrWithDraft.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  I_SchedgagrmthdrWithDraft.SchedgAgrmtIsInPreparation AS SchedgAgrmtIsInPreparation,
  I_SchedgagrmthdrWithDraft.LastChangeDateTime AS LastChangeDateTime,
  I_SchedgagrmthdrWithDraft.QuotationSubmissionDate AS QuotationSubmissionDate,
  I_SchedgagrmthdrWithDraft.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  I_SchedgagrmthdrWithDraft.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  I_SchedgagrmthdrWithDraft.SupplierPhoneNumber AS SupplierPhoneNumber,
  I_SchedgagrmthdrWithDraft.InvoicingParty AS InvoicingParty,
  I_SchedgagrmthdrWithDraft.SupplyingSupplier AS SupplyingSupplier,
  I_SchedgagrmthdrWithDraft.CorrespncExternalReference AS CorrespncExternalReference,
  I_SchedgagrmthdrWithDraft.CorrespncInternalReference AS CorrespncInternalReference,
  _Supplier.SupplierName AS SupplierName,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  cast( '' as mmpur_extreferencesystemid ) AS PurgDocExternalSystem,
  _OvrlTradeCmplncEmbargoStsTxt.OverallTrdCmplncEmbargoStsDesc AS OverallTrdCmplncEmbargoStsDesc,
  I_SchedgagrmthdrWithDraft.OvrlTrdCmplncSnctndListChkSts AS OvrlTrdCmplncSnctndListChkSts,
  _OvTrdComplSanctListChkStsTxt.OvrlTrdCmplncSnctndListStsDesc AS OvrlTrdCmplncSnctndListStsDesc,
  I_SchedgagrmthdrWithDraft.OvrlTrdCmplncLegalCtrlChkSts AS OvrlTrdCmplncLegalCtrlChkSts,
  _OvTrdComplLegalCtrlChkStsTxt.OvrlTrdCmplncLglCtrlChkStsDesc AS OvrlTrdCmplncLglCtrlChkStsDesc,
  I_SchedgagrmthdrWithDraft._DocumentCurrency AS _DocumentCurrency
FROM I_SchedgagrmthdrWithDraft
LEFT OUTER JOIN C_Schedgagrmtitm AS _SchedgAgrmtItmWithDraft ON _SchedgAgrmtItmWithDraft.SchedulingAgreement = SchedulingAgreement  -- association [1..*]
LEFT OUTER JOIN C_Schedgagrmnthdrcnd AS _Schedgagrmthdrcndwithdraft ON SchedulingAgreement = _Schedgagrmthdrcndwithdraft.SchedulingAgreement  -- association [0..*]
LEFT OUTER JOIN C_SchedgAgrmtPartner AS _SchedgAgrmtPartnerWD ON _SchedgAgrmtPartnerWD.SchedulingAgreement = SchedulingAgreement  -- association [1..*]
LEFT OUTER JOIN C_SupplierPurchOrgVH AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier AND _SupplierValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_MM_CompanyCodeValueHelp AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroup ON _PurchasingGroup.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON _PaymentTerms.PaymentTerms = PaymentTerms  -- association [0..1]
LEFT OUTER JOIN C_MM_IncotermValueHelp AS _IncotermsClassification ON _IncotermsClassification.IncotermsClassification = IncotermsClassification AND _IncotermsClassification.IncotermsVersion = IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Schedgagrmttypevh AS _Schedgagrmttypevh ON PurchasingDocumentType = _Schedgagrmttypevh.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_SchedgAgrmtIncoVersion AS _SchedAgrmtIncotermsVersion ON IncotermsVersion = _SchedAgrmtIncotermsVersion.IncotermsVersion  -- association [1..1]
LEFT OUTER JOIN C_SupplierPurchOrgVH AS _SupplyingSupplier ON SupplyingSupplier = _SupplyingSupplier.Supplier AND _SupplyingSupplier.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_SupplierPurchOrgVH AS _InvoicingParty ON InvoicingParty = _InvoicingParty.Supplier AND _InvoicingParty.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_SchedgAgrmtHeaderNotesTP AS _SchedgAgrmtHeaderNotesTP ON SchedulingAgreement = _SchedgAgrmtHeaderNotesTP.SchedulingAgreement  -- association [0..*]
LEFT OUTER JOIN C_MM_PaymentTermValueHelp AS _PaymentTermsValueHelp ON _PaymentTermsValueHelp.PaymentTerms = PaymentTerms  -- association [0..*]
LEFT OUTER JOIN I_SchedulingAgreementStatus AS _SchedgAgrmtStatus ON SchedulingAgreement = _SchedgAgrmtStatus.SchedulingAgreement  -- association [0..1]
LEFT OUTER JOIN C_SchedgAgrmtWorkflow AS _SchedgAgrmtWorkflow ON _SchedgAgrmtWorkflow.SchedulingAgreement = SchedulingAgreement AND _SchedgAgrmtWorkflow.WorkflowTaskStatus <> 'STARTED'  -- association [0..*]
LEFT OUTER JOIN I_PurgTotProdCmplncSuplrStsT AS _PurgTotProdCmplncSuplrStsT ON PurgAggrgdProdCmplncSuplrSts = _PurgTotProdCmplncSuplrStsT.PurgAggrgdProdCmplncSuplrSts AND _PurgTotProdCmplncSuplrStsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TransportationLocationVH AS _TransportationLocation1VH ON IncotermsLocation1Identifier = _TransportationLocation1VH.Location  -- association [0..*]
LEFT OUTER JOIN I_TransportationLocationVH AS _TransportationLocation2VH ON IncotermsLocation2Identifier = _TransportationLocation2VH.Location  -- association [0..*]
LEFT OUTER JOIN I_TransportationLocationVH AS _TransportationLocation3VH ON IncotermsDvtgLocIdentifier = _TransportationLocation3VH.Location  -- association [0..*]
LEFT OUTER JOIN I_OvrlTradeCmplncEmbargoStsTxt AS _OvrlTradeCmplncEmbargoStsTxt ON OverallTrdCmplncEmbargoSts = _OvrlTradeCmplncEmbargoStsTxt.OverallTrdCmplncEmbargoSts AND _OvrlTradeCmplncEmbargoStsTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OvTrdComplSanctListChkStsTxt AS _OvTrdComplSanctListChkStsTxt ON OvrlTrdCmplncSnctndListChkSts = _OvTrdComplSanctListChkStsTxt.OvrlTrdCmplncSnctndListChkSts AND _OvTrdComplSanctListChkStsTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OvTrdComplLegalCtrlChkStsTxt AS _OvTrdComplLegalCtrlChkStsTxt ON OvrlTrdCmplncLegalCtrlChkSts = _OvTrdComplLegalCtrlChkStsTxt.OvrlTrdCmplncLegalCtrlChkSts AND _OvTrdComplLegalCtrlChkStsTxt.Language = $session.system_language  -- association [0..1]
;