C_CABusTransBusPartnerChange

DDL: C_CABUSTRANSBUSPARTNERCHANGE SQL: CCABUSTRANSBPCH Type: view CONSUMPTION Package: ODATA_O2C_FICA_BUSTRANS_DISP
19 Fields 1 Data Sources 5 Associations 3 OData Services

Geschäftsvorfälle Stammdaten Geschäftspartner

C_CABusTransBusPartnerChange is a Consumption CDS View that provides data about "Geschäftsvorfälle Stammdaten Geschäftspartner" in SAP S/4HANA. It reads from 1 data source (P_CABusinessTransaction) and exposes 19 fields with key field CABusinessTransactionUUID. It has 5 associations to related views. It is exposed through 3 OData services (ASQL_F4294, ASQL_F8301, UI_CAACCOUNTBALANCE_DISPLAY). Part of development package ODATA_O2C_FICA_BUSTRANS_DISP.

Data Sources (1)

SourceAliasJoin Type
P_CABusinessTransaction P_CABusinessTransaction from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_CABusTransActivity _BusTransActivity $projection.CABusinessTransactionActivity = _BusTransActivity.CABusinessTransactionActivity
[0..1] I_CABusTransObject _BusTransObject $projection.CABusinessTransactionObject = _BusTransObject.CABusinessTransactionObject
[1..1] I_ContractAccountPartner _CAPartner $projection.BusinessPartner = _CAPartner.BusinessPartner and $projection.ContractAccount = _CAPartner.ContractAccount
[0..1] I_User _User $projection.CreatedByUser = _User.UserID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CCABUSTRANSBPCH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Geschäftsvorfall view
UI.headerInfo.typeNamePlural Geschäftsvorfalle view
UI.headerInfo.title.value CABusTransObjectName view
UI.headerInfo.description.value CABusTransActivityName view
EndUserText.label Geschäftsvorfälle Stammdaten Geschäftspartner view

OData Services (3)

ServiceBindingVersionContractRelease
ASQL_F4294 ASQL_F4294 C2 NOT_RELEASED
ASQL_F8301 ASQL_F8301 C2 NOT_RELEASED
UI_CAACCOUNTBALANCE_DISPLAY UI_CAACCOUNTBALANCE_DISPLAY V4 C1 NOT_RELEASED

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CABusinessTransactionUUID CABusinessTransactionUUID
CABusinessTransactionObject CABusinessTransactionObject
CABusTransObjectName
CABusTransActivityName
CABusinessTransactionActivity CABusinessTransactionActivity
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerFullName _BusinessPartner BusinessPartnerFullName Broker Name
ContractAccount ContractAccount Contract Acct
ContractAccountName _CAPartner ContractAccountName Cont. acct name
HouseNumber1asHouseNumber Straße / Nummer
CityName1asHomeTown Postleitzahl / Ort
CountryName
CreationDate CreationDate Time Stamp
CABusinessTransactionName CABusinessTransactionName
CABusinessTransactionProcess CABusinessTransactionProcess
CABusTransDocument CABusTransDocument
CreatedByUser CreatedByUser User Name
CAReferenceDocument CAReferenceDocument Reference
_BusinessPartner _BusinessPartner

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_CABusTransBusPartnerChange.
-- 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: CCABUSTRANSBPCH

CREATE VIEW C_CABusTransBusPartnerChange 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,
  CABusinessTransactionName,
  CABusinessTransactionProcess,
  CABusTransDocument,
  CreatedByUser,
  CAReferenceDocument
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_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_User AS _User ON CreatedByUser = _User.UserID  -- association [0..1]
;

Learn More