/SAPSLL/PREVD SAP (Preference: Long-Term Vendor Declaration - Header) Table details

Dictionary Type: Table
Description: Preference: Long-Term Vendor Declaration - Header




ABAP Code to SELECT data from /SAPSLL/PREVD
Related tables to /SAPSLL/PREVD
Access table /SAPSLL/PREVD




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

/SAPSLL/PREVD is a standard SAP Table which is used to store Preference: Long-Term Vendor Declaration - Header data and is available within R/3 SAP systems depending on the version and release level.

The /SAPSLL/PREVD table consists of various fields, each holding specific information or linking keys about Preference: Long-Term Vendor Declaration - Header data available in SAP. These include MANDT (Client), GUID_PREVD (Primary Key as GUID in 'RAW' Format), VDTYP (Vendor Declaration Type), RLTYP (Partner Role).. 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: Cannot Be Enhanced


SAP /SAPSLL/PREVD 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
GUID_PREVDPrimary Key as GUID in 'RAW' Format /SAPSLL/GUID_16RAW16SYSUUID
VDTYPVendor Declaration Type /SAPSLL/VDTYPCHAR5/SAPSLL/VDTYP
RLTYPPartner Role /SAPSLL/PR_RLTYPCHAR6/SAPSLL/PR_RLTYP
GUID_PRPrimary Key as GUID in 'RAW' Format /SAPSLL/GUID_16RAW16/SAPSLL/PRSYSUUID
MODELGRPAdministrative Unit /SAPSLL/MODELGRPCHAR10BUT000ALPHABU_PARTNER/SAPSLL/MODELGRP/SAPSLL/BP_PREAD
PARTNERBusiness Partner Number BU_PARTNERCHAR10BUT000ALPHABU_PARTNERBPABUPA
DATBI'Valid To' Date for SAP GTS /SAPSLL/DATBIDATS8DATS/SAPSLL/DATBI
DATAB'Valid From' Date for SAP GTS /SAPSLL/DATABDATS8DATS/SAPSLL/DATAB
DATAB_ORG'Valid From' Date for SAP GTS /SAPSLL/DATABDATS8DATS/SAPSLL/DATAB
DATBI_ORG'Valid To' Date for SAP GTS /SAPSLL/DATBIDATS8DATS/SAPSLL/DATBI
ERNAMName of User Who Created the Object /SAPSLL/ERNAMCHAR12USR02XUBNAME
CRTSPUTC Time Stamp When Object Was Added /SAPSLL/CRTSPDEC15SLLTS/SAPSLL/TSTMP
AENAMName of User Who Changed the Object /SAPSLL/AENAMCHAR12USR02XUBNAME
CHTSPUTC Time Stamp When Object Was Changed /SAPSLL/CHTSPDEC15SLLTS/SAPSLL/TSTMP
MANCOPreference: Request and Reminder Indicator /SAPSLL/MANCONUMC3/SAPSLL/MANCO
MANFDPreference: Date of Request/Reminder Creation /SAPSLL/MANFDDATS8/SAPSLL/MANFD
STATUSStatus of Vendor Declaration /SAPSLL/PREVD_STATUSCHAR2/SAPSLL/PREVD_STATUS
LAND1Preferential Country of Origin /SAPSLL/PURLACHAR3T005LAND1
VDYEARDocument Year /SAPSLL/NRYEARNUMC4/SAPSLL/NRYEAR/SAPSLL/NRYEAR
VDNOVendor Declaration Number /SAPSLL/VDNOCHAR20ALPHA/SAPSLL/VDNO/SAPSLL/VDNO
VDDATEIssue Date of Long-Term Vendor Declaration /SAPSLL/VDDATDATS8DATS
AGRELIndicator for Aggregation Relevance /SAPSLL/AGRELCHAR1XFELD
VDREFYEARDocument Year /SAPSLL/NRYEARNUMC4/SAPSLL/NRYEAR/SAPSLL/NRYEAR
VDREFNOReference Number /SAPSLL/REFNOCHAR40ALPHA/SAPSLL/OBJEX/SAPSLL/REFNO
VALUEComparison Value Preference from Document Item /SAPSLL/EPVAL_FLTFLTP16(16) /SAPSLL/FLOAT
CURRCCurrency of a Value /SAPSLL/AMCURCUKY5TCURCWAERS/SAPSLL/AMCUR
PRDIMPrice Unit /SAPSLL/PUNITDEC5/SAPSLL/PUNIT
DIMUMUnit of Measurement of a Dimension /SAPSLL/DIMUMUNIT3T006CUNITMEINS/SAPSLL/DIMUM
DOCDATEDate of Business Transaction /SAPSLL/RPTDT8DATS8DATS
LGHDLApplication Log: Log Handle BALLOGHNDLCHAR22SYSUUID_22
AGGREGPreference Statement from Aggregation /SAPSLL/AGGREGCHAR1XFELD
DETERMPreference Statement from Calculation /SAPSLL/DETERMCHAR1XFELD
MANUALManual Preference Statement /SAPSLL/MANUALCHAR1XFELD
PRDNANAFTA Certificate of Origin - 'Producer' Field /SAPSLL/NAFTA_COO_PRODUCERCHAR1/SAPSLL/NAFTA_COO_PRODUCER
CUCOOCustom Product's Country of Origin /SAPSLL/CUCOOCHAR3Assigned to domainLAND1
REGIORegion Key /SAPSLL/REGIOCHAR3Assigned to domainREGIO
CUMULPreference: Cumulation Endorsement /SAPSLL/CUMULATIONCHAR1/SAPSLL/CUMULATION
GUID_KPROPrimary Key as GUID in 'RAW' Format /SAPSLL/GUID_16RAW16SYSUUID

Key field Non-key field



How do I retrieve data from SAP table /SAPSLL/PREVD using ABAP code

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

SELECT SINGLE *
FROM /SAPSLL/PREVD
INTO CORRESPONDING FIELDS OF WA_/SAPSLL/PREVD
WHERE...

How to access SAP table /SAPSLL/PREVD

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