SAP Table JHAE

IS-M/AM: OPM Sub-Item Schedule Line

JHAE (IS-M/AM: OPM Sub-Item Schedule Line) 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 JHAE to other SAP tables.

JHAE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AVM_NR IS-M/AM: Sales Document Number AVM_NR JHAK CHAR 10 0
POS_NR IS-M: Order Item Number POS_NR JHAP NUMC 3 0
UPOS_NR IS-M: Order Sub-Item Number UPOS_NR NUMC 4 0
EIN_NR IS-M: Schedule Line EIN_NR NUMC 6 0
STATUSK IS-M: Status STATUSK CHAR 2 0
01 Cancelled (logically deleted)
10 Created incompletely
20 Complete, reserved
30 Complete, fixed posting, still to be released
40 Complete, fixed posting, released, modifiable
50 Complete, released, partially processed
60 Processing complete, no longer modifiable
99 Initial value
XRESERV IS-M: Reservation indicator XRESERV CHAR 1 0
X Yes
NULL No
XSTORNIERT IS-M: Canceled Order Object Indicator XSTORNIERT CHAR 1 0
X Yes
NULL No
STORNOGRND IS-M: Cancellation Reason STOGRD_PAM TJHSTOG CHAR 3 0
EIN_ART IS-M: Schedule Line Type JHAE_ART CHAR 2 0
WERBK_TYP IS-M: Advertising Combination Type WERBK_TYP TJH91 CHAR 2 0
WERBK_KNZ IS-M: Combination Sale Indicator WERBK_KNZ NUMC 4 0
WERBK_POS IS-M: Combination Sale Grouping Item Number WERBK_POS JHAP NUMC 3 0
WERBK_UPOS IS-M: Combination Sale Grouping Sub-Item WERBK_UPOS NUMC 4 0
WERBK_EINT IS-M: Combination Sale Grouping for Schedule Line Number WERBK_EINT JHAE NUMC 6 0
NOTIZKNZ IS-M: Indicates Whether Notes are Available for an OPM Objct NOTIZKNZ CHAR 1 0
X Yes
NULL No
RABE_BETR IS-M/AM: Amount discount JRABBETR CURR 11 2
RABE_GRUND IS-M: Reason for Entering Conditions JGRKOND CHAR 2 0
RABE_BKTYP IS-M: Condition Input Type in the Order BKTYP CHAR 2 0
P+ Surcharge %
B+ Quantity dependent surcharge
P- Discount %
B- Quantity dependent discount
F Quantity dependent fixed price
V Agreed price
W+ Fixed value for surcharge
W- Fixed value for discount
E+ Surcharge amount for schedule line
E- Discount amount for schedule line
ZUSE_BETR IS-M/AM: Amount Surcharge JZUSBETR CURR 11 2
ZUSE_GRUND IS-M: Reason for Entering Conditions JGRKOND CHAR 2 0
ZUSE_BKTYP IS-M: Condition Input Type in the Order BKTYP CHAR 2 0
P+ Surcharge %
B+ Quantity dependent surcharge
P- Discount %
B- Quantity dependent discount
F Quantity dependent fixed price
V Agreed price
W+ Fixed value for surcharge
W- Fixed value for discount
E+ Surcharge amount for schedule line
E- Discount amount for schedule line
XRABZU IS-M: Discount/Surcharge Exists Indicator XRABZU CHAR 1 0
X Yes
NULL No
WAER_IPZA SD Document Currency WAERK CUKY 5 0
XUZUO_LOE Checkbox XFELD CHAR 1 0
X Yes
NULL No
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
STAFO Update group for statistics update STAFO TMCB CHAR 6 0
BAS_S_CHNG_DL_DT Base Soft Deadline Date for Change /NAM/BASE_SOFT_CHANGE_DL_DT DATS 8 0
BAS_S_CHNG_DL_TM Base Soft Deadline Time for Change /NAM/BASE_SOFT_CHANGE_DL_TM TIMS 6 0
BAS_H_CHNG_DL_DT Base Hard Deadline Date for Change /NAM/BASE_HARD_CHANGE_DL_DT DATS 8 0
BAS_H_CHNG_DL_TM Base Hard Deadline Time for Change /NAM/BASE_HARD_CHANGE_DL_TM TIMS 6 0
XCHN_PRODN_DL Deadline Set is a Production Deadline /NAM/XPRODUCTION_DEADLINE CHAR 1 0
X Yes
NULL No
BAS_S_CANC_DL_DT Base Soft Deadline Date for Cancel /NAM/BASE_SOFT_CANCEL_DL_DT DATS 8 0
BAS_S_CANC_DL_TM Base Soft Deadline Time for Cancel /NAM/BASE_SOFT_CANCEL_DL_TM TIMS 6 0
BAS_H_CANC_DL_DT Base Hard Deadline Date for Cancel /NAM/BASE_HARD_CANCEL_DL_DT DATS 8 0
BAS_H_CANC_DL_TM Base Hard Deadline Time for Cancel /NAM/BASE_HARD_CANCEL_DL_TM TIMS 6 0
XCNCL_PRODN_DL Deadline Set is a Production Deadline /NAM/XPRODUCTION_DEADLINE CHAR 1 0
X Yes
NULL No
BAS_DL_TIME_ZONE Time Zone TZNZONE CHAR 6 0

JHAE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JHAE AVM_NR JHAE MANDT JHAK IS-M/AM: Order-Publishing-Media (Header Data) MANDT
JHAE AVM_NR JHAE AVM_NR JHAK IS-M/AM: Order-Publishing-Media (Header Data) AVM_NR
JHAE MANDT JHAE MANDT T000 Clients MANDT
JHAE POS_NR JHAE MANDT JHAP IS-M/AM: Order-Publishing-Media Item MANDT
JHAE POS_NR JHAE AVM_NR JHAP IS-M/AM: Order-Publishing-Media Item AVM_NR
JHAE POS_NR JHAE POS_NR JHAP IS-M/AM: Order-Publishing-Media Item POS_NR
JHAE STAFO JHAE MANDT TMCB Update groups MANDT
JHAE STAFO JHAE STAFO TMCB Update groups STAFO
JHAE STORNOGRND JHAE MANDT TJHSTOG IS-M/AM: Sales Documents: Reversal Reasons MANDT
JHAE STORNOGRND JHAE STORNOGRND TJHSTOG IS-M/AM: Sales Documents: Reversal Reasons STORNOGRD
JHAE WERBK_EINT JHAE WERBK_POS JHAE IS-M/AM: OPM Sub-Item Schedule Line POS_NR
JHAE WERBK_EINT JHAE WERBK_UPOS JHAE IS-M/AM: OPM Sub-Item Schedule Line UPOS_NR
JHAE WERBK_EINT JHAE WERBK_EINT JHAE IS-M/AM: OPM Sub-Item Schedule Line EIN_NR
JHAE WERBK_EINT JHAE MANDT JHAE IS-M/AM: OPM Sub-Item Schedule Line MANDT
JHAE WERBK_EINT JHAE AVM_NR JHAE IS-M/AM: OPM Sub-Item Schedule Line AVM_NR
JHAE WERBK_POS JHAE WERBK_POS JHAP IS-M/AM: Order-Publishing-Media Item POS_NR
JHAE WERBK_POS JHAE MANDT JHAP IS-M/AM: Order-Publishing-Media Item MANDT
JHAE WERBK_POS JHAE AVM_NR JHAP IS-M/AM: Order-Publishing-Media Item AVM_NR
JHAE WERBK_TYP SYST MANDT TJH91 IS-M/AM: Combination Sale Type MANDT
JHAE WERBK_TYP JHAE WERBK_TYP TJH91 IS-M/AM: Combination Sale Type WKOMBI_TYP