1. Home
  2. Resources
  3. SAP Tables
  4. RAIA1 - General structure for appropriation requests

SAP Table RAIA1

General structure for appropriation requests

RAIA1 (General structure for appropriation requests) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RAIA1 to other SAP tables.

RAIA1 table fields

Field Data element Checktable Datatype Length Decimals
POSNR Reference appropriation request IMA_RPOSNR CHAR 12 0
TXT50 Description of appropriation request IMA_TXT50 CHAR 50 0
HEAD1 Description of appropriation request IMA_TXT50 CHAR 50 0
SYSST System status line J_STEXT CHAR 40 0
ANWST User Status Line J_ATEXT CHAR 40 0
STA_FUNCT Pushbutton for status field for investment measures IMA_FUNCT CHAR 18 0
APOSNR Internal number for appropriation requests - 12 character IMA_APOSNR CHAR 12 0
PS_POSNR WBS element investment project IMA_IPOSNR NUMC 8 0
CO_AUFNR Order IMA_IAUFNR CHAR 12 0
KTEXT Description AUFTEXT CHAR 40 0
XABLEHN Rejection of variants of the appropriation request IMA_XABLEH CHAR 1 0
X Yes
NULL No
XGEN Approval field for appropriation requests IMA_XGEN CHAR 1 0
X Yes
NULL No
STA_DOWN Carrier field for icons ICON_TEXT CHAR 132 0
STA_UP Carrier field for icons ICON_TEXT CHAR 132 0
AUFT_GES Carrier field for icons ICON_TEXT CHAR 132 0
AUFT_KOST Carrier field for icons ICON_TEXT CHAR 132 0
AUFT_PRC Carrier field for icons ICON_TEXT CHAR 132 0
AUFT_IZW Carrier field for icons ICON_TEXT CHAR 132 0
AUFT_UMW Carrier field for icons ICON_TEXT CHAR 132 0
AUFT_WRG Carrier field for icons ICON_TEXT CHAR 132 0
AUFT_SPR Carrier field for icons ICON_TEXT CHAR 132 0
AUFT_VER Carrier field for icons ICON_TEXT CHAR 132 0
PROJ_AKT Carrier field for icons ICON_TEXT CHAR 132 0
ZUORD Parameters for copying versions - assign only IMA_ZUORD CHAR 1 0
X Yes
NULL No
CPYVAR Copy parameters - copy variant and assign IMA_CPYVAR CHAR 1 0
X Yes
NULL No
VTRVAR Copy parameters - copy variant + actual carry fwd amount IMA_VTRVAR CHAR 1 0
X Yes
NULL No
WI_DATRE Carrier field for icons ICON_TEXT CHAR 132 0
PR_POSNR Position number IM_POSNR NUMC 8 0
ALT_POSNR Internal number for appropriation request IMA_POSNR CHAR 12 0
ALT_TXT50 Description of appropriation request IMA_TXT50 CHAR 50 0
ALT_SYSST System status line J_STEXT CHAR 40 0
ALT_ANWST User Status Line J_ATEXT CHAR 40 0
AL_POSNR Assignment to original appropriation request IMA_AL_POSNR CHAR 12 0
AL_TXT50 Description of appropriation request IMA_TXT50 CHAR 50 0
PROJ_PSPID Project Definition PS_PSPID CHAR 24 0
PRPS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
XVORP_KZ Create measure as preliminary project without plan values IMA_XVORP_KZ CHAR 1 0
X Yes
NULL No
SYSST_L Status display with text for system status IMA_SYSTLONG CHAR 200 0
ANWST_L Status display with text for user status IMA_USERLONG CHAR 200 0
ZUORD_ANL Carrier field for icons ICON_TEXT CHAR 132 0
ZUORD_EQU Carrier field for icons ICON_TEXT CHAR 132 0
VAPLZ Main work center for maintenance tasks GEWRK CHAR 8 0
VAWRK Plant associated with main work center WERGW CHAR 4 0
VAPLZ_NOCHANGE Change of work center from customer exit IMA_VAPLZ_NOCHANGE CHAR 1 0
X Yes
NULL No
AUFT_IZWEK Distribution to reason for investment IMA_AUFT_IZWEK CHAR 1 0
X Yes
NULL No
AUFT_UMWKZ Distribution to environmental indicator IMA_AUFT_UMWKZ CHAR 1 0
X Yes
NULL No
AUFT_AGSBER Distribution to requesting business area IMA_AUFT_AGSBER CHAR 1 0
X Yes
NULL No
AUFT_AKOSTL Distribution to requesting cost center IMA_AUFT_AKOSTL CHAR 1 0
X Yes
NULL No
AUFT_APRCTR Distribution to requesting profit center IMA_AUFT_APRCTR CHAR 1 0
X Yes
NULL No
AUFT_ASPART Distribution to requesting division IMA_AUFT_ASPART CHAR 1 0
X Yes
NULL No
AUFT_AMATKL Distribution to requesting material group IMA_AUFT_AMATKL CHAR 1 0
X Yes
NULL No
AUFT_ANLN1 Distribution to asset IMA_AUFT_ANLN1 CHAR 1 0
X Yes
NULL No
AUFT_EQUNR Distribution to equipment IMA_AUFT_EQUNR CHAR 1 0
X Yes
NULL No
TREE_COMPRESS Carrier field for icons ICON_TEXT CHAR 132 0
POSID Appropriation Request Number (Formatted for Coding Mask) IMA_POSID CHAR 24 0
VARNT Variant of Appropriation Request IMA_VARNT CHAR 4 0
SYSST1 Object status J_TXT30 CHAR 30 0
SYSST2 Object status J_TXT30 CHAR 30 0
SYSST3 Object status J_TXT30 CHAR 30 0
SYSST4 Object status J_TXT30 CHAR 30 0
ANWST1 Object status J_TXT30 CHAR 30 0
ANWST2 Object status J_TXT30 CHAR 30 0
ANWST3 Object status J_TXT30 CHAR 30 0
ANWST4 Object status J_TXT30 CHAR 30 0
ANWST5 Object status J_TXT30 CHAR 30 0
STA_MNER Carrier field for icons ICON_TEXT CHAR 132 0
TRANSGROUP Master Data Transactions for Appropriation Requests IMA_TRANSGROUP TRANSGROUP0 CHAR 20 0
SYSST_VAR1 Object status J_TXT30 CHAR 30 0
SYSST_VAR2 Object status J_TXT30 CHAR 30 0
SYSST_VAR3 Object status J_TXT30 CHAR 30 0
SYSST_VAR4 Object status J_TXT30 CHAR 30 0
ANWST_VAR1 Object status J_TXT30 CHAR 30 0
ANWST_VAR2 Object status J_TXT30 CHAR 30 0
ANWST_VAR3 Object status J_TXT30 CHAR 30 0
ANWST_VAR4 Object status J_TXT30 CHAR 30 0
ANWST_VAR5 Object status J_TXT30 CHAR 30 0
PLAN_LOCK Carrier field for icons ICON_TEXT CHAR 132 0
FRAME_HEADER1 Text TXT50 CHAR 50 0
PS_VORLAGE Copy from project definition PS_VORLAGE CHAR 24 0
PS_VORSPSP Standard WBS to be copied PS_VORSPSP CHAR 24 0
COPY_PSP_DOC Copy Documents with WBS Elements COPY_PSP_DOC CHAR 1 0
X
NULL
PS_VORLAGE_TEXT PS: Short description (1st text line) PS_POST1 CHAR 40 0
PS_VORSPSP_TEXT PS: Short description (1st text line) PS_POST1 CHAR 40 0
CREATE_PROJ Carrier field for icons ICON_TEXT CHAR 132 0
NO_XVORP_KZ Checkbox XFELD CHAR 1 0
X Yes
NULL No
PLANPRZ Part of Plan Values That Should Be Transferred to Measure IMA_PLANPRZ DEC 3 0
COPY_PSP_MLST Indicator: Copy milestones FLG_CO_MLS CHAR 1 0
X
NULL

RAIA1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RAIA1 TRANSGROUP 'IM-FA-IA' TRANSGROUP0 Definition Table for Transaction Group APPLKEY
RAIA1 TRANSGROUP RAIA1 TRANSGROUP TRANSGROUP0 Definition Table for Transaction Group TRGROUP