SAP ABAP Table CRM_ACE_DS_BW (CRM Accruals: BW Extraction Structure (Calculated Values))
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ FI-GL-GL-CAE (Application Component) CRM Accruals
⤷ FI_GL_CAE_CAE (Package) CRM Accruals
⤷ FI-GL-GL-CAE (Application Component) CRM Accruals
⤷ FI_GL_CAE_CAE (Package) CRM Accruals
Basic Data
Table Category | INTTAB | Structure |
Structure | CRM_ACE_DS_BW | Table Relationship Diagram |
Short Description | CRM Accruals: BW Extraction Structure (Calculated Values) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | CRM Accruals: Ref. Key Structure | |||||
2 | LOGSYS | LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | TBDLS | |
3 | PROCESS_TYPE | CRM_ACE_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | |||
4 | HEAD_NO | CRM_ACE_HEAD_NO | CRM_ACE_HEAD_NO | CHAR | 10 | 0 | Transaction Number | ||
5 | ITEM_NO | CRM_ACE_ITEM_NO | CRM_ACE_ITEM_NO | CHAR | 10 | 0 | Item Number in CRM Document | ||
6 | .INCLUDE | 0 | 0 | CRM Accruals: Ref. Subkey Structure | |||||
7 | SUB_ITEM_NO | CRM_ACE_SUB_ITEM_NO | CHAR | 10 | 0 | Subitem Number in CRM Document | |||
8 | .INCLUDE | 0 | 0 | Extraction Structure for BW (Calculated Values) | |||||
9 | COMP | ACE_COMP | ACE_COMP | CHAR | 4 | 0 | Accrual Engine Application Component | TACECOMP | |
10 | BUKRS | ACE_BUKRS | ACE_BUKRS | CHAR | 4 | 0 | Company Code | * | |
11 | OBJID | ACE_GUID | ACE_GUID | RAW | 16 | 0 | Accrual Object (Internal Display in Form of a GUID) | * | |
12 | SUBID | ACE_SUBID | NUMC | 5 | 0 | Accrual Subobject (Internal Display, Sequence Number) | |||
13 | REF_KEY | ACE_REF_KEY | ACE_REF_KEY | CHAR | 32 | 0 | Unique External Reference for Accrual Object | ||
14 | REF_SUBKEY | ACE_REF_SUBKEY | ACE_REF_SUBKEY | CHAR | 32 | 0 | Unique Reference for an Accrual Subobject | ||
15 | ACRTYPE | ACE_ACRTYPE | ACE_ACRTYPE | CHAR | 6 | 0 | Accrual Type | * | |
16 | ACCRULE | ACCOUNTING_PRINCIPLE | ACCOUNTING_PRINCIPLE | CHAR | 4 | 0 | Accounting Principle | TACC_PRINCIPLE | |
17 | DATE_FROM | ACE_DATEFROM_BW | DATS | DATS | 8 | 0 | From-Date of a BW Extractor Call | ||
18 | DATE_TO | ACE_DATETO_BW | DATS | DATS | 8 | 0 | To-Date of a BW Extractor Call | ||
19 | AMOUNT | ACE_TOTAL_AMOUNT | WERTV8 | CURR | 15 | 2 | Total Amount To Be Accrued | ||
20 | CURRENCY | ACE_DS_CURRENCY | WAERS | CUKY | 5 | 0 | Currency of Accrual Item | * | |
21 | QUANTITY | ACE_TOTAL_QUANTITY | MENGV8 | QUAN | 15 | 3 | Total Quantity To Be Accrued | ||
22 | UNIT | ACE_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure for Accrual Items | * | |
23 | VALITY_FROM | ACE_VALDATE_FROM | DATS | 8 | 0 | Start of Life of an Accrual Subobject | |||
24 | VALITY_TO | ACE_VALDATE_TO | DATS | 8 | 0 | End of Life of an Accrual Subobject | |||
25 | FY_VARIANT | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
26 | VALACT | ACE_ACCRUAL_VALUE_CALC | CURR | 15 | 2 | (Current) Accrual Amount | |||
27 | VALCUM | ACE_ACCRUAL_VALUE_CUM | CURR | 15 | 2 | Cumulative Accrual Amount To Date | |||
28 | VALREMAIN | ACE_ACCRUAL_VALUE_REMAINING | CURR | 15 | 2 | Remaining Value: Amount To Be Distributed in Future | |||
29 | SAP_CALCVAR1 | ACE_CALC_VARIABLE_1 | ACE_CALC_VARIABLES | CHAR | 20 | 0 | Variable for Calculating Accrual Amounts | ||
30 | SAP_CALCVAR2 | ACE_CALC_VARIABLE_2 | ACE_CALC_VARIABLES | CHAR | 20 | 0 | Variable for Calculating Accrual Amounts | ||
31 | SAP_CALCVAR3 | ACE_CALC_VARIABLE_3 | ACE_CALC_VARIABLES | CHAR | 20 | 0 | Variable for Calculating Accrual Amounts | ||
32 | SAP_CALCVAR4 | ACE_CALC_VARIABLE_4 | ACE_CALC_VARIABLES | CHAR | 20 | 0 | Variable for Calculating Accrual Amounts | ||
33 | SAP_CALCVAR5 | ACE_CALC_VARIABLE_5 | ACE_CALC_VARIABLES | CHAR | 20 | 0 | Variable for Calculating Accrual Amounts | ||
34 | SAP_CALCVAR6 | ACE_CALC_VARIABLE_6 | ACE_CALC_VARIABLES | CHAR | 20 | 0 | Variable for Calculating Accrual Amounts | ||
35 | SAP_CALCVAR7 | ACE_CALC_VARIABLE_7 | ACE_CALC_VARIABLES | CHAR | 20 | 0 | Variable for Calculating Accrual Amounts | ||
36 | SAP_CALCVAR8 | ACE_CALC_VARIABLE_8 | ACE_CALC_VARIABLES | CHAR | 20 | 0 | Variable for Calculating Accrual Amounts | ||
37 | .INCLUDE | 0 | 0 | Balance Sheet Account Assignments | |||||
38 | BUS_AREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
39 | PROFIT_CTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
40 | .INCLUDE | 0 | 0 | ||||||
41 | .INCLUDE | 0 | 0 | Account Assignment for Profit and Loss Accounts | |||||
42 | COSTCENTER | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
43 | ORDERID | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
44 | WBS_ELEMENT | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
45 | ACE_PL_ASS_REF | ACE_OBJNR | CHAR | 32 | 0 | External Reference | |||
46 | .INCLUDE | 0 | 0 | ||||||
47 | .INCLUDE | 0 | 0 | ACE Posting Server:Profitability Segment Auxiliary Structure | |||||
48 | CE4_KEY | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
49 | FIELDVAL1 | FIELDVAL | CHAR40 | CHAR | 40 | 0 | Value of any chosen local field | ||
50 | FIELDVAL2 | FIELDVAL | CHAR40 | CHAR | 40 | 0 | Value of any chosen local field | ||
51 | CPUDT | ACE_CREATEDATE | DATUM | DATS | 8 | 0 | Date on which the accrual subobject was added/changed |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRM_ACE_DS_BW | ACCRULE | TACC_PRINCIPLE | ACC_PRINCIPLE | |||
2 | CRM_ACE_DS_BW | COMP | TACECOMP | COMP | KEY | 1 | CN |
3 | CRM_ACE_DS_BW | LOGSYS | TBDLS | LOGSYS |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 500 |