| 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 | * | MANDT | Allow NULL? |
| 2 | ID | Tax Return Maintenance ID | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | J_1UF_TAX21_ID | Allow NULL? |
| 3 | COMPANY_CODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 4 | TAX_GROUP | Sales/Purchases Tax Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | UMKRS | Allow NULL? |
| 5 | BUSINESS_AREA | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 6 | PROFIT_CENTER | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 7 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 8 | FISCAL_PERIOD | Fiscal Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | MONAT | Allow NULL? |
| 9 | RETURN_TYPE | VAT Return Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | J_1UD011012 | Allow NULL? |
| 10 | CLAR_YEAR | Clarification Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | J_1UF_TAX21_CLAR_YEAR | Allow NULL? |
| 11 | CLAR_PERIOD | Clarification Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | J_1UF_TAX21_CLAR_PERIOD | Allow NULL? |
| 12 | RUN_ID | Additional Identification | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | LAUFI | Allow NULL? |
| 13 | RUN_DATE | Date on Which the Program Is to Be Run | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | LAUFD | Allow NULL? |
| 14 | REPORT_DOC_NUM | Identical Document Number | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | J_1UF_IDENT_DOCNUM | Allow NULL? |
| 15 | PERIOD_DOC_NUM | Correction Document Number | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | J_1UF_CORR_DOC_NUM | Allow NULL? |
| 16 | SUBMISSION_DATE | Date of Tax Return Submission | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1UF_TAX21_SUBMISSION_DATE | Allow NULL? |
| 17 | IN_DECL_FLAG | Transfer of Remaining Clarification Amount | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1UF_TAX21_DECL_FLAG | Allow NULL? |
| 18 | AMOUNT_23_1 | Amount of Refund to Payer's Account (Line 23.1) | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1UF_TAX21_AMOUNT_23_1 | |
| 19 | PENALTY_AMOUNT | Tax Return Clarification Penalty (Line 26) | decimal | 13 | 2 | CURR | ((0)) | Yes | | J_1UF_TAX21_PENALTY_AMOUNT | |
| 20 | CLAR_TYPE | Clarification Type | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1UF_TAX21_CLAR_TYPE | Allow NULL? |
| 21 | MARK_ERROR_CORR | Mark Error Correction | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1UFERRCORR | Allow NULL? |
| 22 | COPY_OF_REGISTRY | Copy of Registry in Electronic Form | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1UFCOPYREG | Allow NULL? |
| 23 | MARK_QUAL_CALC | Mark Qualifying Calculations | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1UFQUALCALC | Allow NULL? |
| 24 | ANNEX_INFREEFORM | Annex in Free Form | char | 1 | 0 | CHAR | (N' ') | Yes | | J_1UFFREEANNEX | Allow NULL? |
| 25 | ANNEX_INFREETEXT | Freeform Text for Annex | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | J_1UFTAX21_HJAR | Allow NULL? |
| 26 | NO_ORIGCUSTDECL | No. of Original Customs Declaration (Page 5) | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | J_1UFCUSTDECLPAGE5 | Allow NULL? |
