CRM_ACE_DS_BW SAP (CRM Accruals: BW Extraction Structure (Calculated Values)) Structure details

Dictionary Type: Structure
Description: CRM Accruals: BW Extraction Structure (Calculated Values)




ABAP Code to SELECT data from CRM_ACE_DS_BW
Related tables to CRM_ACE_DS_BW
Access table CRM_ACE_DS_BW




Structure field list including key, data, relationships and ABAP select examples

CRM_ACE_DS_BW is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "CRM Accruals: BW Extraction Structure (Calculated Values)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CRM_ACE_DS_BW TYPE CRM_ACE_DS_BW.

The CRM_ACE_DS_BW table consists of various fields, each holding specific information or linking keys about CRM Accruals: BW Extraction Structure (Calculated Values) data available in SAP. These include LOGSYS (Logical System), PROCESS_TYPE (Business Transaction Type), HEAD_NO (Transaction Number), ITEM_NO (Item Number in CRM Document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CRM_ACE_DS_BW structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
LOGSYSLogical System LOGSYSTEMCHAR10TBDLSALPHALOGSYS
PROCESS_TYPEBusiness Transaction Type CRM_ACE_PROCESS_TYPECHAR4CRM_ACE_PROCESS_TYPE
HEAD_NOTransaction Number CRM_ACE_HEAD_NOCHAR10ALPHACRM_ACE_HEAD_NOCRM_ACE_HEAD_NO
ITEM_NOItem Number in CRM Document CRM_ACE_ITEM_NOCHAR10ALPHACRM_ACE_ITEM_NOCRM_ACE_ITEM_NO
SUB_ITEM_NOSubitem Number in CRM Document CRM_ACE_SUB_ITEM_NOCHAR10
COMPAccrual Engine Application Component ACE_COMPCHAR4TACECOMPACE_COMPACE_COMP
BUKRSCompany Code ACE_BUKRSCHAR4Assigned to domainACE_BUKRSACE_BUKRSACE_BUKRS
OBJIDAccrual Object (Internal Display in Form of a GUID) ACE_GUIDRAW16Assigned to domainACE_GUIDACE_OBJID
SUBIDAccrual Subobject (Internal Display, Sequence Number) ACE_SUBIDNUMC5ACE_SUBID
REF_KEYUnique External Reference for Accrual Object ACE_REF_KEYCHAR32ACE_REF_KEYACE_REF_KEY
REF_SUBKEYUnique Reference for an Accrual Subobject ACE_REF_SUBKEYCHAR32ACE_REF_SUBKEYACE_REF_SUBKEY
ACRTYPEAccrual Type ACE_ACRTYPECHAR6Assigned to domainALPHAACE_ACRTYPEACE_ACRTYPEACE_ACRTYPES_GET
ACCRULEAccounting Principle ACCOUNTING_PRINCIPLECHAR4TACC_PRINCIPLEACCOUNTING_PRINCIPLEACCOUNTING_PRINCIPLE
DATE_FROMFrom-Date of a BW Extractor Call ACE_DATEFROM_BWDATS8DATS
DATE_TOTo-Date of a BW Extractor Call ACE_DATETO_BWDATS8DATS
AMOUNTTotal Amount To Be Accrued ACE_TOTAL_AMOUNTCURR15(2) WERTV8
CURRENCYCurrency of Accrual Item ACE_DS_CURRENCYCUKY5Assigned to domainWAERS
QUANTITYTotal Quantity To Be Accrued ACE_TOTAL_QUANTITYQUAN15(3) MENGV8
UNITUnit of Measure for Accrual Items ACE_UNITUNIT3Assigned to domainCUNITMEINS
VALITY_FROMStart of Life of an Accrual Subobject ACE_VALDATE_FROMDATS8
VALITY_TOEnd of Life of an Accrual Subobject ACE_VALDATE_TODATS8
FY_VARIANTFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VALACT(Current) Accrual Amount ACE_ACCRUAL_VALUE_CALCCURR15(2)
VALCUMCumulative Accrual Amount To Date ACE_ACCRUAL_VALUE_CUMCURR15(2)
VALREMAINRemaining Value: Amount To Be Distributed in Future ACE_ACCRUAL_VALUE_REMAININGCURR15(2)
SAP_CALCVAR1Variable for Calculating Accrual Amounts ACE_CALC_VARIABLE_1CHAR20ACE_CALC_VARIABLES
SAP_CALCVAR2Variable for Calculating Accrual Amounts ACE_CALC_VARIABLE_2CHAR20ACE_CALC_VARIABLES
SAP_CALCVAR3Variable for Calculating Accrual Amounts ACE_CALC_VARIABLE_3CHAR20ACE_CALC_VARIABLES
SAP_CALCVAR4Variable for Calculating Accrual Amounts ACE_CALC_VARIABLE_4CHAR20ACE_CALC_VARIABLES
SAP_CALCVAR5Variable for Calculating Accrual Amounts ACE_CALC_VARIABLE_5CHAR20ACE_CALC_VARIABLES
SAP_CALCVAR6Variable for Calculating Accrual Amounts ACE_CALC_VARIABLE_6CHAR20ACE_CALC_VARIABLES
SAP_CALCVAR7Variable for Calculating Accrual Amounts ACE_CALC_VARIABLE_7CHAR20ACE_CALC_VARIABLES
SAP_CALCVAR8Variable for Calculating Accrual Amounts ACE_CALC_VARIABLE_8CHAR20ACE_CALC_VARIABLES
BUS_AREABusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PROFIT_CTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
COSTCENTERCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
ORDERIDOrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
WBS_ELEMENTWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
ACE_PL_ASS_REFExternal Reference ACE_OBJNRCHAR32
CE4_KEYProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
FIELDVAL1Value of any chosen local field FIELDVALCHAR40CHAR40
FIELDVAL2Value of any chosen local field FIELDVALCHAR40CHAR40
CPUDTDate on which the accrual subobject was added/changed ACE_CREATEDATEDATS8DATUM

Key field Non-key field



How do I retrieve data from SAP structure CRM_ACE_DS_BW using ABAP code?

As CRM_ACE_DS_BW is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CRM_ACE_DS_BW as there is no data to select.

How to access SAP table CRM_ACE_DS_BW

Within an ECC or HANA version of SAP you can also view further information about CRM_ACE_DS_BW and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!