- Home
- Resources
- SAP Tables
- EPPM_QS1_QS5 - Complete Structure for Forms QS1 and QS5
SAP Table EPPM_QS1_QS5
Complete Structure for Forms QS1 and QS5
EPPM_QS1_QS5 (Complete Structure for Forms QS1 and QS5) 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 EPPM_QS1_QS5 to other SAP tables.
Source: EPPM_QS1_QS5 (Complete Structure for Forms QS1 and QS5)
EPPM_QS1_QS5 table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
|
CLNT |
|
3 |
0 |
|
| PP_NR |
Prepayment Document Number |
E_PP_NR |
|
CHAR |
|
12 |
0 |
|
| PP_ZEILE |
Prepayment Document Line |
E_PP_ZEILE |
|
NUMC |
|
6 |
0 |
|
| DEBT_CONS |
Energy Debts |
E_PP_DEBT_CONS |
|
CURR |
|
13 |
2 |
|
| DEBT_NON_CONS |
Non-Energy Debts |
E_PP_DEBT_NON_CONS |
|
CURR |
|
13 |
2 |
|
| AMOUNT_CONS |
Adjustment of Energy Debts |
E_PP_AMOUNT_CONS |
|
CURR |
|
13 |
2 |
|
| AMOUNT_NO_CONS |
Adjustment of Non-Energy Debts |
E_PP_AMOUNT_NO_CONS |
|
CURR |
|
13 |
2 |
|
| CREDIT_VALUE |
Customer Credit |
E_PP_AMOUNT_CREDIT |
|
CURR |
|
13 |
2 |
|
| PAY_AMOUNT |
Credit Memo |
E_PP_PAY_AMOUNT |
|
CURR |
|
13 |
2 |
|
| PAYDATE |
Payment Date |
E_PP_PAYDATE |
|
DATS |
|
8 |
0 |
|
| TRANSFER_DATE |
Entered On |
E_PP_TRANSFERDATE |
|
DATS |
|
8 |
0 |
|
| TRANSFER_TIME |
Transfer Time of Data Record |
E_PP_TRANSFERTIME |
|
TIMS |
|
6 |
0 |
|
| TWAERS |
Transaction Currency |
TWAERS |
|
CUKY |
|
5 |
0 |
|
| RR_OUTLETID |
Business Partner ID of Outlet |
E_PP_OUTLETID |
|
CHAR |
|
12 |
0 |
|
| DEBT_ACTION |
Transaction Description |
E_DEBT |
|
CHAR |
|
1 |
0 |
Possible values
| 1 |
Initialization Process |
| 2 |
Reinitialize Meter |
| 3 |
Change Meter Data |
| 4 |
Transmission from Meter |
| 5 |
Resending |
|
| DEBT_STATUS |
Document Status |
E_PP_STATUS |
|
CHAR |
|
2 |
0 |
Possible values
| 01 |
Entered |
| 02 |
Locked (Must Be Released) |
| 03 |
Released |
| 04 |
Index Cannot Be Written |
| 05 |
Index Was Written |
| 06 |
IDoc Was Created |
| 07 |
Saved |
|
| PRIORITY |
Log Send Priority |
E_PP_PRIORITY |
|
CHAR |
|
1 |
0 |
Possible values
| 1 |
Urgent |
| 2 |
Non Urgent |
| 3 |
1 Hour |
| 4 |
Recorded Delivery |
|
| REASON |
Reason for Creating Data on a PPM |
E_PP_REASON |
|
CHAR |
|
1 |
0 |
Possible values
| 1 |
New Prepayment Meter Installation |
| 2 |
Change of Tenancy |
| 3 |
Change of Supplier |
| 4 |
Prepayment Meter Change |
|
| CHARGEABLE |
Charging Status |
E_PP_CHARGEABLE |
|
CHAR |
|
1 |
0 |
Possible values
| C |
Chargeable |
| N |
Non-Chargeable |
| P |
Pre-Paid |
|
| CARD_REASON |
Reason for New Card |
E_PP_CARD_REASON |
|
CHAR |
|
1 |
0 |
Possible values
| S |
Stolen |
| C |
Card Not Delivered |
| D |
Damaged |
| F |
Faulty |
| L |
Lost |
| O |
Others |
|
| ADRNB |
Address number |
AD_ADDRNUM |
|
CHAR |
|
10 |
0 |
|
| JOB_NR |
Document Number |
E_PP_JOB_NR |
|
CHAR |
|
8 |
0 |
|
| ISSUE_TYPE |
Document Issue Type |
E_PP_ISSUE_TYPE |
|
CHAR |
|
1 |
0 |
Possible values
|
| NAME |
Employee's last name |
NAME |
|
CHAR |
|
35 |
0 |
|
| TARIFTYP |
Rate category |
TARIFTYP |
|
CHAR |
|
10 |
0 |
|
| WEEKLY_MIN |
Minimum Recovery Rate |
E_PP_WEEKLY_MIN |
|
CURR |
|
5 |
2 |
|
| RR_CONS |
Recovery Rate for Energy Debts |
E_RR_CONS |
|
CURR |
|
13 |
2 |
|
| RR_NON_CONS |
Recovery Rate for Non-Energy Debts |
E_RR_NON_CONS |
|
CURR |
|
13 |
2 |
|
| STATUS_TEXT |
Text, 40 Characters Long |
TEXT40 |
|
CHAR |
|
40 |
0 |
|
| ACTION_TEXT |
Text (30 Characters) |
TEXT30 |
|
CHAR |
|
30 |
0 |
|
| PRIORITY_TXT |
Text (10 Characters) |
TEXT10 |
|
CHAR |
|
10 |
0 |
|
| REASON_TEXT |
Text, 40 Characters Long |
TEXT40 |
|
CHAR |
|
40 |
0 |
|
| CHARGEABLE_TEXT |
Text Field |
TEXT50 |
|
CHAR |
|
50 |
0 |
|
| CARD_REASON_TEXT |
Text length 25 |
TEXT25 |
|
CHAR |
|
25 |
0 |
|
| ISSUE_TEXT |
Text (10 Characters) |
TEXT10 |
|
CHAR |
|
10 |
0 |
|
| SEND_DATE |
Scheduled Send Date of Accompanying IDOCs |
SEND_DATE |
|
DATS |
|
8 |
0 |
|
| LAST_RR |
Last Energy Recovery Rate Sent |
E_LAST_RR_CONS |
|
CURR |
|
13 |
2 |
|
| RR_TIME_TO |
To-Time |
E_EDMTIMETO |
|
TIMS |
|
6 |
0 |
|
| RR_TIME_FROM |
From-time |
E_EDMTIMEFROM |
|
TIMS |
|
6 |
0 |
|
