SAP ABAP Table GGREFP (Example for Global FI-SL Line Items (Plan))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
GBAS (Package) FI-SL Customizing / integration / Basis
⤷
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | GGREFP |
|
| Short Description | Example for Global FI-SL Line Items (Plan) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
GU_RECID | OBJNR | CHAR | 18 | 0 | Record number of the line item record | ||
| 3 | |
RLDNR | RLDNR | CHAR | 2 | 0 | Ledger | T881 | |
| 4 | |
RRCTY | RRCTY | CHAR | 1 | 0 | Record Type | ||
| 5 | |
RVERS | RVERS | CHAR | 3 | 0 | Version | T894 | |
| 6 | |
GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
| 7 | |
RTCUR | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
| 8 | |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
| 9 | |
SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
| 10 | |
RPMAX | RPMAX | NUMC | 3 | 0 | Period | ||
| 11 | |
DOCCT | DOCCT | CHAR | 1 | 0 | Document Type | ||
| 12 | |
BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
| 13 | |
DOCLN6 | DOCLN6 | CHAR | 6 | 0 | Six-Character Posting Item for Ledger | ||
| 14 | |
RCOMP_D | RCOMP | CHAR | 6 | 0 | Company | T880 | |
| 15 | |
OBUKR | BUKRS | CHAR | 4 | 0 | Original company code | T001 | |
| 16 | |
RACCT | SAKNR | CHAR | 10 | 0 | Account Number | * | |
| 17 | |
GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
| 18 | |
KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
| 19 | |
FKBER | FKBER | CHAR | 16 | 0 | Functional Area | TFKB | |
| 20 | |
LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | TBDLS | |
| 21 | |
PCOMP | RCOMP | CHAR | 6 | 0 | Sender global company | T880 | |
| 22 | |
POBUKRS | BUKRS | CHAR | 4 | 0 | Original company code | T001 | |
| 23 | |
PRACCT | SAKNR | CHAR | 10 | 0 | Partner account number | * | |
| 24 | |
PPARGB | GSBER | CHAR | 4 | 0 | Trading Partner Business Area of the Business Partner | TGSB | |
| 25 | |
PKOSTL | KOSTL | CHAR | 10 | 0 | Partner cost center | * | |
| 26 | |
SFKBER | FKBER | CHAR | 16 | 0 | Partner Functional Area | TFKB | |
| 27 | |
TSLVT9 | WERTV9 | CURR | 17 | 2 | Balance carried forward in transaction currency | ||
| 28 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 29 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 30 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 31 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 32 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 33 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 34 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 35 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 36 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 37 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 38 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 39 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 40 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 41 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 42 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 43 | |
TSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in transaction currency | ||
| 44 | |
HSLVT9 | WERTV9 | CURR | 17 | 2 | Balance carried forward in local currency | ||
| 45 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 46 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 47 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 48 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 49 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 50 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 51 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 52 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 53 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 54 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 55 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 56 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 57 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 58 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 59 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 60 | |
HSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in local currency | ||
| 61 | |
KSLVT9 | WERTV9 | CURR | 17 | 2 | Balance carried forward in group currency | ||
| 62 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 63 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 64 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 65 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 66 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 67 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 68 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 69 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 70 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 71 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 72 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 73 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 74 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 75 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 76 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 77 | |
KSLXX9 | WERTV9 | CURR | 17 | 2 | Total of transactions of the period in group currency | ||
| 78 | |
MSLVT | MENGV8 | QUAN | 15 | 3 | Balance carried forward of quantity | ||
| 79 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 80 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 81 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 82 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 83 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 84 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 85 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 86 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 87 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 88 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 89 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 90 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 91 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 92 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 93 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 94 | |
MSLXX | MENGV8 | QUAN | 15 | 3 | Total of the transactions of period in units of measure | ||
| 95 | |
ASLVT | MENGV8 | QUAN | 15 | 3 | Balance carried forward of additional quantity | ||
| 96 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 97 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 98 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 99 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 100 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 101 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 102 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 103 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 104 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 105 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 106 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 107 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 108 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 109 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 110 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 111 | |
ASLXX | MENGV8 | QUAN | 15 | 3 | Total of transactions of period in additional quantities | ||
| 112 | |
AUNIT | MEINS | UNIT | 3 | 0 | Additional unit of measure | T006 | |
| 113 | |
SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
| 114 | |
DOCTY | DOCTY | CHAR | 2 | 0 | FI-SL Document Type | T889 | |
| 115 | |
GLVOR | CHAR4 | CHAR | 4 | 0 | Business Transaction | ||
| 116 | |
BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
| 117 | |
WSDAT | DATUM | DATS | 8 | 0 | Value Date for Currency Translation | ||
| 118 | |
REFBELNR | BELNR | CHAR | 10 | 0 | Reference document number of an accounting document | ||
| 119 | |
REFGJAHR | GJAHR | NUMC | 4 | 0 | Reference fiscal year | ||
| 120 | |
REFBUZEI6 | BUZEI6 | NUMC | 6 | 0 | Six-digit number of the reference posting line | ||
| 121 | |
REFDOCCT | DOCCT | CHAR | 1 | 0 | Reference document category | ||
| 122 | |
REFGLVOR | CHAR4 | CHAR | 4 | 0 | FI-SL Business Reference Transaction | ||
| 123 | |
CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
| 124 | |
CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
| 125 | |
USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
| 126 | |
AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | TTYP | |
| 127 | |
AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | GGREFP | AUNIT | |
|
REF | C | CN |
| 2 | GGREFP | AWTYP | |
|
REF | C | CN |
| 3 | GGREFP | DOCTY | |
|
REF | C | CN |
| 4 | GGREFP | LOGSYS | |
|
REF | C | CN |
| 5 | GGREFP | RBUSA | |
|
REF | C | CN |
| 6 | GGREFP | RCLNT | |
|
KEY | 1 | CN |
| 7 | GGREFP | RCOMP | |
|
REF | C | CN |
| 8 | GGREFP | RFAREA | |
|
REF | C | CN |
| 9 | GGREFP | RLDNR | |
|
REF | C | CN |
| 10 | GGREFP | ROBUKRS | |
|
REF | C | CN |
| 11 | GGREFP | RTCUR | |
|
REF | C | CN |
| 12 | GGREFP | RUNIT | |
|
REF | C | CN |
| 13 | GGREFP | RVERS | |
|
REF | C | CN |
| 14 | GGREFP | SBUSA | |
|
REF | C | CN |
| 15 | GGREFP | SCOMP | |
|
REF | C | CN |
| 16 | GGREFP | SFAREA | |
|
REF | C | CN |
| 17 | GGREFP | SOBUKRS | |
|
REF | C | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |