CF003 SAP (Projects) Table details

Dictionary Type: Table
Description: Projects




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




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
MANDTClient MANDTCLNT3T000MANDT
RECTYRecord type CFRECTYCHAR1RECTY
VERSOData area (previously version) CFVERSONUMC2T242VVERSODBE
YEARBFiscal Year CFYEARBNUMC4GJAHRGJAHRFSY
PERDEPeriod CFPERDENUMC3POPERPRD
BUKRSCO company code CFBUKRSCHAR2CHAR2
RNGVDSummariziation key sequence CFRNGVDNUMC4NUMC04
ZTVERScheduling version CFZTVERNUMC4NUMC04
EBUKROriginal company code CFEBUKRCHAR2CHAR2
PGSBRBusiness area CFPGSBRCHAR2CHAR2
PRARTProject type CFPRARTCHAR1CHAR1
VERAPProject manager CFVERAPCHAR18CHAR18
FWERKPlant CFFWERKCHAR2CHAR2
FKOSTCost center CFFKOSTCHAR8CHAR8
VALTYValue type CFVALTYCHAR1T242WVALTYVAT
RECNRCO-BPC record number CFRECNRNUMC8NUM8
AEDTMChanged On CFAEDTMDATS8CFDATUM
UNAMEUser name CFUNAMECHAR12CHAR12
PINTRReference to reports CFPINTRNUMC8NUMC08
PSTATStatus of project CFPSTATCHAR2CHAR2
PHASEProject phase CFPHASECHAR2CHAR2
ANLKLAsset class CFANLKLCHAR4CHAR4
BUZKZBudget for investment CFBUZKZCHAR1CHAR1
BUZGJBudget for fiscal year CFBUZGJNUMC4GJAHRGJAHR
PRIOTPriority CFPRIOTCHAR1CHAR1
EIGN1Proj. attribute 1 CFEIGN1CHAR1CHAR1
EIGN2Proj. attribute 2 CFEIGN2CHAR1CHAR1
EIGN3Proj. attribute 3 CFEIGN3CHAR1CHAR1
EIGN4Proj. attribute 4 CFEIGN4CHAR1CHAR1
EIGN5Proj. attribute 5 CFEIGN5CHAR1CHAR1
EIGN6Proj. attribute 6 CFEIGN6CHAR1CHAR1
EIGN7Proj. attribute 7 CFEIGN7CHAR1CHAR1
EIGN8Proj. attribute 8 CFEIGN8CHAR1CHAR1
WRTTPValue type in order cost segment CFWRTTPCHAR1CHAR1
VARIAVariant CFVARIACHAR1CHAR1
KSTARCost element CFKSTARCHAR8CHAR8
LWERKPlant CFLWERKCHAR2CHAR2
LKOSTCost center CFLKOSTCHAR8CHAR8
LSTARList type key CFLSTARCHAR3CHAR3
ULTARSub-activity type key CFULTARCHAR3CHAR3
PVDS1Summarization key 1 CFPVDS1CHAR16CHAR16
PVDS2Summarization key 2 CFPVDS2CHAR16CHAR16
PVDS3Summarization key 3 CFPVDS3CHAR16CHAR16
PVDS4Summarization key 4 CFPVDS4CHAR16CHAR16
PROJNProject number CFPROJNCHAR16CHAR16
OBGWTPlan/budget OBGWT CFOBGWTCURR15(2) CFCURR8
COBGWTCurrency CFCUKYCUKY5TCURCWAERS
GBUWTPlan/budget GBUWT CFGBUWTCURR15(2) CFCURR8
CGBUWTCurrency CFCUKYCUKY5TCURCWAERS
NTRWTPlan/budget NTRWT CFNTRWTCURR15(2) CFCURR8
CNTRWTCurrency CFCUKYCUKY5TCURCWAERS
RGAWTPlan/budget RGAWT CFRGAWTCURR15(2) CFCURR8
CRGAWTCurrency CFCUKYCUKY5TCURCWAERS
UTRWTBudget balance CFUTRWTCURR15(2) CFCURR8
CUTRWTCurrency CFCUKYCUKY5TCURCWAERS
UBAWTPlan/budget UBAWT CFUBAWTCURR15(2) CFCURR8
CUBAWTCurrency CFCUKYCUKY5TCURCWAERS
BGSUMPlan/budget BGSUM CFBGSUMCURR15(2) CFCURR8
CBGSUMCurrency CFCUKYCUKY5TCURCWAERS
FGAWTPlan/budget FGAWT CFFGAWTCURR15(2) CFCURR8
CFGAWTCurrency CFCUKYCUKY5TCURCWAERS
OPLWTPlan/budget OPLWT CFOPLWTCURR15(2) CFCURR8
COPLWTCurrency CFCUKYCUKY5TCURCWAERS
EPLWTPlan/budget EPLWT CFEPLWTCURR15(2) CFCURR8
CEPLWTCurrency CFCUKYCUKY5TCURCWAERS
PLEWTPlan/budget PLEWT CFPLEWTCURR15(2) CFCURR8
CPLEWTCurrency CFCUKYCUKY5TCURCWAERS
ATAWTOrder open item plan requisition CFATAWTCURR15(2) CFCURR8
CATAWTCurrency CFCUKYCUKY5TCURCWAERS
ATOWTOrder open item plan release CFATOWTCURR15(2) CFCURR8
CATOWTCurrency CFCUKYCUKY5TCURCWAERS
VGSWTOrder assigned value CFVGSWTCURR15(2) CFCURR8
CVGSWTCurrency CFCUKYCUKY5TCURCWAERS
OBLWTProj.manual ord.item CFOBLWTCURR15(2) CFCURR8
COBLWTCurrency CFCUKYCUKY5TCURCWAERS
WTA01Value A Period 01 CFWTA01CURR15(2) CFCURR8
CWTA01Currency CFCUKYCUKY5TCURCWAERS
WTA02Value A Period 02 CFWTA02CURR15(2) CFCURR8
CWTA02Currency CFCUKYCUKY5TCURCWAERS
WTA03Value A Period 03 CFWTA03CURR15(2) CFCURR8
CWTA03Currency CFCUKYCUKY5TCURCWAERS
WTA04Value A Period 04 CFWTA04CURR15(2) CFCURR8
CWTA04Currency CFCUKYCUKY5TCURCWAERS
WTA05Value A Period 05 CFWTA05CURR15(2) CFCURR8
CWTA05Currency CFCUKYCUKY5TCURCWAERS
WTA06Value A Period 06 CFWTA06CURR15(2) CFCURR8
CWTA06Currency CFCUKYCUKY5TCURCWAERS
WTA07Value A Period 07 CFWTA07CURR15(2) CFCURR8
CWTA07Currency CFCUKYCUKY5TCURCWAERS
WTA08Value A Period 08 CFWTA08CURR15(2) CFCURR8
CWTA08Currency CFCUKYCUKY5TCURCWAERS
WTA09Value A Period 09 CFWTA09CURR15(2) CFCURR8
CWTA09Currency CFCUKYCUKY5TCURCWAERS
WTA10Value A Period 10 CFWTA10CURR15(2) CFCURR8
CWTA10Currency CFCUKYCUKY5TCURCWAERS
WTA11Value A Period 11 CFWTA11CURR15(2) CFCURR8
CWTA11Currency CFCUKYCUKY5TCURCWAERS
WTA12Value A Period 12 CFWTA12CURR15(2) CFCURR8
CWTA12Currency CFCUKYCUKY5TCURCWAERS
WTA13Value A Period 13 CFWTA13CURR15(2) CFCURR8
CWTA13Currency CFCUKYCUKY5TCURCWAERS
WTA14Value A Period 14 CFWTA14CURR15(2) CFCURR8
CWTA14Currency CFCUKYCUKY5TCURCWAERS
WTA15Value A Period 15 CFWTA15CURR15(2) CFCURR8
CWTA15Currency CFCUKYCUKY5TCURCWAERS
WTA16Value A Period 16 CFWTA16CURR15(2) CFCURR8
CWTA16Currency CFCUKYCUKY5TCURCWAERS
WTB01Value B Period 01 CFWTB01CURR15(2) CFCURR8
CWTB01Currency CFCUKYCUKY5TCURCWAERS
WTB02Value B Period 02 CFWTB02CURR15(2) CFCURR8
CWTB02Currency CFCUKYCUKY5TCURCWAERS
WTB03Value B Period 03 CFWTB03CURR15(2) CFCURR8
CWTB03Currency CFCUKYCUKY5TCURCWAERS
WTB04Value B Period 04 CFWTB04CURR15(2) CFCURR8
CWTB04Currency CFCUKYCUKY5TCURCWAERS
WTB05Value B Period 05 CFWTB05CURR15(2) CFCURR8
CWTB05Currency CFCUKYCUKY5TCURCWAERS
WTB06Value B Period 06 CFWTB06CURR15(2) CFCURR8
CWTB06Currency CFCUKYCUKY5TCURCWAERS
WTB07Value B Period 07 CFWTB07CURR15(2) CFCURR8
CWTB07Currency CFCUKYCUKY5TCURCWAERS
WTB08Value B Period 08 CFWTB08CURR15(2) CFCURR8
CWTB08Currency CFCUKYCUKY5TCURCWAERS
WTB09Value B Period 09 CFWTB09CURR15(2) CFCURR8
CWTB09Currency CFCUKYCUKY5TCURCWAERS
WTB10Value B Period 10 CFWTB10CURR15(2) CFCURR8
CWTB10Currency CFCUKYCUKY5TCURCWAERS
WTB11Value B Period 11 CFWTB11CURR15(2) CFCURR8
CWTB11Currency CFCUKYCUKY5TCURCWAERS
WTB12Value B Period 12 CFWTB12CURR15(2) CFCURR8
CWTB12Currency CFCUKYCUKY5TCURCWAERS
WTB13Value B Period 13 CFWTB13CURR15(2) CFCURR8
CWTB13Currency CFCUKYCUKY5TCURCWAERS
WTB14Value B Period 14 CFWTB14CURR15(2) CFCURR8
CWTB14Currency CFCUKYCUKY5TCURCWAERS
WTB15Value B Period 15 CFWTB15CURR15(2) CFCURR8
CWTB15Currency CFCUKYCUKY5TCURCWAERS
WTB16Value B Period 16 CFWTB16CURR15(2) CFCURR8
CWTB16Currency CFCUKYCUKY5TCURCWAERS
MGA01Quantity A Period 01 CFMGA01QUAN15(3) CFQUAN8
QMGA01Unit CFUNITUNIT3T006CUNITMEINS
MGA02Quantity A Period 02 CFMGA02QUAN15(3) CFQUAN8
QMGA02Unit CFUNITUNIT3T006CUNITMEINS
MGA03Quantity A Period 03 CFMGA03QUAN15(3) CFQUAN8
QMGA03Unit CFUNITUNIT3T006CUNITMEINS
MGA04Quantity A Period 04 CFMGA04QUAN15(3) CFQUAN8
QMGA04Unit CFUNITUNIT3T006CUNITMEINS
MGA05Quantity A Period 05 CFMGA05QUAN15(3) CFQUAN8
QMGA05Unit CFUNITUNIT3T006CUNITMEINS
MGA06Quantity A Period 06 CFMGA06QUAN15(3) CFQUAN8
QMGA06Unit CFUNITUNIT3T006CUNITMEINS
MGA07Quantity A Period 07 CFMGA07QUAN15(3) CFQUAN8
QMGA07Unit CFUNITUNIT3T006CUNITMEINS
MGA08Quantity A Period 08 CFMGA08QUAN15(3) CFQUAN8
QMGA08Unit CFUNITUNIT3T006CUNITMEINS
MGA09Quantity A Period 09 CFMGA09QUAN15(3) CFQUAN8
QMGA09Unit CFUNITUNIT3T006CUNITMEINS
MGA10Quantity A Period 10 CFMGA10QUAN15(3) CFQUAN8
QMGA10Unit CFUNITUNIT3T006CUNITMEINS
MGA11Quantity A Period 11 CFMGA11QUAN15(3) CFQUAN8
QMGA11Unit CFUNITUNIT3T006CUNITMEINS
MGA12Quantity A Period 12 CFMGA12QUAN15(3) CFQUAN8
QMGA12Unit CFUNITUNIT3T006CUNITMEINS
MGA13Quantity A Period 13 CFMGA13QUAN15(3) CFQUAN8
QMGA13Unit CFUNITUNIT3T006CUNITMEINS
MGA14Quantity A Period 14 CFMGA14QUAN15(3) CFQUAN8
QMGA14Unit CFUNITUNIT3T006CUNITMEINS
MGA15Quantity A Period 15 CFMGA15QUAN15(3) CFQUAN8
QMGA15Unit CFUNITUNIT3T006CUNITMEINS
MGA16Quantity A Period 16 CFMGA16QUAN15(3) CFQUAN8
QMGA16Unit CFUNITUNIT3T006CUNITMEINS

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 table
DATA: 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 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!