| 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 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | RESOR | IS-H MM: Movement Type for Case-Rel. Material Requisition | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T156 | ISH_RESOR | Allow NULL? |
| 4 | RESCC | IS-H MM: Movement type for OU-related material requisition | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T156 | ISH_RESCC | Allow NULL? |
| 5 | BNFOR | IS-H MM: Account Asgmt Category for Case-Rel. Mat. Requisit. | char | 1 | 0 | CHAR | (N' ') | Yes | T163K | ISH_BNFOR | Allow NULL? |
| 6 | BNFCC | IS-H MM: Account asgmt category for OU-rltd mat. requisition | char | 1 | 0 | CHAR | (N' ') | Yes | T163K | ISH_BNFCC | Allow NULL? |
| 7 | BNFDT | IS-H MM: Document Type for Purchase Requisition | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | ISH_BNFDT | Allow NULL? |
| 8 | WATXT | IS-H MM: Goods issue item text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | ISH_WATXT | Allow NULL? |
| 9 | WAKTX | IS-H MM: Header Text for Goods Delivery Document | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | ISH_WAKTX | Allow NULL? |
| 10 | F4HID | IS-H MM: Hierarchy ID for hierarchic material entry | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TNM20H | ISH_MMHID | Allow NULL? |
| 11 | STVER | IS-H MM: Start Screen in Material Requisition Function | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_MSTVERS | Allow NULL? |
| 12 | PRELD | IS-H MM: Preset Desired Delivery Data | nvarchar | 2 | 0 | NUMC | (N'00') | No | | ISH_MPRELD | Allow NULL? |
| 13 | FTXGART | IS-H MM: Approval Type for Free-Text Requisition | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TNM10A | ISH_MFTXGART | Allow NULL? |
| 14 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T024 | EKGRP | Allow NULL? |
| 15 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | * | MATKL | Allow NULL? |