CF003 SAP (Projects) Table details
Dictionary Type: Table
Description: Projects
Description: Projects
Table field list including key, data, relationships and ABAP select examples
CF003 is a standard SAP Table which is used to store Projects data and is available within R/3 SAP systems depending on the version and release level.
The CF003 table consists of various fields, each holding specific information or linking keys about Projects data available in SAP. These include RECTY (Record type), VERSO (Data area (previously version)), YEARB (Fiscal Year), PERDE (Period).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP CF003 table 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 | T000 | MANDT | |||
RECTY | Record type | CFRECTY | CHAR | 1 | RECTY | ||||
VERSO | Data area (previously version) | CFVERSO | NUMC | 2 | T242V | VERSO | DBE | ||
YEARB | Fiscal Year | CFYEARB | NUMC | 4 | GJAHR | GJAHR | FSY | ||
PERDE | Period | CFPERDE | NUMC | 3 | POPER | PRD | |||
BUKRS | CO company code | CFBUKRS | CHAR | 2 | CHAR2 | ||||
RNGVD | Summariziation key sequence | CFRNGVD | NUMC | 4 | NUMC04 | ||||
ZTVER | Scheduling version | CFZTVER | NUMC | 4 | NUMC04 | ||||
EBUKR | Original company code | CFEBUKR | CHAR | 2 | CHAR2 | ||||
PGSBR | Business area | CFPGSBR | CHAR | 2 | CHAR2 | ||||
PRART | Project type | CFPRART | CHAR | 1 | CHAR1 | ||||
VERAP | Project manager | CFVERAP | CHAR | 18 | CHAR18 | ||||
FWERK | Plant | CFFWERK | CHAR | 2 | CHAR2 | ||||
FKOST | Cost center | CFFKOST | CHAR | 8 | CHAR8 | ||||
VALTY | Value type | CFVALTY | CHAR | 1 | T242W | VALTY | VAT | ||
RECNR | CO-BPC record number | CFRECNR | NUMC | 8 | NUM8 | ||||
AEDTM | Changed On | CFAEDTM | DATS | 8 | CFDATUM | ||||
UNAME | User name | CFUNAME | CHAR | 12 | CHAR12 | ||||
PINTR | Reference to reports | CFPINTR | NUMC | 8 | NUMC08 | ||||
PSTAT | Status of project | CFPSTAT | CHAR | 2 | CHAR2 | ||||
PHASE | Project phase | CFPHASE | CHAR | 2 | CHAR2 | ||||
ANLKL | Asset class | CFANLKL | CHAR | 4 | CHAR4 | ||||
BUZKZ | Budget for investment | CFBUZKZ | CHAR | 1 | CHAR1 | ||||
BUZGJ | Budget for fiscal year | CFBUZGJ | NUMC | 4 | GJAHR | GJAHR | |||
PRIOT | Priority | CFPRIOT | CHAR | 1 | CHAR1 | ||||
EIGN1 | Proj. attribute 1 | CFEIGN1 | CHAR | 1 | CHAR1 | ||||
EIGN2 | Proj. attribute 2 | CFEIGN2 | CHAR | 1 | CHAR1 | ||||
EIGN3 | Proj. attribute 3 | CFEIGN3 | CHAR | 1 | CHAR1 | ||||
EIGN4 | Proj. attribute 4 | CFEIGN4 | CHAR | 1 | CHAR1 | ||||
EIGN5 | Proj. attribute 5 | CFEIGN5 | CHAR | 1 | CHAR1 | ||||
EIGN6 | Proj. attribute 6 | CFEIGN6 | CHAR | 1 | CHAR1 | ||||
EIGN7 | Proj. attribute 7 | CFEIGN7 | CHAR | 1 | CHAR1 | ||||
EIGN8 | Proj. attribute 8 | CFEIGN8 | CHAR | 1 | CHAR1 | ||||
WRTTP | Value type in order cost segment | CFWRTTP | CHAR | 1 | CHAR1 | ||||
VARIA | Variant | CFVARIA | CHAR | 1 | CHAR1 | ||||
KSTAR | Cost element | CFKSTAR | CHAR | 8 | CHAR8 | ||||
LWERK | Plant | CFLWERK | CHAR | 2 | CHAR2 | ||||
LKOST | Cost center | CFLKOST | CHAR | 8 | CHAR8 | ||||
LSTAR | List type key | CFLSTAR | CHAR | 3 | CHAR3 | ||||
ULTAR | Sub-activity type key | CFULTAR | CHAR | 3 | CHAR3 | ||||
PVDS1 | Summarization key 1 | CFPVDS1 | CHAR | 16 | CHAR16 | ||||
PVDS2 | Summarization key 2 | CFPVDS2 | CHAR | 16 | CHAR16 | ||||
PVDS3 | Summarization key 3 | CFPVDS3 | CHAR | 16 | CHAR16 | ||||
PVDS4 | Summarization key 4 | CFPVDS4 | CHAR | 16 | CHAR16 | ||||
PROJN | Project number | CFPROJN | CHAR | 16 | CHAR16 | ||||
OBGWT | Plan/budget OBGWT | CFOBGWT | CURR | 15(2) | CFCURR8 | ||||
COBGWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
GBUWT | Plan/budget GBUWT | CFGBUWT | CURR | 15(2) | CFCURR8 | ||||
CGBUWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
NTRWT | Plan/budget NTRWT | CFNTRWT | CURR | 15(2) | CFCURR8 | ||||
CNTRWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
RGAWT | Plan/budget RGAWT | CFRGAWT | CURR | 15(2) | CFCURR8 | ||||
CRGAWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
UTRWT | Budget balance | CFUTRWT | CURR | 15(2) | CFCURR8 | ||||
CUTRWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
UBAWT | Plan/budget UBAWT | CFUBAWT | CURR | 15(2) | CFCURR8 | ||||
CUBAWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
BGSUM | Plan/budget BGSUM | CFBGSUM | CURR | 15(2) | CFCURR8 | ||||
CBGSUM | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
FGAWT | Plan/budget FGAWT | CFFGAWT | CURR | 15(2) | CFCURR8 | ||||
CFGAWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
OPLWT | Plan/budget OPLWT | CFOPLWT | CURR | 15(2) | CFCURR8 | ||||
COPLWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
EPLWT | Plan/budget EPLWT | CFEPLWT | CURR | 15(2) | CFCURR8 | ||||
CEPLWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
PLEWT | Plan/budget PLEWT | CFPLEWT | CURR | 15(2) | CFCURR8 | ||||
CPLEWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
ATAWT | Order open item plan requisition | CFATAWT | CURR | 15(2) | CFCURR8 | ||||
CATAWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
ATOWT | Order open item plan release | CFATOWT | CURR | 15(2) | CFCURR8 | ||||
CATOWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
VGSWT | Order assigned value | CFVGSWT | CURR | 15(2) | CFCURR8 | ||||
CVGSWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
OBLWT | Proj.manual ord.item | CFOBLWT | CURR | 15(2) | CFCURR8 | ||||
COBLWT | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA01 | Value A Period 01 | CFWTA01 | CURR | 15(2) | CFCURR8 | ||||
CWTA01 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA02 | Value A Period 02 | CFWTA02 | CURR | 15(2) | CFCURR8 | ||||
CWTA02 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA03 | Value A Period 03 | CFWTA03 | CURR | 15(2) | CFCURR8 | ||||
CWTA03 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA04 | Value A Period 04 | CFWTA04 | CURR | 15(2) | CFCURR8 | ||||
CWTA04 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA05 | Value A Period 05 | CFWTA05 | CURR | 15(2) | CFCURR8 | ||||
CWTA05 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA06 | Value A Period 06 | CFWTA06 | CURR | 15(2) | CFCURR8 | ||||
CWTA06 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA07 | Value A Period 07 | CFWTA07 | CURR | 15(2) | CFCURR8 | ||||
CWTA07 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA08 | Value A Period 08 | CFWTA08 | CURR | 15(2) | CFCURR8 | ||||
CWTA08 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA09 | Value A Period 09 | CFWTA09 | CURR | 15(2) | CFCURR8 | ||||
CWTA09 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA10 | Value A Period 10 | CFWTA10 | CURR | 15(2) | CFCURR8 | ||||
CWTA10 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA11 | Value A Period 11 | CFWTA11 | CURR | 15(2) | CFCURR8 | ||||
CWTA11 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA12 | Value A Period 12 | CFWTA12 | CURR | 15(2) | CFCURR8 | ||||
CWTA12 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA13 | Value A Period 13 | CFWTA13 | CURR | 15(2) | CFCURR8 | ||||
CWTA13 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA14 | Value A Period 14 | CFWTA14 | CURR | 15(2) | CFCURR8 | ||||
CWTA14 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA15 | Value A Period 15 | CFWTA15 | CURR | 15(2) | CFCURR8 | ||||
CWTA15 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTA16 | Value A Period 16 | CFWTA16 | CURR | 15(2) | CFCURR8 | ||||
CWTA16 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB01 | Value B Period 01 | CFWTB01 | CURR | 15(2) | CFCURR8 | ||||
CWTB01 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB02 | Value B Period 02 | CFWTB02 | CURR | 15(2) | CFCURR8 | ||||
CWTB02 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB03 | Value B Period 03 | CFWTB03 | CURR | 15(2) | CFCURR8 | ||||
CWTB03 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB04 | Value B Period 04 | CFWTB04 | CURR | 15(2) | CFCURR8 | ||||
CWTB04 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB05 | Value B Period 05 | CFWTB05 | CURR | 15(2) | CFCURR8 | ||||
CWTB05 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB06 | Value B Period 06 | CFWTB06 | CURR | 15(2) | CFCURR8 | ||||
CWTB06 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB07 | Value B Period 07 | CFWTB07 | CURR | 15(2) | CFCURR8 | ||||
CWTB07 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB08 | Value B Period 08 | CFWTB08 | CURR | 15(2) | CFCURR8 | ||||
CWTB08 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB09 | Value B Period 09 | CFWTB09 | CURR | 15(2) | CFCURR8 | ||||
CWTB09 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB10 | Value B Period 10 | CFWTB10 | CURR | 15(2) | CFCURR8 | ||||
CWTB10 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB11 | Value B Period 11 | CFWTB11 | CURR | 15(2) | CFCURR8 | ||||
CWTB11 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB12 | Value B Period 12 | CFWTB12 | CURR | 15(2) | CFCURR8 | ||||
CWTB12 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB13 | Value B Period 13 | CFWTB13 | CURR | 15(2) | CFCURR8 | ||||
CWTB13 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB14 | Value B Period 14 | CFWTB14 | CURR | 15(2) | CFCURR8 | ||||
CWTB14 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB15 | Value B Period 15 | CFWTB15 | CURR | 15(2) | CFCURR8 | ||||
CWTB15 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WTB16 | Value B Period 16 | CFWTB16 | CURR | 15(2) | CFCURR8 | ||||
CWTB16 | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
MGA01 | Quantity A Period 01 | CFMGA01 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA01 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA02 | Quantity A Period 02 | CFMGA02 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA02 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA03 | Quantity A Period 03 | CFMGA03 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA03 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA04 | Quantity A Period 04 | CFMGA04 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA04 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA05 | Quantity A Period 05 | CFMGA05 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA05 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA06 | Quantity A Period 06 | CFMGA06 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA06 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA07 | Quantity A Period 07 | CFMGA07 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA07 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA08 | Quantity A Period 08 | CFMGA08 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA08 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA09 | Quantity A Period 09 | CFMGA09 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA09 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA10 | Quantity A Period 10 | CFMGA10 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA10 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA11 | Quantity A Period 11 | CFMGA11 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA11 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA12 | Quantity A Period 12 | CFMGA12 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA12 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA13 | Quantity A Period 13 | CFMGA13 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA13 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA14 | Quantity A Period 14 | CFMGA14 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA14 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA15 | Quantity A Period 15 | CFMGA15 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA15 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
MGA16 | Quantity A Period 16 | CFMGA16 | QUAN | 15(3) | CFQUAN8 | ||||
QMGA16 | Unit | CFUNIT | UNIT | 3 | T006 | CUNIT | MEINS |
Key field | Non-key field |
How do I retrieve data from SAP table CF003 using ABAP code
The following ABAP code Example will allow you to do a basic selection on CF003 to SELECT all data from the tableDATA: WA_CF003 TYPE CF003.
SELECT SINGLE *
FROM CF003
INTO CORRESPONDING FIELDS OF WA_CF003
WHERE...
How to access SAP table CF003
Within an ECC or HANA version of SAP you can also view further information about CF003 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