J_3RCOPSDK SAP (Open Item Data for Clearing Transactions G/L) Structure details
Description: Open Item Data for Clearing Transactions G/L
Structure field list including key, data, relationships and ABAP select examples
J_3RCOPSDK 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 "Open Item Data for Clearing Transactions G/L" 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_3RCOPSDK TYPE J_3RCOPSDK.
The J_3RCOPSDK table consists of various fields, each holding specific information or linking keys about Open Item Data for Clearing Transactions G/L data available in SAP. These include BUKRS (Company Code), GJAHR (Fiscal Year), WAERS (Currency Key), XBLNR (Reference 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: Can be enhanced (character-type or numeric)
SAP J_3RCOPSDK 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 |
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
BLART | Document Type | BLART | CHAR | 2 | Assigned to domain | BLART | BAR | ||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BSCHL | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
ZFBDT | Base date for calculation of term of payment | J_3RCDZFBDT | DATS | 8 | DATUM | ||||
ZUONR | Assignment number | J_3RCDZUONR | CHAR | 18 | ZUONR | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
PROJK | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
VERZG | Calculated Days in Arrears | VERZG | DEC | 5 | WRTV3 | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
CCBTC | Payment cards: Settlement run | CCBTC | CHAR | 10 | ALPHA | CCBTC | |||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
BUPLA | Business place | J_3RCBUPLA | CHAR | 4 | CHAR4 | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | Assigned to domain | UMSKZ | |||
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | Assigned to domain | QSSKZ | |||
ZTERM | Terms of payment key | J_3RCDZTERM | CHAR | 4 | ZTERM | ||||
ZBD1T | Cash discount days 1 | J_3RCDZBD1T | DEC | 3 | ZBDXT | ||||
ZBD2T | Cash discount days 2 | J_3RCDZBD2T | DEC | 3 | ZBDXT | ||||
ZBD3T | Net Payment Terms Period | J_3RCDZBD3T | DEC | 3 | ZBDXT | ||||
ZBD1P | Cash Discount Percentage 1 | J_3RCDZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD2P | Cash Discount Percentage 2 | J_3RCDZBD2P | DEC | 5(3) | PRZ23 | ||||
ZBFIX | Fixed Payment Terms | J_3RCDZBFIX | CHAR | 1 | ZBFIX | ||||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
SAMNR | Invoice List Number | SAMNR | NUMC | 8 | SAMNR | ||||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ANLN2 | New asset subnumber, 4 characters | ANLN2_4 | CHAR | 4 | ALPHA | ANLN2_4 | AN2 | ||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
ANFBN | Document Number of the Bill of Exchange Payment Request | ANFBN | CHAR | 10 | ALPHA | BELNR | |||
KONKO | Open item account number | KONKO | CHAR | 10 | ALPHA | MAXKK | |||
TOLER | Grace Days | TOLER_043G | NUMC | 2 | TOLER_043G | ||||
ZLSPR | Payment Block Key | J_3RCDZLSPR | CHAR | 1 | Assigned to domain | ZAHLS | SPE | ||
MANSP | Dunning block | MANSP | CHAR | 1 | Assigned to domain | MANSP | |||
MANST | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
RSTGR | Reason Code for Payments | RSTGR | CHAR | 3 | Assigned to domain | RSTGR | |||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | Assigned to domain | FIPOS | FIP | ||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
TOGRU | Tolerance group for the business partner/G/L account | TOGRU | CHAR | 4 | Assigned to domain | TOGRU | |||
VBEL2 | Sales Document | VBELN_VA | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
NETDT | Due Date for Net Payment | NETDT | DATS | 8 | DATUM | ||||
EMPFB | Payee/Payer | EMPFB | CHAR | 10 | ALPHA | MAXKK | |||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
ZLSCH | Payment method | J_3RCDZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
SECCO | Section code | J_3RCSECCO | CHAR | 4 | CHAR4 | ||||
PYCUR | Currency for Automatic Payment | J_3RCPYCUR | CUKY | 5 | Assigned to domain | WAERS | |||
PYAMT | Amount in Payment Currency | J_3RCPYAMT | CURR | 13(2) | WERT7 | ||||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN |
Key field | Non-key field |
How do I retrieve data from SAP structure J_3RCOPSDK using ABAP code?
As J_3RCOPSDK 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_3RCOPSDK as there is no data to select.How to access SAP table J_3RCOPSDK
Within an ECC or HANA version of SAP you can also view further information about J_3RCOPSDK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects