I_CashJournalPosition

View for table TCJ_POSITIONS | view: ICASHJNLPOS | TRAN | Extraction: Not supported | Component: Information System
Column Name Description
CompanyCode FK Company Code
CashJournal FK Cash Journal Number
FiscalYear Fiscal Year
CashJournalDocumentInternalID FK Cash Journal Document Number
CashJournalDocumentItem Number of Line Item within Cash Journal Document
Language FK Language Key
Column Name Description
💲 Currency Key (Currency):
TaxAmountInTransCrcy Tax Amount in Document Currency
CashJournalReceiptAmount Cash Journal Amount Field with +/- Sign
Column Name Description
Column Name Description
Column Name Description
CashJournalItemType Cash Journal Item Type Show values
CashJournalDocumentTransType Business Transaction Type Show values
Column Name Description Domain name
CashJournalTransaction null
TaxRate Tax rate PRZ43V
CostCenter Cost Center KOSTL
ProfitCenter Profit Center PRCTR
BusinessArea Business Area GSBER
CashJournalDocumentItemText Cash Journal Line Item Text TEXT50
PersonnelNumber Personnel Number PERNR
Master Data Relations Join Conditions
Cash Journal Number
  • ?
  • Cash Journal Number
  • Client
Company Code
  • Company Code
  • Client
  • I_CASHJOURNALPOSITION.COMPANYCODE == T001.BUKRS
  • I_CASHJOURNALPOSITION.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • I_CASHJOURNALPOSITION.CURRENCY == TCURC.WAERS
  • I_CASHJOURNALPOSITION.MANDT == TCURC.MANDT
Customer Number
  • Customer Number
  • Client
  • I_CASHJOURNALPOSITION.CUSTOMERNUM == KNA1.KUNNR
  • I_CASHJOURNALPOSITION.MANDT == KNA1.MANDT
General Ledger Account
  • ?
  • General Ledger Account
  • Client
  • I_CASHJOURNALPOSITION.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_CASHJOURNALPOSITION.GLACCOUNT == SKA1.SAKNR
  • I_CASHJOURNALPOSITION.MANDT == SKA1.MANDT
Language Key I_CASHJOURNALPOSITION.LANGUAGE == T002.SPRAS
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • I_CASHJOURNALPOSITION.MANDT == LFA1.MANDT
  • I_CASHJOURNALPOSITION.SUPPLIER == LFA1.LIFNR
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • Client
  • I_CASHJOURNALPOSITION.[column in domain "KALSM_D"] == T007A.KALSM
  • I_CASHJOURNALPOSITION.TAXCODE == T007A.MWSKZ
  • I_CASHJOURNALPOSITION.MANDT == T007A.MANDT