JNTRECH SAP (IS-M/SD: Research) Table details
Dictionary Type: Table
Description: IS-M/SD: Research
Description: IS-M/SD: Research
Table field list including key, data, relationships and ABAP select examples
JNTRECH is a standard SAP Table which is used to store IS-M/SD: Research data and is available within R/3 SAP systems depending on the version and release level.
The JNTRECH table consists of various fields, each holding specific information or linking keys about IS-M/SD: Research data available in SAP. These include RENR (IS-M: Research Number), GEPRE (IS-M: Researcher), VSGES (Researcher's Service Company), REART (IS-M: Research Type).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP JNTRECH table 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
RENR | IS-M: Research Number | RECHERNR | NUMC | 10 | RECHERNR | JN2 | |||
GEPRE | IS-M: Researcher | GPRECH | CHAR | 10 | Assigned to domain | ALPHA | GPNR | MJG0R | |
VSGES | Researcher's Service Company | VSGRCHEUR | CHAR | 10 | Assigned to domain | ALPHA | GPNR | MJG0G | |
REART | IS-M: Research Type | RECHART | CHAR | 2 | TJN01 | RECHART | JN0 | ||
REDUA | IS-M: Research Method | RECHDART | CHAR | 2 | TJN03 | RECHDUART | JN1 | ||
AVNR | IS-M/SD: Publishing Sales Order | AVNR | CHAR | 10 | Assigned to domain | ALPHA | AVNR | JK1 | MJK1 |
POSNR | Sales Order Item | APNR | NUMC | 6 | Assigned to domain | APNR | |||
POSEX | External Item Number (Purchase Order Item) | POSEX_ISP | NUMC | 6 | POSEX_ISP | JK2 | |||
POSNR_UR | Original Item in Publishing Sales Order | APNR_UR | NUMC | 6 | Assigned to domain | APNR | |||
GP_AG | IS-M: Sold-to Party from Order Subject to Research | GP_AG | CHAR | 10 | Assigned to domain | ALPHA | GPNR | ||
REERG | Research Result | RECHERG | CHAR | 3 | TJN07 | RECHERG | |||
REERD | IS-M: Completion Date of Research | RECHERLDAT | DATS | 8 | DATUM | ||||
XSCRI | SAPscript text for internal comment | XSCRIPTI | CHAR | 1 | XFELD | ||||
XSCRE | SAPscript text for external comment | XSCRIPTE | CHAR | 1 | XFELD | ||||
REDAU | Duration of Research in Hours | RECHDAUER | TIMS | 6 | DAUERSTD4 | ||||
BEZRE | Carrier Route Subject to Research | BEZRKRCHRE | CHAR | 10 | JVTBEZIRK | ALPHA | BEZIRK | ||
REZUS | Carrier Subject to Research (Checked) | JZUSTRECH | CHAR | 10 | Assigned to domain | ALPHA | GPNR | MJG0Z | |
REVSG | Service Company Subject to Research | VSGRECHE | CHAR | 10 | Assigned to domain | ALPHA | GPNR | MJG0G | |
MAILN | Indicator: Send Mail when Restart Research | MAILNEU | CHAR | 1 | CHAR1 | ||||
MAILE | IS-M: Send mail on completion | MAILERL | CHAR | 1 | CHAR1 | ||||
LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | LOEVM_ISP | CHAR | 1 | XFELD | ||||
LOEKZ | Deletion Indicator for Master Data in Media Sales & Dist. | LOEKZ_ISP | CHAR | 1 | XFELD | ||||
XDIALOG | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
XRECHERLED | Checkbox: Research complete | XRECHERLED | CHAR | 1 | XFELD | ||||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVKOV | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | TVTA | SPART | SPA | C_SPART | |
RUECKGRUND | IS-M: Bank Return Reason | RUECKGRUND | CHAR | 3 | TJN09 | RUECKGRUND | |||
BANKAUSDAT | IS-M: Bank Statement Date | BANKAUSDAT | DATS | 8 | BANKAUSDAT | JFB | |||
BANKBELNR | IS-M: Bank Document Number for Bank Return | BANKBELNR | CHAR | 10 | CHAR10 | ||||
RUECKBETR | IS-M: Billing Amount for Bank Return | RUECKBETR | CURR | 13(2) | WERTV7 | ||||
ABWBETRAG | IS-M: Bank Return Amount | ABWBETRAG | CURR | 13(2) | WERTV7 | ||||
RUECKGEB | IS-M: Return Charge for Bank Return | RUECKGEB | CURR | 13(2) | WERTV7 | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
BANKS | Bank country key | BANKS | CHAR | 3 | T005 | LAND1 | BKL | ||
BANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
BANKN | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BKONT | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
VBELN | IS-M/SD: Billing Document | ISPVBELN | CHAR | 10 | JFRK | ALPHA | ISPVBELN | VF | MJF0 |
GPNR_REGUL | IS-M: Business Partner Number Payer | GPNR_REGUL | CHAR | 10 | Assigned to domain | ALPHA | GPNR | ||
BELNR_SAMM | IS-M: Document Number for Coll.Transfer of Automatic Debit | BELNR_SAMM | CHAR | 10 | ALPHA | BELNR | |||
BELNRRUECK | IS-M: Accounting Document Number for Bank Returns | BELNRRUECK | CHAR | 10 | ALPHA | BELNR | |||
XERNEZ | IS-M: Repeat Automatic Debit (Bank Return) | XERNEZ | CHAR | 1 | XFELD | ||||
XOPERZ | IS-M: Generate Open Item (Bank Return) | XOPERZ | CHAR | 1 | XFELD | ||||
XFKTSTORNO | IS-M: Reverse Billing Document (Bank Return) | XFKTSTORNO | CHAR | 1 | XFELD | ||||
ZWSCHL | IS-M: Payment Method (Bank Returns) | JZWSCHL | CHAR | 1 | TJK42 | ZLSCH | |||
STOGRD | IS-M: Billing Document Reversal Reason | JSTOGRDF | CHAR | 3 | TJF27 | JSTOGRDF | |||
XFKTINDEX | IS-M: Set up Billing Index for Reversed Billing Document | XFKTINDEX | CHAR | 1 | XFELD | ||||
ISPUEBNR | IS-M: Number of Transfer Run to FI | ISPUEBNR | CHAR | 10 | Assigned to domain | ALPHA | ISPUEBNR | ||
XNOMESS | IS-M: Indicator - Do Not Perform Output Determination | XNOMESS | CHAR | 1 | XFELD | ||||
XRECHDRUCK | IS-M: Print Invoice (Bank Returns) | XRECHDRKBR | CHAR | 1 | XFELD | ||||
XEZERDEL | Indicator: Delete Collection Authorization | XEZERDEL | CHAR | 1 | XFELD | ||||
XEZER | Indicator: Is there collection authorization ? | XEZER | CHAR | 1 | XFELD | ||||
ERFUSER | Created By | ERFUSER | CHAR | 12 | USNAM | ||||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
ERFTIME | Time Created | ERFTIME | TIMS | 6 | UZEIT | ||||
AENUSER | Last Changed By | AENUSER | CHAR | 12 | USNAM | ||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
AENTIME | Time of Last Change | AENTIME | TIMS | 6 | UZEIT | ||||
XZUGAUFTR | IS-M: Success research for order | XZUGAUFTR | CHAR | 1 | XFELD | ||||
XABGAUFTR | IS-M: Order failure research | XABGAUFTR | CHAR | 1 | XFELD | ||||
XVRTBEZIRK | Ad pre-print zone | XVRTBEZIRK | CHAR | 1 | XFELD | ||||
XTITBEZIRK | Carrier route | XTITBEZIRK | CHAR | 1 | XFELD | ||||
XBLGBEZIRK | Insert zone | XBLGBEZIRK | CHAR | 1 | XFELD | ||||
XBANKRUECK | IS-M: Checkbox for bank return research | XBANKRUECK | CHAR | 1 | XFELD | ||||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RFBSK | IS-M: Status for Transfer to FI (Bank Returns) | RFBSK_BR | CHAR | 1 | RFBSK_BR | ||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN |
Key field | Non-key field |
How do I retrieve data from SAP table JNTRECH using ABAP code
The following ABAP code Example will allow you to do a basic selection on JNTRECH to SELECT all data from the tableDATA: WA_JNTRECH TYPE JNTRECH.
SELECT SINGLE *
FROM JNTRECH
INTO CORRESPONDING FIELDS OF WA_JNTRECH
WHERE...
How to access SAP table JNTRECH
Within an ECC or HANA version of SAP you can also view further information about JNTRECH 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