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

Dictionary Type: Table
Description: IS-M/SD: Publications




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




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

JDTDRER is a standard SAP Table which is used to store IS-M/SD: Publications data and is available within R/3 SAP systems depending on the version and release level.

The JDTDRER table consists of various fields, each holding specific information or linking keys about IS-M/SD: Publications data available in SAP. These include DRERZ (Publication), BEZEI10 (Short Text for Publication), BEZEI40 (Long Text), UTITEL1 (Subtitle).. 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)


SAP JDTDRER 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
MANDTClient MANDTCLNT3T000MANDT
DRERZPublication DRERZCHAR8ALPHADRERZJD1MJD1
BEZEI10Short Text for Publication KBEZDRERZCHAR10TEXT10
BEZEI40Long Text BEZEI50CHAR50TEXT50
UTITEL1Subtitle UTITELCHAR50TEXT50
UTITEL2Subtitle UTITELCHAR50TEXT50
KZEIGFREField is Inactive (Third-Party Publication) XDRERZFRECHAR1XFELD
GPNRIS-M: Business Partner Publisher GPNRVERLAGCHAR10JGTGPNRALPHAGPNR
KZPOSTFORMPostal format of publication/postcard/other object KZPOSTFORMCHAR1KZPOSTFORM
DRUERZARTPublication Type DRUERZARTCHAR1TJD17DRUERZART
TITELARTTitle type TITELARTNUMC2TJD01TITELART
SPARTDivision for publication SPARTDRERZCHAR2TSPASPARTSPA
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
XMWSTABGRVAT to be accrued proportionally for payment in billing JXMWSTABGRCHAR1XFELD
PVALASTLast edition number assigned for publication PVALASTCHAR8JDTPVAALPHAPVA
XLOESCHVDeletion Flag for Master Data in Media Sales & Distribution LOEVM_ISPCHAR1XFELD
XLOESCHKZDeletion Indicator for Master Data in Media Sales & Dist. LOEKZ_ISPCHAR1XFELD
ERFUSERCreated By ERFUSERCHAR12USNAM
ERFDATECreated On ERFDATEDATS8DATUM
ERFTIMETime Created ERFTIMETIMS6UZEIT
AENUSERLast Changed By AENUSERCHAR12USNAM
AENDATEDate of Last Change AENDATEDATS8DATUM
AENTIMETime of Last Change AENTIMETIMS6UZEIT
XVAKONTIndicator: Additional Account Assignment at Issue Level JXVAKONTRGCHAR1XFELD
XPVAKONTIndicator: Additional Account Assignment at Edition Level JXPVAKONTCHAR1XFELD
XOHNEKONTIndicator: No Additional Account Assignment JXOHNEKONTCHAR1XFELD
XSOFORTVSImmediate shipping for backdated order JXSOFORTVSCHAR1XFELD
XMITLFGVSIndicator: Send with first normal delivery JXVSMITLFGCHAR1XFELD
XOHNERWVSIndicator: No backdated shipping for orders JXOHNERWVSCHAR1XFELD
XERSCHDATDisplay copy numbers in order with check XERSCHDATCHAR1XFELD
XHEFTNUMDisplay copy numbers in order without check XJHEFTNUMCHAR1XFELD
XKEINHEFTHide Copy Numbers in Order XJKEINHEFTCHAR1XFELD
XMDATA_INRIS-M: Product master data managed for copy number (obsolete) JX_MDATA_FOR_ISSUE_NRCHAR1XFELD
PSREMINDIS-M/SD: Product procedure for monitoring PSREMINDCHAR2TJD61PSREMIND
XVA_EXTERNIS-M: Indicator - issues managed externally JXVA_EXTERNCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table JDTDRER using ABAP code

The following ABAP code Example will allow you to do a basic selection on JDTDRER to SELECT all data from the table
DATA: WA_JDTDRER TYPE JDTDRER.

SELECT SINGLE *
FROM JDTDRER
INTO CORRESPONDING FIELDS OF WA_JDTDRER
WHERE...

How to access SAP table JDTDRER

Within an ECC or HANA version of SAP you can also view further information about JDTDRER 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!