I_PH_CASCashItemCube

CAS Cash Item Cube | view: IPHCASHITMCUBE | TRAN | Extraction: Not supported | Component: Financials Philippines
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
OriginalReferenceDocument Journal Entry
ReferenceDocumentFiscalYear Fiscal Year
Column Name Description
💲 null (TransactionCurrency):
DebitAmountInTransCrcy null
CreditAmountInTransCrcy null
💲 null (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy null
CreditAmountInCoCodeCrcy null
💲 null (AdditionalCurrency1):
DebitAmountInFreeDfndCrcy1 null
CreditAmountInFreeDfndCrcy1 null
💲 null (AdditionalCurrency2):
DebitAmountInFreeDfndCrcy2 null
CreditAmountInFreeDfndCrcy2 null
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
ClearingDate Clearing Date
Column Name Description
FinancialAccountType Account type Show values
DebitCreditCode Debit/Credit Code Show values
IsUsedInPaymentTransaction Is Used In Payment Transaction Show values
Column Name Description Domain name
ExternalDocumentID Reference Document Number XBLNR1
BusinessPlace Business Place J_1BBRANCH
OfficialReceiptNumber Reference Document Number XBLNR1
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
GLAccountName G/L Account Short Text TEXT20
DebitCreditCodeName Debit/Credit Code Name DDTEXT
DocumentItemText Item Text TEXT50
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
DocumentReferenceID Reference Document Number XBLNR1
CustomerSupplierAccount Supplier LIFNR
CustomerSupplierName null
BusinessPartnerCountry Business Partner Country/Region LAND1
CustomerSupplierAddress Business Partner Address
CustomerSupplierVATRegn null
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_PH_CASCASHITEMCUBE.MANDT == T003.MANDT
  • I_PH_CASCASHITEMCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_PH_CASCASHITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_PH_CASCASHITEMCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_PH_CASCASHITEMCUBE.COMPANYCODE == T001.BUKRS
  • I_PH_CASCASHITEMCUBE.MANDT == T001.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • I_PH_CASCASHITEMCUBE.COMPANYCODE == SKB1.BUKRS
  • I_PH_CASCASHITEMCUBE.MANDT == SKB1.MANDT
  • I_PH_CASCASHITEMCUBE.GLACCOUNT == SKB1.SAKNR