SAP table GMBDGTLINE (Budget Document Line)
SAP table GMBDGTLINE has 3 primary key fields being CLIENT,BDGT_DOC_NBR,LINE.
Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
BDGT_DOC_NBR | Budget Document Number | CHAR | 10 | 0 | GMBDGTHEADER | GM_BDGT_DOC_NBR | |||||||
LINE | GM Budget Line | CHAR | 6 | 0 | GM_LINE | ||||||||
GRANT_NBR | Grant | CHAR | 20 | 0 | GMGR | GM_GRANT_NBR | |||||||
BDGT_VLDTY_NBR | Budget Validity Number | CHAR | 3 | 0 | GM_BDGT_VLDTY_NBR | ||||||||
SPONSORED_PROG | Sponsored Program | CHAR | 20 | 0 | GMSPPROGRAM | GM_SPONSORED_PROG | |||||||
SPONSORED_CLASS | Sponsored Class | CHAR | 20 | 0 | GMSPCLASS | GM_SPONSORED_CLASS | |||||||
FIN_OBJECT_TYPE | Financing Object Type | CHAR | 1 | 0 | GM_FINANCING_OBJECT_TYPE |
|
|||||||
FINANCING_OBJECT | Financing Object (Internal Number) | CHAR | 22 | 0 | * | GM_FINANCING_OBJECT | |||||||
FUND | Fund | CHAR | 10 | 0 | * | FM_FUND | |||||||
AMOUNT | Budget amount in transaction currency | CURR | 17 | 2 | TVALXX9 | ||||||||
PERC_IDC | Indirect Overhead Rate | DEC | 6 | 3 | GM_INDIRECT_RATE | ||||||||
AMOUNT_IDC | Budget amount in transaction currency | CURR | 17 | 2 | TVALXX9 | ||||||||
TOTAL_AWARD | Budget amount in transaction currency | CURR | 17 | 2 | TVALXX9 | ||||||||
PERC_CSH | GM Cost Sharing rate | DEC | 5 | 2 | GM_CSTSHRNG_RATE | ||||||||
AMOUNT_CSH | Budget amount in transaction currency | CURR | 17 | 2 | TVALXX9 | ||||||||
TOTAL_AMOUNT | Budget amount in transaction currency | CURR | 17 | 2 | TVALXX9 | ||||||||
TEXT | Item Text | CHAR | 50 | 0 | SGTXT | ||||||||
PROCESS | Process | CHAR | 4 | 0 | * | GM_BUDGET_PROCESS | |||||||
VALUETYPE | GM Value Type | CHAR | 2 | 0 | GMVALUETYPE | GM_VALUETYPE | |||||||
POSTING_DATE | Posting Date in the Document | DATS | 8 | 0 | BUDAT | ||||||||
GRANTEE_FY | Fiscal Year for Grantee Organization | NUMC | 4 | 0 | GM_GRANTEE_FY | ||||||||
CLASS_TYPE | Sponsored Class Type | CHAR | 1 | 0 | GM_CLASS_TYPE |
|
|||||||
SIGN | Sign for Line | CHAR | 1 | 0 | GM_LINE_SIGN |
|
|||||||
PARTNER_LINE | GM Budget Line | CHAR | 6 | 0 | GM_LINE | ||||||||
MATERIAL | Material Number | CHAR | 40 | 0 | * | MATNR | |||||||
UNIT_OF_MEASURE | Purchase Order Unit of Measure | UNIT | 3 | 0 | * | BSTME | |||||||
QUANTITY | Purchase Order Quantity | QUAN | 13 | 3 | BSTMG | ||||||||
PRICE_PER_UNIT | Net Price in Purchasing Document (in Document Currency) | CURR | 11 | 2 | BPREI |
GMBDGTLINE foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 GMBDGTLINE | BDGT_DOC_NBR | GMBDGTHEADER | Budget Document Header | CLIENT |
0 GMBDGTLINE | BDGT_DOC_NBR | GMBDGTHEADER | Budget Document Header | BDGT_DOC_NBR |
1 GMBDGTLINE | GRANT_NBR | GMGR | Grant Master | GRANT_NBR |
0 GMBDGTLINE | SPONSORED_CLASS | GMSPCLASS | Sponsored Class Master | CLIENT |
0 GMBDGTLINE | SPONSORED_CLASS | GMSPCLASS | Sponsored Class Master | SPONSORED_CLASS |
1 GMBDGTLINE | SPONSORED_PROG | GMSPPROGRAM | Sponsored program master | CLIENT |
1 GMBDGTLINE | SPONSORED_PROG | GMSPPROGRAM | Sponsored program master | SPONSORED_PROG |
0 GMBDGTLINE | VALUETYPE | GMVALUETYPE | Value Type definition | VALUE_TYPE |