J_3RCLRSEL SAP (Vendor/customer open item auto clearing program structure) Structure details

Dictionary Type: Structure
Description: Vendor/customer open item auto clearing program structure




ABAP Code to SELECT data from J_3RCLRSEL
Related tables to J_3RCLRSEL
Access table J_3RCLRSEL




Structure field list including key, data, relationships and ABAP select examples

J_3RCLRSEL is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Vendor/customer open item auto clearing program structure" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_J_3RCLRSEL TYPE J_3RCLRSEL.

The J_3RCLRSEL table consists of various fields, each holding specific information or linking keys about Vendor/customer open item auto clearing program structure data available in SAP. These include KUNNR (Customer Numbers), LIFNR (Account Number of Vendor or Creditor), BUKRS (Company Code), BELNR (Accounting Document Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP J_3RCLRSEL structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
LINKText field length 200 CHAR200CHAR200CHAR200
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BLDATDocument Date in Document BLDATDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
UMSKSSpecial G/L Transaction Type UMSKSCHAR1UMSKS
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
DMBTRAmount in Local Currency DMBTRCURR13(2) WERT7
WRBTRAmount in document currency WRBTRCURR13(2) WERT7
CLRNGClearing currency amount J_3RCLRNGCURR13(2) WERT7
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
BEDG1Criterion 1 BED1_F123CHAR30Assigned to domainFDNAME
BEDG2Criterion 2 BED2_F123CHAR30Assigned to domainFDNAME
BEDG3Criterion 3 BED3_F123CHAR30Assigned to domainFDNAME
BEDG4Criterion 4 BED4_F123CHAR30Assigned to domainFDNAME
BEDG5Criterion 5 BED5_F123CHAR30Assigned to domainFDNAME
DIFSUMMACleared J_3RCLEARCURR13(2) WERT7
REBZGNumber of the Invoice the Transaction Belongs to REBZGCHAR10ALPHABELNR
REBZZLine Item in the Relevant Invoice REBZZNUMC3BUZEI
REBZJFiscal Year of the Relevant Invoice (for Credit Memo) REBZJNUMC4GJAHRGJAHR
REBZTFollow-On Document Type REBZTCHAR1REBZT
SRTPRIndividual, User-Defined Character CHAR0001CHAR1CHAR0001
QUANTIteration quantity J_3RFCHAR3CHAR3J_3RFCHAR3
NUCLRClearing document sequence number J_3RFCLRNUMCHAR10J_3RFCLRNUM
USTXTDocument Header Text BKTXTCHAR25TEXT25
DE_CRIndividual, User-Defined Character CHAR0001CHAR1CHAR0001
CLRPSIndividual, User-Defined Character CHAR0001CHAR1CHAR0001
DSBLEIndividual, User-Defined Character CHAR0001CHAR1CHAR0001
DSBBTIndividual, User-Defined Character CHAR0001CHAR1CHAR0001
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
KOARTAccount Type KOARTCHAR1KOART
XZAHLIndicator: Is the posting key used in a payment transaction? XZAHLCHAR1XFELD
XZAHRIndicator: Is the posting key used in a payment transaction? XZAHLCHAR1XFELD
XZAHMIndicator: Is the posting key used in a payment transaction? XZAHLCHAR1XFELD
BILDVALNot More Closely Defined Area, Possibly Used for Patchlevels CHAR4CHAR4CHAR4
HWAERLocal Currency HWAERCUKY5Assigned to domainWAERS
CLWRSClearing currency J_3RCLCURCUKY5Assigned to domainWAERS
KURSFExchange rate KURSFDEC9(5) EXCRTKURSF
WWERTTranslation Date WWERT_DDATS8DATUM
KURSRExchange rate KURSFDEC9(5) EXCRTKURSF
KURSCExchange rate KURSFDEC9(5) EXCRTKURSF
DOCLRDocument Number of the Clearing Document AUGBLCHAR10ALPHABELNR
NAME1Name 1 NAME1_GPCHAR35NAME
NAMEOLDName 1 NAME1_GPCHAR35NAME
FLAG_FILLIndividual, User-Defined Character CHAR0001CHAR1CHAR0001
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
XPROCIndicator FLAG_XCHAR1CHAR1_X
INTCNUMInternal Contract Number J_3RF_INTCNTNUMCHAR18ZUONRJ_3RF_CNT_SH
EXTCNUMExternal Contract Number J_3RF_EXTCNTNUMCHAR40Assigned to domainJ_3RF_EXTCNTNUMJ_3RF_CNT_SH
CNTDATEContract Date J_3RF_CNTDATDATS8DATUM

Key field Non-key field



How do I retrieve data from SAP structure J_3RCLRSEL using ABAP code?

As J_3RCLRSEL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on J_3RCLRSEL as there is no data to select.

How to access SAP table J_3RCLRSEL

Within an ECC or HANA version of SAP you can also view further information about J_3RCLRSEL and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!