| 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 | COSTSEXTGUID | GUID (RAW16) | varbinary | 16 | 0 | RAW | | No | | RECAGUID | |
| 3 | SUOBJNR | Object Number of Settlement Unit | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RESCSUOBJNR | Allow NULL? |
| 4 | ROOBJNR | Object Number of Rental Object | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RESCROOBJNR | Allow NULL? |
| 5 | CNOBJNR | Object Number of Real Estate Contract (REC) | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RESCCNOBJNR | Allow NULL? |
| 6 | COSTACCOUNT | Cost Account in G/L Accounting | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | REITCOSTACCOUNT | Allow NULL? |
| 7 | TAXACCOUNT | Tax Account of General Ledger Accounting | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | REITTAXACCOUNT | Allow NULL? |
| 8 | TAXTYPE | Tax Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | RERATAXTYPE | Allow NULL? |
| 9 | TAXGROUP | Tax Group | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | RERATAXGROUP | Allow NULL? |
| 10 | TAXDATE | Date of Tax Calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RERATAXDATE | Allow NULL? |
| 11 | PFROM | Period Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECAPERIODFROM | Allow NULL? |
| 12 | PTO | Period End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECAPERIODTO | Allow NULL? |
| 13 | LOGSYSTEM | Logical System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYSTEM | Allow NULL? |
| 14 | REFDOCTYPE | Reference to Document Class | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | RERAREFDOCTYPE | Allow NULL? |
| 15 | REFDOCID | Reference Key of Document | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | RERAREFDOCID | Allow NULL? |
| 16 | REFITEMNO | Accounting Document Line Item Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | POSNR_ACC | Allow NULL? |
| 17 | HASCOPOSTING | Costs Were Posted in Controlling (CO) | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCHASCOPOSTING | Allow NULL? |
| 18 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 19 | NET_AMOUNT | Net Amount in Transaction Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERANETAMOUNT | |
| 20 | TAX_AMOUNT | Tax Amount in Transaction Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERATAXAMOUNT | |
| 21 | DEDUCT_TAX | Deductible Tax Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERADEDTAXAMT | |
| 22 | NONDEDUCT_TAX | Non-Deductible Tax Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | RERANONDEDTAXAMT | |
| 23 | MEASVALUE | Measurement Amount: Available | decimal | 17 | 4 | QUAN | ((0)) | Yes | | REBDMEASVALUE | |
| 24 | MEASUNIT | Measurement Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | REBDMEASUNIT | Allow NULL? |
| 25 | MEAS | Measurement Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | REBDMEAS | Allow NULL? |
| 26 | POINT | Measuring Point | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | IMRC_POINT | Allow NULL? |
| 27 | CONSUMPTION | Consumption of the Real Estate Object | decimal | 12 | 4 | QUAN | ((0)) | Yes | | REXCJPOWNCONS | |
| 28 | TOTALCONS | Total Consumption | decimal | 12 | 4 | QUAN | ((0)) | Yes | | REXCJPTOTALCONS | |
| 29 | CONSMEASUNIT | Measurement Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | REBDMEASUNIT | Allow NULL? |
| 30 | FIXEDUNITPRICE | Fixed Unit Price for Service Charge Settlement | decimal | 19 | 6 | DEC | ((0)) | Yes | | REXCJPFIXEDUNITPRICE | |
| 31 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 32 | TAXCALCMODE | Tax Calculation Mode: Net or Gross | char | 1 | 0 | CHAR | (N' ') | Yes | | REXCJPTAXCALC | Allow NULL? |
| 33 | APPORTFROM | Start Date of Apportionment Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REXCJPAPPORTFROM | Allow NULL? |
| 34 | APPORTTO | End Date of Apportionment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | REXCJPAPPORTTO | Allow NULL? |
| 35 | CEOBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | J_OBJNR | Allow NULL? |
| 36 | DELETED | Deleted Cost Distribution Entry | char | 1 | 0 | CHAR | (N' ') | Yes | | REXCJPSCCOSTDELETED | Allow NULL? |
| 37 | PROCESSID | Process Identification -> Accounting Reference Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | RECAPROCESSID | Allow NULL? |
