/SAPSLL/PRPREFR3 SAP table for – GTS: Material Master Record: Preference Data (Summarized)

Here we would like to draw your attention to /SAPSLL/PRPREFR3 table in SAP. As we know it is being mainly used with the SAP SD-FT (Foreign Trade in SD) component which is coming under SD module (Sales & Distribution). /SAPSLL/PRPREFR3 is a SAP standard transparent table used for storing GTS: Material Master Record: Preference Data (Summarized) related data in SAP. It comes under the package /SAPSLL/PLUG_IN_R3.

SAP /SAPSLL/PRPREFR3 table

Table /SAPSLL/PRPREFR3 technical data

Table/SAPSLL/PRPREFR3
Data storingGTS: Material Master Record: Preference Data (Summarized)
ModuleSD
ComponentSD-FT
SAP Package/SAPSLL/PLUG_IN_R3
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /SAPSLL/PRPREFR3 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 /SAPSLL/PRPREFR3 table.

  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its a key field. Its include structure/component is is /SAPSLL/PRPREFR3_PK_S
  • DATAB : Validity start date of the condition record
    Its data type is D (Date (Date: YYYYMMDD)) with field length 16
  • PRFTY
    Its data type is C (Character String) with field length 2
  • PRMET
    Its data type is C (Character String) with field length 2
  • PREFE
    Its data type is N (Character String with Digits Only) with field length 4
  • QUANT
    Its data type is F (Floating point number) with field length 8
  • QUAUM
    Its data type is C (Character String) with field length 6
  • VALCP
    Its data type is F (Floating point number) with field length 8
  • VALOR
    Its data type is F (Floating point number) with field length 8
  • VALNO
    Its data type is F (Floating point number) with field length 8
  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 6
  • VALRB
    Its data type is F (Floating point number) with field length 8
  • VLCUR
    Its data type is C (Character String) with field length 10
  • PURLA
    Its data type is C (Character String) with field length 6
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 24
  • CRTSP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 24
  • CHTSP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MATNR : Material Number
    Its a key field. Its data type is C (Character String) with field length 36
  • PLANT
    Its a key field. Its data type is C (Character String) with field length 8
  • LGREG
    Its a key field. Its data type is C (Character String) with field length 10
  • DATBI : Validity end date of the condition record
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 16