V_ACEPSOIT SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
V_ACEPSOIT is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The V_ACEPSOIT table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include COMP (Accrual Engine Application Component), BUKRS (Company Code), GJAHR (Fiscal Year in Accrual Engine), ACRTYPE (Accrual Type).. 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: Not classified
SAP V_ACEPSOIT table view 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 |
| MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
| COMP | Accrual Engine Application Component | ACE_COMP | CHAR | 4 | TACECOMP | ACE_COMP | ACE_COMP | ||
| BUKRS | Company Code | ACE_BUKRS | CHAR | 4 | ACE_BUKRS | ACE_BUKRS | ACE_BUKRS | ||
| GJAHR | Fiscal Year in Accrual Engine | ACEPS_GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| ACRTYPE | Accrual Type | ACE_ACRTYPE | CHAR | 6 | TACE_ACRTYPE | ALPHA | ACE_ACRTYPE | ACE_ACRTYPE | ACE_ACRTYPES_GET |
| ACCRULE | Accounting Principle | ACCOUNTING_PRINCIPLE | CHAR | 4 | TACC_PRINCIPLE | ACCOUNTING_PRINCIPLE | ACCOUNTING_PRINCIPLE | ||
| DOCNR | Document Number of an Accrual Engine Document | ACEPS_DOCNR | CHAR | 15 | CHAR15 | ACE_DOCNR | |||
| VALCUM | Cumulative Value (Previously Accrued) | ACE_AMOUNT_CUMULATED | CURR | 15(2) | |||||
| VALTBP | Amount Currently Posted | ACE_AMOUNT_TBP | CURR | 15(2) | |||||
| CURRENCY | Currency Calculated/Posted in the Accrual Amounts | ACEDS_VALCURRENCY | CUKY | 5 | WAERS | ACEDS_VALCURRENCY | |||
| TRANSTYPE | Transaction in Accrual Engine | ACE_TRANSTYPE | CHAR | 1 | ACE_TRANSTYPE | ACE_TRANSTYPE | |||
| EFFDATE | Key Date/Posting Date for Accruals | ACE_EFFDATE | DATS | 8 | ACE_KEYDATE | ||||
| PODATE | Posting Date | ACE_PODATE | DATS | 8 | DATUM | ACE_PODATE | |||
| POPER | Posting Period in Financial Accounting | ACE_POPER | NUMC | 3 | POPER | ACE_POPER | |||
| POYEAR | Fiscal Year in Financial Accounting | ACE_POYEAR | NUMC | 4 | GJAHR | GJAHR | ACE_POYEAR | ||
| RUNID | Number (Run ID) of a Periodic Accrual Run in the Accl Engine | ACEPS_RUNID | CHAR | 10 | ALPHA | ACEPS_RUNID | ACE_RUNID | ||
| AWTYP | Reference Transaction | AWTYP | CHAR | 5 | AWTYP | ||||
| AWKEY | Reference Key for Accounting Document | ACE_AWKEY | CHAR | 20 | AWKEY | ||||
| AWSYS | Logical system of source document | AWSYS | CHAR | 10 | ALPHA | LOGSYS | |||
| TIMESTMP | Time Added (Greenwich Meantime) | ACE_HZSTMP | DEC | 16 | ACE_TSTMP | ||||
| REVERSAL_DOC | Indicator: Document Is a Reversal Document | ACEPS_FLAG_REVERSAL_DOC | CHAR | 1 | FLAG | ||||
| REVERSED_DOC | Number of the Reversed Accrual Engine Document | ACEPS_DOCNR_REVERSED | CHAR | 15 | CHAR15 | ||||
| SUBID | Accrual Subobject (Internal Display, Sequence Number) | ACE_SUBID | NUMC | 5 | ACE_SUBID | ||||
| UNAME | User Name | ACE_UNAME | CHAR | 12 | UNAME | ||||
| CPUDT | Date on which the accrual subobject was added/changed | ACE_CREATEDATE | DATS | 8 | DATUM | ||||
| CPUTM | Time at which the accrual subobject was added/changed | ACE_CREATETIME | TIMS | 6 | TIME | ||||
| DEACTDATE | Deactivation Date | ACE_DEACTDATE | DATS | 8 | |||||
| STATUS | Processing Status of Posting Data of an Accrual Subobject | ACEPS_HEADER_STATUS | CHAR | 1 | ACEPS_HEADER_STATUS | ||||
| FIRSTYEAR | First Fiscal Year | ACE_FIRSTYEAR | NUMC | 4 | GJAHR | GJAHR | |||
| LASTYEAR | Last Fiscal Year | ACE_LASTYEAR | NUMC | 4 | GJAHR | GJAHR | |||
| OBJID | Accrual Object (Internal Display in Form of a GUID) | ACE_GUID | RAW | 16 | ACE_GUID | ACE_OBJID | |||
| REF_KEY | Unique External Reference for Accrual Object | ACE_REF_KEY | CHAR | 32 | ACE_REF_KEY | ACE_REF_KEY | |||
| REF_SUBKEY | Unique Reference for an Accrual Subobject | ACE_REF_SUBKEY | CHAR | 32 | ACE_REF_SUBKEY | ACE_REF_SUBKEY | |||
| OBJSTATUS | Processing Status of an Accrual Object | ACE_OBJECT_STATUS | CHAR | 1 | ACE_OBJECT_STATUS |
| Key field | Non-key field |
How do I retrieve data from SAP table V_ACEPSOIT using ABAP code
The following ABAP code Example will allow you to do a basic selection on V_ACEPSOIT to SELECT all data from the tableDATA: WA_V_ACEPSOIT TYPE V_ACEPSOIT.
SELECT SINGLE *
FROM V_ACEPSOIT
INTO CORRESPONDING FIELDS OF WA_V_ACEPSOIT
WHERE...
How to access SAP table V_ACEPSOIT
Within an ECC or HANA version of SAP you can also view further information about V_ACEPSOIT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects