C_CACreditItemAnalysis

DDL: C_CACREDITITEMANALYSIS SQL: CCACREDITITMANL Type: view CONSUMPTION
28 Fields 1 Data Sources 4 Associations

Analyse von Guthabenposten

C_CACreditItemAnalysis is a Consumption CDS View that provides data about "Analyse von Guthabenposten" in SAP S/4HANA. It reads from 1 data source (I_CADocumentBPItemLogical) and exposes 28 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CADocumentBPItemLogical BPItem from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_ContractAccountHeader ContrAccHdr $projection.ContractAccount = ContrAccHdr.ContractAccount
[0..1] I_ContractAccountPartner _ContractAccount $projection.BusinessPartner = _ContractAccount.BusinessPartner and $projection.ContractAccount = _ContractAccount.ContractAccount
[1] I_CAContractPartner _CAPartner $projection.BusinessPartner = _CAPartner.BusinessPartner
[0..1] I_CASubApplication _SubApp $projection.CASubApplication = _SubApp.CASubApplication

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCACREDITITMANL view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Analyse von Guthabenposten view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber I_CADocumentBPItemLogical CADocumentNumber Document Number
KEY CARepetitionItemNumber I_CADocumentBPItemLogical CARepetitionItemNumber Repetition Item
KEY CABPItemNumber I_CADocumentBPItemLogical CABPItemNumber Item
KEY CASubItemNumber I_CADocumentBPItemLogical CASubItemNumber Subitem
CAAmountInTransactionCurrency
TransactionCurrency I_CADocumentBPItemLogical TransactionCurrency Transaction Currency
CompanyCode I_CADocumentBPItemLogical CompanyCode Receiver Company Code
Segment I_CADocumentBPItemLogical Segment Segment number
Division I_CADocumentBPItemLogical Division Internal Division ID
BusinessArea I_CADocumentBPItemLogical BusinessArea Business Area
BusinessPartner I_CADocumentBPItemLogical BusinessPartner Issuing Authority
PostalCode
FirstName
LastName
BusinessPartnerName
ContractAccount I_CADocumentBPItemLogical ContractAccount Contract Acct
ContractAccountCategory ContrAccHdr ContractAccountCategory Cont. Acct Cat.
CAAccountDeterminationCode I_CADocumentBPItemLogical CAAccountDeterminationCode Acct Determ. ID
CADocumentType I_CADocumentBPItemLogical CADocumentType Document Type
CAMainTransaction I_CADocumentBPItemLogical CAMainTransaction Main Trans.
CASubTransaction I_CADocumentBPItemLogical CASubTransaction Subtransaction
CANetDueDate I_CADocumentBPItemLogical CANetDueDate Net Due Date
CAContract I_CADocumentBPItemLogical CAContract Contract
CASubApplication I_CADocumentBPItemLogical CASubApplication Subapplication
CASubApplicationText
CAAuthorizationGroup _ContractAccount CAAuthorizationGroup AuthorizGroup
CAProviderContractAuthznGroup _ProviderContract CAAuthorizationGroup AuthorizGroup
_CAPartner _CAPartner

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_CACreditItemAnalysis.
-- 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: CCACREDITITMANL

CREATE VIEW C_CACreditItemAnalysis AS
SELECT
  BPItem.CADocumentNumber AS CADocumentNumber,
  BPItem.CARepetitionItemNumber AS CARepetitionItemNumber,
  BPItem.CABPItemNumber AS CABPItemNumber,
  BPItem.CASubItemNumber AS CASubItemNumber,
  cast(BPItem.CAAmountInTransactionCurrency as abap.curr(23,2)) AS CAAmountInTransactionCurrency,
  BPItem.TransactionCurrency AS TransactionCurrency,
  BPItem.CompanyCode AS CompanyCode,
  BPItem.Segment AS Segment,
  BPItem.Division AS Division,
  BPItem.BusinessArea AS BusinessArea,
  BPItem.BusinessPartner AS BusinessPartner,
  _CAPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  _CAPartner._BusinessPartner.FirstName AS FirstName,
  _CAPartner._BusinessPartner.LastName AS LastName,
  _CAPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  BPItem.ContractAccount AS ContractAccount,
  ContrAccHdr.ContractAccountCategory AS ContractAccountCategory,
  BPItem.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  BPItem.CADocumentType AS CADocumentType,
  BPItem.CAMainTransaction AS CAMainTransaction,
  BPItem.CASubTransaction AS CASubTransaction,
  BPItem.CANetDueDate AS CANetDueDate,
  BPItem.CAContract AS CAContract,
  BPItem.CASubApplication AS CASubApplication,
  _SubApp._CASubApplicationText[1:Language = $session.system_language].CASubApplicationText AS CASubApplicationText,
  _ContractAccount.CAAuthorizationGroup AS CAAuthorizationGroup,
  _ProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup
FROM I_CADocumentBPItemLogical AS BPItem
LEFT OUTER JOIN I_ContractAccountHeader AS ContrAccHdr ON ContractAccount = ContrAccHdr.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccount ON BusinessPartner = _ContractAccount.BusinessPartner AND ContractAccount = _ContractAccount.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_CAContractPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner  -- association [1]
LEFT OUTER JOIN I_CASubApplication AS _SubApp ON CASubApplication = _SubApp.CASubApplication  -- association [0..1]
;

Learn More