C_SupplierSchedgAgrmtHdr

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_SupplierSchedgAgrmtHdr.
-- 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: CSUPSCHEDGAGRMT

CREATE VIEW C_SupplierSchedgAgrmtHdr AS
SELECT
  SchedulingAgreement,
  CompanyCode,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingDocumentSubtype,
  PurchasingDocumentTypeName,
  CreatedByUser,
  CreatedByUserFullName,
  CreationDate,
  Language,
  PurchasingOrganization,
  PurchasingGroup,
  DocumentCurrency,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  NetPaymentDays,
  TargetAmount,
  ExchangeRate,
  ExchangeRateIsFixed,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  cast('' as abap.char( 100 )) AS PaymentTermsDescription,
  PurchasingDocumentOrderDate,
  ScheduleAgreementHasReleaseDoc,
  Supplier,
  SupplierAddressID,
  ValidityStartDate,
  ValidityEndDate,
  PurchasingDocumentOrigin,
  QuotationSubmissionDate,
  SupplierQuotationExternalID,
  VATRegistrationCountry,
  InvoicingParty,
  SupplyingSupplier,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  CorrespncExternalReference,
  CorrespncInternalReference,
  CompanyVATRegistration,
  LastChangeDateTime,
  IsEndOfPurposeBlocked,
  PurchasingDocumentDeletionCode,
  ReleaseIsNotCompleted,
  PurchasingCompletenessStatus,
  PurchasingProcessingStatus,
  _PurgProcessingStatusText.PurchasingProcessingStatusName AS PurchasingProcessingStatusName,
  _SupplierHeadOffice.FullName AS SupplierName,
  _SupplierHeadOffice.EmailAddress AS EmailAddress,
  cast(_SupplierHeadOffice.AddressID as abap.char( 10 )) AS AddressID,
  _SupplierHeadOffice.PhoneNumber AS InternationalPhoneNumber,
  _SupplierHeadOffice.MobilePhoneNumber AS InternationalMobilePhoneNumber,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName
FROM I_Schedgagrmthdr
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory AND PurchasingDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeName ON PurchasingDocumentCategory = _PurchasingDocumentTypeName.PurchasingDocumentCategory AND PurchasingDocumentType = _PurchasingDocumentTypeName.PurchasingDocumentType AND _PurchasingDocumentTypeName.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _PurgDocumentCategoryText ON PurchasingDocumentCategory = _PurgDocumentCategoryText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON IncotermsClassification = _IncotermsClassificationText.IncotermsClassification  -- association [0..*]
LEFT OUTER JOIN I_PurgProcessingStatusText AS _PurgProcessingStatusText ON PurchasingProcessingStatus = _PurgProcessingStatusText.PurchasingProcessingStatus AND _PurgProcessingStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [0..*]
LEFT OUTER JOIN I_SupplierOrAddressContactCard AS _SupplierHeadOffice ON ( _SupplierHeadOffice.ContactCardType = 'Address' AND _SupplierHeadOffice.ContactCardID = SupplierAddressID AND _SupplierHeadOffice.ContactCardRole = 'Supplier' ) OR ( _SupplierHeadOffice.ContactCardType = 'Supplier' AND _SupplierHeadOffice.ContactCardID = Supplier AND _SupplierHeadOffice.ContactCardRole = 'Supplier' )  -- association [1..1]
;