C_ContractFs

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_ContractFs.
-- 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: CCONTRACTFS

CREATE VIEW C_ContractFs AS
SELECT
  I_PurchaseContractVersion.PurchaseContract AS PurchaseContract,
  I_PurchaseContractVersion.ActivePurchasingDocument AS ActivePurchasingDocument,
  PurchasingDocumentVersion,
  _VersionType.ChangeRequestNote AS ChangeRequestNote,
  I_PurchaseContractVersion.PurchaseContractType AS PurchaseContractType,
  _PurchasingDocumentTypeName.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  I_PurchaseContractVersion.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_PurchaseContractVersion.IncotermsClassification AS IncotermsClassification,
  I_PurchaseContractVersion.CreationDate AS CreationDate,
  I_PurchaseContractVersion.DocumentCurrency AS DocumentCurrency,
  I_PurchaseContractVersion.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  PurchasingDocVersionReasonCode,
  I_PurchaseContractVersion.ReleaseCode AS ReleaseCode,
  I_PurchaseContractVersion.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  cast( '' as val_text) AS PurchasingDocumentStatusName,
  I_PurchaseContractVersion.Supplier AS Supplier,
  case when _SupplierHeadOffice.AddressID is not null then _SupplierHeadOffice.FullName else _SupplierHeadOffice1.FullName end as SupplierName AS FullNameendasSupplierName,
  cast('' as contactcardformattedaddress) AS FormattedAddress,
  case when _SupplierHeadOffice.AddressID is not null then cast(_SupplierHeadOffice.AddressID as adrnr) else cast(_SupplierHeadOffice1.AddressID as adrnr) end as AddressID AS AddressIDasadrnrendasAddressID,
  case when _SupplierHeadOffice.AddressID is not null then _SupplierHeadOffice.EmailAddress else _SupplierHeadOffice1.EmailAddress end as EmailAddress AS EmailAddressendasEmailAddress,
  case when _SupplierHeadOffice.AddressID is not null then _SupplierHeadOffice.PhoneNumber else _SupplierHeadOffice1.PhoneNumber end as InternationalPhoneNumber AS PhoneNumberendasInternationalPhoneNumber,
  I_PurchaseContractVersion.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_PurchaseContractVersion.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  I_PurchaseContractVersion.PurchasingGroup AS PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  SupplyingSupplier,
  InvoicingParty,
  SupplierAddressID,
  CreatedByUser,
  I_PurchaseContractVersion.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_PurchaseContractVersion.PaymentTerms AS PaymentTerms,
  cast('' as mm_pur_paymenttermstext) AS PaymentTermsDescription,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  _PurCtrIncotermsVersion.IncotermsVersionName AS IncotermsVersionName,
  I_PurchaseContractVersion.CashDiscount1Days AS CashDiscount1Days,
  I_PurchaseContractVersion.CashDiscount2Days AS CashDiscount2Days,
  I_PurchaseContractVersion.NetPaymentDays AS NetPaymentDays,
  I_PurchaseContractVersion.CashDiscount1Percent AS CashDiscount1Percent,
  I_PurchaseContractVersion.CashDiscount2Percent AS CashDiscount2Percent,
  I_PurchaseContractVersion.ValidityEndDate AS ValidityEndDate,
  I_PurchaseContractVersion.ValidityStartDate AS ValidityStartDate,
  cast( I_PurchaseContractVersion.ExchangeRate as fis_exchange_rate preserving type ) AS ExchangeRate,
  ExchangeRateIsFixed,
  cast ( '' as abap_boolean ) AS PurchasingItemHasHierarchy,
  cast ( '' as abap_boolean ) AS SrvcProcmtItmHierIsEnbld,
  cast ('' as boolean) AS VersionIsEnabled,
  I_PurchaseContractVersion._IncotermsClassification AS _IncotermsClassification,
  I_PurchaseContractVersion._PurchasingDocumentType AS _PurchasingDocumentType,
  I_PurchaseContractVersion._PurchasingDocumentCategory AS _PurchasingDocumentCategory
FROM I_PurchaseContractVersion
LEFT OUTER JOIN I_PurchaseContractHistory AS _PurchaseContractHistory ON PurchaseContract = _PurchaseContractHistory.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_ContractItemFs AS _PurchaseContractItem ON PurchaseContract = _PurchaseContractItem.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_PurContractItemHierFactSheet AS _PurContractItemHierFs ON PurchaseContract = _PurContractItemHierFs.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_ContractFactSheetHeaderText AS _ContractFactSheetHeaderText ON PurchaseContract = _ContractFactSheetHeaderText.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory AND PurchaseContractType = _PurchasingDocumentTypeText.PurchasingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeName ON PurchasingDocumentCategory = _PurchasingDocumentTypeName.PurchasingDocumentCategory AND PurchaseContractType = _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_ReleaseCodeText AS _ReleaseCodeText ON ReleaseCode = _ReleaseCodeText.ReleaseCode  -- association [0..*]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [0..*]
LEFT OUTER JOIN I_PurCtrIncoVersion AS _PurCtrIncotermsVersion ON IncotermsVersion = _PurCtrIncotermsVersion.IncotermsVersion  -- association [1..1]
LEFT OUTER JOIN I_SupplierOrAddressContactCard AS _SupplierHeadOffice ON ( _SupplierHeadOffice.ContactCardType = 'Address' AND _SupplierHeadOffice.ContactCardID = SupplierAddressID AND _SupplierHeadOffice.ContactCardRole = 'Supplier' )  -- association [1..1]
LEFT OUTER JOIN I_SupplierOrAddressContactCard AS _SupplierHeadOffice1 ON ( _SupplierHeadOffice1.ContactCardType = 'Supplier' AND _SupplierHeadOffice1.ContactCardID = Supplier AND _SupplierHeadOffice1.ContactCardRole = 'Supplier' )  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocument AS _Extension ON PurchaseContract = _Extension.PurchasingDocument  -- association [1]
;