SAP ABAP Table JNTRECH (IS-M/SD: Research)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	JNTRECH	Table Relationship Diagram
Short Description	IS-M/SD: Research

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	RENR	☑	RECHERNR	RECHERNR	NUMC	10	0	IS-M: Research Number
3	GEPRE	☐	GPRECH	GPNR	CHAR	10	0	IS-M: Researcher	*
4	VSGES	☐	VSGRCHEUR	GPNR	CHAR	10	0	Researcher's Service Company	*
5	REART	☐	RECHART	RECHART	CHAR	2	0	IS-M: Research Type	TJN01
6	REDUA	☐	RECHDART	RECHDUART	CHAR	2	0	IS-M: Research Method	TJN03
7	AVNR	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
8	POSNR	☐	APNR	APNR	NUMC	6	0	Sales Order Item	*
9	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
10	POSNR_UR	☐	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	*
11	GP_AG	☐	GP_AG	GPNR	CHAR	10	0	IS-M: Sold-to Party from Order Subject to Research	*
12	REERG	☐	RECHERG	RECHERG	CHAR	3	0	Research Result	TJN07
13	REERD	☐	RECHERLDAT	DATUM	DATS	8	0	IS-M: Completion Date of Research
14	XSCRI	☐	XSCRIPTI	XFELD	CHAR	1	0	SAPscript text for internal comment
15	XSCRE	☐	XSCRIPTE	XFELD	CHAR	1	0	SAPscript text for external comment
16	REDAU	☐	RECHDAUER	DAUERSTD4	TIMS	6	0	Duration of Research in Hours
17	BEZRE	☐	BEZRKRCHRE	BEZIRK	CHAR	10	0	Carrier Route Subject to Research	JVTBEZIRK
18	REZUS	☐	JZUSTRECH	GPNR	CHAR	10	0	Carrier Subject to Research (Checked)	*
19	REVSG	☐	VSGRECHE	GPNR	CHAR	10	0	Service Company Subject to Research	*
20	MAILN	☐	MAILNEU	CHAR1	CHAR	1	0	Indicator: Send Mail when Restart Research
21	MAILE	☐	MAILERL	CHAR1	CHAR	1	0	IS-M: Send mail on completion
22	LOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
23	LOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
24	XDIALOG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
25	XRECHERLED	☐	XRECHERLED	XFELD	CHAR	1	0	Checkbox: Research complete
26	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
27	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
28	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
29	RUECKGRUND	☐	RUECKGRUND	RUECKGRUND	CHAR	3	0	IS-M: Bank Return Reason	TJN09
30	BANKAUSDAT	☐	BANKAUSDAT	BANKAUSDAT	DATS	8	0	IS-M: Bank Statement Date
31	BANKBELNR	☐	BANKBELNR	CHAR10	CHAR	10	0	IS-M: Bank Document Number for Bank Return
32	RUECKBETR	☐	RUECKBETR	WERTV7	CURR	13	2	IS-M: Billing Amount for Bank Return
33	ABWBETRAG	☐	ABWBETRAG	WERTV7	CURR	13	2	IS-M: Bank Return Amount
34	RUECKGEB	☐	RUECKGEB	WERTV7	CURR	13	2	IS-M: Return Charge for Bank Return
35	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
36	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
37	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
38	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
39	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
40	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
41	VBELN	☐	ISPVBELN	ISPVBELN	CHAR	10	0	IS-M/SD: Billing Document	JFRK
42	GPNR_REGUL	☐	GPNR_REGUL	GPNR	CHAR	10	0	IS-M: Business Partner Number Payer	*
43	BELNR_SAMM	☐	BELNR_SAMM	BELNR	CHAR	10	0	IS-M: Document Number for Coll.Transfer of Automatic Debit
44	BELNRRUECK	☐	BELNRRUECK	BELNR	CHAR	10	0	IS-M: Accounting Document Number for Bank Returns
45	XERNEZ	☐	XERNEZ	XFELD	CHAR	1	0	IS-M: Repeat Automatic Debit (Bank Return)
46	XOPERZ	☐	XOPERZ	XFELD	CHAR	1	0	IS-M: Generate Open Item (Bank Return)
47	XFKTSTORNO	☐	XFKTSTORNO	XFELD	CHAR	1	0	IS-M: Reverse Billing Document (Bank Return)
48	ZWSCHL	☐	JZWSCHL	ZLSCH	CHAR	1	0	IS-M: Payment Method (Bank Returns)	TJK42
49	STOGRD	☐	JSTOGRDF	JSTOGRDF	CHAR	3	0	IS-M: Billing Document Reversal Reason	TJF27
50	XFKTINDEX	☐	XFKTINDEX	XFELD	CHAR	1	0	IS-M: Set up Billing Index for Reversed Billing Document
51	ISPUEBNR	☐	ISPUEBNR	ISPUEBNR	CHAR	10	0	IS-M: Number of Transfer Run to FI	*
52	XNOMESS	☐	XNOMESS	XFELD	CHAR	1	0	IS-M: Indicator - Do Not Perform Output Determination
53	XRECHDRUCK	☐	XRECHDRKBR	XFELD	CHAR	1	0	IS-M: Print Invoice (Bank Returns)
54	XEZERDEL	☐	XEZERDEL	XFELD	CHAR	1	0	Indicator: Delete Collection Authorization
55	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
56	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
57	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
58	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
59	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
60	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
61	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
62	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
63	XZUGAUFTR	☐	XZUGAUFTR	XFELD	CHAR	1	0	IS-M: Success research for order
64	XABGAUFTR	☐	XABGAUFTR	XFELD	CHAR	1	0	IS-M: Order failure research
65	XVRTBEZIRK	☐	XVRTBEZIRK	XFELD	CHAR	1	0	Ad pre-print zone
66	XTITBEZIRK	☐	XTITBEZIRK	XFELD	CHAR	1	0	Carrier route
67	XBLGBEZIRK	☐	XBLGBEZIRK	XFELD	CHAR	1	0	Insert zone
68	XBANKRUECK	☐	XBANKRUECK	XFELD	CHAR	1	0	IS-M: Checkbox for bank return research
69	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
70	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
71	RFBSK	☐	RFBSK_BR	RFBSK_BR	CHAR	1	0	IS-M: Status for Transfer to FI (Bank Returns)
72	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
73	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JNTRECH	BANKS	T005	LAND1
2	JNTRECH	BEZRE	JVTBEZIRK	BEZIRK	REF	C	CN
3	JNTRECH	BUKRS	T001	BUKRS	REF	1	CN
4	JNTRECH	MANDT	T000	MANDT	KEY	1	CN
5	JNTRECH	REART	TJN01	RECHART	REF	1	CN
6	JNTRECH	REDUA	TJN03	REDART	REF	1	CN
7	JNTRECH	REERG	TJN07	RECHERG	REF	1	CN
8	JNTRECH	RUECKGRUND	TJN09	RUECKGRUND
9	JNTRECH	SPART	TVTA	SPART	KEY	1	CN
10	JNTRECH	STOGRD	TJF27	STOGRD
11	JNTRECH	VBELN	JFRK	VBELN
12	JNTRECH	VKORG	TVKO	VKORG	KEY	1	CN
13	JNTRECH	VTWEG	TVKOV	VTWEG	KEY	1	CN
14	JNTRECH	WAERK	TCURC	WAERS
15	JNTRECH	ZWSCHL	TJK42	ZLSCH		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in