C_PH_CASCashItemQuery

CAS Cash Item Query | view: CPHCASHITMQ | Extraction: Not supported | Component: Financials Philippines
Column Name Description
CompanyCode FK Company Code
PostingDate Posting Date
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
OriginalReferenceDocument Journal Entry
ReferenceDocumentFiscalYear Fiscal Year
Column Name Description
💲 null (TransactionCurrency):
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
💲 null (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
💲 null (AdditionalCurrency1):
DebitAmountInFreeDfndCrcy1 Debit Amount in Free Defined Currency 1
CreditAmountInFreeDfndCrcy1 Credit Amount in Free Defined Currency 1
💲 null (AdditionalCurrency2):
DebitAmountInFreeDfndCrcy2 Debit Amount in Free Defined Currency 2
CreditAmountInFreeDfndCrcy2 Credit Amount in Free Defined Currency 2
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry 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
BusinessPlace Business Place J_1BBRANCH
OfficialReceiptNumber Reference Document Number
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
GLAccountName G/L Account Short Text
DebitCreditCodeName Debit/Credit Code Name DDTEXT
DocumentItemText Item Text
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
DocumentReferenceID Reference Document Number
CustomerSupplierAccount Supplier
CustomerSupplierName null
BusinessPartnerCountry Business Partner Country/Region
CustomerSupplierAddress Business Partner Address
CustomerSupplierVATRegn null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_PH_CASCASHITEMQUERY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_PH_CASCASHITEMQUERY.MANDT == T003.MANDT
Company Code
  • Client
  • Company Code
  • C_PH_CASCASHITEMQUERY.MANDT == T001.MANDT
  • C_PH_CASCASHITEMQUERY.COMPANYCODE == T001.BUKRS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • C_PH_CASCASHITEMQUERY.GLACCOUNT == SKB1.SAKNR
  • C_PH_CASCASHITEMQUERY.MANDT == SKB1.MANDT
  • C_PH_CASCASHITEMQUERY.COMPANYCODE == SKB1.BUKRS