/SAPSLL/SPLAUD SAP (Legal Control - SPL - Audit) Table details
Dictionary Type: Table
Description: Legal Control - SPL - Audit
Description: Legal Control - SPL - Audit
ABAP Code to SELECT data from /SAPSLL/SPLAUD
Related tables to /SAPSLL/SPLAUD
Access table /SAPSLL/SPLAUD
Related tables to /SAPSLL/SPLAUD
Access table /SAPSLL/SPLAUD
Table field list including key, data, relationships and ABAP select examples
/SAPSLL/SPLAUD is a standard SAP Table which is used to store Legal Control - SPL - Audit data and is available within R/3 SAP systems depending on the version and release level.
The /SAPSLL/SPLAUD table consists of various fields, each holding specific information or linking keys about Legal Control - SPL - Audit data available in SAP. These include MANDT (Client), GUID_SPLAUD (Primary Key as GUID in 'RAW' Format), ERNAM (Name of User Who Created the Object), CRTSP (UTC Time Stamp When Object Was Added).. 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: Can be enhanced (character-type or numeric)
SAP /SAPSLL/SPLAUD 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
GUID_SPLAUD | Primary Key as GUID in 'RAW' Format | /SAPSLL/GUID_16 | RAW | 16 | SYSUUID | ||||
ERNAM | Name of User Who Created the Object | /SAPSLL/ERNAM | CHAR | 12 | USR02 | XUBNAME | |||
CRTSP | UTC Time Stamp When Object Was Added | /SAPSLL/CRTSP | DEC | 15 | SLLTS | /SAPSLL/TSTMP | |||
AENAM | Name of User Who Changed the Object | /SAPSLL/AENAM | CHAR | 12 | USR02 | XUBNAME | |||
CHTSP | UTC Time Stamp When Object Was Changed | /SAPSLL/CHTSP | DEC | 15 | SLLTS | /SAPSLL/TSTMP | |||
ADRNR | Address Number of Entry in Address File | /SAPSLL/ADRNR | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ||
LGREG | Legal Regulation | /SAPSLL/LGREG | CHAR | 5 | /SAPSLL/T606G | /SAPSLL/LGREG | /SAPSLL/LGREG | ||
SPL_CHK_DATE | Date of Sanctioned Party List Screening | /SAPSLL/SPLCT | DEC | 15 | SLLTS | /SAPSLL/TSTMP | |||
GUID_LAUNR | Primary Key as GUID in 'RAW' Format | /SAPSLL/GUID_16 | RAW | 16 | SYSUUID | ||||
SPL_SCENARIO | SPL Screening Scenario - Legal Control | /SAPSLL/SPLCS | CHAR | 2 | /SAPSLL/SPLCS | /SAPSLL/SPLCS | |||
SPLAG | SPL Algorithm | /SAPSLL/SPLAG | CHAR | 1 | /SAPSLL/SPLAG | ||||
SPEMP | SPL Base for Checking Employees | /SAPSLL/SPEMP | CHAR | 1 | /SAPSLL/SPEMP | ||||
SPL_RES_SYSTEM | Outcome of System SPL Screening for Legal Control | /SAPSLL/SPLRS | CHAR | 1 | /SAPSLL/SPLRS | /SAPSLL/SPLRS | |||
SPL_RES_USER | Outcome of Manual SPL Screening - User Decision | /SAPSLL/SPLRU | CHAR | 1 | /SAPSLL/SPLRS | /SAPSLL/SPLRU | |||
SPLPN | Flagged on Positive/Negative List | /SAPSLL/SPLPN | CHAR | 1 | /SAPSLL/SPLPN | ||||
SPLIB | Indicator for 'Indirectly Locked' | /SAPSLL/SPLIB | CHAR | 2 | /SAPSLL/SPLIB | ||||
GUID_PRTN | Primary Key of Business Partner | /SAPSLL/PRTN_GUID_16 | RAW | 16 | SYSUUID | ||||
GRVSY | Logical System Group | /SAPSLL/GRVSY | CHAR | 10 | /SAPSLL/TCOGVS | /SAPSLL/GRVSY | /SAPSLL/GRVSY | ||
BPTYP | Business Partner Category in Feeder System | /SAPSLL/BPTYP | CHAR | 2 | /SAPSLL/BPTYP | /SAPSLL/BPTYP | |||
BPVSY | External Business Partner Number | /SAPSLL/BPVSY | CHAR | 40 | ALPHA | /SAPSLL/OBJEX | /SAPSLL/BPVSY | /SAPSLL/BP | |
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
LAND1 | Country Key | /SAPSLL/LAND1 | CHAR | 3 | T005 | LAND1 | /SAPSLL/LAND1 | ||
MOBJT | Type of Main Object | /SAPSLL/MOBJT | CHAR | 1 | /SAPSLL/MOBJT | ||||
GUID_MOBJ | Primary Key of Main Object | /SAPSLL/MOBJ_GUID_16 | RAW | 16 | SYSUUID | ||||
POBJT | Type of Preceding Object | /SAPSLL/POBJT | CHAR | 2 | /SAPSLL/POBJT | ||||
GUID_POBJ | Primary Key of Preceding Object | /SAPSLL/POBJ_GUID_16 | RAW | 16 | Assigned to domain | SYSUUID | |||
GUID_CORPAR | Primary Key as GUID in 'RAW' Format | /SAPSLL/GUID_16 | RAW | 16 | SYSUUID | ||||
QALREF | Type of Reference Number | /SAPSLL/QALREF | CHAR | 6 | /SAPSLL/TCO200 | /SAPSLL/QALREF | |||
REFNO | Reference Number | /SAPSLL/REFNO | CHAR | 40 | ALPHA | /SAPSLL/OBJEX | /SAPSLL/REFNO | ||
REFDT | Date of Reference Object | /SAPSLL/REFDT | DATS | 8 | DATS | /SAPSLL/REFDT | |||
ORGLOGSYS | Logical System of Original Object | /SAPSLL/ORGLOGSYS | CHAR | 10 | TBDLS | ALPHA | LOGSYS | /SAPSLL/ORGLOGSYS | |
OBJTP | Object Type of Reference Document | /SAPSLL/OBJTP | CHAR | 10 | /SAPSLL/OBJTP_REPL | /SAPSLL/OBJTP | |||
ITVSY | External Document Item ID from Feeder System | /SAPSLL/ITVSY | CHAR | 10 | ALPHA | /SAPSLL/OBJEX_10 | /SAPSLL/ITVSY | ||
PAFCT | Partner Function | /SAPSLL/PAFCT | CHAR | 8 | /SAPSLL/TPAFCT | /SAPSLL/PAFCT | /SAPSLL/PAFCT | ||
CORDER | Document Number | /SAPSLL/CUORNO | CHAR | 10 | ALPHA | /SAPSLL/CORNO | /SAPSLL/CUORNO | ||
COYEAR | Document Year | /SAPSLL/NRYEAR | NUMC | 4 | /SAPSLL/NRYEAR | /SAPSLL/NRYEAR | |||
CUHDA | Document Type | /SAPSLL/CUHDA | CHAR | 6 | Assigned to domain | /SAPSLL/CUHDA | |||
GUID_FTORG | Primary Key as GUID in 'RAW' Format | /SAPSLL/GUID_16 | RAW | 16 | SYSUUID | ||||
SPLAMLO | Separation into Business Areas: Logistics | /SAPSLL/SPLAMLO | CHAR | 1 | XFELD | ||||
SPLAMFI | Separation into Business Areas: Financial Accounting | /SAPSLL/SPLAMFI | CHAR | 1 | XFELD | ||||
SPLAMHR | Business Separation of Human Resources - Employees | /SAPSLL/SPLAMHR | CHAR | 1 | XFELD | ||||
SPLAMHR1 | Business Separation of Human Resources - Applicants | /SAPSLL/SPLAMHR1 | CHAR | 1 | XFELD | ||||
DATE_FROM | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS | 8 | DATUM | ||||
DATE_TO | Valid-to date in current Release only 99991231 possible | AD_DATE_TO | DATS | 8 | DATUM | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | TSAD3 | AD_TITLE | |||
NAME1 | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
NAME2 | Name 2 | AD_NAME2 | CHAR | 40 | TEXT40 | ||||
NAME3 | Name 3 | AD_NAME3 | CHAR | 40 | TEXT40 | ||||
NAME4 | Name 4 | AD_NAME4 | CHAR | 40 | TEXT40 | ||||
NAME_TXT | Converted name field (with form of address) | AD_NAMETXT | CHAR | 50 | TEXT50 | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ADRCITY | ALPHA | CITY_CODE | ||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ADRCITYPRT | ALPHA | CITYP_CODE | ||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ADRCITY | ALPHA | CITY_CODE | ||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | ADRREGGRP | REGIOGROUP | |||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | TSAD12 | AD_NO_USE | |||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ADRCITY | ALPHA | CITY_CODE | ||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | T005S | REGIO | |||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | T005 | LAND1 | |||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | TZONE | ZONE | |||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | TSAD12 | AD_NO_USE | |||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ADRSTREET | ALPHA | STRT_CODE | ||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | ADRSTRTYPE | STRTYPEAB | |||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
LANGU | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | TSAD6 | AD_ORIGIN | |||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TTZZ | TZNZONE | |||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | T002 | ISOLA | SPRAS | ||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | ADDRC_DELI_SERV | AD_DELIVERY_SERVICE_TYPE | |||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ADRCOUNTY | ALPHA | CNTY_CODE | ||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ADRTOWNSHIP | ALPHA | TWSHP_CODE | ||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Communication Method (Key) (Business Address Services) | AD_COMM | CHAR | 3 | TSAC | AD_COMM | |||
IDTYP | Identity Card Type | /SAPSLL/IDTYP | CHAR | 4 | /SAPSLL/TCSIDDO | /SAPSLL/IDTYP | |||
SPAID | ID Number for Ad Hoc SPL Screening | /SAPSLL/SPAID | CHAR | 40 | TEXT40 |
Key field | Non-key field |
How do I retrieve data from SAP table /SAPSLL/SPLAUD using ABAP code
The following ABAP code Example will allow you to do a basic selection on /SAPSLL/SPLAUD to SELECT all data from the tableDATA: WA_/SAPSLL/SPLAUD TYPE /SAPSLL/SPLAUD.
SELECT SINGLE *
FROM /SAPSLL/SPLAUD
INTO CORRESPONDING FIELDS OF WA_/SAPSLL/SPLAUD
WHERE...
How to access SAP table /SAPSLL/SPLAUD
Within an ECC or HANA version of SAP you can also view further information about /SAPSLL/SPLAUD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects