FIRUD_ACC_CNTRCT

Transparent Table Application Table
13 Fields 1 CDS Views

Contracts in Accounting

FIRUD_ACC_CNTRCT is an SAP database table in S/4HANA. Contracts in Accounting. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_FinancialContract view from BASIC Interface view for Contracts in Accounting

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY companycode bukrs Company Code
KEY businesspartnercontract firu_intcntnum Int. Contract Number
businesspartnercontractext firu_extcntnum Ext. Contract Number
contractstartdate firu_cnt_startdat Contract Start Date
contractenddate firu_cnt_enddat Contract End Date
customer kunnr Customer
supplier lifnr Supplier
comments firu_comment Comment
creationdatetime timestampl Time Stamp
createdbyuser uname User Name
lastchangedatetime timestampl Time Stamp
lastchangebyusername uname User Name

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.

-- Contracts in Accounting
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIRUD_ACC_CNTRCT (
    CLIENT,                      -- Client [mandt]
    COMPANYCODE,                 -- Company Code [bukrs]
    BUSINESSPARTNERCONTRACT,     -- Int. Contract Number [firu_intcntnum]
    BUSINESSPARTNERCONTRACTEXT,  -- Ext. Contract Number [firu_extcntnum]
    CONTRACTSTARTDATE,           -- Contract Start Date [firu_cnt_startdat]
    CONTRACTENDDATE,             -- Contract End Date [firu_cnt_enddat]
    CUSTOMER,                    -- Customer [kunnr]
    SUPPLIER,                    -- Supplier [lifnr]
    COMMENTS,                    -- Comment [firu_comment]
    CREATIONDATETIME,            -- Time Stamp [timestampl]
    CREATEDBYUSER,               -- User Name [uname]
    LASTCHANGEDATETIME,          -- Time Stamp [timestampl]
    LASTCHANGEBYUSERNAME,        -- User Name [uname]
    PRIMARY KEY (CLIENT, COMPANYCODE, BUSINESSPARTNERCONTRACT)
);

Learn More