SAP ABAP Table /SAPSLL/PRPREF_UI_S (SLL: Preference: Output Structure for /SAPSLL/PRPREF)
Hierarchy
SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation
   SLL-LEG (Application Component) Global Trade Services
     /SAPSLL/LEGAL_PRE_VDEC (Package) Legal Services: Preference Handling - Vendor Declarations
Basic Data
Table Category INTTAB    Structure 
Structure /SAPSLL/PRPREF_UI_S   Table Relationship Diagram
Short Description SLL: Preference: Output Structure for /SAPSLL/PRPREF    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 .INCLUDE       0   0   SLL: Product Master: Preference Data  
2 .INCLUDE       0   0   SLL: Product Master: Preference Data - PK  
3 MANDT MANDT MANDT CLNT 3   0   Client T000
4 .INCLUDE       0   0   SLL: Product Master: Preference Data - PK w/o Client  
5 GUID_PRPREF /SAPSLL/GUID_16 SYSUUID RAW 16   0   Primary Key as GUID in 'RAW' Format  
6 .INCLUDE       0   0   SLL: Product Master: Preference Data - Data Part  
7 .INCLUDE       0   0   SLL: Product Master: Preference Data - SK  
8 .INCLUDE       0   0   Legal and Logistics Services: Product Master - PK w/o Client  
9 GUID_PR /SAPSLL/GUID_16 SYSUUID RAW 16   0   Primary Key as GUID in 'RAW' Format /SAPSLL/PR
10 .INCLUDE       0   0   SLL: GUID for Identifying the Entry in the Model Table  
11 GUID_MODEL /SAPSLL/GUID_MODEL /SAPSLL/GUID_MODEL CHAR 20   0   GUID for Table Entry of Preference Model  
12 LGREG /SAPSLL/LGREG /SAPSLL/LGREG CHAR 5   0   Legal Regulation /SAPSLL/T606G
13 PRFTY /SAPSLL/PRFTY /SAPSLL/PRFTY CHAR 1   0   Type of Preference Data in Product Master  
14 PRMET /SAPSLL/PRMET /SAPSLL/PRMET CHAR 1   0   Preference: Comparison Method  
15 .INCLUDE       0   0   SLL: Valid To  
16 DATBI /SAPSLL/RPTET /SAPSLL/TSTMP DEC 15   0   Definitive Date (Valid-To Date)  
17 .INCLUDE       0   0   SLL: Valid From  
18 DATAB /SAPSLL/RPTST /SAPSLL/TSTMP DEC 15   0   Definitive Date (Valid-From Time)  
19 .INCLUDE       0   0   SLL: Product Master: Peference Data - Data Part w/o ETS  
20 PREFE /SAPSLL/PREFE /SAPSLL/PREFE NUMC 2   0   Preference: Preference Indicator  
21 QUANT /SAPSLL/QUANT_FLT /SAPSLL/FLOAT FLTP 16   16   Quantity as Floating Point Field  
22 QUAUM /SAPSLL/DIMUM MEINS UNIT 3   0   Unit of Measurement of a Dimension *
23 VALCP /SAPSLL/PRE_VALCP_FLT /SAPSLL/FLOAT FLTP 16   16   Preferential Threshold Value  
24 VALOR /SAPSLL/PRE_VALOR_FLT /SAPSLL/FLOAT FLTP 16   16   Positive Share  
25 VALNO /SAPSLL/PRE_VALNO_FLT /SAPSLL/FLOAT FLTP 16   16   Proportion of Dutiable Components  
26 VALRB /SAPSLL/PRE_VALRB_FLT /SAPSLL/FLOAT FLTP 16   16   RVC Benefit for Designated Intermediate Material  
27 VLCUR /SAPSLL/AMCUR WAERS CUKY 5   0   Currency of a Value *
28 MODEL /SAPSLL/MODEL /SAPSLL/MODEL CHAR 5   0   Preference Model /SAPSLL/TLEMO
29 .INCLUDE       0   0   GTS: Administration: Created By, Changed By, Time Stamp  
30 ERNAM /SAPSLL/ERNAM XUBNAME CHAR 12   0   Name of User Who Created the Object USR02
31 CRTSP /SAPSLL/CRTSP /SAPSLL/TMELS DEC 15   0   Date and Time When Object Was Added  
32 AENAM /SAPSLL/AENAM XUBNAME CHAR 12   0   Name of User Who Changed the Object USR02
33 CHTSP /SAPSLL/CHTSP /SAPSLL/TMELS DEC 15   0   Date and Time When Object Was Changed  
34 .INCLUDE       0   0   SLL: Preferential Origin  
35 PURLA /SAPSLL/PURLA LAND1 CHAR 3   0   Preferential Country of Origin *
36 .INCLU-VD       0   0   SLL: Preference: Long-Term Vendor Declaration - SK  
37 VDTYPVD /SAPSLL/VDTYP /SAPSLL/VDTYP CHAR 5   0   Vendor Declaration Type  
38 RLTYPVD /SAPSLL/PR_RLTYP /SAPSLL/PR_RLTYP CHAR 6   0   Partner Role  
39 GUID_PRVD /SAPSLL/GUID_16 SYSUUID RAW 16   0   Primary Key as GUID in 'RAW' Format /SAPSLL/PR
40 MODELGRPVD /SAPSLL/MODELGRP BU_PARTNER CHAR 10   0   Administrative Unit *
41 PARTNERVD BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number BUT000
42 DATBIVD /SAPSLL/DATBI DATS DATS 8   0   "Valid To" Date for SAP GTS  
43 .INCLUDE       0   0   Legal and Logistics Srv.: Prod.Master Mapping - PK W/O Clnt  
44 GRVSY /SAPSLL/GRVSY /SAPSLL/GRVSY CHAR 10   0   Logical System Group /SAPSLL/TCOGVS
45 PRVSY /SAPSLL/PRVSY /SAPSLL/OBJEX_PRVSY CHAR 40   0   Product Number  
46 PRTYP /SAPSLL/PRTYP /SAPSLL/PRTYP CHAR 2   0   Prod. Cat. fr. Backend System for Legal and Logistics Serv.  
47 PRNUM_TXT /SAPSLL/PRTXT TEXT60 CHAR 60   0   Product Master Short Text  
48 PREFE_TXT TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
49 LGREG_TXT TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
50 PRENE_TXT TEXT80 TEXT80UEB CHAR 80   0   Text (80 Characters)  
51 GUID_MODEL_TXT TEXT10 TEXT10 CHAR 10   0   Text (10 Characters)  
52 DATAB8 /SAPSLL/DATAB DATS DATS 8   0   "Valid From" Date for SAP GTS  
53 DATBI8 /SAPSLL/DATBI DATS DATS 8   0   "Valid To" Date for SAP GTS  
54 PRENE /SAPSLL/PRENE /SAPSLL/PRENE NUMC 2   0   Preference: Indicator for Vendor Declaration (Internal)  
55 .INCLUDE       0   0   Addresses (Business Address Services)  
56 CLIENT MANDT MANDT CLNT 3   0   Client T000
57 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
58 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
59 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses TSADV
60 DATE_TO AD_DATE_TO DATUM DATS 8   0   Valid-to date in current Release only 99991231 possible  
61 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
62 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
63 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
64 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
65 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
66 NAME_TEXT AD_NAMETXT TEXT50 CHAR 50   0   Converted name field (with form of address)  
67 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
68 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
69 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
70 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file ADRCITY
71 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file ADRCITYPRT
72 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
73 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file ADRCITY
74 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
75 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
76 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
77 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
78 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
79 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
80 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
81 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
82 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
83 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag TSAD12
84 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
85 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
86 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) ADRCITY
87 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
88 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
89 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
90 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
91 STREET AD_STREET TEXT60 CHAR 60   0   Street  
92 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag TSAD12
93 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File ADRSTREET
94 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
95 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
96 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
97 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
98 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
99 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
100 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
101 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
102 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
103 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
104 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
105 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
106 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
107 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
108 ADDR_GROUP AD_GROUP AD_GROUP CHAR 4   0   Address Group (Key) (Business Address Services) TSAD7
109 FLAGGROUPS AD_FLGGP XFELD CHAR 1   0   Flag: There are more address group assignments  
110 PERS_ADDR AD_PRSADDR XFELD CHAR 1   0   Flag: This is a personal address  
111 SORT1 AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
112 SORT2 AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
113 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
114 DEFLT_COMM AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) TSAC
115 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
116 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
117 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
118 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
119 FLAGCOMM2 AD_FLGCM02 XFELD CHAR 1   0   Flag: Telephone number(s) maintained  
120 FLAGCOMM3 AD_FLGCM03 XFELD CHAR 1   0   Flag: Fax number(s) maintained  
121 FLAGCOMM4 AD_FLGCM04 XFELD CHAR 1   0   Flag: Teletex number(s) maintained  
122 FLAGCOMM5 AD_FLGCM05 XFELD CHAR 1   0   Flag: Telex number(s) maintained  
123 FLAGCOMM6 AD_FLGCM06 XFELD CHAR 1   0   Indicator: E-Mail Address(es) Maintained  
124 FLAGCOMM7 AD_FLGCM07 XFELD CHAR 1   0   Flag: RML (remote mail) addresse(s) maintained  
125 FLAGCOMM8 AD_FLGCM08 XFELD CHAR 1   0   Flag: X.400 addresse(s) maintained  
126 FLAGCOMM9 AD_FLGCM09 XFELD CHAR 1   0   Flag: RFC destination(s) maintained  
127 FLAGCOMM10 AD_FLGCM10 XFELD CHAR 1   0   Flag: Printer maintained  
128 FLAGCOMM11 AD_FLGCM11 XFELD CHAR 1   0   Flag: SSF maintained  
129 FLAGCOMM12 AD_FLGCM12 XFELD CHAR 1   0   Flag: URI/FTP address maintained  
130 FLAGCOMM13 AD_FLGCM13 XFELD CHAR 1   0   Flag: Pager address maintained  
131 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key) TSAD6
132 MC_NAME1 AD_MC_NAME CHAR25 CHAR 25   0   Name (field NAME1) in upper case for matchcode  
133 MC_CITY1 AD_MC_CITY CHAR25 CHAR 25   0   City name in upper case for search help  
134 MC_STREET AD_MC_STRT CHAR25 CHAR 25   0   Street name in upper case for search help  
135 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
136 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
137 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
138 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
139 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
140 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language *
141 ADRC_UUID AD_UUID SYSUUID RAW 16   0   UUID Used in the Address  
142 UUID_BELATED AD_UUID_BELATED AD_UUID_BELATED CHAR 1   0   Indicator: UUID was generated later  
143 ID_CATEGORY AD_ID_CATEGORY AD_ID_CATEGORY CHAR 1   0   Category of an Address ID  
144 ADRC_ERR_STATUS AD_ERR_STATUS AD_ERR_STATUS CHAR 1   0   Error Status of Address  
145 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
146 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service ADDRC_DELI_SERV
147 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
148 COUNTY_CODE AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county *
149 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
150 TOWNSHIP_CODE AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township *
151 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
152 MC_COUNTY AD_MC_COUNTY CHAR25 CHAR 25   0   County name in upper case for search help  
153 MC_TOWNSHIP AD_MC_TWSHP CHAR25 CHAR 25   0   Township name in upper case for search help  
154 XPCPT AD_XPCPT AD_XPCPT CHAR 1   0   Business Purpose Completed Flag  
155 LINECOLOR CHAR04 CHAR4 CHAR 4   0   Data Type 4 Characters  
156 PARTNER_EXT /SAPSLL/BPVSY /SAPSLL/OBJEX CHAR 40   0   External Business Partner Number  
157 PROCID /SAPSLL/PROCID /SAPSLL/PROCID CHAR 1   0   Procurement Indicator  
158 PRSALE /SAPSLL/PRSALE /SAPSLL/PRSALE CHAR 1   0   Indicator for Product Saleability  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /SAPSLL/PRPREF_UI_S ADDRORIGIN TSAD6 ORIGIN REF C CN
2 /SAPSLL/PRPREF_UI_S ADDR_GROUP TSAD7 ADDR_GROUP REF C CN
3 /SAPSLL/PRPREF_UI_S AENAM USR02 BNAME KEY 1 CN
4 /SAPSLL/PRPREF_UI_S CITYH_CODE ADRCITY CITY_CODE REF C CN
5 /SAPSLL/PRPREF_UI_S CITYP_CODE ADRCITYPRT CITYP_CODE REF C CN
6 /SAPSLL/PRPREF_UI_S CITY_CODE ADRCITY CITY_CODE REF C CN
7 /SAPSLL/PRPREF_UI_S CITY_CODE2 ADRCITY CITY_CODE REF C CN
8 /SAPSLL/PRPREF_UI_S CLIENT T000 MANDT KEY 1 CN
9 /SAPSLL/PRPREF_UI_S COUNTRY T005 LAND1 REF 1 CN
10 /SAPSLL/PRPREF_UI_S DEFLT_COMM TSAC COMM_TYPE REF C CN
11 /SAPSLL/PRPREF_UI_S DELI_SERV_TYPE ADDRC_DELI_SERV DELI_SERV_TYPE REF 1 CN
12 /SAPSLL/PRPREF_UI_S DONT_USE_P TSAD12 UNDELIVER REF C CN
13 /SAPSLL/PRPREF_UI_S DONT_USE_S TSAD12 UNDELIVER REF C CN
14 /SAPSLL/PRPREF_UI_S ERNAM USR02 BNAME KEY 1 CN
15 /SAPSLL/PRPREF_UI_S GUID_PR /SAPSLL/PR MANDT KEY 1 CN
16 /SAPSLL/PRPREF_UI_S GUID_PRVD /SAPSLL/PR MANDT 1 CN
17 /SAPSLL/PRPREF_UI_S LANGU T002 SPRAS REF C CN
18 /SAPSLL/PRPREF_UI_S LGREG /SAPSLL/T606G MANDT KEY 1 CN
19 /SAPSLL/PRPREF_UI_S MANDT T000 MANDT KEY 1 CN
20 /SAPSLL/PRPREF_UI_S MODEL /SAPSLL/TLEMO MANDT REF 1 CN
21 /SAPSLL/PRPREF_UI_S NATION TSADV NATION KEY 1 CN
22 /SAPSLL/PRPREF_UI_S PARTNERVD BUT000 PARTNER KEY 1 CN
23 /SAPSLL/PRPREF_UI_S PO_BOX_CTY T005 LAND1 REF C CN
24 /SAPSLL/PRPREF_UI_S PO_BOX_REG T005S BLAND REF C CN
25 /SAPSLL/PRPREF_UI_S REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
26 /SAPSLL/PRPREF_UI_S REGION T005S BLAND REF C CN
27 /SAPSLL/PRPREF_UI_S STREETABBR ADRSTRTYPE STRTYPEAB REF C CN
28 /SAPSLL/PRPREF_UI_S STREETCODE ADRSTREET STRT_CODE REF C CN
29 /SAPSLL/PRPREF_UI_S TIME_ZONE TTZZ TZONE REF C CN
30 /SAPSLL/PRPREF_UI_S TITLE TSAD3 TITLE REF C CN
31 /SAPSLL/PRPREF_UI_S TRANSPZONE TZONE ZONE1 REF C CN
History
Last changed by/on SAP  20141106 
SAP Release Created in 300_620