SAP Table JDTDRER
IS-M/SD: Publications
JDTDRER (IS-M/SD: Publications) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link JDTDRER to other SAP tables.
JDTDRER table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||||
| DRERZ | Publication | DRERZ | CHAR | 8 | 0 | |||||||||||||||||||||||||
| BEZEI10 | Short Text for Publication | KBEZDRERZ | CHAR | 10 | 0 | |||||||||||||||||||||||||
| BEZEI40 | Long Text | BEZEI50 | CHAR | 50 | 0 | |||||||||||||||||||||||||
| UTITEL1 | Subtitle | UTITEL | CHAR | 50 | 0 | |||||||||||||||||||||||||
| UTITEL2 | Subtitle | UTITEL | CHAR | 50 | 0 | |||||||||||||||||||||||||
| KZEIGFRE | Field is Inactive (Third-Party Publication) | XDRERZFRE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| GPNR | IS-M: Business Partner Publisher | GPNRVERLAG | JGTGPNR | CHAR | 10 | 0 | ||||||||||||||||||||||||
| KZPOSTFORM | Postal format of publication/postcard/other object | KZPOSTFORM | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| DRUERZART | Publication Type | DRUERZART | TJD17 | CHAR | 1 | 0 | ||||||||||||||||||||||||
| TITELART | Title type | TITELART | TJD01 | NUMC | 2 | 0 | ||||||||||||||||||||||||
| SPART | Division for publication | SPARTDRERZ | TSPA | CHAR | 2 | 0 | ||||||||||||||||||||||||
| MATKL | Material Group | MATKL | T023 | CHAR | 9 | 0 | ||||||||||||||||||||||||
| XMWSTABGR | VAT to be accrued proportionally for payment in billing | JXMWSTABGR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| PVALAST | Last edition number assigned for publication | PVALAST | JDTPVA | CHAR | 8 | 0 | ||||||||||||||||||||||||
| XLOESCHV | Deletion Flag for Master Data in Media Sales & Distribution | LOEVM_ISP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| XLOESCHKZ | Deletion Indicator for Master Data in Media Sales & Dist. | LOEKZ_ISP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| ERFUSER | Created By | ERFUSER | CHAR | 12 | 0 | |||||||||||||||||||||||||
| ERFDATE | Created On | ERFDATE | DATS | 8 | 0 | |||||||||||||||||||||||||
| ERFTIME | Time Created | ERFTIME | TIMS | 6 | 0 | |||||||||||||||||||||||||
| AENUSER | Last Changed By | AENUSER | CHAR | 12 | 0 | |||||||||||||||||||||||||
| AENDATE | Date of Last Change | AENDATE | DATS | 8 | 0 | |||||||||||||||||||||||||
| AENTIME | Time of Last Change | AENTIME | TIMS | 6 | 0 | |||||||||||||||||||||||||
| XVAKONT | Indicator: Additional Account Assignment at Issue Level | JXVAKONTRG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| XPVAKONT | Indicator: Additional Account Assignment at Edition Level | JXPVAKONT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| XOHNEKONT | Indicator: No Additional Account Assignment | JXOHNEKONT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| XSOFORTVS | Immediate shipping for backdated order | JXSOFORTVS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| XMITLFGVS | Indicator: Send with first normal delivery | JXVSMITLFG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| XOHNERWVS | Indicator: No backdated shipping for orders | JXOHNERWVS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| XERSCHDAT | Display copy numbers in order with check | XERSCHDAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| XHEFTNUM | Display copy numbers in order without check | XJHEFTNUM | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| XKEINHEFT | Hide Copy Numbers in Order | XJKEINHEFT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| XMDATA_INR | IS-M: Product master data managed for copy number (obsolete) | JX_MDATA_FOR_ISSUE_NR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
| PSREMIND | IS-M/SD: Product procedure for monitoring | PSREMIND | TJD61 | CHAR | 2 | 0 | ||||||||||||||||||||||||
| XVA_EXTERN | IS-M: Indicator - issues managed externally | JXVA_EXTERN | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||
JDTDRER foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JDTDRER | DRUERZART | JDTDRER | MANDT | TJD17 | IS-M/SD: Publication Types | MANDT |
| JDTDRER | DRUERZART | JDTDRER | DRUERZART | TJD17 | IS-M/SD: Publication Types | DEART |
| JDTDRER | GPNR | JDTDRER | MANDT | JGTGPNR | IS-M: Central Business Partner Table | MANDT |
| JDTDRER | GPNR | JDTDRER | GPNR | JGTGPNR | IS-M: Central Business Partner Table | GPNR |
| JDTDRER | MANDT | JDTDRER | MANDT | T000 | Clients | MANDT |
| JDTDRER | MATKL | JDTDRER | MANDT | T023 | Material Groups | MANDT |
| JDTDRER | MATKL | JDTDRER | MATKL | T023 | Material Groups | MATKL |
| JDTDRER | PSREMIND | JDTDRER | MANDT | TJD61 | IS-M/SD: Product Procedure for Monitoring | MANDT |
| JDTDRER | PSREMIND | JDTDRER | PSREMIND | TJD61 | IS-M/SD: Product Procedure for Monitoring | PSREMIND |
| JDTDRER | PVALAST | JDTDRER | MANDT | JDTPVA | IS-M/SD: Editions | MANDT |
| JDTDRER | PVALAST | JDTDRER | DRERZ | JDTPVA | IS-M/SD: Editions | DRERZ |
| JDTDRER | PVALAST | JDTDRER | PVALAST | JDTPVA | IS-M/SD: Editions | PVA |
| JDTDRER | SPART | JDTDRER | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| JDTDRER | SPART | JDTDRER | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| JDTDRER | TITELART | JDTDRER | MANDT | TJD01 | IS-M/SD: Title Types | MANDT |
| JDTDRER | TITELART | JDTDRER | TITELART | TJD01 | IS-M/SD: Title Types | TITELART |
