I_StRpAccountingDocumentItmC

Accounting Document Item Cube for Statutory Reporting | view: ISRACCDOCITMC | TRAN | Extraction: Not supported | Component: Financials Arabic Emirates
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy Amount in Company Code Currency
CreditAmountInCoCodeCrcy Amount in Company Code Currency
GLAcctBalanceAmt Amount in Company Code Currency
💲 Additional Currency 1 (AdditionalCurrency1):
DebitAmountInAddlCrcy1 Amount in Additional Currency 1
CreditAmountInAddlCrcy1 Amount in Additional Currency 1
💲 Additional Currency 2 (AdditionalCurrency2):
DebitAmountInAddlCrcy2 Amount in Additional Currency 2
CreditAmountInAddlCrcy2 Amount in Additional Currency 2
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ReportingDate Reporting Date
Column Name Description
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
OriginRefDocBusObjTypeName null
GLAccountName G/L Account Short Text TEXT20
BusinessPartnerName1 Name of Supplier TEXT80
OriginalReferenceDocument Original Reference Document AWKEY
SourceDocumentText null
AccountingDocumentTypeName Document Type Name TEXT20
DocumentItemText Item Text TEXT50
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_STRPACCOUNTINGDOCUMENTITMC.COMPANYCODE == T001.BUKRS
  • I_STRPACCOUNTINGDOCUMENTITMC.MANDT == T001.MANDT
G/L Account
  • Client
  • ?
  • G/L Account
  • I_STRPACCOUNTINGDOCUMENTITMC.MANDT == SKB1.MANDT
  • I_STRPACCOUNTINGDOCUMENTITMC.[column in domain "BUKRS"] == SKB1.BUKRS
  • I_STRPACCOUNTINGDOCUMENTITMC.GLACCOUNT == SKB1.SAKNR
Transaction Currency
  • Transaction Currency
  • Client
  • I_STRPACCOUNTINGDOCUMENTITMC.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_STRPACCOUNTINGDOCUMENTITMC.MANDT == TCURC.MANDT