C_CABusTransDoubtfulEntries

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_CABusTransDoubtfulEntries.
-- 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: CCBUSTRANDBTENTR

CREATE VIEW C_CABusTransDoubtfulEntries AS
SELECT
  CABusinessTransactionUUID,
  CABusinessTransactionObject,
  _BusTransObject._CABusTransObjText[1: Language=$session.system_language].CABusTransObjectName AS CABusTransObjectName,
  _BusTransActivity._CABusTransActivityText[1: Language=$session.system_language].CABusTransActivityName AS CABusTransActivityName,
  CABusinessTransactionActivity,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  ContractAccount,
  _CAPartner.ContractAccountName AS ContractAccountName,
  concat_with_space(_BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.StreetName, _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber, 1) as HouseNumber AS HouseNumber1asHouseNumber,
  concat_with_space(_BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode, _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.CityName, 1) as HomeTown AS CityName1asHomeTown,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation._Country._Text[1: Language=$session.system_language].CountryName AS CountryName,
  CreationDate,
  CreatedByUser,
  _CreatedByContact.FullName AS CreatedByUserName,
  CAAmountInTransactionCurrency,
  Currency,
  CABusTransDocument,
  CAReceivableAdjustmentReason,
  CABusinessTransactionProcess,
  _CAReceivableAdjustmentReason._Text[1: Language=$session.system_language].CAReceivableAdjustReasonName AS CAReceivableAdjustReasonName,
  CABusinessTransactionName
FROM P_CABusinessTransaction
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..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 C_CAInvcgUserContact AS _CreatedByContact ON CreatedByUser = _CreatedByContact.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_CAReceivableAdjustmentReason AS _CAReceivableAdjustmentReason ON CAReceivableAdjustmentReason = _CAReceivableAdjustmentReason.CAReceivableAdjustmentReason  -- association [0..1]
;