| 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 | MCAVAR | MCA Variant | nvarchar | 10 | 0 | CHAR | (N' ') | No | GLE_MCA_TMCAVAR | GLE_MCA_DTE_MCAVAR | Allow NULL? |
| 3 | PRCCAT | Process Category | nvarchar | 6 | 0 | CHAR | (N' ') | No | * | GLE_MCA_DTE_PRC_CAT | Allow NULL? |
| 4 | PRCTYPE | Process Type | nvarchar | 10 | 0 | CHAR | (N' ') | No | GLE_MCA_TPRCTYPE | GLE_MCA_DTE_PRC_TYPE | Allow NULL? |
| 5 | SUBLEDGER_AR | Subledger AR Valuation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | GLE_MCA_DTE_FXR_SUBLEDER_AR | Allow NULL? |
| 6 | SUBLEDGER_AP | Subledger AP Valuation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | GLE_MCA_DTE_FXR_SUBLEDER_AP | Allow NULL? |
| 7 | AGGVAR_SRC | Aggregation Variant Source | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | GLE_MCA_TAGGVAR | GLE_MCA_DTE_AGG_VARIANT_SRC | Allow NULL? |
| 8 | AGGVAR_TGT | Aggregation Variant Target | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | GLE_MCA_TAGGVAR | GLE_MCA_DTE_AGG_VARIANT_TGT | Allow NULL? |
| 9 | TRANS_METH_FC | Use Original or Recalculate Functional Currency | char | 1 | 0 | CHAR | (N' ') | Yes | | GLE_MCA_DTE_TRANSFER_METH_FC | Allow NULL? |
| 10 | TRANS_METH_LCA | Use Original or Recalculate 1st Other Local Currency | char | 1 | 0 | CHAR | (N' ') | Yes | | GLE_MCA_DTE_TRANSFER_METH_LCA | Allow NULL? |
| 11 | TRANS_METH_LCB | Use Original or Recalculate 2nd Other Local Currency | char | 1 | 0 | CHAR | (N' ') | Yes | | GLE_MCA_DTE_TRANSFER_METH_LCB | Allow NULL? |
| 12 | FIXVALVAR_SRC | Fixed Values Variant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | GLE_MCA_TFIXVAL | GLE_MCA_DTE_FIXVAL_VARIANT_SRC | Allow NULL? |
| 13 | FIXVALVAR_TGT | Fixed Values Variant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | GLE_MCA_TFIXVAL | GLE_MCA_DTE_FIXVAL_VARIANT_TGT | Allow NULL? |