P_StRpTrialBalanceItem

DDL: P_STRPTRIALBALANCEITEM SQL: PSRTRLBALITM Type: view COMPOSITE Package: GLO_FIN_IS_TB_GEN
143 Fields 1 Data Sources

Trial Balance Item

P_StRpTrialBalanceItem is a Composite CDS View that provides data about "Trial Balance Item" in SAP S/4HANA. It reads from 1 data source (P_StRpTrialBalanceItem2) and exposes 143 fields with key fields Ledger, CompanyCode, FiscalYear, SourceLedger, AccountingDocument. Part of development package GLO_FIN_IS_TB_GEN.

Data Sources (1)

SourceAliasJoin Type
P_StRpTrialBalanceItem2 P_StRpTrialBalanceItem2 from

Parameters (4)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to
P_FromFiscalPeriod fis_period_from
P_ToFiscalPeriod fis_period_to

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PSRTRLBALITM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view

Fields (143)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY SourceLedger SourceLedger Source Ledger
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
AccountingDocumentItem AccountingDocumentItem Posting View Item
FiscalPeriod FiscalPeriod Tax period
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
ProfitCenter ProfitCenter Profit Center
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
ControllingArea ControllingArea Controlling Area
Segment Segment Segment number
ChartOfAccounts ChartOfAccounts Node Class
AlternativeGLAccount AlternativeGLAccount Group Account
CountryChartOfAccounts CountryChartOfAccounts Chart of Accts
GLAccount GLAccount General Ledger
ReconciliationAccountType ReconciliationAccountType Reconcil. ID
Supplier Supplier Supplier
Customer Customer Sold-to Party
FinancialAccountType FinancialAccountType Fin. Account Type
SpecialGLCode SpecialGLCode Special G/L Ind
AccountingDocumentType AccountingDocumentType Journal Entry Type
PostingKey PostingKey Posting Key
AccountingDocumentCategory AccountingDocumentCategory Journal Entry Category
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
DebitCreditCode DebitCreditCode Single-Character Flag
CashJournalItemType CashJournalItemType
ItemType ItemType Object Type
TaxCode TaxCode Tax Code
JrnlEntryItemMigrationSource JrnlEntryItemMigrationSource
FiscalYearVariant FiscalYearVariant FY Variant
ReferenceDocument ReferenceDocument Reference Document
OffsettingAccount OffsettingAccount Offsetting Acct
OffsettingAccountType OffsettingAccountType Offset Acct Type
CompanyCodeCurrency CompanyCodeCurrency Local Currency
CarryFwdBalAmtInCCCrcy CarryFwdBalAmtInCCCrcy
PrevPeriodYTDAmtInCCCrcy PrevPeriodYTDAmtInCCCrcy
StartingBalanceAmtInCoCodeCrcy StartingBalanceAmtInCoCodeCrcy
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
EndingBalanceAmtInCoCodeCrcy EndingBalanceAmtInCoCodeCrcy
YTDAmtInLoclCrcy YTDAmtInLoclCrcy
TransactionCurrency TransactionCurrency Transaction Currency
CarryFwdBalanceAmtInTransCrcy CarryFwdBalanceAmtInTransCrcy
PrevPerdYTDAmountInTransCrcy PrevPerdYTDAmountInTransCrcy
StartingBalanceAmtInTransCrcy StartingBalanceAmtInTransCrcy
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
EndingBalanceAmtInTransCrcy EndingBalanceAmtInTransCrcy
YrToDteAmtInTransacCrcy YrToDteAmtInTransacCrcy
BalanceTransactionCurrency BalanceTransactionCurrency Currency
CarryFwdBalAmtInBalTransCrcy CarryFwdBalAmtInBalTransCrcy
PrevPeriodYTDAmtInBalTransCrcy PrevPeriodYTDAmtInBalTransCrcy
StartingBalAmtInBalTransCrcy StartingBalAmtInBalTransCrcy
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
EndingBalanceAmtInBalTransCrcy EndingBalanceAmtInBalTransCrcy
YearToDateAmountInBalTransCrcy YearToDateAmountInBalTransCrcy
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
CarryFwdBalanceAmtInGlobalCrcy CarryFwdBalanceAmtInGlobalCrcy
PrevPerdYTDAmountInGlobalCrcy PrevPerdYTDAmountInGlobalCrcy
StartingBalanceAmtInGlobalCrcy StartingBalanceAmtInGlobalCrcy
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
EndingBalanceAmtInGlobalCrcy EndingBalanceAmtInGlobalCrcy
YearToDateAmountInGlobalCrcy YearToDateAmountInGlobalCrcy
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
CarryFwdBalAmountInFDCrcy1 CarryFwdBalAmountInFDCrcy1
PrevPerdYTDAmountInFDCrcy1 PrevPerdYTDAmountInFDCrcy1
StrtgBalAmtInFreeDfndCrcy1 StrtgBalAmtInFreeDfndCrcy1
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
EndingBalAmtInFreeDfndCrcy1 EndingBalAmtInFreeDfndCrcy1
YearToDateAmountInFDCrcy1 YearToDateAmountInFDCrcy1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
CarryFwdBalAmountInFDCrcy2 CarryFwdBalAmountInFDCrcy2
PrevPerdYTDAmountInFDCrcy2 PrevPerdYTDAmountInFDCrcy2
StrtgBalAmtInFreeDfndCrcy2 StrtgBalAmtInFreeDfndCrcy2
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
EndingBalAmtInFreeDfndCrcy2 EndingBalAmtInFreeDfndCrcy2
YearToDateAmountInFDCrcy2 YearToDateAmountInFDCrcy2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
CarryFwdBalAmountInFDCrcy3 CarryFwdBalAmountInFDCrcy3
PrevPerdYTDAmountInFDCrcy3 PrevPerdYTDAmountInFDCrcy3
StrtgBalAmtInFreeDfndCrcy3 StrtgBalAmtInFreeDfndCrcy3
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
EndingBalAmtInFreeDfndCrcy3 EndingBalAmtInFreeDfndCrcy3
YearToDateAmountInFDCrcy3 YearToDateAmountInFDCrcy3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
CarryFwdBalAmountInFDCrcy4 CarryFwdBalAmountInFDCrcy4
PrevPerdYTDAmountInFDCrcy4 PrevPerdYTDAmountInFDCrcy4
StrtgBalAmtInFreeDfndCrcy4 StrtgBalAmtInFreeDfndCrcy4
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
EndingBalAmtInFreeDfndCrcy4 EndingBalAmtInFreeDfndCrcy4
YearToDateAmountInFDCrcy4 YearToDateAmountInFDCrcy4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
CarryFwdBalAmountInFDCrcy5 CarryFwdBalAmountInFDCrcy5
PrevPerdYTDAmountInFDCrcy5 PrevPerdYTDAmountInFDCrcy5
StrtgBalAmtInFreeDfndCrcy5 StrtgBalAmtInFreeDfndCrcy5
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
EndingBalAmtInFreeDfndCrcy5 EndingBalAmtInFreeDfndCrcy5
YearToDateAmountInFDCrcy5 YearToDateAmountInFDCrcy5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
CarryFwdBalAmountInFDCrcy6 CarryFwdBalAmountInFDCrcy6
PrevPerdYTDAmountInFDCrcy6 PrevPerdYTDAmountInFDCrcy6
StrtgBalAmtInFreeDfndCrcy6 StrtgBalAmtInFreeDfndCrcy6
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
EndingBalAmtInFreeDfndCrcy6 EndingBalAmtInFreeDfndCrcy6
YearToDateAmountInFDCrcy6 YearToDateAmountInFDCrcy6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
CarryFwdBalAmountInFDCrcy7 CarryFwdBalAmountInFDCrcy7
PrevPerdYTDAmountInFDCrcy7 PrevPerdYTDAmountInFDCrcy7
StrtgBalAmtInFreeDfndCrcy7 StrtgBalAmtInFreeDfndCrcy7
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
EndingBalAmtInFreeDfndCrcy7 EndingBalAmtInFreeDfndCrcy7
YearToDateAmountInFDCrcy7 YearToDateAmountInFDCrcy7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8
CarryFwdBalAmountInFDCrcy8 CarryFwdBalAmountInFDCrcy8
PrevPerdYTDAmountInFDCrcy8 PrevPerdYTDAmountInFDCrcy8
StrtgBalAmtInFreeDfndCrcy8 StrtgBalAmtInFreeDfndCrcy8
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
EndingBalAmtInFreeDfndCrcy8 EndingBalAmtInFreeDfndCrcy8
YearToDateAmountInFDCrcy8 YearToDateAmountInFDCrcy8
AssignmentReference AssignmentReference Assignment Reference
DocumentItemText DocumentItemText Text
_Supplier _Supplier
_Customer _Customer
_CompanyCode _CompanyCode
_GLAccountText _GLAccountText
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_GLAccountInCompanyCode _GLAccountInCompanyCode
_ProfitCenter _ProfitCenter
_FunctionalArea _FunctionalArea
_BusinessArea _BusinessArea
_Segment _Segment
_AlternativeGLAccount _AlternativeGLAccount
_ControllingArea _ControllingArea
_CountryChartOfAccounts _CountryChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_TaxCode _TaxCode
_AccountingDocumentType _AccountingDocumentType
_PostingKey _PostingKey
_JournalEntry _JournalEntry

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_StRpTrialBalanceItem.
-- 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: PSRTRLBALITM
-- Parameters: P_FromPostingDate : fis_budat_from, P_ToPostingDate : fis_budat_to, P_FromFiscalPeriod : fis_period_from, P_ToFiscalPeriod : fis_period_to

CREATE VIEW P_StRpTrialBalanceItem AS
SELECT
  Ledger,
  CompanyCode,
  FiscalYear,
  SourceLedger,
  AccountingDocument,
  LedgerGLLineItem,
  AccountingDocumentItem,
  FiscalPeriod,
  PostingDate,
  DocumentDate,
  IsReversal,
  IsReversed,
  ProfitCenter,
  FunctionalArea,
  BusinessArea,
  ControllingArea,
  Segment,
  ChartOfAccounts,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  GLAccount,
  ReconciliationAccountType,
  Supplier,
  Customer,
  FinancialAccountType,
  SpecialGLCode,
  AccountingDocumentType,
  PostingKey,
  AccountingDocumentCategory,
  AccountingDocCreatedByUser,
  DebitCreditCode,
  CashJournalItemType,
  ItemType,
  TaxCode,
  JrnlEntryItemMigrationSource,
  FiscalYearVariant,
  ReferenceDocument,
  OffsettingAccount,
  OffsettingAccountType,
  CompanyCodeCurrency,
  CarryFwdBalAmtInCCCrcy,
  PrevPeriodYTDAmtInCCCrcy,
  StartingBalanceAmtInCoCodeCrcy,
  AmountInCompanyCodeCurrency,
  EndingBalanceAmtInCoCodeCrcy,
  YTDAmtInLoclCrcy,
  TransactionCurrency,
  CarryFwdBalanceAmtInTransCrcy,
  PrevPerdYTDAmountInTransCrcy,
  StartingBalanceAmtInTransCrcy,
  AmountInTransactionCurrency,
  EndingBalanceAmtInTransCrcy,
  YrToDteAmtInTransacCrcy,
  BalanceTransactionCurrency,
  CarryFwdBalAmtInBalTransCrcy,
  PrevPeriodYTDAmtInBalTransCrcy,
  StartingBalAmtInBalTransCrcy,
  AmountInBalanceTransacCrcy,
  EndingBalanceAmtInBalTransCrcy,
  YearToDateAmountInBalTransCrcy,
  GlobalCurrency,
  CarryFwdBalanceAmtInGlobalCrcy,
  PrevPerdYTDAmountInGlobalCrcy,
  StartingBalanceAmtInGlobalCrcy,
  AmountInGlobalCurrency,
  EndingBalanceAmtInGlobalCrcy,
  YearToDateAmountInGlobalCrcy,
  FreeDefinedCurrency1,
  CarryFwdBalAmountInFDCrcy1,
  PrevPerdYTDAmountInFDCrcy1,
  StrtgBalAmtInFreeDfndCrcy1,
  AmountInFreeDefinedCurrency1,
  EndingBalAmtInFreeDfndCrcy1,
  YearToDateAmountInFDCrcy1,
  FreeDefinedCurrency2,
  CarryFwdBalAmountInFDCrcy2,
  PrevPerdYTDAmountInFDCrcy2,
  StrtgBalAmtInFreeDfndCrcy2,
  AmountInFreeDefinedCurrency2,
  EndingBalAmtInFreeDfndCrcy2,
  YearToDateAmountInFDCrcy2,
  FreeDefinedCurrency3,
  CarryFwdBalAmountInFDCrcy3,
  PrevPerdYTDAmountInFDCrcy3,
  StrtgBalAmtInFreeDfndCrcy3,
  AmountInFreeDefinedCurrency3,
  EndingBalAmtInFreeDfndCrcy3,
  YearToDateAmountInFDCrcy3,
  FreeDefinedCurrency4,
  CarryFwdBalAmountInFDCrcy4,
  PrevPerdYTDAmountInFDCrcy4,
  StrtgBalAmtInFreeDfndCrcy4,
  AmountInFreeDefinedCurrency4,
  EndingBalAmtInFreeDfndCrcy4,
  YearToDateAmountInFDCrcy4,
  FreeDefinedCurrency5,
  CarryFwdBalAmountInFDCrcy5,
  PrevPerdYTDAmountInFDCrcy5,
  StrtgBalAmtInFreeDfndCrcy5,
  AmountInFreeDefinedCurrency5,
  EndingBalAmtInFreeDfndCrcy5,
  YearToDateAmountInFDCrcy5,
  FreeDefinedCurrency6,
  CarryFwdBalAmountInFDCrcy6,
  PrevPerdYTDAmountInFDCrcy6,
  StrtgBalAmtInFreeDfndCrcy6,
  AmountInFreeDefinedCurrency6,
  EndingBalAmtInFreeDfndCrcy6,
  YearToDateAmountInFDCrcy6,
  FreeDefinedCurrency7,
  CarryFwdBalAmountInFDCrcy7,
  PrevPerdYTDAmountInFDCrcy7,
  StrtgBalAmtInFreeDfndCrcy7,
  AmountInFreeDefinedCurrency7,
  EndingBalAmtInFreeDfndCrcy7,
  YearToDateAmountInFDCrcy7,
  FreeDefinedCurrency8,
  CarryFwdBalAmountInFDCrcy8,
  PrevPerdYTDAmountInFDCrcy8,
  StrtgBalAmtInFreeDfndCrcy8,
  AmountInFreeDefinedCurrency8,
  EndingBalAmtInFreeDfndCrcy8,
  YearToDateAmountInFDCrcy8,
  AssignmentReference,
  DocumentItemText
FROM P_StRpTrialBalanceItem2
;

Learn More