VSAFFH_CN SAP (Version: PRT allocation to work order) Table details

Dictionary Type: Table
Description: Version: PRT allocation to work order




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




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

VSAFFH_CN is a standard SAP Table which is used to store Version: PRT allocation to work order data and is available within R/3 SAP systems depending on the version and release level.

The VSAFFH_CN table consists of various fields, each holding specific information or linking keys about Version: PRT allocation to work order data available in SAP. These include VSNMR (Number or description of a version), AUFPL (Routing number of operations in the order), PZLFH (Item counter for production resources/tools), LOEKZ (Deletion Indicator).. 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 VSAFFH_CN 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 MANDTCLNT3Assigned to domainMANDT
VSNMRNumber or description of a version VSNMRCHAR12VSNMRVS2
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
PZLFHItem counter for production resources/tools PZLFHNUMC8PZLFH
LOEKZDeletion Indicator LKENZCHAR1XFELD
PARKZIndicator: inactive changes PARKZCHAR1XFELD
DATUIDate record created on ANDATDATS8DATUM
USERIUser who created record ANNAMCHAR12USNAM
DATUCChanged On AEDATDATS8DATUM
USERCName of Person Who Changed Object AENAMCHAR12USNAM
OBJTYObject types of the CIM resource CR_OBJTYCHAR2CR_OBJTY
OBJIDObject ID of the resource CR_OBJIDNUMC8CRIDCR_OBJID
PLNTY_KEYTask List Type PLNTYCHAR1TCA01PLNTYPTYH_TCA01
PLNNR_KEYKey for Task List Group PLNNRCHAR8ALPHAPLNNRPLNPLKS
PZLFH_KEYItem counter for production resources/tools PZLFHNUMC8PZLFH
ZAEHL_KEYInternal counter CIM_COUNTNUMC8CIM_COUNT
OBJCTObject of a task list OBJCT_DCHAR1OBJKT
APLZLInternal counter CIM_COUNTNUMC8CIM_COUNT
PSNFHItem Number for Production Resource/Tool PSNFHNUMC4PSNFH
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
STEUFControl key for management of production resources/tools STEUFCHAR4TCF10STEUF
KZKBLIndicator: Create load records for prod. resources/tools KZKBLCHAR1XFELD
BZOFFBReference date to start of production resource/tool usage BZOFFBCHAR2TCA54CP_BZOFF
OFFSTBOffset to start of production resource/tool usage OFFSTBQUAN5VNZTV
EHOFFBOffset unit for start of prod. resource/tool usage EHOFFBUNIT3T006CUNITMEINS
BZOFFEReference date for end of production resource/tool usage BZOFFECHAR2TCA54CP_BZOFF
OFFSTEOffset to finish of production resource/tool usage OFFSTEQUAN5VNZTV
EHOFFEOffset unit for end of production resource/tool usage EHOFFEUNIT3T006CUNITMEINS
FSFHDEarliest scheduled start (date) for PRT usage CF_FSFHDDATS8DATUM
FSFHZEarliest scheduled start (time) for PRT usage CF_FSFHZTIMS6UZEIT
FEFHDEarliest scheduled finish (date) of PRT usage CF_FEFHDDATS8DATUM
FEFHZEarliest scheduled end (time) of PRT usage CF_FEFHZTIMS6UZEIT
SSFHDLatest scheduled start (date) for PRT usage CF_SSFHDDATS8DATUM
SSFHZLatest scheduled start (time) for PRT usage CF_SSFHZTIMS6UZEIT
SEFHDLatest scheduled finish (date) of PRT usage CF_SEFHDDATS8DATUM
SEFHZLatest scheduled end (time) for PRT usage CF_SEFHZTIMS6UZEIT
ISFHDActual start (date) of PRT usage CF_ISFHDDATS8DATUM
ISFHZActual start (time) of PRT usage CF_ISFHZTIMS6UZEIT
IEFHDActual finish (date) of PRT usage CF_IEFHDDATS8DATUM
IEFHZActual finish (time) of PRT usage CF_IEFHZTIMS6UZEIT
DAUFLDuration of PRT usage CF_DAUFLFLTP16(16) CX_ZEIT
DAUEHTime unit for duration of PRT usage CF_DAUEHUNIT3T006CUNITMEINS
MGEINHQuantity unit of production resource/tool MGEINHUNIT3T006CUNITMEINS
MGVGWStandard value for the PRT quantity MGVGWQUAN9(3) MENG9
MGSOLEHQuantity unit of production resource/tool MGEINHUNIT3T006CUNITMEINS
MGSOLTotal planned quantity of production resource/tool MGSOLQUAN9(3) MENG9
MGISTEHQuantity unit of production resource/tool MGEINHUNIT3T006CUNITMEINS
MGISTConfirmed quantity of production resource/tool MGISTQUAN9(3) MENG9
MGRSTEHQuantity unit of production resource/tool MGEINHUNIT3T006CUNITMEINS
MGRSTRemaining quantity of the production resource/tool MGRSTQUAN9(3) MENG9
MGAUSEHQuantity unit of production resource/tool MGEINHUNIT3T006CUNITMEINS
MGAUSQuantity of checked-out production resources/tools MGAUSQUAN9(3) MENG9
MGFORMFormula for calculating the total quantity of PRT CF_MGFORMCHAR6TC25AP_FORMEL
EWEINHUsage value unit of the production resource/tool EWEINHUNIT3T006CUNITMEINS
EWVGWStandard usage value for production resources/tools EWVGWQUAN9(3) MENG9
EWSOLEHUsage value unit of the production resource/tool EWEINHUNIT3T006CUNITMEINS
EWSOLTotal planned usage value of production resource/tool EWSOLQUAN9(3) MENG9
EWISTEHUsage value unit of the production resource/tool EWEINHUNIT3T006CUNITMEINS
EWISTActual usage value for production resource/tool EWISTQUAN9(3) MENG9
EWRSTEHUsage value unit of the production resource/tool EWEINHUNIT3T006CUNITMEINS
EWRSTRemaining usage value of the production resource/tool EWRSTQUAN9(3) MENG9
EWFORMFormula for calculating the total usage value of PRT CF_EWFORMCHAR6TC25AP_FORMEL
TXTSPLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
KTSCHStandard text key for production resources/tools CF_KTSCHCHAR7T435KTSCH
TXTZ1First line of text for production resources/tools TXTZ1CHAR40TEXT40
OBJTYPEChange indicator OCM_OBJ_TYPECHAR1OCM_OBJ_TYPE
CH_PROCProcess that has lead to the change of an object OCM_CH_PROCCHAR1OCM_CH_PROC
AENNRChange Number AENNRCHAR12Assigned to domainAENNRAENNRAEN
ORGAUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
ORGPZLFHItem counter for production resources/tools PZLFHNUMC8PZLFH

Key field Non-key field



How do I retrieve data from SAP table VSAFFH_CN using ABAP code

The following ABAP code Example will allow you to do a basic selection on VSAFFH_CN to SELECT all data from the table
DATA: WA_VSAFFH_CN TYPE VSAFFH_CN.

SELECT SINGLE *
FROM VSAFFH_CN
INTO CORRESPONDING FIELDS OF WA_VSAFFH_CN
WHERE...

How to access SAP table VSAFFH_CN

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