FIAAGEND_FRMNUM

Transparent Table Application Table

Fixed Asset Form Numbers - the log of numbers assigned

FIAAGEND_FRMNUM is an SAP database table in S/4HANA. Fixed Asset Form Numbers - the log of numbers assigned. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FixedAssetFormNumber view from BASIC Fixed Asset Form Numbers

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY frm_type fiaagen_frm_type Form Type
KEY comp_code bukrs Company Code
KEY asset_no anln1 Asset
KEY asset_subno anln2 Sub-number
KEY accountingdocument belnr_d Document Number
KEY fiscalyear gjahr Fiscal Year
KEY valid_to_date bdatu Valid To
KEY reporting_entity srf_reporting_entity Reporting Entity
KEY rep_cat_id srf_rep_cat_id Report ID
KEY report_run_id srf_report_run_id Report Run ID
frm_number fiaagen_frm_number Form Number
srf_db_key /bobf/conf_key NodeID

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.

-- Fixed Asset Form Numbers - the log of numbers assigned
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIAAGEND_FRMNUM (
    CLIENT,              -- Client [mandt]
    FRM_TYPE,            -- Form Type [fiaagen_frm_type]
    COMP_CODE,           -- Company Code [bukrs]
    ASSET_NO,            -- Asset [anln1]
    ASSET_SUBNO,         -- Sub-number [anln2]
    ACCOUNTINGDOCUMENT,  -- Document Number [belnr_d]
    FISCALYEAR,          -- Fiscal Year [gjahr]
    VALID_TO_DATE,       -- Valid To [bdatu]
    REPORTING_ENTITY,    -- Reporting Entity [srf_reporting_entity]
    REP_CAT_ID,          -- Report ID [srf_rep_cat_id]
    REPORT_RUN_ID,       -- Report Run ID [srf_report_run_id]
    FRM_NUMBER,          -- Form Number [fiaagen_frm_number]
    SRF_DB_KEY,          -- NodeID [/bobf/conf_key]
    PRIMARY KEY (CLIENT, FRM_TYPE, COMP_CODE, ASSET_NO, ASSET_SUBNO, ACCOUNTINGDOCUMENT, FISCALYEAR, VALID_TO_DATE, REPORTING_ENTITY, REP_CAT_ID, REPORT_RUN_ID)
);