HRFPM_FPM_POS

Transparent Table Application Table
53 Fields 1 CDS Views

HRFPM: FPM Documents - Items

HRFPM_FPM_POS is an SAP database table in S/4HANA. HRFPM: FPM Documents - Items. It contains 53 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
HRFPM_CDS_FPM_POS view from CDS View von HRFPM_FPM_POS

Fields (53)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY plvar PLVAR Plan version
KEY otype OTYPE Object type
KEY objid OBJEKTID Object ID
KEY enc_type HRFPM_ENC_TYPE Designation Type
KEY datbi ENDDA End Date
KEY endda_key ENDDA End Date
KEY fpm_posnr HRFPM_FPM_POSNR Item
plvar_dp PLVAR Plan version
otype_dp OTYPE Object type
objid_dp OBJEKTID Object ID
enc_type_dp HRFPM_ENC_TYPE Designation Type
datbi_dp ENDDA End Date
endda_key_dp ENDDA End Date
fpm_posnr_dp HRFPM_FPM_POSNR Item
enc_type_mp HRFPM_ENC_TYPE Designation Type
belnr_mp HRFPM_FPM_DOCNR Document Number
fpm_posnr_mp HRFPM_FPM_POSNR Item
begda BEGDA Start Date
endda ENDDA End Date
betrg BPREP_REQ_AMOUNT Amount
waers WAERS Currency
erlkz KBLERLKZ Item Completed
due_date HRFPM_DUE_DATE Due Date
perio PFREQ Time unit
saknr SAKNR G/L Account
bukrs BUKRS Company Code
kokrs KOKRS CO Area
kostl KOSTL Cost Center
aufnr AUFNR Order
posnr PS_PSP_PNR WBS Element
nplnr NPLNR Network
vornr VORNR Activity
grant_nbr GM_GRANT_NBR Grant
geber BP_GEBER Fund
budget_pd FM_BUDGET_PERIOD Budget Period
fkber FKBER Functional Area
fistl FISTL Funds Center
fipex FM_FIPEX Commitment Item
gsber GSBER Business Area
segmt FB_SEGMENT Segment
negative_cmmtnt HRFPM_FM_POS_NEGATIVE Negative Cmmt
payarea ABKRS Payroll area
flexdim HRFPM_FLEX_DIM Addnl Dimension
status HRFPM_FPM_STATUS Posting Status
delta_amount BPREP_REQUIRED_AMOUNT Flagged Change
currency WAERS Currency
db_action HRFPM_FPM_POS_DB_ACTION Action on Database
request_id HRFPM_CHANGE_REQUEST_ID ID
closed HRFPM_CLOSED_INDICATOR Completed
costitem HCP_COSTITEM Cost Item
begdafor BEGDA Start Date
enddafor ENDDA 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.

-- HRFPM: FPM Documents - Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFPM_FPM_POS (
    MANDT,            -- Client [MANDT]
    PLVAR,            -- Plan version [PLVAR]
    OTYPE,            -- Object type [OTYPE]
    OBJID,            -- Object ID [OBJEKTID]
    ENC_TYPE,         -- Designation Type [HRFPM_ENC_TYPE]
    DATBI,            -- End Date [ENDDA]
    ENDDA_KEY,        -- End Date [ENDDA]
    FPM_POSNR,        -- Item [HRFPM_FPM_POSNR]
    PLVAR_DP,         -- Plan version [PLVAR]
    OTYPE_DP,         -- Object type [OTYPE]
    OBJID_DP,         -- Object ID [OBJEKTID]
    ENC_TYPE_DP,      -- Designation Type [HRFPM_ENC_TYPE]
    DATBI_DP,         -- End Date [ENDDA]
    ENDDA_KEY_DP,     -- End Date [ENDDA]
    FPM_POSNR_DP,     -- Item [HRFPM_FPM_POSNR]
    ENC_TYPE_MP,      -- Designation Type [HRFPM_ENC_TYPE]
    BELNR_MP,         -- Document Number [HRFPM_FPM_DOCNR]
    FPM_POSNR_MP,     -- Item [HRFPM_FPM_POSNR]
    BEGDA,            -- Start Date [BEGDA]
    ENDDA,            -- End Date [ENDDA]
    BETRG,            -- Amount [BPREP_REQ_AMOUNT]
    WAERS,            -- Currency [WAERS]
    ERLKZ,            -- Item Completed [KBLERLKZ]
    DUE_DATE,         -- Due Date [HRFPM_DUE_DATE]
    PERIO,            -- Time unit [PFREQ]
    SAKNR,            -- G/L Account [SAKNR]
    BUKRS,            -- Company Code [BUKRS]
    KOKRS,            -- CO Area [KOKRS]
    KOSTL,            -- Cost Center [KOSTL]
    AUFNR,            -- Order [AUFNR]
    POSNR,            -- WBS Element [PS_PSP_PNR]
    NPLNR,            -- Network [NPLNR]
    VORNR,            -- Activity [VORNR]
    GRANT_NBR,        -- Grant [GM_GRANT_NBR]
    GEBER,            -- Fund [BP_GEBER]
    BUDGET_PD,        -- Budget Period [FM_BUDGET_PERIOD]
    FKBER,            -- Functional Area [FKBER]
    FISTL,            -- Funds Center [FISTL]
    FIPEX,            -- Commitment Item [FM_FIPEX]
    GSBER,            -- Business Area [GSBER]
    SEGMT,            -- Segment [FB_SEGMENT]
    NEGATIVE_CMMTNT,  -- Negative Cmmt [HRFPM_FM_POS_NEGATIVE]
    PAYAREA,          -- Payroll area [ABKRS]
    FLEXDIM,          -- Addnl Dimension [HRFPM_FLEX_DIM]
    STATUS,           -- Posting Status [HRFPM_FPM_STATUS]
    DELTA_AMOUNT,     -- Flagged Change [BPREP_REQUIRED_AMOUNT]
    CURRENCY,         -- Currency [WAERS]
    DB_ACTION,        -- Action on Database [HRFPM_FPM_POS_DB_ACTION]
    REQUEST_ID,       -- ID [HRFPM_CHANGE_REQUEST_ID]
    CLOSED,           -- Completed [HRFPM_CLOSED_INDICATOR]
    COSTITEM,         -- Cost Item [HCP_COSTITEM]
    BEGDAFOR,         -- Start Date [BEGDA]
    ENDDAFOR,         -- End Date [ENDDA]
    PRIMARY KEY (MANDT, PLVAR, OTYPE, OBJID, ENC_TYPE, DATBI, ENDDA_KEY, FPM_POSNR)
);

Learn More