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