SAP Table JJTDIEN
IS-M/AM: Service
JJTDIEN (IS-M/AM: Service) 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 JJTDIEN to other SAP tables.
JJTDIEN table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| MATNR | IS-M: Service material number | MATNR_DIEN | CHAR | 18 | 0 | |||||||
| DIENTYP | IS-M: Service Type | DIENTYP | TJH71 | CHAR | 4 | 0 | ||||||
| KTGRM | Account assignment group for this material | KTGRM | TVKM | CHAR | 2 | 0 | ||||||
| WAEHRUNG | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
| MTART | Material Type | MTART | T134 | CHAR | 4 | 0 | ||||||
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||
| LOEVM | Deletion Flag for Master Data in Media Sales & Distribution | LOEVM_ISP | CHAR | 1 | 0 |
Possible values
|
||||||
| LOEKZ | Deletion Indicator for Master Data in Media Sales & Dist. | LOEKZ_ISP | CHAR | 1 | 0 |
Possible values
|
||||||
| XSCRIPTE | SAPscript text for external comment | XSCRIPTE | CHAR | 1 | 0 |
Possible values
|
||||||
| CO_AUFNR | IS-M: Order No.of Internal CO Order for Account Assignment | JHCO_AUFNR | AUFK | CHAR | 12 | 0 | ||||||
| KOSTL | Cost Center | KOSTL | CSKS | CHAR | 10 | 0 | ||||||
| RK_AUFNR | Order Number of RK Order for Account Assignment | J_RK_AUFNR | CHAR | 8 | 0 | |||||||
| RK_POSNR | Item Number of RK Order for Account Assignment | J_RK_POSNR | NUMC | 2 | 0 | |||||||
| KOSTL_R2 | Cost center in R/2 | KOSTL_R2 | CHAR | 8 | 0 | |||||||
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 | 0 | ||||||
| KURZTEXT | IS-M: Short Text | BEZEICHN15 | CHAR | 15 | 0 | |||||||
| LANGTEXT | IS-M: Long Text | BEZEICHN50 | CHAR | 50 | 0 | |||||||
| 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 | |||||||
JJTDIEN foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JJTDIEN | CO_AUFNR | SYST | MANDT | AUFK | Order master data | MANDT |
| JJTDIEN | CO_AUFNR | JJTDIEN | CO_AUFNR | AUFK | Order master data | AUFNR |
| JJTDIEN | DIENTYP | JJTDIEN | MANDT | TJH71 | IS-M/AM: Service Type | MANDT |
| JJTDIEN | DIENTYP | JJTDIEN | DIENTYP | TJH71 | IS-M/AM: Service Type | DIENTYP |
| JJTDIEN | KOSTL | JJTDIEN | KOSTL | CSKS | Cost Center Master Data | KOSTL |
| JJTDIEN | KOSTL | * | CSKS | Cost Center Master Data | DATBI | |
| JJTDIEN | KOSTL | SYST | MANDT | CSKS | Cost Center Master Data | MANDT |
| JJTDIEN | KOSTL | * | CSKS | Cost Center Master Data | KOKRS | |
| JJTDIEN | KTGRM | JJTDIEN | MANDT | TVKM | Materials: Account Assignment Groups | MANDT |
| JJTDIEN | KTGRM | JJTDIEN | KTGRM | TVKM | Materials: Account Assignment Groups | KTGRM |
| JJTDIEN | MANDT | JJTDIEN | MANDT | T000 | Clients | MANDT |
| JJTDIEN | MEINS | JJTDIEN | MANDT | T006 | Units of Measurement | MANDT |
| JJTDIEN | MEINS | JJTDIEN | MEINS | T006 | Units of Measurement | MSEHI |
| JJTDIEN | MTART | JJTDIEN | MTART | T134 | Material Types | MTART |
| JJTDIEN | MTART | JJTDIEN | MANDT | T134 | Material Types | MANDT |
| JJTDIEN | PRCTR | JJTDIEN | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| JJTDIEN | PRCTR | * | CEPC | Profit Center Master Data Table | DATBI | |
| JJTDIEN | PRCTR | * | CEPC | Profit Center Master Data Table | KOKRS | |
| JJTDIEN | PRCTR | SYST | MANDT | CEPC | Profit Center Master Data Table | MANDT |
| JJTDIEN | WAEHRUNG | JJTDIEN | MANDT | TCURC | Currency Codes | MANDT |
| JJTDIEN | WAEHRUNG | JJTDIEN | WAEHRUNG | TCURC | Currency Codes | WAERS |
