J_3RFCNT

Transparent Table Application Table
11 Fields 2 CDS Views

Maintain Internal Contract Numbers

J_3RFCNT is an SAP database table in S/4HANA. Maintain Internal Contract Numbers. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_KZ_BusinessPartnerContract view from BASIC Internal Contract Numbers
I_RU_ContractBasic view from BASIC Contract Accounting Russia basic

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY intcnum j_3rf_intcntnum Int. Contract Number
extcnum j_3rf_extcntnum Ext. Contract Number
cntdate j_3rf_cntdat Contract Date
cnttype j_3rf_cnttype Contr. Type
kunnr kunnr Customer
lifnr lifnr Supplier
comments j_3rf_cntcomm Contract Comments
src j_3rf_cntsrcty Source type
cnt_enddat j_3rs_cnt_enddat Contract End Date

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.

-- Maintain Internal Contract Numbers
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_3RFCNT (
    MANDT,       -- Client [mandt]
    BUKRS,       -- Company Code [bukrs]
    INTCNUM,     -- Int. Contract Number [j_3rf_intcntnum]
    EXTCNUM,     -- Ext. Contract Number [j_3rf_extcntnum]
    CNTDATE,     -- Contract Date [j_3rf_cntdat]
    CNTTYPE,     -- Contr. Type [j_3rf_cnttype]
    KUNNR,       -- Customer [kunnr]
    LIFNR,       -- Supplier [lifnr]
    COMMENTS,    -- Contract Comments [j_3rf_cntcomm]
    SRC,         -- Source type [j_3rf_cntsrcty]
    CNT_ENDDAT,  -- Contract End Date [j_3rs_cnt_enddat]
    PRIMARY KEY (MANDT, BUKRS, INTCNUM)
);

Learn More