P_CACUSTTRIALBALCARFWD

DDL: P_CACUSTTRIALBALCARFWD Type: view_entity COMPOSITE
18 Fields 2 Data Sources 3 Associations

P_CACUSTTRIALBALCARFWD is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CADocumentBPItem, P_CACUSTTRIALBALPREVFYDET) and exposes 18 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_CADocumentBPItem _BPItem from
P_CACUSTTRIALBALPREVFYDET _CompFisc inner

Parameters (1)

NameTypeDefault
P_FiscalYear fis_gjahr

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompCode $projection.CompanyCode = _CompCode.CompanyCode
[0..1] I_RetainedEarningsGLAccount _RetEarnGLAccount $projection.ChartOfAccounts = _RetEarnGLAccount.ChartOfAccounts and _RetEarnGLAccount.ProfitLossAccountType = 'X'
[0..1] I_GLAccountInCompanyCode _AlternateGLAcctInCompany $projection.GLAccount = _AlternateGLAcctInCompany.GLAccount and $projection.CompanyCode = _AlternateGLAcctInCompany.CompanyCode

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber I_CADocumentBPItem CADocumentNumber Document Number
KEY CARepetitionItemNumber I_CADocumentBPItem CARepetitionItemNumber Repetition Item
KEY CABPItemNumber I_CADocumentBPItem CABPItemNumber Item
KEY CASubItemNumber I_CADocumentBPItem CASubItemNumber Subitem
CompanyCode I_CADocumentBPItem CompanyCode Receiver Company Code
ChartOfAccounts _CompCode ChartOfAccounts Node Class
CountryChartOfAccounts _CompCode CountryChartOfAccounts Chart of Accts
BusinessPartner I_CADocumentBPItem BusinessPartner Issuing Authority
TransactionCurrency I_CADocumentBPItem TransactionCurrency Transaction Currency
CompanyCodeCurrency I_CADocumentBPItem CompanyCodeCurrency Local Currency
GLAccount I_CADocumentBPItem CAReconciliationAccount G/L Account
CAAmountInLocalCurrency I_CADocumentBPItem CAAmountInLocalCurrency Local Crcy Amt
CAAmountInTransactionCurrency I_CADocumentBPItem CAAmountInTransactionCurrency Amount
FiscalYearStartDate P_CACUSTTRIALBALPREVFYDET FiscalYearStartDate
FiscalPeriod P_CACUSTTRIALBALPREVFYDET FiscalPeriod Tax period
_RetEarnGLAccount _RetEarnGLAccount
_CompCode _CompCode
_AlternateGLAcctInCompany _AlternateGLAcctInCompany

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 P_CACUSTTRIALBALCARFWD.
-- 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.
-- Parameters: P_FiscalYear : fis_gjahr

CREATE VIEW P_CACUSTTRIALBALCARFWD AS
SELECT
  _BPItem.CADocumentNumber AS CADocumentNumber,
  _BPItem.CARepetitionItemNumber AS CARepetitionItemNumber,
  _BPItem.CABPItemNumber AS CABPItemNumber,
  _BPItem.CASubItemNumber AS CASubItemNumber,
  _BPItem.CompanyCode AS CompanyCode,
  _CompCode.ChartOfAccounts AS ChartOfAccounts,
  _CompCode.CountryChartOfAccounts AS CountryChartOfAccounts,
  _BPItem.BusinessPartner AS BusinessPartner,
  _BPItem.TransactionCurrency AS TransactionCurrency,
  _BPItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  _BPItem.CAReconciliationAccount AS GLAccount,
  _BPItem.CAAmountInLocalCurrency AS CAAmountInLocalCurrency,
  _BPItem.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _CompFisc.FiscalYearStartDate AS FiscalYearStartDate,
  _CompFisc.FiscalPeriod AS FiscalPeriod
FROM I_CADocumentBPItem AS _BPItem
INNER JOIN P_CACUSTTRIALBALPREVFYDET AS _CompFisc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_RetainedEarningsGLAccount AS _RetEarnGLAccount ON ChartOfAccounts = _RetEarnGLAccount.ChartOfAccounts AND _RetEarnGLAccount.ProfitLossAccountType = 'X'  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _AlternateGLAcctInCompany ON GLAccount = _AlternateGLAcctInCompany.GLAccount AND CompanyCode = _AlternateGLAcctInCompany.CompanyCode  -- association [0..1]
;

Learn More