| 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 | BAUID | IS-H: Identification of Building Unit | nvarchar | 8 | 0 | CHAR | (N' ') | No | | BAUID | Allow NULL? |
| 3 | BAUTY | Category of a Building Unit | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TN11B | BAUTYPEX | Allow NULL? |
| 4 | BAUNA | Building Unit Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | BAUNA | Allow NULL? |
| 5 | BKURZ | IS-H: Building Unit Identifier | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | BKURZ | Allow NULL? |
| 6 | BAUKB | IS-H: Short Text for Building Unit | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BAUKB | Allow NULL? |
| 7 | TELNR | Telephone Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TELF | Allow NULL? |
| 8 | TELFX | Fax Number | nvarchar | 31 | 0 | CHAR | (N' ') | Yes | | TELFX | Allow NULL? |
| 9 | TELTX | Teletex number | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | TELTX | Allow NULL? |
| 10 | KZTXT | IS-H: Comment on Building Unit | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | TEXT_BAU | Allow NULL? |
| 11 | ARCHV | IS-H: Archived Data Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ARCHIV | Allow NULL? |
| 12 | LOEKZ | Deletion Flag/Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LOEKZ | Allow NULL? |
| 13 | LOUSR | User Who Deleted Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_LOUSR | Allow NULL? |
| 14 | LODAT | Date of Deletion | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_LODAT | Allow NULL? |
| 15 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 16 | ERUSR | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 17 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 18 | UPUSR | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 19 | XKOOR | IS-H: X-Coordinate of Building Unit in Overview Graphic | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RI_XKOOR | Allow NULL? |
| 20 | YKOOR | IS-H: Y-Coordinate of Building Unit in Overview Graphic | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RI_YKOOR | Allow NULL? |
| 21 | BEGDT | IS-H: Valid-From Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_BEGDT | Allow NULL? |
| 22 | ENDDT | IS-H: Valid-To Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ENDDT | Allow NULL? |
| 23 | FREIG | Release Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FREIG | Allow NULL? |
| 24 | BREIT | IS-H: Width of Building Unit for X-Coordinate | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RI_BREIT | Allow NULL? |
| 25 | LAENG | IS-H: Length of a build. unit for Y-coordinate | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RI_LAENG | Allow NULL? |
| 26 | LGTXT | Indicator that Long Text Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_LGTXT | Allow NULL? |
| 27 | ADRNR | IS-H: Address Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | NADR | ISH_ADRNR | Allow NULL? |
| 28 | ADROB | IS-H: Address Object | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ISH_ADROBJ | Allow NULL? |
| 29 | EANNR | International Article Number (EAN) | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | ISH_EANNR | Allow NULL? |
| 30 | TALST | Service in Service Catalog | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | TARLS | Allow NULL? |
| 31 | ADDIN | Additional Per Diem Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_ADD_IND | Allow NULL? |
| 32 | MIGRATED_OBJID | Object ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | HROBJID | Allow NULL? |
