SPSINFO_FC101 SAP (Structure for Project Structure Overview Reporting) Structure details
Description: Structure for Project Structure Overview Reporting
Related tables to SPSINFO_FC101
Access table SPSINFO_FC101
Structure field list including key, data, relationships and ABAP select examples
SPSINFO_FC101 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 "Structure for Project Structure Overview Reporting" 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_SPSINFO_FC101 TYPE SPSINFO_FC101.
The SPSINFO_FC101 table consists of various fields, each holding specific information or linking keys about Structure for Project Structure Overview Reporting data available in SAP. These include ARNUMMER (Archiving Session Number), VSGRUPPE (Group for a project version), VSNUMMER (Number or description of a version), OBJEKTID (ID/Object key).. 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 SPSINFO_FC101 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 |
ARNUMMER | Archiving Session Number | ADMI_RUN_D | CHAR | 6 | ADMI_RUN | ||||
VSGRUPPE | Group for a project version | VSGRUPPE | CHAR | 20 | TEXT20 | ||||
VSNUMMER | Number or description of a version | VSNMR | CHAR | 12 | VSNMR | VS2 | |||
OBJEKTID | ID/Object key | PS_IS_ID | CHAR | 40 | CHAR40 | ||||
KURZTEXT | Short text/description of the object | KURZTEXT | CHAR | 40 | TEXT40 | ||||
OBJEKTTYP | Object Type Text | OTEXT | CHAR | 25 | TEXT25 | ||||
ECKST | Basic start date | PS_ECKST | DATS | 8 | DATUM | ||||
ECKEN | Finish date (from basic dates) | PS_ECKEN | DATS | 8 | DATUM | ||||
PROGST | Forecast start date | PS_PROGST | DATS | 8 | DATUM | ||||
PROGEN | Forecast finish date | PS_PROGEN | DATS | 8 | DATUM | ||||
TESTFR | Earliest scheduled start (from basic dates) | PS_TESTFR | DATS | 8 | DATUM | ||||
TEENFR | Earliest scheduled finish (from basic dates) | PS_TEENFR | DATS | 8 | DATUM | ||||
TESTSP | Latest scheduled start (from basic dates) | PS_TESTSP | DATS | 8 | DATUM | ||||
TEENSP | Latest scheduled finish (from basic dates) | PS_TEENSP | DATS | 8 | DATUM | ||||
TPSTFR | Earliest scheduled start (from forecast dates) | PS_TPSTFR | DATS | 8 | DATUM | ||||
TPENFR | Earliest scheduled finish (from forecast dates) | PS_TPENFR | DATS | 8 | DATUM | ||||
TPSTSP | Latest scheduled start (from forecast dates) | PS_TPSTSP | DATS | 8 | DATUM | ||||
TPENSP | Latest scheduled finish (from forecast dates) | PS_TPENSP | DATS | 8 | DATUM | ||||
VORLST | Tentative start date | PS_VORLST | DATS | 8 | DATUM | ||||
VORLEN | Tentative finish date | PS_VORLEN | DATS | 8 | DATUM | ||||
ISTST | Actual start date | PS_ISTST | DATS | 8 | DATUM | ||||
ISTEN | Actual finish date | PS_ISTEN | DATS | 8 | DATUM | ||||
DATFS | Earliest start date | PS_DATFS | DATS | 8 | DATUM | ||||
DATSE | Latest finish date | PS_DATSE | DATS | 8 | DATUM | ||||
EDAUER | Duration | PS_EDAUER_2 | QUAN | 10(1) | DAUER_9_1 | ||||
EDAUEH | Actual duration unit | PS_DAUEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PDAUER | Forecast duration | PS_PDAUER_VZ | QUAN | 10(1) | PS_DAUER_VZ | ||||
PDAUEH | Actual duration unit | PS_DAUEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VDAUER | Tentative duration | PS_VDAUER_VZ | QUAN | 10(1) | PS_DAUER_VZ | ||||
VDAUEH | Actual duration unit | PS_DAUEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
IDAUER | Actual duration | PS_IDAUER_VZ | QUAN | 10(1) | PS_DAUER_VZ | ||||
IDAUEH | Actual duration unit | PS_DAUEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
RDAUER | Remaining duration | PS_RDAUER_VZ | QUAN | 10(1) | PS_DAUER_VZ | ||||
RDAUEH | Actual duration unit | PS_DAUEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ABARBD | Processing % of duration | PS_ABARBD | NUMC | 3 | CO_ABARB | ||||
EARBEI | Work | PS_EARBEI_2 | QUAN | 13(3) | PS_ARBEIT_2 | ||||
EARBEH | Unit for work | PS_ARBEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PARBEI | Forecast work | PS_PARBEI_VZ | QUAN | 13(3) | PS_ARBEIT_VZ | ||||
PARBEH | Unit for work | PS_ARBEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VARBEI | Tentative work | PS_VARBEI_VZ | QUAN | 13(3) | PS_ARBEIT_VZ | ||||
VARBEH | Unit for work | PS_ARBEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
IARBEI | Actual work | PS_IARBEI_VZ | QUAN | 13(3) | PS_ARBEIT_VZ | ||||
IARBEH | Unit for work | PS_ARBEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
RARBEI | Remaining work | PS_RARBEI_VZ | QUAN | 13(3) | PS_ARBEIT_VZ | ||||
RARBEH | Unit for work | PS_ARBEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ABARBA | Percent of completion for work | PS_ABARBA | NUMC | 3 | CO_ABARB | ||||
SLWID | Key word ID for user-defined fields | SLWID | CHAR | 7 | Assigned to domain | SLWID | |||
USR00 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
USR01 | User field with 20 characters | USRCHAR20 | CHAR | 20 | USRCHAR20 | ||||
USR02 | User field with 10 characters | USRCHAR10 | CHAR | 10 | USRCHAR10 | ||||
USR03 | User field with 10 characters | USRCHAR10 | CHAR | 10 | USRCHAR10 | ||||
USR04 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13(3) | USRQUAN13 | ||||
USE04 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
USR05 | User field for quantity (length 10.3) | USRQUAN13 | QUAN | 13(3) | USRQUAN13 | ||||
USE05 | User field: Unit for quantity fields | USRUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
USR06 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13(3) | USRCURR13 | ||||
USE06 | User field: Unit for value fields | USRCUKY | CUKY | 5 | Assigned to domain | WAERS | |||
USR07 | User-defined field for values (length 10,3) | USRCURR13 | CURR | 13(3) | USRCURR13 | ||||
USE07 | User field: Unit for value fields | USRCUKY | CUKY | 5 | Assigned to domain | WAERS | |||
USR08 | User field for date | USRDATE | DATS | 8 | USRDATE | ||||
USR09 | User field for date | USRDATE | DATS | 8 | USRDATE | ||||
USR10 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | FLAG | ||||
USR11 | User-defined field: Indicator for reports | USRFLAG | CHAR | 1 | FLAG | ||||
VERNR | Number of responsible person (project mgr)/MRP controller | PS_VERNR_C | CHAR | 8 | CHAR8 | ||||
VERNA | Name of responsible person (Project manager) | PS_VERNA | CHAR | 25 | PS_VERNA | ||||
AENNR | Change Number | AENNR | CHAR | 12 | Assigned to domain | AENNR | AENNR | AEN | |
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
ARBPL | Work center | ARBPL | CHAR | 8 | ARBPL | AGR | |||
KALID | Factory Calendar | WFCID | CHAR | 2 | Assigned to domain | WFCID | FCI | ||
TXTSP | Language: The long text was stored in this language | LTXSP | LANG | 1 | Assigned to domain | ISOLA | SPRAS | ||
PSPRI | Priority | NW_PRIO | CHAR | 1 | Assigned to domain | NW_PRIO | |||
STATXT | Edited status text | STATUSTEXT_2 | CHAR | 80 | CHAR80 | ||||
FRUEHER | Actual start is before earliest scheduled start | FRUEHER_2 | QUAN | 10(1) | DAUER_9_1 | ||||
SPAETER | Actual Finish/Planned Finish After Latest Scheduled Finish | SPAETER_2 | QUAN | 10(1) | DAUER_9_1 | ||||
VERZUG | Duration After Latest Scheduled Finish | VERZUG_2 | QUAN | 10(1) | DAUER_9_1 | ||||
VORBEI | Duration After Earliest Scheduled Start | VORBEI_2 | QUAN | 10(1) | DAUER_9_1 | ||||
VEINH | Unit for Duration of the Delay | VERZ_EINHT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PUFGS | Total float | PUFFR_GESM | DEC | 3 | PUFFER | ||||
PUFFR | Free float | PUFFR_FREI | DEC | 3 | PUFFER | ||||
PUFGP | Total float (from forecast) | PPUFF_GESM | DEC | 3 | PUFFER | ||||
PUFFP | Free float (from forecast) | PPUFF_FREI | DEC | 3 | PUFFER | ||||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
OWAERS | Object currency for network activity | OWAERS | CUKY | 5 | Assigned to domain | WAERS | |||
MEINH | Unit of Measure for Display | MEINH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PROKSTPLAN | Current project cost plan | PROKSTPLAN | CURR | 15(2) | WERTV8 | ||||
PROKSTPLN2 | Project cost plan (version 2) | PROKSTPLN2 | CURR | 15(2) | WERTV8 | ||||
AUFKSTPLAN | Current order cost plan | AUFKSTPLAN | CURR | 15(2) | WERTV8 | ||||
AUFKSTPLN2 | Order cost plan (version 2) | AUFKSTPLN2 | CURR | 15(2) | WERTV8 | ||||
PROERLPLAN | Current project revenue plan | PROERLPLAN | CURR | 15(2) | WERTV8 | ||||
PROERLPLN2 | Project revenue plan (version 2) | PROERLPLN2 | CURR | 15(2) | WERTV8 | ||||
AUFERLPLAN | Current order revenue plan | AUFERLPLAN | CURR | 15(2) | WERTV8 | ||||
AUFERLPLN2 | Order revenue plan (version 2) | AUFERLPLN2 | CURR | 15(2) | WERTV8 | ||||
KREDFINPLN | Current financial budget, credit side | KREDFINPLN | CURR | 15(2) | WERTV8 | ||||
DEBFINPLN | Current cash budget, debit side | DEBFINPLN | CURR | 15(2) | WERTV8 | ||||
BUDGET | Budget of a Measure (App. Request Variant Was Replaced) | BUDGET | CURR | 15(2) | WERTV8 | ||||
FREIGABE | Release | FREIGABE | CURR | 15(2) | WERTV8 | ||||
AUFTRANF | Residual order plan | AUFTRANF | CURR | 15(2) | WERTV8 | ||||
FESTPROBL | Fixed price commitment | FESTPROBL | CURR | 15(2) | WERTV8 | ||||
KSTOBLGES | Total cost commitment | KSTOBLGES | CURR | 15(2) | WERTV8 | ||||
ISTKOSTEN | Actual costs | ISTKOSTEN | CURR | 15(2) | WERTV8 | ||||
ISTERLOESE | Actual revenues | ISTERLOESE | CURR | 15(2) | WERTV8 | ||||
KZHLNG | Total credit side payments (down payments and payments) | KZHLNG | CURR | 15(2) | WERTV8 | ||||
DZHLNG | Total debit side payments (down payments and payments) | DZHLNG | CURR | 15(2) | WERTV8 | ||||
.INCLU--AP | 0 | ||||||||
PROKSTPLAN_OC | Current Project Cost Plan in Object Currency | PROKSTPLANOC | CURR | 15(2) | WERTV8 | ||||
PROKSTPLN2_OC | Project Cost Plan (Version 2) in Object Currency | PROKSTPLN2OC | CURR | 15(2) | WERTV8 | ||||
AUFKSTPLAN_OC | Current Order Cost Plan in Object Currency | AUFKSTPLANOC | CURR | 15(2) | WERTV8 | ||||
AUFKSTPLN2_OC | Order Cost Plan (Version 2) in Object Currency | AUFKSTPLN2OC | CURR | 15(2) | WERTV8 | ||||
PROERLPLAN_OC | Current Project Revenue Plan in Object Currency | PROERLPLANOC | CURR | 15(2) | WERTV8 | ||||
PROERLPLN2_OC | Project Revenue Plan (Version 2) in Object Currency | PROERLPLN2OC | CURR | 15(2) | WERTV8 | ||||
AUFERLPLAN_OC | Current Order Revenue Plan in Object Currency | AUFERLPLANOC | CURR | 15(2) | WERTV8 | ||||
AUFERLPLN2_OC | Order Revenue Plan (Version 2) in Object Currency | AUFERLPLN2OC | CURR | 15(2) | WERTV8 | ||||
KREDFINPLN_OC | Current Credit Side Cash Budget in Object Currency | KREDFINPLNOC | CURR | 15(2) | WERTV8 | ||||
DEBFINPLN_OC | Current Debit Side Cash Budget in Object Currency | DEBFINPLNOC | CURR | 15(2) | WERTV8 | ||||
BUDGET_OC | Appropriation Budget (Appr.Request Variant Replaced) in OC | BUDGETOC | CURR | 15(2) | WERTV8 | ||||
FREIGABE_OC | Release in Object Currency | FREIGABEOC | CURR | 15(2) | WERTV8 | ||||
AUFTRANF_OC | Residual Order Plan in Object Currency | AUFTRANFOC | CURR | 15(2) | WERTV8 | ||||
FESTPROBL_OC | Fixed Price Commitment in Object Currency | FESTPROBLOC | CURR | 15(2) | WERTV8 | ||||
KSTOBLGES_OC | Total Cost Commitment in Object Currency | KSTOBLGESOC | CURR | 15(2) | WERTV8 | ||||
ISTKOSTEN_OC | Act. Costs in Object Currency | ISTKOSTENOC | CURR | 15(2) | WERTV8 | ||||
ISTERLOESE_OC | Actual Revenues in Object Currency | ISTERLOESEOC | CURR | 15(2) | WERTV8 | ||||
KZHLNG_OC | Total Vendor Payments (Down Payments and Payments) OC | KZHLNGOC | CURR | 15(2) | WERTV8 | ||||
DZHLNG_OC | Total Customer Payments (Down Payments and Payments) OC | DZHLNGOC | CURR | 15(2) | WERTV8 | ||||
EV_PLAN_ORG1 | Budgeted cost of work scheduled | EVPLANORG1 | CURR | 15(2) | WERTV8 | ||||
EV_ACT_ORG1 | Budgeted cost of work performed | EVACTORG1 | CURR | 15(2) | WERTV8 | ||||
EV_ACT_CORR1 | Budgeted cost of work performed, adjusted | EVACTCORR1 | CURR | 15(2) | WERTV8 | ||||
EV_PLAN_QUAN_ORG1 | Budgeted cost of work scheduled, quantity | EVPLANQUANORG1 | QUAN | 15(3) | CQUA8 | ||||
EV_PLAN_QUAN_ORG1_UNIT | BCWS, Unit of Measure | EV_PLAN_QUAN_ORG1_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
EV_ACT_QUAN_ORG1 | Budgeted cost of work performed, quantity | EVACTQUANORG1 | QUAN | 15(3) | CQUA8 | ||||
EV_ACT_QUAN_ORG1_UNIT | BCWP, Unit of Measure | EV_ACT_QUAN_ORG1_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
EV_ACT_QUAN_CORR1 | Budgeted cost of work performed, adjusted quantity | EVACTQUANCORR1 | QUAN | 15(3) | CQUA8 | ||||
EV_ACT_QUAN_CORR1_UNIT | BCWP, Adjusted Quantity (Unit) | EV_ACT_QUAN_CORR1_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
POC_PLAN_ORG_AGG1 | Aggregate planned percentage of completion | POCPLANORGAGG1 | DEC | 6(3) | EV_PROGRES | ||||
POC_PLAN_ORG_NAGG1 | Non-aggregated planned percentage of completion | POCPLANORGNAGG1 | DEC | 6(3) | EV_PROGRES | ||||
POC_ACT_ORG_AGG1 | Aggregated actual POC | POCACTORGAGG1 | DEC | 6(3) | EV_PROGRES | ||||
POC_ACT_ORG_NAGG1 | Non-aggregated actual percentage of completion | POCACTORGNAGG1 | DEC | 6(3) | EV_PROGRES | ||||
POC_ACT_CORR_AGG1 | Adjusted aggregated actual POC | POCACTCORRAGG1 | DEC | 6(3) | EV_PROGRES | ||||
POC_ACT_CORR_NAGG1 | Adjusted non-aggregated actual percentage of completion | POCACTCORRNAGG1 | DEC | 6(3) | EV_PROGRES | ||||
EV_COST_VAR_ORG | Cost Variance Based on EV_ACT_ORG1 | EWALVARORG | CURR | 15(2) | WERTV8 | ||||
EV_SCHED_VAR_ORG | Schedule Variance Based on EV_ACT_ORG1 | EVSCHVARORG | CURR | 15(2) | WERTV8 | ||||
EV_COST_INDX_ORG | Cost Index Based on EV_ACT_ORG1 | EWALINDXORG | DEC | 7(2) | DEC5_2 | ||||
EV_SCHED_INDX_ORG | Date Index Based on POC_ACT_ORG_AGG1 | EVSCHINDXORG | DEC | 7(2) | DEC5_2 | ||||
EV_COST_VAR_CORR | Cost Variance Based on EV_ACT_CORR1 | EWALVARCORR | CURR | 15(2) | WERTV8 | ||||
EV_SCHED_VAR_CORR | Schedule Variance Based on EV_ACT_CORR1 | EVSCHVARCORR | CURR | 15(2) | WERTV8 | ||||
EV_COST_INDX_CORR | Cost Index Based on EV_ACT_CORR1 | EWALINDXCORR | DEC | 7(2) | DEC5_2 | ||||
EV_SCHED_INDX_CORR | Date Index Based on POC_ACT_CORR_AGG1 | EVSCHINDXCORR | DEC | 7(2) | DEC5_2 | ||||
.INCLU--AP | 0 | ||||||||
EV_PLAN_ORG1_OC | Budgeted cost of work scheduled | EVPLANORG1 | CURR | 15(2) | WERTV8 | ||||
EV_ACT_ORG1_OC | Budgeted cost of work performed | EVACTORG1 | CURR | 15(2) | WERTV8 | ||||
EV_ACT_CORR1_OC | Budgeted cost of work performed, adjusted | EVACTCORR1 | CURR | 15(2) | WERTV8 | ||||
EV_COST_VAR_ORG_OC | Cost Variance Based on EV_ACT_ORG1 | EWALVARORG | CURR | 15(2) | WERTV8 | ||||
EV_SCHED_VAR_ORG_OC | Schedule Variance Based on EV_ACT_ORG1 | EVSCHVARORG | CURR | 15(2) | WERTV8 | ||||
EV_SCHED_VAR_CORR_OC | Cost Variance Based on EV_ACT_CORR1 | EWALVARCORR | CURR | 15(2) | WERTV8 | ||||
EV_COST_VAR_CORR_OC | Schedule Variance Based on EV_ACT_CORR1 | EVSCHVARCORR | CURR | 15(2) | WERTV8 | ||||
EVMET_P1 | Measurement method for PS progress analysis (plan) | EV_METHOD_PLN | CHAR | 10 | CHAR10 | ||||
EVMET_A1 | Measurement method in PS progress analysis (actual) | EV_METHOD_ACT | CHAR | 10 | CHAR10 | ||||
EVGEW | Aggregation weight for POC (PS progress) | EV_WEIGHTD | DEC | 8 | DEC8 | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
HIERSTUFE | Classification: Level in Hierarchy | HIERSTUFE | INT4 | 10 | INT4 | ||||
TABNAME | Table Name | TABNAME | CHAR | 30 | Assigned to domain | AS4TAB | DTB | ||
TABINDEX | Entry (line number on a list) | PS_ENTRY | INT4 | 10 | SYST_LONG | ||||
DIFFERENZ | Absolute difference | 0 | |||||||
DIFFPROZ | Percentage difference | 0 | |||||||
VERSFELD | Versions data | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure SPSINFO_FC101 using ABAP code?
As SPSINFO_FC101 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 SPSINFO_FC101 as there is no data to select.How to access SAP table SPSINFO_FC101
Within an ECC or HANA version of SAP you can also view further information about SPSINFO_FC101 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