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

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

TableVSAFFH_CN
Data storingVersion: PRT allocation to work order
ModulePS
ComponentPS-SIM
SAP PackageCNVS
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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