VSAFFH_CN SAP table for - Version: PRT allocation to work order

Table of Contents

Here we would like to draw your attention to VSAFFH_CN table in SAP. As we know it is being mainly used with the SAP PS-SIM (Simulation in PS) component which is coming under PS module (Project Systems). VSAFFH_CN is a SAP standard transparent table used for storing Version: PRT allocation to work order related data in SAP. It comes under the package CNVS.

SAP VSAFFH_CN table

Table VSAFFH_CN technical data

Table	VSAFFH_CN
Data storing	Version: PRT allocation to work order
Module	PS
Component	PS-SIM
SAP Package	CNVS
Delivery Class	A – Application table (master and transaction data)
Table Category	TRANSPARENT

SAP VSAFFH_CN Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in VSAFFH_CN table.

MANDT : Client
Its a key field. Its data type is C (Character String) with field length 3

USERI : User Who Created Record
Its data type is C (Character String) with field length 12

DATUC : Last Changed On
Its data type is D (Date (Date: YYYYMMDD)) with field length 8

USERC : Name of Person Who Changed Object
Its data type is C (Character String) with field length 12

OBJTY : Object types of the CIM resource
Its data type is C (Character String) with field length 2

OBJID : Accrual Object (Internal Display in Form of a GUID)
Its data type is N (Character String with Digits Only) with field length 8

PLNTY_KEY : Task List Type
Its data type is C (Character String) with field length 1

PLNNR_KEY : Key for Task List Group
Its data type is C (Character String) with field length 8

PZLFH_KEY : Item counter for production resources/tools
Its data type is N (Character String with Digits Only) with field length 8

ZAEHL_KEY : Internal counter
Its data type is N (Character String with Digits Only) with field length 8

OBJCT : Object of a task list
Its data type is C (Character String) with field length 1

.INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
Its a key field. Its include structure/component is is VSKEY_INC

APLZL : Internal counter
Its data type is N (Character String with Digits Only) with field length 8

PSNFH : Item Number for Production Resource/Tool
Its data type is N (Character String with Digits Only) with field length 4

OBJNR : Object number
Its data type is C (Character String) with field length 22

STEUF : Control key for management of production resources/tools
Its data type is C (Character String) with field length 4

KZKBL : Indicator: Create load records for prod. resources/tools
Its data type is C (Character String) with field length 1

BZOFFB : Reference date to start of production resource/tool usage
Its data type is C (Character String) with field length 2

OFFSTB : Offset to start of production resource/tool usage
Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3

EHOFFB : Offset unit for start of prod. resource/tool usage
Its data type is C (Character String) with field length 3

BZOFFE : Reference date for end of production resource/tool usage
Its data type is C (Character String) with field length 2

OFFSTE : Offset to finish of production resource/tool usage
Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3

VSNMR
Its a key field. Its data type is C (Character String) with field length 12

EHOFFE : Offset unit for end of production resource/tool usage
Its data type is C (Character String) with field length 3

FSFHD : Earliest scheduled start (date) for PRT usage
Its data type is D (Date (Date: YYYYMMDD)) with field length 8

FSFHZ : Earliest scheduled start (time) for PRT usage
Its data type is T (Time (Time: HHMMSS)) with field length 6

FEFHD : Earliest scheduled finish (date) of PRT usage
Its data type is D (Date (Date: YYYYMMDD)) with field length 8

FEFHZ : Earliest scheduled end (time) of PRT usage
Its data type is T (Time (Time: HHMMSS)) with field length 6

SSFHD : Latest scheduled start (date) for PRT usage
Its data type is D (Date (Date: YYYYMMDD)) with field length 8

SSFHZ : Latest scheduled start (time) for PRT usage
Its data type is T (Time (Time: HHMMSS)) with field length 6

SEFHD : Latest scheduled finish (date) of PRT usage
Its data type is D (Date (Date: YYYYMMDD)) with field length 8

SEFHZ : Latest scheduled end (time) for PRT usage
Its data type is T (Time (Time: HHMMSS)) with field length 6

ISFHD : Actual start (date) of PRT usage
Its data type is D (Date (Date: YYYYMMDD)) with field length 8

AUFPL : Routing number of operations in the order
Its a key field. Its data type is N (Character String with Digits Only) with field length 10

ISFHZ : Actual start (time) of PRT usage
Its data type is T (Time (Time: HHMMSS)) with field length 6

IEFHD : Actual finish (date) of PRT usage
Its data type is D (Date (Date: YYYYMMDD)) with field length 8

IEFHZ : Actual finish (time) of PRT usage
Its data type is T (Time (Time: HHMMSS)) with field length 6

DAUFL : Duration of PRT usage
Its data type is F (Floating point number) with field length 8

DAUEH : Time unit for duration of PRT usage
Its data type is C (Character String) with field length 3

MGEINH : Quantity unit of production resource/tool
Its data type is C (Character String) with field length 3

MGVGW : Standard value for the PRT quantity
Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5

MGSOLEH : Quantity unit of production resource/tool
Its data type is C (Character String) with field length 3

MGSOL : Total planned quantity of production resource/tool
Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5

MGISTEH : Quantity unit of production resource/tool
Its data type is C (Character String) with field length 3

PZLFH : Item counter for production resources/tools
Its a key field. Its data type is N (Character String with Digits Only) with field length 8

MGIST : Confirmed quantity of production resource/tool
Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5

MGRSTEH : Quantity unit of production resource/tool
Its data type is C (Character String) with field length 3

MGRST : Remaining quantity of the production resource/tool
Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5

MGAUSEH : Quantity unit of production resource/tool
Its data type is C (Character String) with field length 3

MGAUS : Quantity of checked-out production resources/tools
Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5

MGFORM : Formula for calculating the total quantity of PRT
Its data type is C (Character String) with field length 6

EWEINH : Usage value unit of the production resource/tool
Its data type is C (Character String) with field length 3

EWVGW : Standard usage value for production resources/tools
Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5

EWSOLEH : Usage value unit of the production resource/tool
Its data type is C (Character String) with field length 3

EWSOL : Total planned usage value of production resource/tool
Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5

EWISTEH : Usage value unit of the production resource/tool
Its data type is C (Character String) with field length 3

EWIST : Actual usage value for production resource/tool
Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5

EWRSTEH : Usage value unit of the production resource/tool
Its data type is C (Character String) with field length 3

EWRST : Remaining usage value of the production resource/tool
Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5

EWFORM : Formula for calculating the total usage value of PRT
Its data type is C (Character String) with field length 6

TXTSP : Language Key
Its data type is C (Character String) with field length 1

KTSCH : Standard text key for production resources/tools
Its data type is C (Character String) with field length 7

TXTZ1 : First line of text for production resources/tools
Its data type is C (Character String) with field length 40

OBJTYPE : ACL: Object Type
Its data type is C (Character String) with field length 1

CH_PROC : Process that has lead to the change of an object
Its data type is C (Character String) with field length 1

LOEKZ : CHAR01 data element for SYST
Its data type is C (Character String) with field length 1

AENNR : Change Number
Its data type is C (Character String) with field length 12

ORGAUFPL
Its data type is N (Character String with Digits Only) with field length 10

ORGPZLFH
Its data type is N (Character String with Digits Only) with field length 8

PARKZ : Indicator: inactive changes
Its data type is C (Character String) with field length 1

DATUI : Date Record Created on
Its data type is D (Date (Date: YYYYMMDD)) with field length 8

VSAFFH_CN related tables

VSAFVV_CN : Version: Quantities/Dates/Values in order operation
VSRPSCO_CN : Version: Cumulation table for project reporting
VSHIST_NP : Tranfer history for network
VSAFAB_CN : Version: Network relationships
VSAFFL_CN : Version: Order sequences PP orders
VSKBKO_CN : Version: Capacity requirements header for an order
VSAFKO_CN : Version: Order header data for PP orders
VSPLAF_CN : Version: Planned order
VSHIST_NV : Tranfer history for network activity
TC54T : Language dependent texts for TCN54: Simulation profile
PROJVS_ENQ : Block key project (project versions)
VSPROJ_CN : Version: Project definition
VSSTEU : Version: Control table – one entry per version object –
VSHIST_OR : Transfer history order
VSFPLA_CN : Version: Billing schedule
TCN52 : Valid user status for version profile
VSRSDB_CN : Version: Index of RESB for direct procurement elements
TCNVSC : Customizing: Possible version number per version category
VSEVFG_CN : Version: PS EV, percent of completion
VSAFIH_CN : Version: Order header for plant maintenance

VSAFFH_CN related transaction codes under SAP package CNVS

CJV2 : Change project version (simulation)
CJV3 : Display Project Version (Simulation)
CJV5 : Delete simulation version
CN72 : Create Project Version
CJV6 : Maintenance: Version administration
CJV4 : Transfer project
CJV7 : Display transfer log
CJV1 : Create project version (simulation)

VSAFFH_CN SAP table for – Version: PRT allocation to work order

Table VSAFFH_CN technical data

SAP VSAFFH_CN Table Fields

VSAFFH_CN related tables

VSAFFH_CN related transaction codes under SAP package CNVS

Related References

About SAP

Most Popular

SAP Analytics & Administration

Useful References

VSAFFH_CN SAP table for – Version: PRT allocation to work order

Table VSAFFH_CN technical data

SAP VSAFFH_CN Table Fields

VSAFFH_CN related tables

VSAFFH_CN related transaction codes under SAP package CNVS

Related References

Related Tutorials

About SAP

Most Popular

SAP Analytics & Administration

Useful References