| 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 | /1MD/0GCOA | Chart of Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | KTOPL | Allow NULL? |
| 3 | /1MD/0GFRS | Financial Reporting Structure | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | USMDZ1_FRS | Allow NULL? |
| 4 | /1MD/0GFRSI | Financial Reporting Structure Item | nvarchar | 10 | 0 | CHAR | (N' ') | No | /1MD/MD______04Y | USMDZ1_FRSI | Allow NULL? |
| 5 | /1MD/0GLANGUAGE | Language Key (Technical) | char | 1 | 0 | CHAR | (N' ') | No | * | SPRAST | Allow NULL? |
| 6 | USMD_EDTN_NUMBER | Edition Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | USMD_EDITION_NUMBER | Allow NULL? |
| 7 | USMD_ACTIVE | Active/Inactive Data Record | char | 1 | 0 | CHAR | (N' ') | No | | USMD_ACTIVE | Allow NULL? |
| 8 | USMD_O_FRSITXT | Obsolete Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | USMD_OBSOLETE | Allow NULL? |
| 9 | /1MD/0GFRSITBEG1 | Start of Group Row for Financial Statement Item | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FRSITRBEG1 | Allow NULL? |
| 10 | /1MD/0GFRSITBEG2 | Start of Group Row for Financial Statement Item | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FRSITRBEG2 | Allow NULL? |
| 11 | /1MD/0GFRSITBEG3 | Start of Group Row for Financial Statement Item | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FRSITRBEG3 | Allow NULL? |
| 12 | /1MD/0GFRSITBEG4 | Start of Group Row for Financial Statement Item | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FRSITRBEG4 | Allow NULL? |
| 13 | /1MD/0GFRSITEND1 | End of Group Row for Financial Statement Item | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FRSITREND1 | Allow NULL? |
| 14 | /1MD/0GFRSITEND2 | End of Group Row for Financial Statement Item | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FRSITREND2 | Allow NULL? |
| 15 | /1MD/0GFRSITEND3 | End of Group Row for Financial Statement Item | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FRSITREND3 | Allow NULL? |
| 16 | /1MD/0GFRSITEND4 | End of Group Row for Financial Statement Item | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FRSITREND4 | Allow NULL? |
| 17 | /1MD/0GFRSITTOT1 | Graduated Total Line for Financial Statement Item | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FRSITRTOT1 | Allow NULL? |
| 18 | /1MD/0GFRSITTOT2 | Graduated Total Line for Financial Statement Item | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FRSITRTOT2 | Allow NULL? |
| 19 | /1MD/0GFRSITTOT3 | Graduated Total Line for Financial Statement Item | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FRSITRTOT3 | Allow NULL? |
| 20 | /1MD/0GFRSITTOT4 | Graduated Total Line for Financial Statement Item | nvarchar | 45 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FRSITRTOT4 | Allow NULL? |
