SAP ABAP Table ESSR (Service Entry Sheet Header Data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ ML (Package) R/3 services management
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ ML (Package) R/3 services management
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | ESSR | Table Relationship Diagram |
Short Description | Service Entry Sheet Header Data |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | LBLNI | LBLNI | LBLNI | CHAR | 10 | 0 | Entry Sheet Number | ||
3 | .INCLUDE | 0 | 0 | Service Entry: Data Fields in Header | |||||
4 | LBLNE | LBLNE1 | XBLNR1 | CHAR | 16 | 0 | External Entry Sheet Number | ||
5 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
6 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
7 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
8 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
9 | SBNAMAG | SBNAMAG | SBNAM | CHAR | 12 | 0 | Person Responsible (Internally) | ||
10 | SBNAMAN | SBNAMAN | SBNAM | CHAR | 12 | 0 | Person Responsible (Externally) | ||
11 | DLORT | DLORT | TEXT25 | CHAR | 25 | 0 | Location Where Service Was Performed | ||
12 | LBLDT | LBLDT | DATUM | DATS | 8 | 0 | Price Reference Date of Entry Sheet | ||
13 | LZVON | LZVON | DATUM | DATS | 8 | 0 | Period | ||
14 | LZBIS | LZBIS | DATUM | DATS | 8 | 0 | End of period | ||
15 | LWERT | LWERT | WERT11 | CURR | 11 | 2 | Value of Services | ||
16 | UWERT | NETWR_UNG | WERT11V | CURR | 11 | 2 | Portion from Unplanned Services | ||
17 | UNPLV | UNPLV | WERT11V | CURR | 11 | 2 | Portion Unplanned Value Without Reference to Contract | ||
18 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
19 | PACKNO | PACKNO | PACKNO | NUMC | 10 | 0 | Package number | ESLH | |
20 | TXZ01 | TXZ01_ESSR | TEXT40 | CHAR | 40 | 0 | Short Text of Service Entry Sheet | ||
21 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | EKKO | |
22 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | EKPO | |
23 | LOEKZ | LOEKZ_ESSR | ELOEK | CHAR | 1 | 0 | Deletion indicator in entry sheet | ||
24 | KZABN | KZABN | CHAR01 | CHAR | 1 | 0 | Acceptance indicator | ||
25 | FINAL | FINAL | CHAR01 | CHAR | 1 | 0 | Indicator: Final Entry Sheet | ||
26 | FRGGR | FRGGR | FRGGR | CHAR | 2 | 0 | Release group | T16FG | |
27 | FRGSX | FRGSX | FRGSX | CHAR | 2 | 0 | Release Strategy | T16FS | |
28 | FRGKL | FRGKL | CHAR01 | CHAR | 1 | 0 | Release indicator: Entry sheet | ||
29 | FRGZU | FRGZU | FRGZU | CHAR | 8 | 0 | Release status | ||
30 | FRGRL | FRGRL | XFELD | CHAR | 1 | 0 | Release Not Yet Completely Effected | ||
31 | F_LOCK | F_LOCK | XFELD | CHAR | 1 | 0 | Block Release of Entry Sheet | ||
32 | PWWE | MC_PWWE | DEC3 | DEC | 3 | 0 | Points score for quality of services | ||
33 | PWFR | MC_PWFR | DEC3 | DEC | 3 | 0 | Points score for on-time delivery | ||
34 | BLDAT | BLDAT_SRV | DATUM | DATS | 8 | 0 | Document Date in Document | ||
35 | BUDAT | BUDAT_SRV | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
36 | XBLNR | XBLNR_SRV1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
37 | BKTXT | BKTXT_SRV | TEXT25 | CHAR | 25 | 0 | Document Header Text | ||
38 | KNTTP | KNTTP | KNTTP | CHAR | 1 | 0 | Account assignment category | T163K | |
39 | KZVBR | KZVBR | KZVBR | CHAR | 1 | 0 | Consumption posting | ||
40 | NETWR | NETWR_ESSR | WERT11 | CURR | 11 | 2 | Net Value of Entry Sheet | ||
41 | BANFN | BANFN_ESSR | BANFN | CHAR | 10 | 0 | Purchase Requisition Number | ||
42 | BNFPO | BNFPO_ESSR | BNFPO | NUMC | 5 | 0 | Item number of purchase requisition | EBAN | |
43 | WARPL | WARPL | WARPL | CHAR | 12 | 0 | Maintenance Plan | MPLA | |
44 | WAPOS | WAPOS | POSNU | CHAR | 16 | 0 | Maintenance item | ||
45 | ABNUM | ABNUM | ABNUM | INT4 | 10 | 0 | Maintenance Plan Call Number | ||
46 | FKNUM | FKNUM | FKNUM | CHAR | 10 | 0 | Shipment cost number | VFKK | |
47 | FKPOS | FKPOS | FKPOS | NUMC | 6 | 0 | Shipment costs item | VFKP | |
48 | USER1 | ESSR_D | CHAR20 | CHAR | 20 | 0 | Technical Reference Field for External Entry Sheet Number | ||
49 | USER2 | USR_ESSR | CHAR20 | CHAR | 20 | 0 | User field: Service entry sheet | ||
50 | NAVNW | NAVNW_SRV | WERT11V | CURR | 11 | 2 | Non-deductible input tax | ||
51 | SPEC_NO | SPEC_NO | SPEC10 | CHAR | 10 | 0 | Number of a Set of Model Service Specifications | * | |
52 | CUOBJ | CUOBJ | CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
53 | LEMIN | SRVRET | XFELD | CHAR | 1 | 0 | Returns Indicator | ||
54 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ESSR | BNFPO | EBAN | BNFPO | REF | 1 | CN |
2 | ESSR | EBELN | EKKO | EBELN | |||
3 | ESSR | EBELP | EKPO | EBELP | |||
4 | ESSR | FKNUM | VFKK | FKNUM | |||
5 | ESSR | FKPOS | VFKP | FKPOS | |||
6 | ESSR | FRGGR | T16FG | FRGGR | |||
7 | ESSR | FRGSX | T16FS | FRGSX | |||
8 | ESSR | KNTTP | T163K | KNTTP | REF | 1 | N |
9 | ESSR | MANDT | T000 | MANDT | KEY | 1 | N |
10 | ESSR | PACKNO | ESLH | PACKNO | |||
11 | ESSR | WAERS | TCURC | WAERS | REF | 1 | N |
12 | ESSR | WARPL | MPLA | WARPL |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |