| 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 | TAB | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | DBNAM | Allow NULL? |
| 3 | CYCLE | Allocation/cycle | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CYCLE | Allow NULL? |
| 4 | SDATE | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | T811C | SDATE | Allow NULL? |
| 5 | SEQNR | Segment number within a cycle | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | SQNR | Allow NULL? |
| 6 | NAME | Name of a segment in assessment/distribution | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SEQNAME | Allow NULL? |
| 7 | SEQPOS | Item of segment in cycle | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SEQPOS | Allow NULL? |
| 8 | SRULE | Assessment/distribution rule sender | char | 1 | 0 | CHAR | (N' ') | Yes | | SRULE | Allow NULL? |
| 9 | RRULE | Assessment/Distribution Rule Receiver | char | 1 | 0 | CHAR | (N' ') | Yes | | RRULE | Allow NULL? |
| 10 | ACTIVE | Indicator: Segment Locked | char | 1 | 0 | CHAR | (N' ') | Yes | | SEQBLK | Allow NULL? |
| 11 | NEGTEST | Indicator: Scale Negative Tracing Factors | char | 1 | 0 | NUMC | (N'0') | Yes | | NEGTEST | Allow NULL? |
| 12 | SCSET | Set ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SETNR | Allow NULL? |
| 13 | SSET | Set ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SETNR | Allow NULL? |
| 14 | RSET | Set ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SETNR | Allow NULL? |
| 15 | RCSET | Set ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SETNR | Allow NULL? |
| 16 | SPERCENT | Sender percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | SNDPERCENT | |
| 17 | SFFELD1 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 18 | SFFELD2 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 19 | SFFELD3 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 20 | SFFELD4 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 21 | SFFELD5 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 22 | SFFELD6 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 23 | SFFELD7 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 24 | SFFELD8 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 25 | SFFELD9 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 26 | SFFELD10 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 27 | FACURR | Currency key allocations | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | FACUR | Allow NULL? |
| 28 | RFFELD1 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 29 | RFFELD2 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 30 | RFFELD3 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 31 | RFFELD4 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 32 | RFFELD5 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 33 | RFFELD6 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 34 | RFFELD7 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 35 | RFFELD8 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 36 | RFFELD9 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 37 | RFFELD10 | Fixed amount field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIX_AMOUNT | Allow NULL? |
| 38 | SCIP | Origin plan/actual | char | 1 | 0 | CHAR | (N' ') | Yes | | SCFLAG | Allow NULL? |
| 39 | RCDATA | Field group | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FIELDGROUP | Allow NULL? |
| 40 | ASACC | Assessment Cost Element | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ASACC | Allow NULL? |
| 41 | PAFLDF | Value field name for fixed cost center costs | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | RKE_FELDF | Allow NULL? |
| 42 | PAFLDG | Value field for variable cost-center costs | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | RKE_FELDG | Allow NULL? |
| 43 | RRFELD1 | Account assignment field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | KALC_RRFLD | Allow NULL? |
| 44 | SORTFIELD | Segment Sort Field | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KALC_SORTF | Allow NULL? |
| 45 | SENDER_NOT | Exclude Sender as Receiver | char | 1 | 0 | CHAR | (N' ') | Yes | | KALC_SNOR | Allow NULL? |
| 46 | MRULE | Allocation: Manipulation Rule for Cyclical Maintenance | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | KALC_MRULE | Allow NULL? |
| 47 | ABSCH | Allocation Structure for Settlement/Assessment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BRGABSCH | Allow NULL? |
| 48 | ERSCH | PA transfer structure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ERSCH | Allow NULL? |
| 49 | SWEIGHT_FACT | Decimal Places Factor for Sender Weighting Factors | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | KALC_SWEIGHTF | Allow NULL? |
| 50 | RWEIGHT_FACT | Decimal Places Factor of the Receiver Weighting Factors | nvarchar | 7 | 0 | NUMC | (N'0000000') | Yes | | KALC_RWEIGHTF | Allow NULL? |
