SAP ABAP Table SDBT_NOTHDR (Service Notification Header)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MD-SDB (Application Component) Solution Database
⤷ CSKN (Package) Customer Service: Knowledge Base Development
⤷ CRM-MD-SDB (Application Component) Solution Database
⤷ CSKN (Package) Customer Service: Knowledge Base Development
Basic Data
Table Category | INTTAB | Structure |
Structure | SDBT_NOTHDR | Table Relationship Diagram |
Short Description | Service Notification Header |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | NOTIF_NO | CRMTQMNUM | CRMTQMNUM | CHAR | 12 | 0 | Notification Number | ||
2 | PLANPLANT | IWERK | WERKS | CHAR | 4 | 0 | Maintenance Planning Plant | * | |
3 | LOC_ACC | CHAR12 | CHAR12 | CHAR | 12 | 0 | Character Field of Length 12 | ||
4 | EQUIPMENT | EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | * | |
5 | ASSEMBLY | CHAR18 | CHAR18 | CHAR | 18 | 0 | Field length 18 | ||
6 | BREAKDOWN | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
7 | STRMLFNDATE | DATE8 | DATE | DATS | 8 | 0 | Date in CHAR format | ||
8 | ENDMLFNDATE | DATE8 | DATE | DATS | 8 | 0 | Date in CHAR format | ||
9 | STRMLFNTIME | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
10 | ENDMLFNTIME | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
11 | DOWNTIME | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
12 | UNIT | AUSME | MEINS | UNIT | 3 | 0 | Unit of issue | * | |
13 | ISOCODE_UNIT | ISOCD_UNIT | ISOCD_UNIT | CHAR | 3 | 0 | ISO code for unit of measurement | * | |
14 | PLANGROUP | CHAR3 | CHAR3 | CHAR | 3 | 0 | 3-Byte field | ||
15 | MNTPLAN | WARPL | WARPL | CHAR | 12 | 0 | Maintenance Plan | * | |
16 | MNTCALL_NO | ABNUM | ABNUM | INT4 | 10 | 0 | Maintenance Plan Call Number | ||
17 | MAINTITEM | WAPOS | POSNU | CHAR | 16 | 0 | Maintenance item | ||
18 | NOTIF_TYPE | CHAR2 | CHAR2 | CHAR | 2 | 0 | Version Number Component | ||
19 | SHORT_TEXT | CHAR40 | CHAR40 | CHAR | 40 | 0 | Character field of length 40 | ||
20 | PRIOTYPE | TYPPR | TYPPR | CHAR | 2 | 0 | Priority Type | ||
21 | PRIORITY | SDB_PRIOR | SDB_PRIOR | CHAR | 1 | 0 | Priority Level | ||
22 | CREATED_BY | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
23 | CREATED_ON | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
24 | CHANGED_BY | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
25 | CHANGED_ON | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
26 | NOTIFTIME | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
27 | NOTIF_DATE | DATE8 | DATE | DATS | 8 | 0 | Date in CHAR format | ||
28 | REPORTEDBY | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
29 | DESSTDATE | DATE8 | DATE | DATS | 8 | 0 | Date in CHAR format | ||
30 | DESSTTIME | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
31 | DESENDDATE | DATE8 | DATE | DATS | 8 | 0 | Date in CHAR format | ||
32 | DESENDTM | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
33 | ORDERID | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
34 | MATERIAL | MATNR | MATNR | CHAR | 18 | 0 | Material Number | ||
35 | CUST_NO | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
36 | OBJECT_NO | SDBOBJNR | J_OBJNR | CHAR | 22 | 0 | Object number for status management | * | |
37 | COMPDATE | DATE8 | DATE | DATS | 8 | 0 | Date in CHAR format | ||
38 | COMPTIME | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
39 | CATPROFILE | CRMT_SUBJECT_PROFILE | CRM_SUBJECT_PROFILE | CHAR | 9 | 0 | Subject Profile | * | |
40 | LONG_TEXT | INDLTXT | CHAR1 | CHAR | 1 | 0 | Long Text | ||
41 | PRILANG | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
42 | REFDATE | DATE8 | DATE | DATS | 8 | 0 | Date in CHAR format | ||
43 | REFTIME | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
44 | SALES_ORD | KDAUF | VBELN | CHAR | 10 | 0 | Sales Order Number | ||
45 | PURCH_NO_C | BSTKD | BSTKD | CHAR | 35 | 0 | Customer purchase order number | ||
46 | PURCH_DATE | CRMTBSTDK | DATUM | DATS | 8 | 0 | Customer Purchase Order Date | ||
47 | DIVISION | SPART | SPART | CHAR | 2 | 0 | Division | ||
48 | SALES_ORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
49 | DISTR_CHAN | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
50 | ADDR_NUMBER | CADNR | CADRNR | CHAR | 10 | 0 | Addresses: Address Number | * | |
51 | CHANGED_AT | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
52 | CREATED_AT | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
53 | CAT_TYPE | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
54 | CODE_GROUP | CHAR8 | CHAR8 | CHAR | 8 | 0 | Character field, 8 characters long | ||
55 | CODING | CHAR4 | CHAR4 | CHAR | 4 | 0 | Not More Closely Defined Area, Possibly Used for Patchlevels | ||
56 | PM_WKCTR | NUM8 | NUM8 | NUMC | 8 | 0 | Eight-digit numeric value | ||
57 | SERIALNO | GERNR | GERNR | CHAR | 18 | 0 | Serial Number | ||
58 | DELETE_FLAG | FLAGDEL | CHAR1 | CHAR | 1 | 0 | Delete data record | ||
59 | DEVICEDATA | CHAR40 | CHAR40 | CHAR | 40 | 0 | Character field of length 40 | ||
60 | SALES_OFFICE | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | * | |
61 | SALES_GRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | * | |
62 | NOTIFTMEZ | TIMEZONE | TZNZONE | CHAR | 6 | 0 | Time Zone | * | |
63 | FUNCT_LOC | TPLNR | TPLNR | CHAR | 30 | 0 | Functional Location | * | |
64 | ABCINDIC | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
65 | SORTFIELD | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
66 | MAINTPLANT | IWERK | WERKS | CHAR | 4 | 0 | Maintenance Planning Plant | * | |
67 | MAINTLOC | CRMTPMLOC | AP_STAND | CHAR | 10 | 0 | Location of Maintenance Object | * | |
68 | MAINTROOM | CHAR8 | CHAR8 | CHAR | 8 | 0 | Character field, 8 characters long | ||
69 | PLSECTN | CRMTBEBER | CRMTBEBER | CHAR | 3 | 0 | Organizational Area | ||
70 | PP_WKCTR | NUM8 | NUM8 | NUMC | 8 | 0 | Eight-digit numeric value | ||
71 | BUS_AREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
72 | CO_AREA | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
73 | COSTCENTER | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
74 | WBS_ELEMENT | CHAR24 | CHAR24 | CHAR | 24 | 0 | Character field length 24 | ||
75 | ASSET_NO | ANLN1 | ANLN1 | CHAR | 12 | 0 | Main Asset Number | * | |
76 | SUB_NUMBER | ANLN2 | ANLN2 | CHAR | 4 | 0 | Asset Subnumber | * | |
77 | STDGORD | CHAR12 | CHAR12 | CHAR | 12 | 0 | Character Field of Length 12 | ||
78 | STLMTORDER | CHAR12 | CHAR12 | CHAR | 12 | 0 | Character Field of Length 12 | ||
79 | COMP_CODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
80 | SALES_ORG_LOC_ACC | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
81 | DIVISION_LOC_ACC | SPART | SPART | CHAR | 2 | 0 | Division | ||
82 | DIST_CHAN_LOC_ACC | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
83 | ADDR_NO_LOC_ACC | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
84 | DOC_NUMBER | VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | ||
85 | ITM_NUMBER | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item |
History
Last changed by/on | SAP | 20110908 |
SAP Release Created in |