1. SAP Tutorial
  2. FI Module

TCJ_CPD SAP table for – FBCJ: One-Time Account Data of Cash Journal Document Items

Here we would like to draw your attention to TCJ_CPD table in SAP. As we know it is being mainly used with the SAP FI-GL (General Ledger Accounting in FI) component which is coming under FI module (Financial Accounting). TCJ_CPD is a SAP standard transp table used for storing FBCJ: One-Time Account Data of Cash Journal Document Items related data in SAP. It comes under the package CAJO.

SAP TCJ_CPD table

Table TCJ_CPD technical data

TableTCJ_CPD
Data storingFBCJ: One-Time Account Data of Cash Journal Document Items
ModuleFI
Sub ModuleFI-GL-GL-AP
SAP PackageCAJO
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP TCJ_CPD Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in TCJ_CPD table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • COMP_CODE : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • CAJO_NUMBER : Cash Journal Number
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • FISC_YEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • POSTING_NUMBER : Cash Journal Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • POSITION_NUMBER : Number of Line Item within Cash Journal Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : Financial Accounting: One-Time Account Data without Pointer
  • NAME1 : Name 1
    Its data type is CHAR (Character String) with field length 35
  • NAME2 : Name 2
    Its data type is CHAR (Character String) with field length 35
  • NAME3 : Name 3
    Its data type is CHAR (Character String) with field length 35
  • NAME4 : Name 4
    Its data type is CHAR (Character String) with field length 35
  • PSTLZ : Postal Code
    Its data type is CHAR (Character String) with field length 10
  • ORT01 : City
    Its data type is CHAR (Character String) with field length 35
  • LAND1 : Country Key
    Its data type is CHAR (Character String) with field length 3
  • STRAS : House number and street
    Its data type is CHAR (Character String) with field length 35
  • PFACH : PO Box
    Its data type is CHAR (Character String) with field length 10
  • PSTL2 : P.O. Box Postal Code
    Its data type is CHAR (Character String) with field length 10
  • PSKTO : Account Number of Bank Account At Post Office
    Its data type is CHAR (Character String) with field length 16
  • BANKN : Bank account number
    Its data type is CHAR (Character String) with field length 18
  • BANKL : Bank number
    Its data type is CHAR (Character String) with field length 15
  • BANKS : Bank country key
    Its data type is CHAR (Character String) with field length 3
  • STCD1 : Tax Number 1
    Its data type is CHAR (Character String) with field length 16
  • STCD2 : Tax Number 2
    Its data type is CHAR (Character String) with field length 11
  • STKZU : Liable for VAT
    Its data type is CHAR (Character String) with field length 1
  • STKZA : Indicator: Business Partner Subject to Equalization Tax?
    Its data type is CHAR (Character String) with field length 1
  • REGIO : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • BKONT : Bank Control Key
    Its data type is CHAR (Character String) with field length 2
  • DTAWS : Instruction key for data medium exchange
    Its data type is CHAR (Character String) with field length 2
  • DTAMS : Report key for data medium exchange
    Its data type is CHAR (Character String) with field length 1
  • XCPDK : Indicator: Is the account a one-time account?
    Its data type is CHAR (Character String) with field length 1
  • EMPFG : Payee code
    Its data type is CHAR (Character String) with field length 16
  • SPRAS : Character field of length 1
    Its data type is CHAR (Character String) with field length 1
  • FITYP : Tax type
    Its data type is CHAR (Character String) with field length 2
  • STCDT : Tax Number Type
    Its data type is CHAR (Character String) with field length 2
  • STKZN : Natural Person
    Its data type is CHAR (Character String) with field length 1
  • STCD3 : Tax Number 3
    Its data type is CHAR (Character String) with field length 18
  • STCD4 : Tax Number 4
    Its data type is CHAR (Character String) with field length 18
  • BKREF : Reference specifications for bank details
    Its data type is CHAR (Character String) with field length 20
  • J_1KFREPRE : Name of Representative
    Its data type is CHAR (Character String) with field length 10
  • J_1KFTBUS : Type of Business
    Its data type is CHAR (Character String) with field length 30
  • J_1KFTIND : Type of Industry
    Its data type is CHAR (Character String) with field length 30
  • ANRED : Title
    Its data type is CHAR (Character String) with field length 15

    • TCJ_CPD related tables

    • TCJ_DOCUMENTS : Cash Journal Documents (Header Data)
    • TCJ_CHECK_STACKS : Check Lists in Cash Journal
    • TCJ_NUMB_GROUP : Numbering Group for Cash Documents
    • TCJ_CPD : FBCJ: One-Time Account Data of Cash Journal Document Items
    • TCJ_CJ_NAMES : Cash Journal Names
    • TCJ_NUMB_GROUPT : Numbering Group for Cash Documents (Text)
    • TCJ_WTAX_ITEMS : Withholding Tax Items for Cash Journal Document Items
    • TCJ_C_JOURNALS : Cash Journals
    • TCJ_MAX_AMOUNT : Cash Journal: Amount Limit
    • TCJ_PRINT : Cash Journal Print Parameters
    • TCJ_TRANSACTIONS : Cash Journal Business Transactions
    • TCJ_POSITIONS : Cash Journal Document Items
    • TCJ_TRANS_NAMES : Cash Journal Business Transaction Names

    TCJ_CPD related transaction codes under SAP package CAJO

    • FBCJC5 : Maintain Numb. Groups for Cash Docs
    • FBCJC1 : Cash Journal Document Number Range
    • FBCJC3 : C FI Maintain Tables TCJ_PRINT
    • FBCJ : Cash Journal
    • FBCJC0 : C FI Maintain Tables TCJ_C_JOURNALS
    • FBCJ3 : Display Cash Journal
    • FBCJC2 : C FI Maint. Tables TCJ_TRANSACTIONS
    • FBCJC6 : Number range maintenance: CAJO_DOC3

    Related References

    Related Tutorials

    TCJ_WTAX_ITEMS SAP table for – Withholding Tax Items for Cash Journal Document Items

    TCJ_WTAX_ITEMS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Withholding...

    FBCJ SAP tcode for – Cash Journal

    FBCJ tcode in SAP FI (General Ledger Accounting in FI) module. This transaction code is used for Cash Journal. See...

    TCJ_POSITIONS SAP table for – Cash Journal Document Items

    TCJ_POSITIONS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Cash...

    TCJ_DOCUMENTS SAP table for – Cash Journal Documents (Header Data)

    TCJ_DOCUMENTS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Cash...

    TCJ_TRANSACTIONS SAP table for – Cash Journal Business Transactions

    TCJ_TRANSACTIONS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Cash...

    FBCJC1 SAP tcode for – Cash Journal Document Number Range

    FBCJC1 tcode in SAP FI (General Ledger Accounting in FI) module. This transaction code is used for Cash Journal Document...

    TCJ_CHECK_STACKS SAP table for – Check Lists in Cash Journal

    TCJ_CHECK_STACKS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Check...

    «
    »