C_CABusTransInvoicing

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_CABusTransInvoicing.
-- 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: CCABUSTRANINVOIC

CREATE VIEW C_CABusTransInvoicing 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,
  CABusTransDocument,
  CAReferenceDocument,
  _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,
  CABusinessTransactionName,
  CAAmountInTransactionCurrency,
  Currency,
  CABusinessTransactionProcess,
  CreatedByUser,
  _CreatedByContact.FullName AS CreatedByUserName,
  CAMainTransaction,
  CASubTransaction,
  CompanyCode,
  BusinessArea,
  Segment,
  CASubApplication,
  CAContract,
  _CompCode.CompanyCodeName AS CompanyCodeName,
  CAPostingDate,
  CAClearingReason,
  _CAClearingReason ._Text[1: Language=$session.system_language].CAClearingReasonName AS CAClearingReasonName,
  _CAMainTransaction._Text[1: Language=$session.system_language].CAMainTransactionName AS CAMainTransactionName,
  _CASubTransaction._Text[1: Language=$session.system_language].CASubTransactionName AS CASubTransactionName,
  CADocumentOriginCode,
  _DocOriginCode._Text[1: Language=$session.system_language].CADocumentOriginCodeName AS CADocumentOriginCodeName
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 I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CAMainTransaction AS _CAMainTransaction ON CAMainTransaction = _CAMainTransaction.CAMainTransaction  -- association [1..1]
LEFT OUTER JOIN I_CASubTransaction AS _CASubTransaction ON CAMainTransaction = _CASubTransaction.CAMainTransaction AND CASubTransaction = _CASubTransaction.CASubTransaction  -- association [1..1]
LEFT OUTER JOIN C_CAInvcgUserContact AS _CreatedByContact ON CreatedByUser = _CreatedByContact.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_ContrAcctPrtnWthoutExtnblty AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_CAClearingReason AS _CAClearingReason ON CAClearingReason = _CAClearingReason.CAClearingReason  -- association [1..1]
LEFT OUTER JOIN I_CADocumentOriginCode AS _DocOriginCode ON CADocumentOriginCode = _DocOriginCode.CADocumentOriginCode  -- association [1..1]
LEFT OUTER JOIN I_CAProviderContractHeader AS _ProviderContract ON CASubApplication = 'P' AND CAContract = _ProviderContract.CAProviderContract  -- association [0..1]
;