I_CABusinessTransaction

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 I_CABusinessTransaction.
-- 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 I_CABusinessTransaction AS
SELECT
  guid AS CABusinessTransactionUUID,
  cast(erdat as erdat_bt preserving type) AS CreationDate,
  cast(ertim as ttet_dt_cr_time preserving type) AS CreationTime,
  cast(ernam as vdm_createdbyuserid preserving type) AS CreatedByUser,
  keypp AS CASubAreaForParallelization,
  cast (objid as objid_bt preserving type) AS CABusinessTransactionObject,
  cast (actid as actid_bt preserving type) AS CABusinessTransactionActivity,
  cast('' as event_bt_txt) AS CABusinessTransactionName,
  cast(gpart as bu_partner preserving type) AS BusinessPartner,
  cast( vkont as vkont_gfn_kk preserving type) AS ContractAccount,
  cast(vtref as vtref_kk preserving type) AS CAContract,
  subap AS CASubApplication,
  cast(awkey as fac_awkey_bt preserving type) AS OriginalReferenceDocument,
  cast(awtyp as fis_awtyp preserving type) AS ReferenceDocumentType,
  cast(awsys as fis_awsys preserving type) AS ReferenceDocumentLogicalSystem,
  cast(logsys as logsystem preserving type) AS LogicalSystem,
  xtref AS CABusTransExternalReference,
  proid AS CABusinessTransactionProcess,
  text AS CABusTransProcessName,
  doc1t AS CABusTransDocumentType,
  cast(doc1r as doclr_bt preserving type) AS CABusTransDocument,
  xblnr AS CAReferenceDocument,
  opord AS CAClassificationKey,
  herkf AS CADocumentOriginCode,
  budat AS CAPostingDate,
  augrd AS CAClearingReason,
  hvorg AS CAMainTransaction,
  tvorg AS CASubTransaction,
  cast( bukrs as fis_bukrs preserving type) AS CompanyCode,
  cast( segment as fb_segment preserving type) AS Segment,
  cast( gsber as fis_rbusa preserving type) AS BusinessArea,
  cast( ldgrp as fagl_ldgrp preserving type) AS LedgerGroup,
  objrl AS CABusTransRelationship,
  objky AS CABusTransRelatedObject,
  cotyp AS CACorrespondenceType,
  cast(cokey as cokey_bt_kk preserving type) AS CorrespondenceKey,
  copri AS CorrespondencePrintDate,
  cast(waers as waers preserving type) AS Currency,
  cast(betrw as betrw_kk preserving type) AS CAAmountInTransactionCurrency,
  poken_pay AS CAPaymentExceptionReason,
  poken_dun AS CADunningExceptionReason,
  cast(grund as grund_bt_kk preserving type) AS CAReceivableAdjustmentReason,
  pprsc AS CAPromiseToPayReason,
  cast(pprsw as pprsw_bt_kk preserving type) AS CAPromiseToPayWthdrwlReason,
  deagd AS CAInstlmntPlanDactvtnRsn
FROM dfkkevl
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CABusTransActivity AS _CABusTransActivity ON CABusinessTransactionActivity = _CABusTransActivity.CABusinessTransactionActivity  -- association [0..1]
LEFT OUTER JOIN I_CABusTransDocumentType AS _CABusTransDocumentType ON CABusTransDocumentType = _CABusTransDocumentType.CABusTransDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CABusTransObject AS _CABusTransObject ON CABusinessTransactionObject = _CABusTransObject.CABusinessTransactionObject  -- association [0..1]
LEFT OUTER JOIN I_CABusTransProcess AS _CABusTransProcess ON CABusinessTransactionProcess = _CABusTransProcess.CABusinessTransactionProcess  -- association [0..1]
LEFT OUTER JOIN I_CABusTransRelationship AS _CABusTransRelationship ON CABusTransRelationship = _CABusTransRelationship.CABusTransRelationship  -- association [0..1]
LEFT OUTER JOIN I_CAClearingReason AS _CAClearingReason ON CAClearingReason = _CAClearingReason.CAClearingReason  -- association [0..1]
LEFT OUTER JOIN I_CACorrespondenceType AS _CACorrespondenceType ON CACorrespondenceType = _CACorrespondenceType.CACorrespondenceType  -- association [0..1]
LEFT OUTER JOIN I_CADocumentOriginCode AS _CADocumentOriginCode ON CADocumentOriginCode = _CADocumentOriginCode.CADocumentOriginCode  -- association [0..1]
LEFT OUTER JOIN I_CADunningExceptionReason AS _CADunningExceptionReason ON CADunningExceptionReason = _CADunningExceptionReason.CADunningExceptionReason  -- association [0..1]
LEFT OUTER JOIN I_CAInstlmntPlanDactvtnRsn AS _CAInstlmntPlanDactvtnRsn ON CAInstlmntPlanDactvtnRsn = _CAInstlmntPlanDactvtnRsn.CAInstlmntPlanDactvtnRsn  -- association [0..1]
LEFT OUTER JOIN I_CAPaymentExceptionReason AS _CAPaymentExceptionReason ON CAPaymentExceptionReason = _CAPaymentExceptionReason.CAPaymentExceptionReason  -- association [0..1]
LEFT OUTER JOIN I_CAPromiseToPayReason AS _CAPromiseToPayReason ON CAPromiseToPayReason = _CAPromiseToPayReason.CAPromiseToPayReason  -- association [0..1]
LEFT OUTER JOIN I_CAPromiseToPayWthdrwlReason AS _CAPromiseToPayWthdrwlReason ON CAPromiseToPayWthdrwlReason = _CAPromiseToPayWthdrwlReason.CAPromiseToPayWthdrwlReason  -- association [0..1]
LEFT OUTER JOIN I_CAReceivableAdjustmentReason AS _CAReceivableAdjustmentReason ON CAReceivableAdjustmentReason = _CAReceivableAdjustmentReason.CAReceivableAdjustmentReason  -- association [0..1]
LEFT OUTER JOIN I_CAStatisticalItemCode AS _CAStatisticalItemCode ON CAStatisticalItemCode = _CAStatisticalItemCode.CAStatisticalItemCode  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccount ON ContractAccount = _ContractAccount.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CAProviderContractHeader AS _ProviderContract ON CASubApplication = 'P' AND CAContract = _ProviderContract.CAProviderContract  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
;