SAP Table RLACCT

Returnable packaging account

RLACCT (Returnable packaging account) 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 RLACCT to other SAP tables.

RLACCT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
ACCTNO Returnable packaging account RL_ACCTNO CHAR 12 0
RET_MATNR Returnable packaging RL_RET_MATNR MARA CHAR 18 0
BUKRS Company Code BUKRS T001 CHAR 4 0
PRPSHPA Assignment ID of Main Partner Relationship RL_PRPSHPA RLPSHPA NUMC 12 0
PP_VALFROM Valid from date RL_VALFROM DATS 8 0
PP_VALTO Valid-to date RL_VALTO DATS 8 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
ACCTME Account Unit of Measure RL_ACCTME T006 UNIT 3 0
ROLEACM Role of location in account statement RL_ROLEACM CHAR 1 0
1 Customer
2 Vendor
ACCTBAL Current Account Balance in Base Unit of Measure RL_ACCTBAL QUAN 13 3
SEQNO Posting sequence number of returnable packaging account RL_SEQNO INT4 10 0
OTYPE Object type RL_OTYPE CHAR 2 0
OBJID Processor ID in organizational management RL_ACTORID CHAR 12 0
ACCTSTATE Returnable Packaging Account Status RL_ACCTSTATE CHAR 1 0
1 Active
2 Blocked
3 Marked for deletion
4 Marked for archiving
VKORG Sales organization RL_VKORG TVKO CHAR 4 0
VTWEG Distribution channel RL_VTWEG TVTW CHAR 2 0
NRART Type of partner number RL_NRART TVPA CHAR 2 0
PARNR Output Partner RL_PARNR CHAR 10 0
ACST_CTRL Statement control for returnable packaging account RL_ACST_CTRL CHAR 1 0
0 No statements
1 Statements are received
2 Statements are sent
CPCTRL Procedure for returnable packaging account matching RL_CPCTRL CHAR 1 0
0 No matching
1 Matching without matching groups
2 Matching only with matching groups
3 Matching with or without matching groups
ACST_CREATE_CTRL Control for Creation and Sending of RP Account Statements RL_ACST_CREATE_CTRL CHAR 1 0
A Creation and Sending via SWP
B Own Creation, Sending and Matching via SWP
C Creation by Partner; no Sending via SWP
D Creation by Partner, Sending via SWP
E Creation by Partner, Sending and Matching via SWP
KONNR Number of Outline Agreement RL_KONNR EKKO CHAR 10 0
KTPNR Item Number of Outline Agreement RL_KTPNR EKPO NUMC 5 0
PLANING Indicator Quantity Below Reorder Point Quantity RL_PLANING CHAR 1 0
X Yes
NULL No
PLANING_CTRL Planning Type for Returnable Packaging Account RL_PLANING_CTRL CHAR 1 0
NULL Acct. not active for planning, no display of open quantities
1 Acct. active for planning, no automatic PO order creation
2 Acct. active for planning, automatic PO order creation
REORDBAL Reorder Point Quantity in Base Unit of Quantity RL_REORDBAL QUAN 13 3
ORDQUAN Purchase Order Quantity in Base Unit of Quantity RL_ORDQUAN QUAN 13 3
REF_PURCH_DOC Reference Document for Purchasing Document RL_REFPURCH_DOC CHAR 10 0

RLACCT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RLACCT ACCTME RLACCT ACCTME T006 Units of Measurement MSEHI
RLACCT ACCTME RLACCT MANDT T006 Units of Measurement MANDT
RLACCT BUKRS RLACCT MANDT T001 Company Codes MANDT
RLACCT BUKRS RLACCT BUKRS T001 Company Codes BUKRS
RLACCT KONNR SYST MANDT EKKO Purchasing Document Header MANDT
RLACCT KONNR RLACCT KONNR EKKO Purchasing Document Header EBELN
RLACCT KTPNR SYST MANDT EKPO Purchasing Document Item MANDT
RLACCT KTPNR RLACCT KONNR EKPO Purchasing Document Item EBELN
RLACCT KTPNR RLACCT KTPNR EKPO Purchasing Document Item EBELP
RLACCT MEINS RLACCT MANDT T006 Units of Measurement MANDT
RLACCT MEINS RLACCT MEINS T006 Units of Measurement MSEHI
RLACCT NRART RLACCT NRART TVPA Partner: Partner Types (Entities) NRART
RLACCT NRART SYST MANDT TVPA Partner: Partner Types (Entities) MANDT
RLACCT PRPSHPA SYST MANDT RLPSHPA Assignments Relationship-Account MANDT
RLACCT PRPSHPA RLACCT PRPSHPA RLPSHPA Assignments Relationship-Account PSHPASS
RLACCT RET_MATNR RLACCT MANDT MARA General Material Data MANDT
RLACCT RET_MATNR RLACCT RET_MATNR MARA General Material Data MATNR
RLACCT VKORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
RLACCT VKORG RLACCT VKORG TVKO Organizational Unit: Sales Organizations VKORG
RLACCT VTWEG SYST MANDT TVTW Organizational Unit: Distribution Channels MANDT
RLACCT VTWEG RLACCT VTWEG TVTW Organizational Unit: Distribution Channels VTWEG