C_ConditionContract_F6883

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_F6883.
-- 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_F6883 AS
SELECT
  ConditionContract,
  CndnContrType,
  _CndnContrType._Text[1: Language = $session.system_language ].CndnContrTypeDesc AS CndnContrTypeDesc,
  CndnContrProcVar,
  _CndnContrProcVar._Text[1: Language = $session.system_language ].CndnContrProcVarDesc AS CndnContrProcVarDesc,
  Customer,
  _Customer.CustomerName AS CustomerName,
  _Customer.OrganizationBPName1 AS CustomerName_H,
  Supplier,
  _CndnContrActvtnStatus.CndnContrActvtnStatus AS CndnContrActvtnStatus,
  _CndnContrActvtnStatus._Text[1: Language = $session.system_language ].CndnContrActvtnStatusName AS CndnContrActvtnStatusName,
  CndnContrValidFrom,
  CndnContrValidTo,
  CndnContrClassfctnType,
  _CndnContrClassfctnType._Text[1: Language = $session.system_language ].CndnContrClassfctnTypeDesc AS CndnContrClassfctnTypeDesc,
  DocumentReferenceID,
  CndnContrAssgmtRef,
  ExternalDocumentReferenceID,
  CndnContrExternalPartner,
  CndnContrSourceDocCat,
  _CndnContrSourceDocCat._Text[1: Language = $session.system_language ].CndnContrSourceDocCatName AS CndnContrSourceDocCatName,
  CndnContrSourceDoc,
  CndnContrSourceDocItem,
  CndnContrSourceUUID,
  CreatedByUser,
  cast( _CreatedByUser.UserDescription as wlf_created_by_fullname preserving type ) AS CreatedByUserFullName,
  cast( CreationUTCDateTime as wcb_created_on_tstmp preserving type ) AS CndnContrCreationDateTime,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS LastChangedByUserFullName,
  cast( LastChangeUTCDateTime as wcb_changed_on_tstmp preserving type ) AS CndnContrLastChangedDateTime,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast( PurchasingOrganization as wlf_ekorg preserving type ) AS PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  SalesOrganization,
  _SalesOrganization._Text[1: Language = $session.system_language ].SalesOrganizationName AS SalesOrganizationName,
  DistributionChannel,
  _DistributionChannel._Text[1: Language = $session.system_language ].DistributionChannelName AS DistributionChannelName,
  Division,
  _Division._Text[1: Language = $session.system_language ].DivisionName AS DivisionName,
  SalesGroup,
  _SalesGroup._Text[1: Language = $session.system_language ].SalesGroupName AS SalesGroupName,
  SalesOffice,
  _SalesOffice._Text[1: Language = $session.system_language ].SalesOfficeName AS SalesOfficeName,
  CndnContrCustSettlmtCat,
  _CndnContrCustSettlmtCat._Text[1: Language = $session.system_language ].CndnContrCustSettlmtCatName AS CndnContrCustSettlmtCatName,
  SettlmtProduct,
  _SettlmtProduct._Text[1: Language = $session.system_language ].ProductName AS ProductName,
  CndnContrExtensionCalendar,
  _CndnContrExtensionCalendar._Text[1: Language = $session.system_language ].FactoryCalendarName AS FactoryCalendarName,
  PriorSupplier,
  BusVolTableGroup,
  _BusVolTableGroup._Text[1: Language = $session.system_language ].BusVolTableGroupDesc AS BusVolTableGroupDesc,
  AmountFieldGroup,
  _AmountFieldGroup._Text[1: Language = $session.system_language ].AmountFieldGroupDesc AS AmountFieldGroupDesc,
  FinalSettlmtCalendar,
  PartialSettlmtCalendar,
  DeltaSettlmtCalendar,
  DeltaAccrualSettlmtCalendar,
  AccrualClearingSettlmtCalendar,
  PrecedingConditionDocument,
  CndnContrUUID,
  CndnContrPurposeCat,
  Contract.CndnContrCurrency AS CndnContrCurrency,
  _CndnContrCurrency._Text[1: Language = $session.system_language ].CurrencyName AS CurrencyName,
  CndnContrUnit,
  CndnContrWeightUnit,
  CndnContrVolumeUnit,
  CndnContrPointsQtyUnit,
  ExchangeRate,
  ExchangeRateDate,
  ExchangeRateType,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  NetPaymentDays,
  PaymentMethod,
  AccrualUpdateIsRequired,
  SettlmtPartTxRegnNmbr,
  TaxCountry,
  cast(_TaxCountry._Text[1: Language = $session.system_language ].CountryName as fot_tax_country_descr preserving type ) AS TaxCountryName,
  SettlmtPartTxRegnCntry,
  cast(_SettlmtPartTxRegnCntry._Text[1: Language = $session.system_language ].CountryName as wcb_tax_country_text preserving type ) AS SettlmtPartTxRegnCntryName,
  CndnContrPartnerCat,
  CndnContrSettlmtType,
  CndnContrProcessCategory,
  _CndnContrProcessCategory._Text[1: Language = $session.system_language ].CndnContrProcessCategoryDesc AS CndnContrProcessCategoryDesc,
  cast( 1 as wcb_cc_chart_counter ) AS CndnContrTypeEnumtnVal,
  cast( _MainSystemStatus.CndnContrMainSystemStatus as wcb_main_system_status preserving type ) AS CndnContrMainSystemStatus,
  _MainSystemStatus._SystemStatus._SystemStatusText[1: Language = $session.system_language ].SystemStatusName AS CndnContrMainSystemStatusText,
  PersonWorkAgreement,
  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..*]
LEFT OUTER JOIN E_ConditionContract AS _Extension ON ConditionContract = _Extension.ConditionContract  -- association [1..1]
;