C_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 C_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.
-- SQL view name: CCABUSTRANS

CREATE VIEW C_CABusinessTransaction AS
SELECT
  CABusinessTransactionUUID,
  CreationDate,
  CreationTime,
  dats_tims_to_tstmp( CreationDate, CreationTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') as CABusTransCreationDateTime AS clientNULLasCABusTransCreationDateTime,
  CreatedByUser,
  _User.UserDescription AS UserDescription,
  CASubAreaForParallelization,
  CABusinessTransactionObject,
  _BusTransObject._CABusTransObjText[1: Language=$session.system_language].CABusTransObjectName AS CABusTransObjectName,
  CABusinessTransactionActivity,
  _BusTransActivity._CABusTransActivityText[1: Language=$session.system_language].CABusTransActivityName AS CABusTransActivityName,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _ContractAccountPartner.ContractAccountName AS ContractAccountName,
  ContractAccount,
  CAContract,
  CASubApplication,
  cast(lpad(OriginalReferenceDocument, 20, '0') as fac_awkey_bt preserving type ) AS OriginalReferenceDocument,
  OriginalReferenceDocument AS TechOriginalReferenceDocument,
  ReferenceDocumentType,
  ReferenceDocumentLogicalSystem,
  LogicalSystem,
  CABusTransExternalReference,
  CABusinessTransactionProcess,
  CABusTransProcessName,
  CABusTransDocumentType,
  CABusTransDocument,
  CAReferenceDocument,
  CAClassificationKey,
  CADocumentOriginCode,
  CAPostingDate,
  CAClearingReason,
  CAMainTransaction,
  CASubTransaction,
  CompanyCode,
  _CompCode.CompanyCodeName AS CompanyCodeName,
  Segment,
  BusinessArea,
  LedgerGroup,
  CABusTransRelationship,
  CABusTransRelatedObject,
  CACorrespondenceType,
  CorrespondenceKey,
  CorrespondencePrintDate,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  CAMassRunDate,
  CAMassRunID,
  Currency,
  CAAmountInTransactionCurrency,
  CAPaymentExceptionReason,
  CADunningExceptionReason,
  CAReceivableAdjustmentReason,
  CAPromiseToPayReason,
  CAPromiseToPayWthdrwlReason,
  CAInstlmntPlanDactvtnRsn,
  CADocumentNumber,
  CABusinessTransactionName,
  cast('' as awkey_semobj_kk) AS OriginalRefDocSemanticObject,
  cast('' as vtref_semobj_kk) AS CAContractSemanticObject,
  _CorrespncType._Text[1: Language=$session.system_language].CACorrespondenceTypeName AS CACorrespondenceTypeName,
  _CAClearingReason ._Text[1: Language=$session.system_language].CAClearingReasonName AS CAClearingReasonName,
  _DocOriginCode._Text[1: Language=$session.system_language].CADocumentOriginCodeName AS CADocumentOriginCodeName,
  _CAMainTransaction._Text[1: Language=$session.system_language].CAMainTransactionName AS CAMainTransactionName,
  _SubTransaction._Text[1: Language=$session.system_language].CASubTransactionName AS CASubTransactionName,
  _PaytExcptnRsn._Text[1: Language=$session.system_language].CAPaymentExceptionReasonName AS CAPaymentExceptionReasonName,
  _CADunningExceptionReason._Text[1: Language=$session.system_language].CADunningExceptionReasonName AS CADunningExceptionReasonName,
  _CAReceivableAdjustmentReason._Text[1: Language=$session.system_language].CAReceivableAdjustReasonName AS CAReceivableAdjustReasonName,
  _CAPromiseToPayReason._Text[1: Language=$session.system_language].CAPromiseToPayReasonName AS CAPromiseToPayReasonName,
  _CAPromiseToPayWthdrwlReason._Text[1: Language=$session.system_language].CAPrmsToPayWthdrwlReasonName AS CAPrmsToPayWthdrwlReasonName,
  _CAInstlmntPlanDactvtnRsn._Text[1: Language=$session.system_language].CAInstlmntPlanDactvtnRsnName AS CAInstlmntPlanDactvtnRsnName
FROM P_CABusinessTransaction
LEFT OUTER JOIN C_CABusTransReversal AS _BusTransReversal ON CABusinessTransactionUUID = _BusTransReversal.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_CABusTransInstallmentPlan AS _BusTransInstallmentPlan ON CABusinessTransactionUUID = _BusTransInstallmentPlan.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_CABusTransReturns AS _BusTransReturns ON CABusinessTransactionUUID = _BusTransReturns.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_CABusTransIncomingPayment AS _BusTransIncomingPayment ON CABusinessTransactionUUID = _BusTransIncomingPayment.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_CABusTransOtherPostings AS _BusTransOtherPost ON CABusinessTransactionUUID = _BusTransOtherPost.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_CABusTransDoubtfulEntries AS _BusTransDoubtEntr ON CABusinessTransactionUUID = _BusTransDoubtEntr.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_CABusTransCorrespondence AS _BusTransCorrespondence ON CABusinessTransactionUUID = _BusTransCorrespondence.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_CABusTransPaytException AS _BusTransPaytException ON CABusinessTransactionUUID = _BusTransPaytException.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_CABusTransInvoicing AS _BusTransInvoicing ON CABusinessTransactionUUID = _BusTransInvoicing.CABusinessTransactionUUID  -- association [1..1]
LEFT OUTER JOIN C_CABusTransPromiseToPay AS _BusTransPromiseToPay ON CABusinessTransactionUUID = _BusTransPromiseToPay.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_CABusTransDunningException AS _BusTransDunningException ON CABusinessTransactionUUID = _BusTransDunningException.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_CABusTransContrAcctChange AS _BusTransContrAcctChange ON CABusinessTransactionUUID = _BusTransContrAcctChange.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_CABusTransDocumentChange AS _BusTransDocumentChange ON CABusinessTransactionUUID = _BusTransDocumentChange.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_CABusTransBusPartnerChange AS _BusTransBusPartnerChange ON CABusinessTransactionUUID = _BusTransBusPartnerChange.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN C_CABusTransClarificationCase AS _BusTransClarificationCase ON CABusinessTransactionUUID = _BusTransClarificationCase.CABusinessTransactionUUID  -- association [0..1]
LEFT OUTER JOIN I_CABusTransActivity AS _BusTransActivity ON CABusinessTransactionActivity = _BusTransActivity.CABusinessTransactionActivity  -- association [0..1]
LEFT OUTER JOIN I_CABusTransObject AS _BusTransObject ON CABusinessTransactionObject = _BusTransObject.CABusinessTransactionObject  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON CreatedByUser = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CADocumentOriginCode AS _DocOriginCode ON CADocumentOriginCode = _DocOriginCode.CADocumentOriginCode  -- association [1..1]
LEFT OUTER JOIN I_CAMainTransaction AS _CAMainTransaction ON CAMainTransaction = _CAMainTransaction.CAMainTransaction  -- association [1..1]
LEFT OUTER JOIN I_CASubTransaction AS _SubTransaction ON CAMainTransaction = _SubTransaction.CAMainTransaction AND CASubTransaction = _SubTransaction.CASubTransaction  -- association [1..1]
LEFT OUTER JOIN I_CAClearingReason AS _CAClearingReason ON CAClearingReason = _CAClearingReason.CAClearingReason  -- association [1..1]
LEFT OUTER JOIN I_CACorrespondenceType AS _CorrespncType ON CACorrespondenceType = _CorrespncType.CACorrespondenceType  -- association [1..1]
LEFT OUTER JOIN I_CAPaymentExceptionReason AS _PaytExcptnRsn ON CAPaymentExceptionReason = _PaytExcptnRsn.CAPaymentExceptionReason  -- association [0..1]
LEFT OUTER JOIN I_CADunningExceptionReason AS _CADunningExceptionReason ON CADunningExceptionReason = _CADunningExceptionReason.CADunningExceptionReason  -- association [1..1]
LEFT OUTER JOIN I_CAReceivableAdjustmentReason AS _CAReceivableAdjustmentReason ON CAReceivableAdjustmentReason = _CAReceivableAdjustmentReason.CAReceivableAdjustmentReason  -- 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_CAInstlmntPlanDactvtnRsn AS _CAInstlmntPlanDactvtnRsn ON CAInstlmntPlanDactvtnRsn = _CAInstlmntPlanDactvtnRsn.CAInstlmntPlanDactvtnRsn  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..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 [0..1]
LEFT OUTER JOIN I_CAProviderContractHeader AS _ProviderContract ON CASubApplication = 'P' AND CAContract = _ProviderContract.CAProviderContract  -- association [0..1]
;