SAP table EPPM_QS1_QS5 (Complete Structure for Forms QS1 and QS5)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
PP_NR Prepayment Document Number CHAR 12 0 E_PP_NR
PP_ZEILE Prepayment Document Line NUMC 6 0 E_PP_ZEILE
DEBT_CONS Energy Debts CURR 13 2 E_PP_DEBT_CONS
DEBT_NON_CONS Non-Energy Debts CURR 13 2 E_PP_DEBT_NON_CONS
AMOUNT_CONS Adjustment of Energy Debts CURR 13 2 E_PP_AMOUNT_CONS
AMOUNT_NO_CONS Adjustment of Non-Energy Debts CURR 13 2 E_PP_AMOUNT_NO_CONS
CREDIT_VALUE Customer Credit CURR 13 2 E_PP_AMOUNT_CREDIT
PAY_AMOUNT Credit Memo CURR 13 2 E_PP_PAY_AMOUNT
PAYDATE Payment Date DATS 8 0 E_PP_PAYDATE
TRANSFER_DATE Entered On DATS 8 0 E_PP_TRANSFERDATE
TRANSFER_TIME Transfer Time of Data Record TIMS 6 0 E_PP_TRANSFERTIME
TWAERS Transaction Currency CUKY 5 0 * TWAERS
RR_OUTLETID Business Partner ID of Outlet CHAR 12 0 E_PP_OUTLETID
DEBT_ACTION Transaction Description CHAR 1 0 E_DEBT
DEBT_STATUS Document Status CHAR 2 0 E_PP_STATUS
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 CHAR 1 0 E_PP_PRIORITY
1 Urgent
2 Non Urgent
3 1 Hour
4 Recorded Delivery
REASON Reason for Creating Data on a PPM CHAR 1 0 E_PP_REASON
1 New Prepayment Meter Installation
2 Change of Tenancy
3 Change of Supplier
4 Prepayment Meter Change
CHARGEABLE Charging Status CHAR 1 0 E_PP_CHARGEABLE
C Chargeable
N Non-Chargeable
P Pre-Paid
CARD_REASON Reason for New Card CHAR 1 0 E_PP_CARD_REASON
C Card Not Delivered
D Damaged
F Faulty
L Lost
O Others
S Stolen
ADRNB Address Number CHAR 10 0 * AD_ADDRNUM
JOB_NR Document Number CHAR 8 0 E_PP_JOB_NR
ISSUE_TYPE Document Issue Type CHAR 1 0 E_PP_ISSUE_TYPE
G Card
O OCU
NAME Employee's last name CHAR 35 0 NAME
TARIFTYP Rate category CHAR 10 0 TARIFTYP
WEEKLY_MIN Minimum Recovery Rate CURR 5 2 E_PP_WEEKLY_MIN
RR_CONS Recovery Rate for Energy Debts CURR 13 2 E_RR_CONS
RR_NON_CONS Recovery Rate for Non-Energy Debts CURR 13 2 E_RR_NON_CONS
STATUS_TEXT Text, 40 Characters Long CHAR 40 0 TEXT40
ACTION_TEXT Text (30 Characters) CHAR 30 0 TEXT30
PRIORITY_TXT Text (10 Characters) CHAR 10 0 TEXT10
REASON_TEXT Text, 40 Characters Long CHAR 40 0 TEXT40
CHARGEABLE_TEXT Text Field CHAR 50 0 TEXT50
CARD_REASON_TEXT Text length 25 CHAR 25 0 TEXT25
ISSUE_TEXT Text (10 Characters) CHAR 10 0 TEXT10
SEND_DATE Scheduled Send Date of Accompanying IDOCs DATS 8 0 SEND_DATE
LAST_RR Last Sent Energy Recovery Rate CURR 13 2 E_LAST_RR_CONS
RR_TIME_TO To-Time TIMS 6 0 E_EDMTIMETO
RR_TIME_FROM From-time TIMS 6 0 E_EDMTIMEFROM