| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | LNRVL | IS-H: Sequence Number of Services From Preliminary Entry | nvarchar | 10 | 0 | CHAR | (N' ') | No | | ISH_LNRVL | Allow NULL? |
| 3 | FALNR | IS-H: Case Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NFAL | FALNR | Allow NULL? |
| 4 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TN01 | EINRI | Allow NULL? |
| 5 | LEIST | Service in Service Catalog | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NTPK | TARLS | Allow NULL? |
| 6 | HAUST | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK01 | TARID | Allow NULL? |
| 7 | LEITX | IS-H: Service Short Text (May Differ from Service Master) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | TEXT_LEI | Allow NULL? |
| 8 | LEITX_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 9 | ERBTY | Type of Service Performance | char | 1 | 0 | CHAR | (N' ') | Yes | | TYP_ERBR | Allow NULL? |
| 10 | ERBTY_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 11 | ANART | IS-H: Analysis Type for Service (DKG-NT Germany) | char | 1 | 0 | CHAR | (N' ') | Yes | | ANALYSEART | Allow NULL? |
| 12 | ANART_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 13 | IBGDT | IS-H: Date when Service Performance Starts (Actual) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | I_BDT_LS | Allow NULL? |
| 14 | IBGDT_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 15 | IENDT | IS-H: Date when Service Performance Ends (Actual) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | I_EDT_LS | Allow NULL? |
| 16 | IENDT_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 17 | IBZT | IS-H: Time when Service Performance Starts (Actual) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | I_BZT_LS | Allow NULL? |
| 18 | IBZT_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 19 | IEZT | IS-H: Time Service Performance Ends (Actual) | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | I_EZT_LS | Allow NULL? |
| 20 | IEZT_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 21 | IMENG | Service Quantity | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | I_MENG_LS | Allow NULL? |
| 22 | IMENG_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 23 | REMRK | IS-H: User's Comment on Service | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_REMRK | Allow NULL? |
| 24 | REMRK_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 25 | STALS | IS-H: Service Status (Planned/Performed) | char | 1 | 0 | CHAR | (N' ') | Yes | | STATUS_LS | Allow NULL? |
| 26 | STALS_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 27 | HCOKZ | IS-H: Service Relevant for CO | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_HCOKZ | Allow NULL? |
| 28 | HCOKZ_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 29 | ABRKZ | Service Can Be Billed For | char | 1 | 0 | CHAR | (N' ') | Yes | | ABRKZ | Allow NULL? |
| 30 | ABRKZ_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 31 | KTRKZ | IS-H: Service is Cost Object | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_KTRKZ | Allow NULL? |
| 32 | KTRKZ_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 33 | ERBOE | IS-H: Organizational Unit that Performs the Service | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | NORG | ERBOE | Allow NULL? |
| 34 | ERBOE_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 35 | ANFOE | Departmental Organizational Unit That Requests the Service | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | NORG | ANFOE | Allow NULL? |
| 36 | ANFOE_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 37 | ANPOE | IS-H: Nursing Organizational Unit Requesting the Service | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | NORG | ANPOE | Allow NULL? |
| 38 | ANPOE_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 39 | TARAS | IS-H: Multiplication Factor | decimal | 6 | 3 | DEC | ((0)) | Yes | | TARAS6 | |
| 40 | TARAS_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 41 | BEGTX | IS-H: Reason for Multiplication Factor | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BEGRUENDTX | Allow NULL? |
| 42 | BEGTX_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 43 | TARIF | IS-H: Service Catalog Identification Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNK01 | TARID | Allow NULL? |
| 44 | TARIF_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 45 | TARSP | IS-H: Column in Service Catalog | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | NTSI | TARSP | Allow NULL? |
| 46 | TARSP_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 47 | PREIS | IS-H: Indiv. Price of Service Different from Service Master | decimal | 11 | 2 | CURR | ((0)) | Yes | | RI_PREIS | |
| 48 | PREIS_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 49 | TARLS | Service in Service Catalog | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NTPK | TARLS | Allow NULL? |
| 50 | TARLS_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 51 | ENTKY | Charge Key for Paragraph 301/DALE-UV | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ENTKEY | Allow NULL? |
| 52 | ENTKY_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 53 | ENZKY | IS-H: Add. Key for Charge Type for FR/Case, Proc.Surcharges | char | 1 | 0 | CHAR | (N' ') | Yes | | NZUSKEY | Allow NULL? |
| 54 | ENZKY_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 55 | ENTG2 | IS-H: Charge Type According to ยง301 | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | ENTGART2 | Allow NULL? |
| 56 | ENTG2_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 57 | LFDBEW | IS-H: Sequence Number of Movement | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | NBEW | LFDBEW | Allow NULL? |
| 58 | LFDBEW_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 59 | REFKY | Reference Code for Service from External System | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | REFKY | Allow NULL? |
| 60 | REFKY_X | IS-H: Transfer Field at Service Rule Action | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_AKFELD | Allow NULL? |
| 61 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 62 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 63 | ORGID | IS-H: Org. Unit (for OU-Related Service Entry Only) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | NORG | ORGID_LS | Allow NULL? |
