CAUFVTAB SAP (Maps Database View CAUFV as Internal Table) Structure details

Dictionary Type: Structure
Description: Maps Database View CAUFV as Internal Table




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




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

CAUFVTAB 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 "Maps Database View CAUFV as Internal Table" 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_CAUFVTAB TYPE CAUFVTAB.

The CAUFVTAB table consists of various fields, each holding specific information or linking keys about Maps Database View CAUFV as Internal Table data available in SAP. These include AUFNR (Order Number), WERKS (Plant), DISPO (MRP controller for the order), FEVOR (Production Supervisor).. 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 CAUFVTAB 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
MANDTClient MANDTCLNT3T000MANDT
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
DISPOMRP controller for the order CO_DISPOCHAR3T024DDISPODGR
FEVORProduction Supervisor FEVORCHAR3T024FFEVORCFV
PVERWTask list usage PLN_VERWECHAR3T411PLN_VERWEH_T411
PLNBEZMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
PLNAWApplication of the task list PLNAWCHAR1TCA09PLNAW
PLNTYTask List Type PLNTYCHAR1TCA01PLNTYPTYH_TCA01
PLNNRKey for Task List Group PLNNRCHAR8ALPHAPLNNRPLNPLKS
PLNALGroup Counter PLNALCHAR2ALPHAALTNRPAL
PLAUFDate for routing transfer CO_PLAUFDATS8DATUM
PLGRPResponsible planner group/department VAGRPCHAR3T024AVAGRPH_T024A
PLSVBTo lot size LOSGRBISQUAN13(3) MENG13
PLSVNFrom Lot Size LOSGRVONQUAN13(3) MENG13
PLNMETask list unit of measure PLNMEUNIT3T006CUNITMEINS
PDATVValid-From Date DATUVDATS8DATUM
PAENRChange Number AENNRCHAR12AENRAENNRAENNRAEN
STLTYBOM category STLTYCHAR1STLTY
STLSTBOM status STLSTNUMC2T415SSTLST
STLNRBill of material STNUMCHAR8NUMCVSTNUMSTLNR
STLANBOM Usage STLANCHAR1T416STLANCSV
SDATVValid-From Date DATUVDATS8DATUM
SBMNGBase quantity BASMNQUAN13(3) MENG13
SBMEHBase Unit of Measure MEINSUNIT3T006CUNITMEINS
SAENRChange Number AENNRCHAR12AENRAENNRAENNRAEN
STLBEZMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
STLALAlternative BOM STALTCHAR2ALPHAALTNR
SLSVNFrom Lot Size LOSVNQUAN13(3) MENG13
SLSBSTo Lot Size LOSBSQUAN13(3) MENG13
AUFLDDate of BOM Explosion/Routing Transfer CO_AUFLDDATS8DATUM
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10RESBRSNUMRES
FTRMSScheduled release date CO_FTRMSDATS8DATUM
FTRMIActual release date CO_FTRMIDATS8DATUM
FTRMPPlanned release date CO_FTRMPDATS8DATUM
GLTRPBasic finish date CO_GLTRPDATS8DATUM
GSTRPBasic start date CO_GSTRPDATS8DATUM
GLTRSScheduled finish CO_GLTRSDATS8DATUM
GSTRSScheduled start CO_GSTRSDATS8DATUM
GSTRIActual start date CO_GSTRIDATS8DATUM
GLTRIActual finish date CO_GLTRIDATS8DATUM
GETRIConfirmed Order Finish Date CO_GETRIDATS8DATUM
GASMGTotal scrap quantity in the order GASMGQUAN13(3) MENG13
GAMNGTotal order quantity GAMNGQUAN13(3) MENG13
GMEINCommon unit of measure for all order items CO_GMEINUNIT3T006CUNITMEINS
TERKZScheduling type TERMKZCHAR1T482TERART
REDKZReduction indicator for scheduling REDKZCHAR1REDKZ
FHORIScheduling Margin Key for Floats FHORICHAR3T436AFHORI
APRIOOrder priority CO_APRIOCHAR1CHAR1
AUARTOrder Type AUFARTCHAR4T003OAUFARTAAT
AUTYPOrder category AUFTYPNUMC2AUFTYP
REFNRReference order number AUFREFNRCHAR12AUFKALPHAAUFNRANV
ERNAMEntered by AUFERFNAMCHAR12USNAM
ERDATCreated on AUFERFDATDATS8DATUM
AENAMLast changed by AUFAENAMCHAR12USNAM
AEDATChange date for Order Master AUFAEDATDATS8DATUM
KTEXTDescription AUFTEXTCHAR40TEXT40
LTEXTLong Text Exists AUFLTEXTCHAR1XFELD
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
STATSStatus Profile J_STSMACHAR8TJ20J_STSMA
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
LOEKZDeletion flag AUFLOEKZCHAR1XFELD
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
CCKEYCost collector key CCKEYCHAR23CCKEY
ASTKZIdentifier for statistical order AUFSTKZCHAR1XFELD
WAERSOrder Currency AUFWAERSCUKY5TCURCWAERS
OBJIDObject ID CCOBJIDCHAR1CHAR1
PLGKZIdentifier for planning with line items PLGKZCHAR1XFELD
KAPPLApplication KAPPLCHAR2T681AKAPPLKAP
KALSMCosting Sheet AUFKALSMCHAR6T683KALSM
ZSCHLOverhead key AUFZSCHLCHAR6CHAR6
ABKRSProcessing group AUFABKRSNUMC2TKO08AKREISAKR
PROFIDNetwork profile PROFIDNZPLCHAR7TCN41PROFILIDPNW
UPTERIndicator: Change to Scheduled Dates CO_UPTERCHAR1CHAR1
BEDIDID of the capacity requirements record BEDIDNUMC12KBKOBEDID
LODIVLot size divisor LOSDIVQUAN13(3) MENG13
VORGZFloat before production (in days) VORGZNUMC3NUM3
SICHZFloat after production (in days) SICHZNUMC3NUM3
FREIZRelease period (in days) FREIZNUMC3NUM3
PRONRProject definition PS_PSP_PRONUMC8Assigned to domainKONPDPS_PSPNR
PSPELWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8PRPSKONPRPS_POSNR
ZAEHLInternal counter CIM_COUNTNUMC8CIM_COUNT
MZAEHLInternal counter CIM_COUNTNUMC8CIM_COUNT
ZKRIZCounter for additional criteria DZKRIZNUMC7ZKRIZ
PRUEFLOSInspection Lot Number QPLOSNUMC12QALSQPLOSQLSQALS
PLARTBasis for scheduling PS_PLARTCHAR1PS_PLART
RGEKZIndicator: Backflush RGEKZCHAR1XFELD
KLVARPCosting variant for planned costs KALKVARPLNCHAR4TCK03KLVAR
KLVARICosting variant for actual costs KALKVARISTCHAR4TCK03KLVAR
ABGSLResults Analysis Key ABGR_SCHLCHAR6TKKAAABGR_SCHLACS
AWSLSVariance Key AWSLSCHAR6TKV01AWSLS
FLG_AOBIndicator: relationships FLG_AOBCHAR1FLAG
FLG_ARBEIIndicator: Default value work is relevant FLG_ARBEICHAR1FLAG
PRCTRProfit Center PRCTRCHAR10CEPCALPHAPRCTRPRCPRCTR_EMPTY
GLTPPFinish date (forecast) CO_GLTPPDATS8DATUM
GSTPPForecast start date CO_GSTPPDATS8DATUM
GLTPSScheduled forecast finish CO_GLTPSDATS8DATUM
GSTPSScheduled forecast start CO_GSTPSDATS8DATUM
FTRPSScheduled release date (forecast) CO_FTRPSDATS8DATUM
RDKZPReduction indicator for scheduling (forecast) REDKZPCHAR1REDKZ
TRKZPScheduling type (forecast) TERMKZPCHAR1T482TERART
RUECKCompletion confirmation number for the operation CO_RUECKNUMC10CO_RUECKRCK
RMZHLInternal counter CIM_COUNTNUMC8CIM_COUNT
KVEWEUsage of the condition table KVEWECHAR1T681VKVEWEKVW
IGMNGYield confirmed from order confirmation CO_IGMNGQUAN13(3) MENG13
RATIDID of the capacity requirements record BEDIDNUMC12KBKOBEDID
GROIDID of the capacity requirements record BEDIDNUMC12KBKOBEDID
CUOBJConfiguration (internal object number) CUOBJNUMC18CUOBJCUX
GLUZSScheduled finish time CO_GLUZSTIMS6UHRZT
GSUZSScheduled Start (Time) CO_GSUZSTIMS6ATIME
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS
RSHTYObject types of the CIM resource CR_OBJTYCHAR2CR_OBJTY
RSHIDObject ID of the resource CR_OBJIDNUMC8CRIDCR_OBJID
RSNTYObject types of the CIM resource CR_OBJTYCHAR2CR_OBJTY
RSNIDObject ID of the resource CR_OBJIDNUMC8CRIDCR_OBJID
NAUTERMIndicator: Do not schedule automatically CO_NAUTERMCHAR1KREUZ
NAUCOSTIndicator: Do not cost automatically CO_NAUCOSTCHAR1KREUZ
STUFELevel (in multi-level BOM explosions) HISTUDEC2DEC2
WEGXXPath (for multi-level BOM explosions) WEGXXDEC4DEC4
VWEGXPath (for multi-level BOM explosions) WEGXXDEC4DEC4
ARSNRNumber of Reservation/Dependent Requirement RSNUMNUMC10RESBRSNUMRES
ARSPSOrder Item Number CO_POSNRNUMC4CO_POSNR
MAUFNRNumber of superior order MAUFNRCHAR12AUFKALPHAAUFNRUAF
LKNOTLeft node in collective order CO_LKNOTCHAR12AUFKALPHAAUFNR
RKNOTRight node of a collective order CO_RKNOTCHAR12AUFKALPHAAUFNR
PRODNETIndicator: Order is part of collective order CO_PRODNETCHAR1KREUZ
IASMGScrap confirmed for order CO_IASMGQUAN13(3) MENG13
ABARBConfirmation: Degree of processing CO_ABARBNUMC3CO_ABARB
TXJCDTax Jurisdiction TXJCDCHAR15TTXJTXJCDTXJ
SCOPEObject Class SCOPE_CVCHAR2SCOPESCOPE_CVPCO
NO_DISPEffective for Materials Planning NO_DISP_PLUSCHAR1NO_DISP_PLUS
AUFNTNumber of superior network CO_TEILNETCHAR12Assigned to domainALPHAAUFNR
AUFPTRouting number of operations in the order CO_AUFPLNUMC10AUFPL
APLZTGeneral counter for order CO_APLZLNUMC8Assigned to domainCO_APLZL
CSPLITApportionment Structure CSPLITCHAR4MAKVCSPLIT
AENNRChange Number AENNRCHAR12AENRAENNRAENNRAEN
CY_SEQNRSeq. number order CY_SEQNRNUMC14CY_SEQNR
BREAKSIndicator: Scheduling allowing for breaks BREAKSCHAR1XFELD
VORGZ_TRMScheduled float before production in days VORGZ_TRMDEC6(3) PUFFER_TRM
SICHZ_TRMScheduled float after production in days SICHZ_TRMDEC6(3) PUFFER_TRM
TRMDTDate of the last scheduling TRMDTDATS8DATUM
GLUZPBasic finish (time) CO_GLUZPTIMS6UHRZT
GSUZPBasic start time CO_GSUZPTIMS6UHRZT
GSUZIActual start time CO_GSUZITIMS6UHRZT
GEUZIConfirmed order finish (time) CO_GEUZITIMS6UHRZT
GLUPPForecast finish (time) CO_GLUPPTIMS6UHRZT
GSUPPForecast start (time) CO_GSUPPTIMS6UHRZT
GLUPSScheduled forecast finish time CO_GLUPSTIMS6UHRZT
GSUPSScheduled start time (Forecast) CO_GSUPSTIMS6UHRZT
CHSCHSearch procedure for batch determination KALSMA_CHCHAR6T683KALSM
LEAD_AUFNRLeading order in current processing CO_LAUFNRCHAR12Assigned to domainALPHAAUFNR
PNETSTARTDOutline start of collective network (date) CO_PSTARTDDATS8DATUM
PNETSTARTTStart time of a collective order CO_PSTARTTTIMS6ATIME
PNETENDDOutline finish of collective order (date) CO_PENDDDATS8DATUM
PNETENDTOutline finish time CO_PENDTTIMS6ATIME
FLG_MLTPSOrder with multiple items CO_MLTPSCHAR1KREUZ
IDAT2Technical completion date AUFIDAT2DATS8DATUM
KDAUF_AUFKSales Order Number KDAUFCHAR10VBUKALPHAVBELNAUN
KDPOS_AUFKItem Number in Sales Order KDPOSNUMC6NUM06KPO
KBEDInd: do not create capacity requirements KBED_DCHAR1XFELD
SFCPFProduction Scheduling Profile CO_PRODPRFCHAR6TCO43CO_PRODPRF
KKALKRIndicator: Components will not be costed COMP_CALCCHAR1XFELD
KSTARSettlement cost element AUFKSTARCHAR10Assigned to domainALPHAKSTAR
USER4Estimated total costs of order AUFUSER4CURR11(2) AUFUSER4
RMNGATotal confirmed rework quantity RMNGAQUAN13(3) MENGV13
NOPCOSTDo not calculate planned costs for order CO_NOPCOSTCHAR1XFELD
KSTEMPFIndicator: Direct cost collector CO_KSTEMPFCHAR1CO_KSTEMPF
NETZKONTIndicator for the account assignment of a network(hdr/act.) NETZKONTCHAR1NETZKONT
PKOSACost collector for production process PROCNR PKOSA_DCHAR12Assigned to domainALPHAAUFNR
PROCNRProduction Process CKML_F_PROCNRNUMC12Assigned to domainCK_KALNRCKML_PROCNR
PROTYProcess Category (Procurement/Consumption) CKML_PROZESS_TYPCHAR4Assigned to domainCKML_PROZESS_TYP
RSORDRefurbishment order indicator (PM) RSORDCHAR1XFELD
ATRKZRequest ID ATRKZCHAR1ATRKZ
BEMOTAccounting Indicator BEMOTCHAR2TBMOTBEMOT
ADRNRAAddress number AD_ADDRNUMCHAR10Assigned to domainALPHAAD_ADDRNUMADR
COMP_RESOCM: Result of comparison of two order objects OCM_COMP_RESCHAR1OCM_COMP_RES
CH_PROCProcess that has lead to the change of an object OCM_CH_PROCCHAR1OCM_CH_PROC
ERFZEITTime created C_TIMETIMS6UZEIT
AEZEITChanged at CO_CHG_TIMETIMS6UZEIT
KAPVERSAVersion of Available Capacity KAPVERSANUMC2TC36KAPVERSION
COLORDPROCCollective order with/without automatic goods movement CO_COLORDPRCCHAR1CO_COLORDPRC
KZERBIndicator: Project summarization via master data charact. PS_KZERBCHAR1XFELD
IVPROInvestment measure profile IM_PROFILCHAR6TAPRFIM_PROFIL
SOWRKLocation plant AUFSOWRKCHAR4T001WWERKS
ABUKRRequesting company code IM_ABUKRSCHAR4T001BUKRSBUK
AKSTLRequesting cost center PS_AKSTLCHAR10CSKSALPHAKOSTLKOS
SIZECLScale of investment objects IM_SIZECLCHAR2TAIF5ALPHASIZECL
IZWEKReason for investment IZWEKCHAR2T087IIZWEK
UMWKZReason for environmental investment AM_UMWKZCHAR5T087KAM_UMWKZ
CONF_KEYIdentical object CC_CONF_KEYNUMC8CC_NUMC8
VSNMR_VSales document version number VSNMR_VCHAR12VSNMR
TERHWScheduling note from order scheduling TERHWCHAR1TERHW
ST_ARBIDObject ID OBJEKTIDNUMC8NUM08PON
COSTUPDCosts are updated CN_COSTUPDCHAR1XFELD
OBJTYPEChange indicator OCM_OBJ_TYPECHAR1OCM_OBJ_TYPE
KOSTVResponsible cost center AUFKOSTVCHAR10Assigned to domainALPHAKOSTL
FUNC_AREAFunctional Area FKBERCHAR16TFKBFKBERFBE
SPLSTATStatus of an order in a split hierarchy SPLIT_STATCHAR1SPLIT_STAT
MAX_GAMNGMaximum Value of Total Order Quantity After Distribution CO_MES_MAX_GAMNGQUAN13(3) MENG13
MES_ROUTINGIDKey of a Routing from an ME System CO_MES_INT_ROUTINGIDCHAR64CHAR64
RMANRSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
POSNR_RMAItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
POSNV_RMAItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
VNAMEJoint Venture JV_NAMECHAR6T8JVALPHAJV_NAMEJVV
RECIDRecovery Indicator JV_RECINDCHAR2T8JJALPHAJV_RECIND
ETYPEEquity type JV_ETYPECHAR3T8JGALPHAJV_ETYPE
OTYPEJoint Venture Object Type JV_OTYPECHAR4ALPHAJV_OTYPE
JV_JIBCLJIB/JIBE Class JV_JIBCLCHAR3T8J6AJV_JIBCLJIB
JV_JIBSAJIB/JIBE Subclass A JV_JIBSACHAR5T8J6CJV_JIBSAJBS
JV_OCOJV original cost object JV_OR_COCHAR1JV_OR_COB
DUMMY_CI_AUFKSingle-Character Indicator CHAR1CHAR1CHAR1
CALIDFactory Calendar WFCIDCHAR2TFACDWFCIDFCI
KALSNCalendar Selection for Order KALSNNUMC2KALSN
CFB_MAXLZMaximum Storage Period MAXLZDEC5DEC5
CFB_LZEIHUnit for maximum storage period LZEIHUNIT3T006CUNITMEINS
CFB_ADTDAYSAdditional Days CFB_ADTDAYSDEC4DECV4
CFB_DATOFMDate of Manufacture CFB_DATOFMDATS8DATUM
CFB_BBDPIBest-Before Date (BBD)/ Shelf Life Expiration Date (SLED) CFB_BBD_PPPIDATS8DATUM
.INCLU--AP 0
CPD_UPDATTime Stamp /CPD/PFP_TSTMPDEC15TSTLC/CPD/PFP_TSTMP
.INCLU--AP 0
/CUM/INDCUCU: Order is Used for Compatible Units /CUM/INDCUCHAR1FLAG
/CUM/CMNUMCU: Construction Measure Number /CUM/CMNUMCHAR12ALPHA/CUM/CMNUM/CUM/CMNUM/CUM/V_CMNUM_ALL
/CUM/AUESTCU: Automatic Copy of Estimated Costs /CUM/AUESTCHAR1FLAG
/CUM/INTCUNRCU: Internal CU Number in a Work Order /CUM/INTCUNRNUMC6NUMC6
/CUM/CUGUIDUUID in X form (binary) SYSUUID_XRAW16SYSUUID
/CUM/DESNUMCU: Design Number /CUM/DESNUMCHAR12Assigned to domainALPHA/CUM/DESNUM/CUM/DESNUM
/CUM/DESGUIDCU: GUID of Design Document /CUM/DESGUIDRAW16SYSUUID
/CUM/AUFPL_TMPRouting number of operations in the order CO_AUFPLNUMC10AUFPL
/CUM/IWERK_TLSELMaintenance Planning Plant IWERKCHAR4Assigned to domainWERKSIWK
.INCLU--AP 0
/MRSS/PL_STRU_IDResource planning nodes /MRSS/T_PLAN_STRUCT_IDNUMC8Assigned to domainCR_OBJID
/MRSS/PL_MAN_TYPAssignment to resource planner or contact person /MRSS/T_MANAGER_TYPECHAR1/MRSS/_MANAGER_TYPE
/MRSS/ORDER_PROBOrder probability in percent /MRSS/T_ORDER_PROBCHAR3OPROB/MRSS/_ORDER_PROB
/MRSS/ACT_TYPEProcess variant /MRSS/T_ACTIVITY_TYPECHAR1/MRSS/_ACTIVITY_TYPE
/MRSS/INIT_DONEInternal initialization carried out once /MRSS/T_INIT_DONECHAR1FLAG
/MRSS/DATACHANGEData was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGEDCHAR1FLAG
/MRSS/SALES_ORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
/MRSS/NW_BOOKEDNetwork Set to 'Booked' /MRSS/T_NW_BOOKEDCHAR1FLAG
.INCLU--AP 0
AD01PROFNRDynamic Item Processor Profile AD01PROFNRCHAR8AD01C_PROFAD01PROFNRAD0DIP_PROFILE
.INCLU--AP 0
MILL_RATIOFactor for Quantity-Based Settlement MILL_RATIOINT410CDINT4
.INCLU--AP 0
MILL_OC_ZUSKZCombination Indicator MILL_OC_ZUSKZCHAR1MILL_OC_ZUSKZ
.INCLU--AP 0
CLAIM_CONTROLClaim creation control indicator WTYSC_CLAIM_CONTROLCHAR1WTYSCC_CLM_CONTWTYSC_CLAIM_CONTROL
UPDATE_NEEDEDClaim inconsistency with order indicator WTYSC_UPDATE_NEEDEDCHAR1WTYSC_UPDATE_NEEDED
UPDATE_CONTROLClaim update trigger point from service order WTYSC_UPDATE_CONTROLCHAR1WTYSCC_UPDT_CONTWTYSC_UPDATE_CONTROL

Key field Non-key field



How do I retrieve data from SAP structure CAUFVTAB using ABAP code?

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

How to access SAP table CAUFVTAB

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