JHATSTATTD SAP (IS-M/AM: Status/Characteristic Alignment from Technical Todo) Table details

Dictionary Type: Table
Description: IS-M/AM: Status/Characteristic Alignment from Technical Todo




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




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

JHATSTATTD is a standard SAP Table which is used to store IS-M/AM: Status/Characteristic Alignment from Technical Todo data and is available within R/3 SAP systems depending on the version and release level.

The JHATSTATTD table consists of various fields, each holding specific information or linking keys about IS-M/AM: Status/Characteristic Alignment from Technical Todo data available in SAP. These include AVM_NR (IS-M/AM: Sales Document Number), POS_NR (IS-M: Order Item Number), EIN_NR (IS-M: Schedule Line), MOTIV (IS-M: Ad Spec Number (Ad)).. 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 JHATSTATTD 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
AVM_NRIS-M/AM: Sales Document Number AVM_NRCHAR10JHAKALPHAAVM_NRJHAMJHA
POS_NRIS-M: Order Item Number POS_NRNUMC3JHAPAVM_PNR
EIN_NRIS-M: Schedule Line EIN_NRNUMC6Assigned to domainAVMENR
MOTIVIS-M: Ad Spec Number (Ad) MOTIV_NRNUMC6JHAMOTPAM_MOTIV
ISTMELD_NRIS-M: Actual Message Number from Technical System ISTMELD_NRNUMC6NUMC6
STAT_EBENEIS-M: Order Level of Status STAT_EBENECHAR2LEVEL_AUF
TEC_AVM_NRIS-M: Order number in technical system TEC_AVM_NRCHAR10CHAR10
MOTIVIDIS-M: Assigned ad spec/ad spec file in technical system MOTIVIDCHAR12MOTIVID
AENVERS_NRIS-M: Last Change Version for Technical System AENVERS_NRNUMC4AENVERS_NR
STATUSKIS-M: Status STATUSKCHAR2PAM_STATUS
STATUSPRODIS-M: Ad Production Status STATUSPRODCHAR2PAM_STATUS
STATUSPLAZIS-M: Positioning status STATUSPLAZCHAR2PAM_STATUS
MERK_ID_01IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT01IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_02IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT02IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_03IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT03IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_04IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT04IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_05IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT05IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_06IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT06IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_07IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT07IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_08IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT08IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_09IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT09IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_10IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT10IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_11IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT11IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_12IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT12IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_13IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT13IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_14IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT14IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_15IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT15IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_16IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT16IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_17IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT17IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_18IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT18IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_19IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT19IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_20IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT20IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_21IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT21IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_22IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT22IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_23IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT23IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_24IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT24IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_25IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT25IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_26IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT26IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_27IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT27IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_28IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT28IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_29IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT29IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
MERK_ID_30IS-M: Characteristic ID MERKMAL_IDCHAR10CHAR10
MERKWERT30IS-M: Characteristic Value MERKMAL_WRCHAR10CHAR10
TECERR_TYPIS-M: Error Type - Data Transfer from Technical System TECERR_TYPCHAR1TECERR_TYP

Key field Non-key field



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

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

SELECT SINGLE *
FROM JHATSTATTD
INTO CORRESPONDING FIELDS OF WA_JHATSTATTD
WHERE...

How to access SAP table JHATSTATTD

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