C_ConditionContract_F6740

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_F6740.
-- 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_F6740 AS
SELECT
  ConditionContract,
  CndnContrType,
  CndnContrProcVar,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  _Supplier.OrganizationBPName1 AS SupplierName_H,
  Customer,
  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,
  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,
  DistributionChannel,
  Division,
  _Division._Text.DivisionName as DivisionName : localized AS DivisionNameasDivisionNamelocalized,
  SalesGroup,
  _SalesGroup._Text.SalesGroupName as SalesGroupName : localized AS SalesGroupNameasSalesGroupNamelocalized,
  SalesOffice,
  CndnContrSuplrSettlmtCat,
  SettlmtProduct,
  _SettlmtProduct._Text.ProductName as ProductName : localized AS ProductNameasProductNamelocalized,
  CndnContrExtensionCalendar,
  PriorSupplier,
  BusVolTableGroup,
  AmountFieldGroup,
  FinalSettlmtCalendar,
  PartialSettlmtCalendar,
  DeltaSettlmtCalendar,
  DeltaAccrualSettlmtCalendar,
  AccrualClearingSettlmtCalendar,
  virtual PrecedingConditionContract : char10 AS virtualPrecedingConditionContractchar10,
  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,
  CndnContrPartnerCat,
  CndnContrProcessCategory,
  PersonWorkAgreement,
  CndnContrWorkerCostCenter,
  virtual DisplayCurrency : displaycurrency AS virtualDisplayCurrencydisplaycurrency,
  virtual UICT_CurSettlmtNetAmtInDC : boolean AS virtualUICT_CurSettlmtNetAmtInDCboolean,
  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_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_CndnContrProcVar : boolean AS virtualUICT_CndnContrProcVarboolean,
  virtual UICT_TaxCountry : boolean AS virtualUICT_TaxCountryboolean,
  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
FROM R_ConditionContractTP
;