| 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 | ORGFA | IS-H: Org. Unit with Departmental Assignment Authority | nvarchar | 8 | 0 | CHAR | (N' ') | No | NORG | ISH_ORGFA | Allow NULL? |
| 3 | ORGPF | Organizational Unit with Nursing Assignment Authority | nvarchar | 8 | 0 | CHAR | (N' ') | No | NORG | ISH_ORGPF | Allow NULL? |
| 4 | RI_ENDDT | IS-H: Valid-To Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RI_ENDDT | Allow NULL? |
| 5 | RI_BEGDT | IS-H: Valid-From Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_BEGDT | Allow NULL? |
| 6 | PBSUM | IS-H: Total Planned Beds in Organizational Unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PBSUMME | Allow NULL? |
| 7 | PBKHG | IS-H: Planned beds of an org. unit subsidized acc. to KHG | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PBKHG | Allow NULL? |
| 8 | PBHBFG | IS-H: Planned beds of an org. unit subsidized acc. to HBFG | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PBHBFG | Allow NULL? |
| 9 | PBSON | IS-H: Other planned beds of an org. unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PBSONST | Allow NULL? |
| 10 | ABSUM | IS-H: Total of all Setup Beds in Organizational Unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ABSUMME | Allow NULL? |
| 11 | ABKHG | IS-H: Setup beds of an org. unit subsidized accrd. to KHG | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ABKHG | Allow NULL? |
| 12 | ABHBFG | IS-H: Setup beds of an org. unit subsidized accrd. to HBFG | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ABHBFG | Allow NULL? |
| 13 | ABVER | IS-H: Setup Contractual Beds in Organizational Unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ABVERTRAG | Allow NULL? |
| 14 | ABSON | IS-H: Other setup beds of an org. unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ABSONST | Allow NULL? |
| 15 | ABINT | IS-H: Setup Intensive Care Beds of an Org. uUnit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ABINTENSIV | Allow NULL? |
| 16 | ABBELEG | IS-H: Setup External Beds of Organizational Unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ABBELEG | Allow NULL? |
| 17 | PBVIP | Planned VIP Beds in Organizational Unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISH_CN_PBVIP | Allow NULL? |
| 18 | PBNEGA | Planned Negative Air Pressure Beds of an Org. Unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISH_CN_PBNEGA | Allow NULL? |
| 19 | PBRES | Planned Observation Beds in Organizational Unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISH_CN_PBRES | Allow NULL? |
| 20 | ABVIP | VIP Setup Beds in Organizational Unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISH_CN_ABVIP | Allow NULL? |
| 21 | ABNEGA | Setup Negative Air Pressure Beds of an Org. Unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISH_CN_ABNEGA | Allow NULL? |
| 22 | ABRES | Observation Setup Beds in Organizational Unit | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ISH_CN_ABRES | Allow NULL? |
