P_CN_CADEAcctgBalWthAddlInfo

DDL: P_CN_CADEACCTGBALWTHADDLINFO SQL: PCADEACCTGBALINF Type: view COMPOSITE Package: GLO_FIN_CADE_CN
41 Fields 1 Data Sources

CADE Accounting Balance With Additional Information

P_CN_CADEAcctgBalWthAddlInfo is a Composite CDS View that provides data about "CADE Accounting Balance With Additional Information" in SAP S/4HANA. It reads from 1 data source (I_CN_CADEJournalEntryWithBal) and exposes 41 fields with key fields CompanyCode, FiscalYear, Ledger, FiscalYearPeriod, GLAccount. Part of development package GLO_FIN_CADE_CN.

Data Sources (1)

SourceAliasJoin Type
I_CN_CADEJournalEntryWithBal I_CN_CADEJournalEntryWithBal from

Parameters (6)

NameTypeDefault
P_CompanyCode bukrs
P_FiscalYear fis_gjahr
P_Ledger fis_rldnr
P_FromFiscalPeriod fins_fiscalperiod
P_ToFiscalPeriod fins_fiscalperiod
P_IsSpecialPeriod xfeld

Annotations (10)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PCADEACCTGBALINF view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode JournalEntryItem CompanyCode Receiver Company Code
KEY FiscalYear JournalEntryItem FiscalYear G/L Fiscal Year
KEY Ledger JournalEntryItem Ledger Ledger
KEY FiscalYearPeriod JournalEntryItem FiscalYearPeriod Period/Year
KEY GLAccount GLAccount General Ledger
Supplier Supplier Supplier
Customer Customer Sold-to Party
CostCenter CostCenter Cost Center
InternalOrder InternalOrder Order
BillToParty BillToParty Inv. Recipient
BusinessArea BusinessArea Business Area
BusinessProcess BusinessProcess Business Process
ControllingArea ControllingArea Controlling Area
CustomerGroup CustomerGroup Customer Group
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
FunctionalArea FunctionalArea Sendr Fctl Area
Fund Fund Sender Fund
FundsCenter FundsCenter Funds Center
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
ProfitCenter ProfitCenter Profit Center
Project Project WBS Element
ProjectNetwork ProjectNetwork Order
SalesDistrict SalesDistrict Sales District
SalesOrganization SalesOrganization Sales Organization
Segment Segment Segment number
ShipToParty ShipToParty Ship-To Party (obsolete)
SoldMaterial SoldMaterial Product Sold
WBSElement WBSElement WBS Internal ID
CompanyCodeCurrency JournalEntryItem CompanyCodeCurrency Local Currency
EndingBalanceAmtInCoCodeCrcy JournalEntryItem EndingBalanceAmtInCoCodeCrcy
EndingBalanceAmtInTransCrcy JournalEntryItem EndingBalanceAmtInTransCrcy
OpeningBalanceAmtInCoCodeCrcy JournalEntryItem OpeningBalanceAmtInCoCodeCrcy
OpeningBalanceAmtInTransCrcy JournalEntryItem OpeningBalanceAmtInTransCrcy
DebitAmountInCoCodeCrcy JournalEntryItem DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
DebitAmountInTransCrcy JournalEntryItem DebitAmountInTransCrcy Debit Amt in DC
CreditAmountInCoCodeCrcy JournalEntryItem CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
CreditAmountInTransCrcy JournalEntryItem CreditAmountInTransCrcy Credit Amt in DC

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_CN_CADEAcctgBalWthAddlInfo.
-- 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: PCADEACCTGBALINF
-- Parameters: P_CompanyCode : bukrs, P_FiscalYear : fis_gjahr, P_Ledger : fis_rldnr, P_FromFiscalPeriod : fins_fiscalperiod, P_ToFiscalPeriod : fins_fiscalperiod, P_IsSpecialPeriod : xfeld

CREATE VIEW P_CN_CADEAcctgBalWthAddlInfo AS
SELECT
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.FiscalYearPeriod AS FiscalYearPeriod,
  GLAccount,
  Supplier,
  Customer,
  CostCenter,
  InternalOrder,
  BillToParty,
  BusinessArea,
  BusinessProcess,
  ControllingArea,
  CustomerGroup,
  DistributionChannel,
  FunctionalArea,
  Fund,
  FundsCenter,
  HouseBank,
  HouseBankAccount,
  Material,
  MaterialGroup,
  Plant,
  ProfitCenter,
  Project,
  ProjectNetwork,
  SalesDistrict,
  SalesOrganization,
  Segment,
  ShipToParty,
  SoldMaterial,
  WBSElement,
  JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntryItem.EndingBalanceAmtInCoCodeCrcy AS EndingBalanceAmtInCoCodeCrcy,
  JournalEntryItem.EndingBalanceAmtInTransCrcy AS EndingBalanceAmtInTransCrcy,
  JournalEntryItem.OpeningBalanceAmtInCoCodeCrcy AS OpeningBalanceAmtInCoCodeCrcy,
  JournalEntryItem.OpeningBalanceAmtInTransCrcy AS OpeningBalanceAmtInTransCrcy,
  JournalEntryItem.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  JournalEntryItem.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  JournalEntryItem.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  JournalEntryItem.CreditAmountInTransCrcy AS CreditAmountInTransCrcy
FROM I_CN_CADEJournalEntryWithBal
;

Learn More