1. Home
  2. Resources
  3. SAP Tables
  4. J_3RCLRSEL - Vendor/customer open item auto clearing program structure

SAP Table J_3RCLRSEL

Vendor/customer open item auto clearing program structure

J_3RCLRSEL (Vendor/customer open item auto clearing program structure) 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 J_3RCLRSEL to other SAP tables.

Source: J_3RCLRSEL (Vendor/customer open item auto clearing program structure)

J_3RCLRSEL table fields

Field Data element Checktable Datatype Length Decimals
LINK Text field length 200 CHAR200 CHAR 200 0
KUNNR Customer Number KUNNR CHAR 10 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
BUKRS Company Code BUKRS CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BLDAT Document Date in Document BLDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
UMSKZ Special G/L Indicator UMSKZ CHAR 1 0
UMSKS Special G/L Transaction Type UMSKS CHAR 1 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
DMBTR Amount in Local Currency DMBTR CURR 13 2
WRBTR Amount in document currency WRBTR CURR 13 2
CLRNG Clearing currency amount J_3RCLRNG CURR 13 2
WAERS Currency Key WAERS CUKY 5 0
BEDG1 Criterion 1 BED1_F123 CHAR 30 0
BEDG2 Criterion 2 BED2_F123 CHAR 30 0
BEDG3 Criterion 3 BED3_F123 CHAR 30 0
BEDG4 Criterion 4 BED4_F123 CHAR 30 0
BEDG5 Criterion 5 BED5_F123 CHAR 30 0
DIFSUMMA Cleared J_3RCLEAR CURR 13 2
REBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
REBZZ Line Item in the Relevant Invoice REBZZ NUMC 3 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
REBZT Follow-On Document Type REBZT CHAR 1 0
SRTPR Individual, User-Defined Character CHAR0001 CHAR 1 0
QUANT Iteration quantity J_3RFCHAR3 CHAR 3 0
NUCLR Clearing document sequence number J_3RFCLRNUM CHAR 10 0
USTXT Document Header Text BKTXT CHAR 25 0
DE_CR Individual, User-Defined Character CHAR0001 CHAR 1 0
CLRPS Individual, User-Defined Character CHAR0001 CHAR 1 0
DSBLE Individual, User-Defined Character CHAR0001 CHAR 1 0
DSBBT Individual, User-Defined Character CHAR0001 CHAR 1 0
GJAHR Fiscal Year GJAHR NUMC 4 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
XZAHL Indicator: Is the posting key used in a payment transaction? XZAHL CHAR 1 0
X Yes
NULL No
XZAHR Indicator: Is the posting key used in a payment transaction? XZAHL CHAR 1 0
X Yes
NULL No
XZAHM Indicator: Is the posting key used in a payment transaction? XZAHL CHAR 1 0
X Yes
NULL No
BILDVAL Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0
HWAER Local Currency HWAER CUKY 5 0
CLWRS Clearing currency J_3RCLCUR CUKY 5 0
KURSF Exchange rate KURSF DEC 9 5
WWERT Translation Date WWERT_D DATS 8 0
KURSR Exchange rate KURSF DEC 9 5
KURSC Exchange rate KURSF DEC 9 5
DOCLR Document Number of the Clearing Document AUGBL CHAR 10 0
NAME1 Name 1 NAME1_GP CHAR 35 0
NAMEOLD Name 1 NAME1_GP CHAR 35 0
FLAG_FILL Individual, User-Defined Character CHAR0001 CHAR 1 0
HKONT General Ledger Account HKONT CHAR 10 0
XPROC Indicator FLAG_X CHAR 1 0
NULL Not Selected
X Selected
INTCNUM Internal Contract Number J_3RF_INTCNTNUM CHAR 18 0
EXTCNUM External Contract Number J_3RF_EXTCNTNUM CHAR 40 0
CNTDATE Contract Date J_3RF_CNTDAT DATS 8 0