C_ConditionContract_F5413

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_F5413.
-- 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_F5413 AS
SELECT
  ConditionContract,
  CndnContrType,
  cast ( CndnContrSettlmtType as wb2_rebate_type_fio preserving type ) AS CndnContrSettlmtType,
  CndnContrPartnerCat,
  CndnContrProcessCategory,
  CndnContrProcVar,
  Customer,
  Supplier,
  CndnContrActvtnStatus,
  CndnContrValidFrom,
  CndnContrValidTo,
  CndnContrClassfctnType,
  DocumentReferenceID,
  CndnContrAssgmtRef,
  ExternalDocumentReferenceID,
  CndnContrExternalPartner,
  CndnContrSourceDocCat,
  CndnContrSourceDoc,
  CndnContrSourceDocItem,
  CndnContrSourceUUID,
  CreatedByUser,
  cast( _CreatedByUser.UserDescription as wlf_created_by_fullname preserving type ) AS CreatedByUserFullName,
  CreationDate,
  CreationTime,
  CreationTimeZone,
  cast( CreationUTCDateTime as wcb_created_on_tstmp preserving type ) AS CreationUTCDateTime,
  LastChangedByUser,
  LastChangedDate,
  LastChangeTime,
  cast( LastChangeUTCDateTime as wcb_changed_on_tstmp preserving type ) AS LastChangeUTCDateTime,
  CompanyCode,
  cast( PurchasingOrganization as wlf_ekorg preserving type ) AS PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  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,
  CndnContrSuplrSettlmtCat,
  CndnContrCustSettlmtCat,
  SettlmtProduct,
  _SettlmtProduct._Text.ProductName as ProductName : localized AS ProductNameasProductNamelocalized,
  CndnContrExtensionCalendar,
  PriorSupplier,
  BusVolTableGroup,
  AmountFieldGroup,
  FinalSettlmtCalendar,
  PartialSettlmtCalendar,
  DeltaSettlmtCalendar,
  DeltaAccrualSettlmtCalendar,
  AccrualClearingSettlmtCalendar,
  PrecedingConditionDocument,
  CndnContrUUID,
  CndnContrPurposeCat,
  CndnContrCurrency,
  _CndnContrCurrency._Text.CurrencyName as CurrencyName : localized AS CurrencyNameasCurrencyNamelocalized,
  CndnContrUnit,
  CndnContrWeightUnit,
  CndnContrVolumeUnit,
  CndnContrPointsQtyUnit,
  ExchangeRate,
  ExchangeRateDate,
  ExchangeRateType,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  NetPaymentDays,
  PaymentMethod,
  AccrualUpdateIsRequired,
  SettlmtPartTxRegnNmbr,
  TaxCountry,
  SettlmtPartTxRegnCntry,
  PersonWorkAgreement,
  CndnContrWorkerCostCenter,
  virtual UICT_CurSettlmtNetAmtInDC : boolean AS virtualUICT_CurSettlmtNetAmtInDCboolean,
  virtual DisplayCurrency : displaycurrency AS virtualDisplayCurrencydisplaycurrency,
  virtual UICT_HDR_Partner_Info : boolean AS virtualUICT_HDR_Partner_Infoboolean,
  virtual UICT_HDR_Actvtn_Status : boolean AS virtualUICT_HDR_Actvtn_Statusboolean,
  virtual UICT_HDR_Lock_Status : boolean AS virtualUICT_HDR_Lock_Statusboolean,
  virtual UICT_HDR_Main_Status : boolean AS virtualUICT_HDR_Main_Statusboolean,
  virtual UICT_COLL_Gen_Info : boolean AS virtualUICT_COLL_Gen_Infoboolean,
  virtual UICT_COLL_CONTR_GEN_DATA : boolean AS virtualUICT_COLL_CONTR_GEN_DATAboolean,
  virtual UICT_COLL_CONTR_REFERENCES : boolean AS virtualUICT_COLL_CONTR_REFERENCESboolean,
  virtual UICT_COLL_CONTR_ADMIN_DATA : boolean AS virtualUICT_COLL_CONTR_ADMIN_DATAboolean,
  virtual UICT_COLL_PAYMENT_TRMS : boolean AS virtualUICT_COLL_PAYMENT_TRMSboolean,
  virtual UICT_COLL_Settlmt_Data : boolean AS virtualUICT_COLL_Settlmt_Databoolean,
  virtual UICT_COLL_Bsc_Contr_Data : boolean AS virtualUICT_COLL_Bsc_Contr_Databoolean,
  virtual UICT_COLL_Crcy_Pay_Trms : boolean AS virtualUICT_COLL_Crcy_Pay_Trmsboolean,
  virtual UICT_COLL_Org_data : boolean AS virtualUICT_COLL_Org_databoolean,
  virtual UICT_FLDGRP_Contr_Dets : boolean AS virtualUICT_FLDGRP_Contr_Detsboolean,
  virtual UICT_FLDGRP_Contr_Valdty : boolean AS virtualUICT_FLDGRP_Contr_Valdtyboolean,
  virtual UICT_FLDGRP_ORG_DATA_SLS : boolean AS virtualUICT_FLDGRP_ORG_DATA_SLSboolean,
  virtual UICT_FLDGRP_ORG_DATA_PURG : boolean AS virtualUICT_FLDGRP_ORG_DATA_PURGboolean,
  virtual UICT_FLDGRP_ADMIN_DATA : boolean AS virtualUICT_FLDGRP_ADMIN_DATAboolean,
  virtual UICT_FLDGRP_PAY_TERMS : boolean AS virtualUICT_FLDGRP_PAY_TERMSboolean,
  virtual UICT_FLDGRP_PAY_TERMS_DAYS : boolean AS virtualUICT_FLDGRP_PAY_TERMS_DAYSboolean,
  virtual UICT_FLDGRP_CONTR_TAX : boolean AS virtualUICT_FLDGRP_CONTR_TAXboolean,
  virtual UICT_FLDGRP_CONTR_CURRENCY : boolean AS virtualUICT_FLDGRP_CONTR_CURRENCYboolean,
  virtual UICT_FLDGRP_Crcy_Pay_Terms : boolean AS virtualUICT_FLDGRP_Crcy_Pay_Termsboolean,
  virtual UICT_FLDGRP_Org_Data : boolean AS virtualUICT_FLDGRP_Org_Databoolean,
  virtual UICT_FLDGRP_Org_Data2 : boolean AS virtualUICT_FLDGRP_Org_Data2boolean,
  virtual UICT_FLDGRP_Settlmt_Data : boolean AS virtualUICT_FLDGRP_Settlmt_Databoolean,
  virtual UICT_CndnContrProcVar : boolean AS virtualUICT_CndnContrProcVarboolean,
  virtual UICT_BusVolTableGroup : boolean AS virtualUICT_BusVolTableGroupboolean,
  virtual UICT_AmountFieldGroup : boolean AS virtualUICT_AmountFieldGroupboolean,
  virtual UICT_CndnContrUnit : boolean AS virtualUICT_CndnContrUnitboolean,
  virtual UICT_CndnContrWeightUnit : boolean AS virtualUICT_CndnContrWeightUnitboolean,
  virtual UICT_CndnContrVolumeUnit : boolean AS virtualUICT_CndnContrVolumeUnitboolean,
  virtual UICT_TaxCountry : boolean AS virtualUICT_TaxCountryboolean,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Customer.CustomerName AS CustomerName,
  _LastChangedByUser.UserDescription AS LastChangedByUserFullName,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _Supplier.SupplierName AS SupplierName
FROM R_ConditionContractTP
;