CRM_ACE_PS_BW SAP (CRM Accruals: BW Extraction Structure (Posted Values)) Structure details

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




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




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

CRM_ACE_PS_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 (Posted 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_PS_BW TYPE CRM_ACE_PS_BW.

The CRM_ACE_PS_BW table consists of various fields, each holding specific information or linking keys about CRM Accruals: BW Extraction Structure (Posted 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_PS_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_COMPCHAR4Assigned to domainACE_COMPACE_COMP
BUKRSCompany Code ACE_BUKRSCHAR4Assigned to domainACE_BUKRSACE_BUKRSACE_BUKRS
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_PRINCIPLECHAR4Assigned to domainACCOUNTING_PRINCIPLEACCOUNTING_PRINCIPLE
FYEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
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
CUMVALCAPCumulative Asset Balance Sheet Value Posted in Previous Yrs ACE_CUM_AMOUNT_CAPITALIZEDCURR15(2)
VALCAPPosted Asset Balance Sheet Value (by Year) ACE_AMOUNT_CAPITALIZEDCURR15(2)
CUMVALACTCumulative Recognition Posted in Previous Years ACE_CUM_AMOUNT_ACCRUEDCURR15(2)
VALACTRecognition Postings Made (Year-Based) ACE_AMOUNT_ACCRUEDCURR15(2)
VALRETIREPosted Retirement Amount ACE_AMOUNT_RETIREDCURR15(2)
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_PS_BW using ABAP code?

As CRM_ACE_PS_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_PS_BW as there is no data to select.

How to access SAP table CRM_ACE_PS_BW

Within an ECC or HANA version of SAP you can also view further information about CRM_ACE_PS_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!