TCJ_CPD

Transparent Table Application Table
42 Fields 1 CDS Views

FBCJ: One-Time Account Data of Cash Journal Document Items

TCJ_CPD is an SAP database table in S/4HANA. FBCJ: One-Time Account Data of Cash Journal Document Items. It contains 42 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CashJournalOneTimeAccount view from BASIC View for table TCJ_CPD

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY comp_code BUKRS Company Code
KEY cajo_number CJNR Cash Journal Number
KEY fisc_year GJAHR Fiscal Year
KEY posting_number CJBELNR Internal doc. number
KEY position_number CJBUZEI Item
name1 NAME1_GP Name
name2 NAME2_GP Name 2
name3 NAME3_GP Name 3
name4 NAME4_GP Name 4
pstlz PSTLZ Postal Code
ort01 ORT01_GP City
land1 LAND1_GP Country/Region Key
stras STRAS_GP Street
pfach PFACH PO Box
pstl2 PSTL2 PO Box PCode
pskto PSKTO Curr.Acct or Ref.No.
bankn BANKN Bank Account
bankl BANKL Bank Number
banks BANKS Bank Ctry/Reg.
stcd1 STCD1 Tax Number 1
stcd2 STCD2 Tax Number 2
stkzu STKZU Liable for VAT
stkza STKZA Equalizatn tax
regio REGIO Region
bkont BKONT Control Key
dtaws DTAWS Instruction Key
dtams DTAMS DME Rec. Code
xcpdk XCPDK One-time acct
empfg EMPFG Pmnt Recipient
spras CHAR_LG_01 CHAR1
fityp J_1AFITP_D Tax Type
stcdt J_1ATOID Tax number type
stkzn STKZN Natural person
stcd3 STCD3 Tax Number 3
stcd4 STCD4 Tax Number 4
bkref BKREF Reference
j_1kfrepre REPRES Rep's Name
j_1kftbus GESTYP Type of Business
j_1kftind INDTYP Type of Industry
anred ANRED Title
intad INTAD Clrk's internet

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- FBCJ: One-Time Account Data of Cash Journal Document Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCJ_CPD (
    MANDT,            -- Client [MANDT]
    COMP_CODE,        -- Company Code [BUKRS]
    CAJO_NUMBER,      -- Cash Journal Number [CJNR]
    FISC_YEAR,        -- Fiscal Year [GJAHR]
    POSTING_NUMBER,   -- Internal doc. number [CJBELNR]
    POSITION_NUMBER,  -- Item [CJBUZEI]
    NAME1,            -- Name [NAME1_GP]
    NAME2,            -- Name 2 [NAME2_GP]
    NAME3,            -- Name 3 [NAME3_GP]
    NAME4,            -- Name 4 [NAME4_GP]
    PSTLZ,            -- Postal Code [PSTLZ]
    ORT01,            -- City [ORT01_GP]
    LAND1,            -- Country/Region Key [LAND1_GP]
    STRAS,            -- Street [STRAS_GP]
    PFACH,            -- PO Box [PFACH]
    PSTL2,            -- PO Box PCode [PSTL2]
    PSKTO,            -- Curr.Acct or Ref.No. [PSKTO]
    BANKN,            -- Bank Account [BANKN]
    BANKL,            -- Bank Number [BANKL]
    BANKS,            -- Bank Ctry/Reg. [BANKS]
    STCD1,            -- Tax Number 1 [STCD1]
    STCD2,            -- Tax Number 2 [STCD2]
    STKZU,            -- Liable for VAT [STKZU]
    STKZA,            -- Equalizatn tax [STKZA]
    REGIO,            -- Region [REGIO]
    BKONT,            -- Control Key [BKONT]
    DTAWS,            -- Instruction Key [DTAWS]
    DTAMS,            -- DME Rec. Code [DTAMS]
    XCPDK,            -- One-time acct [XCPDK]
    EMPFG,            -- Pmnt Recipient [EMPFG]
    SPRAS,            -- CHAR1 [CHAR_LG_01]
    FITYP,            -- Tax Type [J_1AFITP_D]
    STCDT,            -- Tax number type [J_1ATOID]
    STKZN,            -- Natural person [STKZN]
    STCD3,            -- Tax Number 3 [STCD3]
    STCD4,            -- Tax Number 4 [STCD4]
    BKREF,            -- Reference [BKREF]
    J_1KFREPRE,       -- Rep's Name [REPRES]
    J_1KFTBUS,        -- Type of Business [GESTYP]
    J_1KFTIND,        -- Type of Industry [INDTYP]
    ANRED,            -- Title [ANRED]
    INTAD,            -- Clrk's internet [INTAD]
    PRIMARY KEY (MANDT, COMP_CODE, CAJO_NUMBER, FISC_YEAR, POSTING_NUMBER, POSITION_NUMBER)
);

Learn More