SAP ABAP Table JDTDRER (IS-M/SD: Publications)

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	JDTDRER	Table Relationship Diagram
Short Description	IS-M/SD: Publications

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	DRERZ	☑	DRERZ	DRERZ	CHAR	8	0	Publication
3	BEZEI10	☐	KBEZDRERZ	TEXT10	CHAR	10	0	Short Text for Publication
4	BEZEI40	☐	BEZEI50	TEXT50	CHAR	50	0	Long Text
5	UTITEL1	☐	UTITEL	TEXT50	CHAR	50	0	Subtitle
6	UTITEL2	☐	UTITEL	TEXT50	CHAR	50	0	Subtitle
7	KZEIGFRE	☐	XDRERZFRE	XFELD	CHAR	1	0	Field is Inactive (Third-Party Publication)
8	GPNR	☐	GPNRVERLAG	GPNR	CHAR	10	0	IS-M: Business Partner Publisher	JGTGPNR
9	KZPOSTFORM	☐	KZPOSTFORM	KZPOSTFORM	CHAR	1	0	Postal format of publication/postcard/other object
10	DRUERZART	☐	DRUERZART	DRUERZART	CHAR	1	0	Publication Type	TJD17
11	TITELART	☐	TITELART	TITELART	NUMC	2	0	Title type	TJD01
12	SPART	☐	SPARTDRERZ	SPART	CHAR	2	0	Division for publication	TSPA
13	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
14	XMWSTABGR	☐	JXMWSTABGR	XFELD	CHAR	1	0	VAT to be accrued proportionally for payment in billing
15	PVALAST	☐	PVALAST	PVA	CHAR	8	0	Last edition number assigned for publication	JDTPVA
16	XLOESCHV	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
17	XLOESCHKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
18	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
19	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
20	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
21	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
22	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
23	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
24	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
25	XVAKONT	☐	JXVAKONTRG	XFELD	CHAR	1	0	Indicator: Additional Account Assignment at Issue Level
26	XPVAKONT	☐	JXPVAKONT	XFELD	CHAR	1	0	Indicator: Additional Account Assignment at Edition Level
27	XOHNEKONT	☐	JXOHNEKONT	XFELD	CHAR	1	0	Indicator: No Additional Account Assignment
28	XSOFORTVS	☐	JXSOFORTVS	XFELD	CHAR	1	0	Immediate shipping for backdated order
29	XMITLFGVS	☐	JXVSMITLFG	XFELD	CHAR	1	0	Indicator: Send with first normal delivery
30	XOHNERWVS	☐	JXOHNERWVS	XFELD	CHAR	1	0	Indicator: No backdated shipping for orders
31	XERSCHDAT	☐	XERSCHDAT	XFELD	CHAR	1	0	Display copy numbers in order with check
32	XHEFTNUM	☐	XJHEFTNUM	XFELD	CHAR	1	0	Display copy numbers in order without check
33	XKEINHEFT	☐	XJKEINHEFT	XFELD	CHAR	1	0	Hide Copy Numbers in Order
34	XMDATA_INR	☐	JX_MDATA_FOR_ISSUE_NR	XFELD	CHAR	1	0	IS-M: Product master data managed for copy number (obsolete)
35	PSREMIND	☐	PSREMIND	PSREMIND	CHAR	2	0	IS-M/SD: Product procedure for monitoring	TJD61
36	XVA_EXTERN	☐	JXVA_EXTERN	XFELD	CHAR	1	0	IS-M: Indicator - issues managed externally

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JDTDRER	DRUERZART	TJD17	DEART	REF	1	CN
2	JDTDRER	GPNR	JGTGPNR	GPNR	REF	C	CN
3	JDTDRER	MANDT	T000	MANDT	KEY	1	CN
4	JDTDRER	MATKL	T023	MATKL	REF	C	CN
5	JDTDRER	PSREMIND	TJD61	PSREMIND	REF	1	CN
6	JDTDRER	PVALAST	JDTPVA	PVA	KEY	1	CN
7	JDTDRER	SPART	TSPA	SPART	REF	1	CN
8	JDTDRER	TITELART	TJD01	TITELART	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in