STRPTRIALBALANCEITEMCUBE

44 Fields

STRPTRIALBALANCEITEMCUBE is an SAP database table in S/4HANA. It contains 44 fields.

Fields (44)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY SourceLedger SourceLedger 1
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 1
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentType AccountingDocumentType 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AssignmentReference AssignmentReference 1
BusinessArea BusinessArea 1
CarryFwdBalAmtInCCCrcy CarryFwdBalAmtInCCCrcy 1
CompanyCodeCurrency CompanyCodeCurrency 1
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
CreditCarryFwdBalAmtInCCCrcy CreditCarryFwdBalAmtInCCCrcy 1
CreditEndingBalAmtInCCCrcy CreditEndingBalAmtInCCCrcy 1
CreditPrevPeriodYTDAmtInCCCrcy CreditPrevPeriodYTDAmtInCCCrcy 1
CreditStartingBalAmtInCCCrcy CreditStartingBalAmtInCCCrcy 1
Customer Customer 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
DebitCarryFwdBalAmtInCCCrcy DebitCarryFwdBalAmtInCCCrcy 1
DebitCreditCode DebitCreditCode 1
DebitEndingBalAmtInCCCrcy DebitEndingBalAmtInCCCrcy 1
DebitPrevPeriodYTDAmtInCCCrcy DebitPrevPeriodYTDAmtInCCCrcy 1
DebitStartingBalAmtInCCCrcy DebitStartingBalAmtInCCCrcy 1
DocumentDate DocumentDate 1
DocumentItemText DocumentItemText 1
EndingBalanceAmtInCoCodeCrcy EndingBalanceAmtInCoCodeCrcy 1
FinancialAccountType FinancialAccountType 1
FiscalPeriod FiscalPeriod 1
FunctionalArea FunctionalArea 1
GLAccountLongName GLAccountLongName 1
PostingDate PostingDate 1
PostingKey PostingKey 1
PrevPeriodYTDAmtInCCCrcy PrevPeriodYTDAmtInCCCrcy 1
SpecialGLCode SpecialGLCode 1
StartingBalanceAmtInCoCodeCrcy StartingBalanceAmtInCoCodeCrcy 1
Supplier Supplier 1
YTDAmtInLoclCrcy YTDAmtInLoclCrcy 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STRPTRIALBALANCEITEMCUBE (
    ACCOUNTINGDOCUMENT,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    ASSIGNMENTREFERENCE,
    BUSINESSAREA,
    CARRYFWDBALAMTINCCCRCY,
    COMPANYCODECURRENCY,
    CREDITAMOUNTINCOCODECRCY,
    CREDITCARRYFWDBALAMTINCCCRCY,
    CREDITENDINGBALAMTINCCCRCY,
    CREDITPREVPERIODYTDAMTINCCCRCY,
    CREDITSTARTINGBALAMTINCCCRCY,
    CUSTOMER,
    DEBITAMOUNTINCOCODECRCY,
    DEBITCARRYFWDBALAMTINCCCRCY,
    DEBITCREDITCODE,
    DEBITENDINGBALAMTINCCCRCY,
    DEBITPREVPERIODYTDAMTINCCCRCY,
    DEBITSTARTINGBALAMTINCCCRCY,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    ENDINGBALANCEAMTINCOCODECRCY,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FUNCTIONALAREA,
    GLACCOUNTLONGNAME,
    POSTINGDATE,
    POSTINGKEY,
    PREVPERIODYTDAMTINCCCRCY,
    SPECIALGLCODE,
    STARTINGBALANCEAMTINCOCODECRCY,
    SUPPLIER,
    YTDAMTINLOCLCRCY,
    YTDCRDTAMTINCOCODECRCY,
    YTDDEBITAMTINCOCODECRCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More