| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | HASCTCDCURR | Differing Condition Currency Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | RECAHASCTCDCURR | Allow NULL? |
| 4 | DEFCDCURR | Proposal for Differing Condition Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | RECACTDEFCDCURR | Allow NULL? |
| 5 | DEFAULTAREA | Defaults for Area Units | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | REBDDEFAULTAREA | Allow NULL? |
| 6 | DEFAULTVOLUME | Defaults for Units of Volume | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | REBDDEFAULTVOLUME | Allow NULL? |
| 7 | DEFAULTLENGTH | Defaults for Units of Length | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | REBDDEFAULTLENGTH | Allow NULL? |
| 8 | ISAMMULTIASS | Multiple Assignment Allowed for Assets | char | 1 | 0 | CHAR | (N' ') | Yes | | REBDISAMMULTIASS | Allow NULL? |
| 9 | ISPMMULTIASS | Multiple Assignment of Functional Locations Allowed? | char | 1 | 0 | CHAR | (N' ') | Yes | | REBDISPMMULTIASS | Allow NULL? |
| 10 | ISPSMULTIASS | Multiple Assignment of WBS Elements Allowed? | char | 1 | 0 | CHAR | (N' ') | Yes | | REBDISPSMULTIASS | Allow NULL? |
| 11 | ISORMULTIASS | Multiple Assignment of Orders Allowed? | char | 1 | 0 | CHAR | (N' ') | Yes | | REBDISORMULTIASS | Allow NULL? |
| 12 | ISCCMULTIASS | Allow Multiple Assignment for Cost Centers | char | 1 | 0 | CHAR | (N' ') | Yes | | REBDISCCMULTIASS | Allow NULL? |
| 13 | ISAMOBLIGATORY | Assigning Fixed Asset Is Mandatory | char | 1 | 0 | CHAR | (N' ') | Yes | | REEXISAMOBLIGATORY | Allow NULL? |
| 14 | FIRSTDATE | Default Date: First Possible Point in Time | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECAFIRSTDATE | Allow NULL? |
| 15 | FCOMACTIVE | Approvals Active | char | 1 | 0 | CHAR | (N' ') | Yes | | REEXFCOMACTIVE | Allow NULL? |
| 16 | FCOMACTIVEFROM | Approvals Active From | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REEXFCOMACTIVEFROM | Allow NULL? |
| 17 | HASTAXDIST | Company Code Opts for Input Tax | char | 1 | 0 | CHAR | (N' ') | Yes | | REITHASTAXDIST | Allow NULL? |
| 18 | TAXDSPS | Perform Input Tax Distribution for Projects | char | 1 | 0 | CHAR | (N' ') | Yes | | REITTAXDSPS | Allow NULL? |
| 19 | TAXDSPM | Perform Input Tax Dist. for PM Orders Using Funct.Location | char | 1 | 0 | CHAR | (N' ') | Yes | | REITTAXDSPM | Allow NULL? |
| 20 | TAXDSOR | Perform Input Tax Distribution for Directly Assigned Orders | char | 1 | 0 | CHAR | (N' ') | Yes | | REITTAXDSOR | Allow NULL? |
| 21 | TAXDSKS | Perform Input Tax Distribution for Cost Centers | char | 1 | 0 | CHAR | (N' ') | Yes | | REITTAXDSKS | Allow NULL? |
| 22 | TAXDSMSGPS | Message Type If Option Rate for Project Not Determined | char | 1 | 0 | CHAR | (N' ') | Yes | | REITTAXDSMSGPS | Allow NULL? |
| 23 | TAXDSMSGPM | Message Type If Option Rate for PM Order Not Determined | char | 1 | 0 | CHAR | (N' ') | Yes | | REITTAXDSMSGPM | Allow NULL? |
| 24 | TAXDSMSGOR | Message Type If Option Rate for Int. Order Not Determined | char | 1 | 0 | CHAR | (N' ') | Yes | | REITTAXDSMSGOR | Allow NULL? |
| 25 | TAXDSMSGKS | Message Type If Option Rate for Cost Center Not Determined | char | 1 | 0 | CHAR | (N' ') | Yes | | REITTAXDSMSGKS | Allow NULL? |
| 26 | DATEOFSERVSRC | Source of Date of Service | char | 1 | 0 | CHAR | (N' ') | Yes | | REITDSDATEOFSERVSRC | Allow NULL? |
| 27 | TAXCORRIND | Mode for Input Tax Correction | char | 1 | 0 | CHAR | (N' ') | Yes | | REITTAXCORRIND | Allow NULL? |
| 28 | CCTYPE | Company Code Type | char | 1 | 0 | CHAR | (N' ') | Yes | | REMMCCTYPE | Allow NULL? |
| 29 | DEFHBKID | Short Key for a House Bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012 | REMMDEFHBKID | Allow NULL? |
| 30 | DEFHKTID | ID for Account Details | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012K | REMMDEFHKTID | Allow NULL? |
| 31 | NRINTINVOICE | Number Range Interval for Invoice Numbers | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | RERAINVNRINTINVOICE | Allow NULL? |
| 32 | NRINTCREDITMEMO | Number Range Interval for Credit Memos | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | RERAINVNRINTCREDITMEMO | Allow NULL? |
| 33 | NODOCUPDATE | Suppress Update of Invoice Number in FI Document | char | 1 | 0 | CHAR | (N' ') | Yes | | RERAINVNODOCUPDATE | Allow NULL? |
| 34 | ACCSYSTEM | Definition of Accounting System | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVRAACCSYSTEM | RERAACCSYSTEM | Allow NULL? |
| 35 | CNDSPOS | Is Summarization of Line Items Active? | char | 1 | 0 | CHAR | (N' ') | Yes | | RERACNDSPOS | Allow NULL? |
| 36 | CNDSTAX | Is Summarization of Tax Items Active? | char | 1 | 0 | CHAR | (N' ') | Yes | | RERACNDSTAX | Allow NULL? |
| 37 | HASPARTNERBLOCK | Locking Partner Data in Posting Term Possible | char | 1 | 0 | CHAR | (N' ') | Yes | | RERAHASPARTNERBLOCK | Allow NULL? |
| 38 | CREATENEWITEMS | Create new residual items for incoming payment | char | 1 | 0 | CHAR | (N' ') | Yes | | REEXCREATENEWITEMS | Allow NULL? |
| 39 | FILLASSDOCUMENT | Fill Assignment in Document | char | 1 | 0 | CHAR | (N' ') | Yes | | REEXFILLASSDOCUMENT | Allow NULL? |
| 40 | FILLBUSAREA | Fill Business Area During Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | RERAFILLBUSAREA | Allow NULL? |
| 41 | HASTAXACCRUAL | Tax Accrual/Deferral Active in Company Code | char | 1 | 0 | CHAR | (N' ') | Yes | | RERAHASTAXACCRUAL | Allow NULL? |
| 42 | HASACRPSTDATEDEP | Accrual/Deferral Dependent on Periodic Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | RERAHASACRPSTDATEDEP | Allow NULL? |
| 43 | INPTAXZEROTYPE | Tax Type 0% Input Tax | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVRATAXTYPE | RERAINPTAXZEROTYPE | Allow NULL? |
| 44 | INPTAXZEROGROUP | Tax Group 0% Input Tax | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | TIVRATAXGROUP | RERAINPTAXZEROGROUP | Allow NULL? |
| 45 | OUTTAXZEROTYPE | Tax Type 0% Output Tax | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVRATAXTYPE | RERAOUTTAXZEROTYPE | Allow NULL? |
| 46 | OUTTAXZEROGROUP | Tax Group 0% Output Tax | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | TIVRATAXGROUP | RERAOUTTAXZEROGROUP | Allow NULL? |
| 47 | DISTCOMPLETE | Full Distribution for Integrated Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | RERADISTCOMPLETE | Allow NULL? |
| 48 | FILLSEPAMANDATE | Indicator: Fill SEPA Mandate in FI Document | char | 1 | 0 | CHAR | (N' ') | Yes | | REEXFILLSEPAMANDATE | Allow NULL? |
| 49 | CVCREATE | Allow Automatic Creation of Vendor? | char | 1 | 0 | CHAR | (N' ') | Yes | | RERAOPCVCREATE | Allow NULL? |
| 50 | CANMSUASSIGNMSU | Can a Master SU Be Assigned to a Master SU? | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCCANMSUASSIGNTOMSU | Allow NULL? |
| 51 | SUPURPSUBSTIND | Apportionment Rules in COA Settlement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | RESCSUPURPSUBSTIND | Allow NULL? |
| 52 | NOTAXCORR | No Input Tax Adjustment in the Service Charge Settlement | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCNOTAXCORR | Allow NULL? |
| 53 | MEASPOINTTYPE | Measuring Point Category | char | 1 | 0 | CHAR | (N' ') | Yes | * | IMRC_MPTYP | Allow NULL? |
| 54 | USECF4POST | Use Periodic Posting Run for Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | RESRUSECF4POST | Allow NULL? |
