I_STRPTRIALBALANCEITEMCUBE

CDS View
81 Fields 27 CDS Views

Trail Balance Item Cube

I_STRPTRIALBALANCEITEMCUBE is a CDS View in S/4HANA. Trail Balance Item Cube. It contains 81 fields. 27 CDS views read from this table.

CDS Views using this table (27)

ViewTypeJoinVDMDescription
C_AT_StRpAuditBalanceItemQuery view from CONSUMPTION Austrian Audit Balance Item Query
C_GR_JournalDocumentCube view_entity from CONSUMPTION Greece Journal document - Cube
C_GR_StRpCustTrialBalItmQuery view from CONSUMPTION Greece Customer Trial Balance – Query
C_GR_StRpSuplrTrialBalItmQuery view from CONSUMPTION Greece Supplier Trial Balance – Query
C_GR_StRpTrialBalHierCube view_entity from CONSUMPTION Greece Trial Balance Hierarchy - Cube
C_KR_StRpTrialBalanceItemQuery view from CONSUMPTION South Korea Trial Balance Query
C_NO_StRpTrialBalanceItemQuery view from CONSUMPTION Norway Trial Balance Query
C_PL_SAFTGenLdgrAcctBalCube view from CONSUMPTION SAFT PL General Ledger Balance Cube
C_PL_StRpCustTrialBalItmQuery view from CONSUMPTION Customer Trial Balance Query – Poland
C_PL_StRpGLAcctTrialBalItmQry view from CONSUMPTION GL Account Trial Balance Query – Poland
C_PL_StRpSuplrTrialBalItmQuery view from CONSUMPTION Supplier Trial Balance Query – Poland
C_RO_StRpCashJournalC view_entity inner CONSUMPTION Romanian Cash Journal - Cube
C_RO_StRpGLAcctJrnlEntryItmQry view from CONSUMPTION GL Account Trial Balance Query – Romania
C_RO_StRpInventoryRegisterC view_entity from CONSUMPTION Romanian inventory register - Cube
C_RS_StRpGeneralLedgerCube view_entity from General Ledger Items for Serbia - Cube
C_SI_StRpGeneralLedgerCube view from General Ledger Items for Slovenia - Cube
C_StRpTrialBalanceItemQuery view from CONSUMPTION Trial Balance Query
I_BG_TrlBalGLAcctLineItem view_entity from COMPOSITE BGTRB Gather all needed data from cube
I_PL_SAFTGenLdgrAcctBalCube view_entity from COMPOSITE SAFT PL KR General Ledger - Cube
P_BG_GLOffstAcctRptRecAcct view_entity from COMPOSITE
P_BG_StRpTrialBalanceLog view_entity from CONSUMPTION
P_CL_TrialBalanceRptgCrcyAmt view from CONSUMPTION
P_GR_StRpTrialBalanceItemLog view from CONSUMPTION Trial Balance Item - Log of reported documents - Greece
P_NO_SAFTJournalEntryItemLog view from CONSUMPTION
P_PE_TrialBalanceRptgCrcyAmt view_entity from CONSUMPTION
P_PL_StRpTrialBalanceItemLog view from CONSUMPTION Trial Balance Item - Log of reported documents - Poland
P_RS_GL_ITEMLOG view_entity from CONSUMPTION Gl Items - Log of reported documents

Fields (81)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 3
KEY CompanyCode CompanyCode 3
KEY FiscalYear FiscalYear 3
KEY Ledger Ledger 3
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY SourceLedger SourceLedger 2
KEY StatryRptCategory StatryRptCategory 2
KEY StatryRptgEntity StatryRptgEntity 2
KEY StatryRptRunID StatryRptRunID 2
_AccountingDocumentType _AccountingDocumentType 1
_AlternativeGLAccount _AlternativeGLAccount 1
_BusinessArea _BusinessArea 1
_ChartOfAccounts _ChartOfAccounts 1
_CompanyCode _CompanyCode 2
_ControllingArea _ControllingArea 1
_CorporateGroupAccount _CorporateGroupAccount 1
_CorporateGroupChartOfAccounts _CorporateGroupChartOfAccounts 1
_CountryChartOfAccounts _CountryChartOfAccounts 1
_Customer _Customer 2
_FunctionalArea _FunctionalArea 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 1
_GLAccountInCompanyCode _GLAccountInCompanyCode 1
_GLAccountText _GLAccountText 1
_JournalEntry _JournalEntry 1
_PostingKey _PostingKey 1
_ProfitCenter _ProfitCenter 1
_ReportedItemsLog _ReportedItemsLog 1
_Segment _Segment 1
_Supplier _Supplier 2
_TaxCode _TaxCode 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 1
AccountingDocumentCategory AccountingDocumentCategory 2
AccountingDocumentItem AccountingDocumentItem 2
AccountingDocumentType AccountingDocumentType 2
AlternativeGLAccount AlternativeGLAccount 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AssignmentReference AssignmentReference 1
BusinessArea BusinessArea 1
CashJournalItemType CashJournalItemType 1
ChartOfAccounts ChartOfAccounts 2
CompanyCodeCurrency CompanyCodeCurrency 1
ControllingArea ControllingArea 1
CorporateGroupAccount CorporateGroupAccount 1
CorporateGroupChartOfAccounts CorporateGroupChartOfAccounts 1
CountryChartOfAccounts CountryChartOfAccounts 1
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
CreditEndingBalAmtInCCCrcy CreditEndingBalAmtInCCCrcy 1
CreditStartingBalAmtInCCCrcy CreditStartingBalAmtInCCCrcy 1
Customer Customer 2
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
DebitCreditCode DebitCreditCode 1
DebitEndingBalAmtInCCCrcy DebitEndingBalAmtInCCCrcy 1
DebitStartingBalAmtInCCCrcy DebitStartingBalAmtInCCCrcy 1
DocumentDate DocumentDate 3
DocumentItemText DocumentItemText 1
EndingBalanceAmtInCoCodeCrcy EndingBalanceAmtInCoCodeCrcy 1
FinancialAccountType FinancialAccountType 2
FiscalPeriod FiscalPeriod 2
FiscalYearVariant FiscalYearVariant 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 2
GLAccountLongName GLAccountLongName 2
IsBalanceSheetAccount IsBalanceSheetAccount 1
IsReversal IsReversal 2
IsReversed IsReversed 2
ItemType ItemType 1
JrnlEntryItemMigrationSource JrnlEntryItemMigrationSource 1
OffsettingAccount OffsettingAccount 1
OffsettingAccountType OffsettingAccountType 1
PostingDate PostingDate 3
PostingKey PostingKey 1
ProfitCenter ProfitCenter 1
ReconciliationAccountType ReconciliationAccountType 2
ReferenceDocument ReferenceDocument 1
Segment Segment 1
SpecialGLCode SpecialGLCode 1
StartingBalanceAmtInCoCodeCrcy StartingBalanceAmtInCoCodeCrcy 1
Supplier Supplier 2
TaxCode TaxCode 1
YTDCrdtAmtInCoCodeCrcy YTDCrdtAmtInCoCodeCrcy 1
YTDDebitAmtInCoCodeCrcy YTDDebitAmtInCoCodeCrcy 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Trail Balance Item Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STRPTRIALBALANCEITEMCUBE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    _ACCOUNTINGDOCUMENTTYPE,
    _ALTERNATIVEGLACCOUNT,
    _BUSINESSAREA,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _CORPORATEGROUPACCOUNT,
    _CORPORATEGROUPCHARTOFACCOUNTS,
    _COUNTRYCHARTOFACCOUNTS,
    _CUSTOMER,
    _FUNCTIONALAREA,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _GLACCOUNTTEXT,
    _JOURNALENTRY,
    _POSTINGKEY,
    _PROFITCENTER,
    _REPORTEDITEMSLOG,
    _SEGMENT,
    _SUPPLIER,
    _TAXCODE,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINCOMPANYCODECURRENCY,
    ASSIGNMENTREFERENCE,
    BUSINESSAREA,
    CASHJOURNALITEMTYPE,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    CORPORATEGROUPACCOUNT,
    CORPORATEGROUPCHARTOFACCOUNTS,
    COUNTRYCHARTOFACCOUNTS,
    CREDITAMOUNTINCOCODECRCY,
    CREDITENDINGBALAMTINCCCRCY,
    CREDITSTARTINGBALAMTINCCCRCY,
    CUSTOMER,
    DEBITAMOUNTINCOCODECRCY,
    DEBITCREDITCODE,
    DEBITENDINGBALAMTINCCCRCY,
    DEBITSTARTINGBALAMTINCCCRCY,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    ENDINGBALANCEAMTINCOCODECRCY,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FISCALYEARVARIANT,
    FUNCTIONALAREA,
    GLACCOUNT,
    GLACCOUNTLONGNAME,
    ISBALANCESHEETACCOUNT,
    ISREVERSAL,
    ISREVERSED,
    ITEMTYPE,
    JRNLENTRYITEMMIGRATIONSOURCE,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    POSTINGDATE,
    POSTINGKEY,
    PROFITCENTER,
    RECONCILIATIONACCOUNTTYPE,
    REFERENCEDOCUMENT,
    SEGMENT,
    SPECIALGLCODE,
    STARTINGBALANCEAMTINCOCODECRCY,
    SUPPLIER,
    TAXCODE,
    YTDCRDTAMTINCOCODECRCY,
    YTDDEBITAMTINCOCODECRCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More