C_ConditionContract_F4578

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_ConditionContract_F4578.
-- 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.

CREATE VIEW C_ConditionContract_F4578 AS
SELECT
  Contract.ConditionContract AS ConditionContract,
  text.element: ['CndnContrTypeDesc'] Contract.CndnContrType as CndnContrType AS CndnContrTypeasCndnContrType,
  Contract._CndnContrType._Text[1: Language = $session.system_language ].CndnContrTypeDesc AS CndnContrTypeDesc,
  Contract.CndnContrClassfctnType AS CndnContrClassfctnType,
  Contract._CndnContrClassfctnType._Text[1: Language = $session.system_language ].CndnContrClassfctnTypeDesc AS CndnContrClassfctnTypeDesc,
  Contract.CndnContrProcVar AS CndnContrProcVar,
  Contract._CndnContrProcVar._Text[1: Language = $session.system_language ].CndnContrProcVarDesc AS CndnContrProcVarDesc,
  Contract.DocumentReferenceID AS DocumentReferenceID,
  Contract.CndnContrAssgmtRef AS CndnContrAssgmtRef,
  Contract.ExternalDocumentReferenceID AS ExternalDocumentReferenceID,
  Contract.CndnContrExternalPartner AS CndnContrExternalPartner,
  Contract.CndnContrActvtnStatus AS CndnContrActvtnStatus,
  Contract._CndnContrActvtnStatus._Text[1: Language = $session.system_language ].CndnContrActvtnStatusName AS CndnContrActvtnStatusName,
  Contract.CndnContrValidFrom AS CndnContrValidFrom,
  Contract.CndnContrValidTo AS CndnContrValidTo,
  cast( _MainSystemStatus.CndnContrMainSystemStatus as wcb_main_system_status preserving type ) AS CndnContrMainSystemStatus,
  _MainSystemStatus._SystemStatus._SystemStatusText[1: Language = $session.system_language ].SystemStatusName AS CndnContrMainSystemStatusText,
  Contract.Supplier AS Supplier,
  Contract._Supplier.SupplierName AS SupplierName,
  Contract._Supplier.OrganizationBPName1 AS SupplierName_H,
  Contract.PriorSupplier AS PriorSupplier,
  Contract._PriorSupplier.SupplierName AS PriorSupplierName,
  Contract.CompanyCode AS CompanyCode,
  Contract._CompanyCode.CompanyCodeName AS CompanyCodeName,
  Contract.PurchasingOrganization AS PurchasingOrganization,
  Contract._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  Contract.PurchasingGroup AS PurchasingGroup,
  Contract._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  Contract.SalesOrganization AS SalesOrganization,
  Contract._SalesOrganization._Text[1: Language = $session.system_language ].SalesOrganizationName AS SalesOrganizationName,
  Contract.DistributionChannel AS DistributionChannel,
  Contract._DistributionChannel._Text[1: Language = $session.system_language ].DistributionChannelName AS DistributionChannelName,
  Contract.Division AS Division,
  Contract._Division._Text[1: Language = $session.system_language ].DivisionName AS DivisionName,
  Contract.SalesGroup AS SalesGroup,
  Contract._SalesGroup._Text[1: Language = $session.system_language ].SalesGroupName AS SalesGroupName,
  Contract.SalesOffice AS SalesOffice,
  Contract._SalesOffice._Text[1: Language = $session.system_language ].SalesOfficeName AS SalesOfficeName,
  Contract.CreatedByUser AS CreatedByUser,
  cast( Contract._CreatedByUser.UserDescription as wlf_created_by_fullname preserving type ) AS CreatedByUserFullName,
  cast( Contract.CreationUTCDateTime as wcb_created_on_tstmp preserving type ) AS CreationUTCDateTime,
  Contract.LastChangedByUser AS LastChangedByUser,
  Contract._LastChangedByUser.UserDescription AS LastChangedByUserFullName,
  cast( Contract.LastChangeUTCDateTime as wcb_changed_on_tstmp preserving type ) AS LastChangeUTCDateTime,
  Contract.CndnContrCurrency AS CndnContrCurrency,
  Contract._CndnContrCurrency._Text[1: Language = $session.system_language ].CurrencyName AS CurrencyName,
  Contract.PaymentTerms AS PaymentTerms,
  Contract.CashDiscount1Days AS CashDiscount1Days,
  Contract.CashDiscount1Percent AS CashDiscount1Percent,
  Contract.CashDiscount2Days AS CashDiscount2Days,
  Contract.CashDiscount2Percent AS CashDiscount2Percent,
  Contract.NetPaymentDays AS NetPaymentDays,
  Contract.PaymentMethod AS PaymentMethod,
  Contract.SettlmtProduct AS SettlmtProduct,
  Contract._SettlmtProduct._Text[1: Language = $session.system_language ].ProductName AS ProductName,
  Contract.CndnContrPurposeCat AS CndnContrPurposeCat,
  Contract._CndnContrPurposeCat._Text[1: Language = $session.system_language ].CndnContrPurposeCatName AS CndnContrPurposeCatName,
  Contract.CndnContrSourceDocCat AS CndnContrSourceDocCat,
  Contract._CndnContrSourceDocCat._Text[1: Language = $session.system_language ].CndnContrSourceDocCatName AS CndnContrSourceDocCatName,
  Contract.CndnContrSourceDoc AS CndnContrSourceDoc,
  Contract.CndnContrUnit AS CndnContrUnit,
  Contract.CndnContrWeightUnit AS CndnContrWeightUnit,
  Contract.CndnContrVolumeUnit AS CndnContrVolumeUnit,
  Contract.CndnContrPointsQtyUnit AS CndnContrPointsQtyUnit,
  Contract.AccrualUpdateIsRequired AS AccrualUpdateIsRequired,
  Contract.CndnContrUUID AS CndnContrUUID,
  Contract.CndnContrSourceUUID AS CndnContrSourceUUID,
  Contract.CndnContrProcessCategory AS CndnContrProcessCategory,
  Contract._CndnContrProcessCategory._Text[1: Language = $session.system_language ].CndnContrProcessCategoryDesc AS CndnContrProcessCategoryDesc,
  cast( 1 as wcb_cc_chart_counter ) AS CndnContrChartCounter,
  Contract.Customer AS Customer,
  Contract.PersonWorkAgreement AS PersonWorkAgreement,
  Contract.CndnContrWorkerCostCenter AS CndnContrWorkerCostCenter
FROM R_ConditionContract AS Contract
LEFT OUTER JOIN C_CndnContrMainSystStatus AS _MainSystemStatus ON CndnContrUUID = _MainSystemStatus.CndnContrUUID  -- association [0..1]
LEFT OUTER JOIN I_CndnContrActSystemStatus AS _SettlmtLockStatus ON CndnContrUUID = _SettlmtLockStatus.StatusObjectUUID AND _SettlmtLockStatus.SystemStatus = 'ICC08'  -- association [0..1]
LEFT OUTER JOIN I_CnConSettlementLockStatusT AS _CnConSettlementLockStatusName ON _CnConSettlementLockStatusName.Language = $session.system_language  -- association [0..*]
;