| 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 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TKA01 | KOKRS | Allow NULL? |
| 3 | VERSA | Results Analysis Version | nvarchar | 3 | 0 | CHAR | (N' ') | No | | VERSN_ABGR | Allow NULL? |
| 4 | ABSBW | Cutoff Period for Planned Results Analysis | nvarchar | 7 | 0 | NUMC | (N'0000000') | No | | ABSCHL_PER_PLAN | Allow NULL? |
| 5 | ABSPE | Cutoff Period | nvarchar | 7 | 0 | NUMC | (N'0000000') | No | | ABSCHL_PER | Allow NULL? |
| 6 | RUNDZ | Rounding Number for Decimal Places | char | 1 | 0 | NUMC | (N'0') | No | | RUND_ZAHL | Allow NULL? |
| 7 | SCHIC | Indicator for Cost Component Split | char | 1 | 0 | CHAR | (N' ') | No | | SCHICHTUNG | Allow NULL? |
| 8 | TRBVA | Split According to Creation and Usage | char | 1 | 0 | CHAR | (N' ') | No | | BI_VB_AU | Allow NULL? |
| 9 | KERLE | Cost Element for Calculated Revenue | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_ERL_E | Allow NULL? |
| 10 | KKSTE | Cost Element for Calculated Costs | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_KST_E | Allow NULL? |
| 11 | KGWBS | Cost Element for Capitalized Profit | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_GWBST | Allow NULL? |
| 12 | KRDVB | Cost Element for Reserves for Imminent Loss (Crtn/Balance) | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_RDV_BI | Allow NULL? |
| 13 | KRDVV | Cost Element for Reserves for Imminent Loss (Usage) | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_RDV_VB | Allow NULL? |
| 14 | KRDVW | Cost Element for Reserves for Imminent Loss (Value Adjust.) | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_RDV_WB | Allow NULL? |
| 15 | KEBST | Cost Element for Revenue in Excess of Billings | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_EF_BST | Allow NULL? |
| 16 | KEUBS | Cost Element for Revenue Surplus | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_E_UBS | Allow NULL? |
| 17 | KGEWB | Cost Element for POC Profit Increase | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_GEW_BI | Allow NULL? |
| 18 | KGEWA | Cost Element for POC Profit Decrease | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_GEW_AU | Allow NULL? |
| 19 | KVRLB | Cost Element for POC Loss Creation | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_VRL_BI | Allow NULL? |
| 20 | KVRLA | Cost Element for POC Loss Cancellation | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_VRL_AU | Allow NULL? |
| 21 | KVRLV | Cost Element for POC Loss Realization | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_VRL_VB | Allow NULL? |
| 22 | KKSTI | Cost Element for Valuated Actual Costs | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_KST_I | Allow NULL? |
| 23 | KPROI | Cost Element for Valuated Actual Costs of Comp./Commissions | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_PRO_I | Allow NULL? |
| 24 | RFLG1 | Legacy Data Transfer | char | 1 | 0 | CHAR | (N' ') | No | | ALTDATEN | Allow NULL? |
| 25 | RFLG2 | Deletion of Results Analysis Data | char | 1 | 0 | CHAR | (N' ') | No | | LOESCHEN | Allow NULL? |
| 26 | RFLG3 | Transfer Results Analysis Data to Financial Accounting? | char | 1 | 0 | CHAR | (N' ') | No | | ABGRFIBUKZ | Allow NULL? |
| 27 | RFLG4 | Valuation Across Company Codes | char | 1 | 0 | CHAR | (N' ') | No | | BEW_ALL_BU | Allow NULL? |
| 28 | RFLG5 | Usage of Results Analysis Version | char | 1 | 0 | CHAR | (N' ') | No | | VSN_ABG_VW | Allow NULL? |
| 29 | RKST1 | Cost Element for Variances | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KST_ABW | Allow NULL? |
| 30 | RKST2 | Cost Elem Reduction in Rev.in Excess of Billg by Down Paymts | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KKA_KST_ANZ_KB | Allow NULL? |
| 31 | EZPOS | Generate Line Items | char | 1 | 0 | CHAR | (N' ') | No | | ENZLPOSUPD | Allow NULL? |
| 32 | RFLG6 | Can Orders for Project or Sales Order Have WIP? | char | 1 | 0 | CHAR | (N' ') | No | | AUFT_WIPEL | Allow NULL? |
| 33 | RFLG7 | Status Control | char | 1 | 0 | CHAR | (N' ') | No | | STATU_ZEIT | Allow NULL? |
| 34 | RFLG8 | Copy Flag: Copy or Maintain Referenced Version | char | 1 | 0 | CHAR | (N' ') | No | | KKA_KOPIE | Allow NULL? |
| 35 | ZOABG | Interpret Assignment with Results Analysis Key? | char | 1 | 0 | CHAR | (N' ') | No | | ABGSL_TKAZ | Allow NULL? |
| 36 | FSABG | Define Update Separately for Each Results Analysis Key | char | 1 | 0 | CHAR | (N' ') | No | | ABGSL_TKAR | Allow NULL? |
| 37 | RFLG9 | Cross-Business-Area Valuation | char | 1 | 0 | CHAR | (N' ') | Yes | | KKA_BEW_ALL_GB | Allow NULL? |
| 38 | RFLG10 | Object Currency in Results Analysis | char | 1 | 0 | CHAR | (N' ') | Yes | | KKA_OBJEKTWAEHRUNG | Allow NULL? |
| 39 | RFLG11 | Reserved for SAP Development | char | 1 | 0 | CHAR | (N' ') | Yes | | RESERV_FLG | Allow NULL? |
| 40 | RFLG12 | Reserved for SAP Development | char | 1 | 0 | CHAR | (N' ') | Yes | | RESERV_FLG | Allow NULL? |
| 41 | RKST3 | Cost Element for Down Payment Surplus | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KKA_KST_ANZ_UE | Allow NULL? |
| 42 | REFVA | Associated Results Analysis Version w/ Operational Valuation | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TKKAP | KKA_REFVA | Allow NULL? |
| 43 | VALUTYP | Valuation View | char | 1 | 0 | NUMC | (N'0') | Yes | | VALUTYP | Allow NULL? |
| 44 | ABRKZI | Version of Actual RA Data Relevant to Settlement | char | 1 | 0 | CHAR | (N' ') | Yes | | KKA_ABRKZI | Allow NULL? |
| 45 | ABROBI | Flag: Objects Settled with Actual Results Analysis | char | 1 | 0 | CHAR | (N' ') | Yes | | KKA_OBIABR | Allow NULL? |
| 46 | VERSP | Plan Version | nvarchar | 3 | 0 | CHAR | (N' ') | No | TKA09 | PLAN_VERSN | Allow NULL? |
| 47 | ABRKZP | Version of Planned RA Data Relevant to Settlement | char | 1 | 0 | CHAR | (N' ') | Yes | | KKA_ABRKZP | Allow NULL? |
| 48 | ABROBP | Flag: Objects Settled with Planned Results Analysis | char | 1 | 0 | CHAR | (N' ') | Yes | | KKA_OBPABR | Allow NULL? |
| 49 | FIBUP | Transfer Planned Results Analysis to Financial Accounting? | char | 1 | 0 | CHAR | (N' ') | Yes | | KKA_P_FIBU | Allow NULL? |
| 50 | BUABG | Interpret Posting Rule with Results Analysis Key? | char | 1 | 0 | CHAR | (N' ') | Yes | | ABGSL_TKAB | Allow NULL? |
| 51 | PLBFS | Update Plan Values of Valuation | char | 1 | 0 | CHAR | (N' ') | No | | KKA_PLBFS | Allow NULL? |
| 52 | PLBERL | Cost Element for Planned Revenues of Valuation | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KKA_KST_PLB_ERL | Allow NULL? |
| 53 | PLBKOS | Cost Element for Planned Costs of Valuation | nvarchar | 10 | 0 | CHAR | (N' ') | No | | KKA_KST_PLB_KOS | Allow NULL? |
| 54 | RKST4 | Cost Element Reserved for SAP Development | nvarchar | 10 | 0 | CHAR | (N' ') | No | | RESERV_KST | Allow NULL? |
| 55 | RKFT5 | Cost Element Reserved for SAP Development | nvarchar | 10 | 0 | CHAR | (N' ') | No | | RESERV_KST | Allow NULL? |
| 56 | SAVE_WIP | Indicator: Save Work in Progress Details for Reporting | char | 1 | 0 | CHAR | (N' ') | Yes | | AD01_SAVE_WIP | Allow NULL? |
