1. Home
  2. Resources
  3. SAP Tables
  4. SLL_CD_1 - BW Extractor Structure for Customs Document

SAP Table SLL_CD_1

BW Extractor Structure for Customs Document

SLL_CD_1 (BW Extractor Structure for Customs Document) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link SLL_CD_1 to other SAP tables.

SLL_CD_1 table fields

Field Data element Checktable Datatype Length Decimals
CDNUM Document Number /SAPSLL/CUORNO CHAR 10 0
CDYEA Document Year /SAPSLL/NRYEAR NUMC 4 0
CDITN Customs Document Item Number /SAPSLL/CDITN CHAR 10 0
ROCANCEL BW Delta Process: Record Mode RODMUPDMOD CHAR 1 0
NULL After-Image
X Before-Image
A Add
D Delete (Key Only)
N New Image
R Reverse-Image
Y Update Image (Value from Update)
CDSTA GTS: Processing Status of Document in Customs Area /SAPSLL/PROST CHAR 2 0
0A New
1A Available for Processing
2A Processing Blocked - Awaiting Reply from Authorities
3A Processing Restricted - Document Registered with Authorities
3B Processing Restricted - Document Completed
4A Cancellation Requested
4B Canceled
INDEI Import/Export Indicator (Exclusive) /SAPSLL/INDEI_EXCL CHAR 1 0
1 Import/Arrival
2 Export/Dispatch
FCOTD Customs Declaration or Customs Shipment /SAPSLL/FCOTD CHAR 1 0
1 Customs Declaration
2 Customs Shipment
FRELP Indicator: Relevance to Preference Processing /SAPSLL/FRELP CHAR 1 0
X Relevant for Preference Processing
NULL Not Relevant for Preference Processing
PREFL Indicator: Preference Eligibility /SAPSLL/PREFL CHAR 1 0
X Eligible for Preference
NULL Not Eligible for Preference
PREPD Indicator: Price-Dependent Preference /SAPSLL/PREPD CHAR 1 0
X Preference Is Price Dependent
NULL Preference Is not Price Dependent
FRELR Indicator: Relevance to Restitution /SAPSLL/FRELR CHAR 1 0
X Relevant for Restitution
NULL Not Relevant for Restitution
CDDAT Customs Document Date /SAPSLL/CDDAT DATS 8 0
EXDAT Export Date /SAPSLL/EXDAT DATS 8 0
CRDAT Creation Date /SAPSLL/CRDA2 DATS 8 0
NSCTC Numbering Scheme for Tariff Code Number /SAPSLL/NSCTC CHAR 10 0
NUCTC Country for Tariff Code Number /SAPSLL/NUCTC CHAR 3 0
NUMTC Tariff Code Number /SAPSLL/NUMTC CHAR 20 0
NSCCC Numbering Scheme for Commodity Code /SAPSLL/NSCCC CHAR 10 0
NUCCC Country for Commodity Code /SAPSLL/NUCCC CHAR 3 0
NUMCC Commodity Code /SAPSLL/NUMCC CHAR 20 0
NSCRC Numbering Scheme for Commmon Agricultural Policy Number /SAPSLL/NSCRC CHAR 10 0
NUMRC Common Agricultural Policy (CAP) Number /SAPSLL/NUMRC CHAR 20 0
BOPNO Bill of Material No. /SAPSLL/BOPNO CHAR 10 0
SECNC Security Number for Customs/Shipping Processing /SAPSLL/SECNC CHAR 40 0
SECNR Security Number for Restitution /SAPSLL/SECNR CHAR 40 0
PRNUM Internal Product Number /SAPSLL/PRNUM CHAR 20 0
CTYDP Country of Departure Key /SAPSLL/CTYDP CHAR 3 0
CTYAR Country of Destination Key /SAPSLL/CTYAR CHAR 3 0
CUCOO Custom Product's Country of Origin /SAPSLL/CUCOO CHAR 3 0
FTORG Foreign Trade Organizational Unit /SAPSLL/FTORG CHAR 10 0
LEGUN Legal Unit /SAPSLL/FTVBS CHAR 10 0
PSEND Consignor /SAPSLL/PSEND CHAR 10 0
VSEND Vendor Number of Sender (Import) /SAPSLL/VSEND CHAR 10 0
PRECP Consignee /SAPSLL/PRECP CHAR 10 0
CRECP Customer Number of Consignee (Export / Import) /SAPSLL/CRECP CHAR 10 0
PDECL Declarant /SAPSLL/PDECL CHAR 10 0
PDECS Substitute Declarant /SAPSLL/PDECS CHAR 10 0
POENT Office of Entry /SAPSLL/POENT CHAR 10 0
PODES Office of Destination /SAPSLL/COFAR CHAR 10 0
PODEP Office of Departure /SAPSLL/COFDP CHAR 10 0
POEXI Office of Exit /SAPSLL/COFOT CHAR 10 0
CCAFA Concession Requested /SAPSLL/CCAFA CHAR 5 0
CUPRO Place into a Customs Status (Procedure) /SAPSLL/CUPRO CHAR 8 0
DCTYP Declaration Type /SAPSLL/DCTYP CHAR 10 0
CSSTA Customs Status of Good /SAPSLL/CSSTA CHAR 3 0
MTRDO Inland Mode of Transport /SAPSLL/MTRDO CHAR 2 0
MTBRC Mode of Transport at Border /SAPSLL/MTRBC CHAR 2 0
CUHDA Document Type /SAPSLL/CUHDA CHAR 6 0
CUITA Item Category in SAP GTS /SAPSLL/CUITA CHAR 6 0
LREGC Legal Regulation for Customs and Transit Processing /SAPSLL/LREGC CHAR 5 0
LREGP Legal Regulation for Preference Processing /SAPSLL/LREGP CHAR 5 0
LREGR Legal Regulation for Restitution /SAPSLL/LREGR CHAR 5 0
INCOT Incoterm /SAPSLL/INCOT CHAR 3 0
INCOL Incoterm Location /SAPSLL/INCOLO CHAR 40 0
EXART Customs Business Transaction Type /SAPSLL/EXART CHAR 2 0
PYTYP Payment Method /SAPSLL/PYTYP CHAR 1 0
AUTNO Authorization Number /SAPSLL/AUTNO CHAR 40 0
ECPID Customs ID for Customs Procedure with Economic Significance /SAPSLL/ECPID_SPI CHAR 10 0
PRSRC Source Procedure /SAPSLL/PRSRC CHAR 2 0
01 Community Area
02 Third Country
03 Free Zone
04 Customs Warehouse
05 Outward Processing
06 Processing under Customs Control
07 Inward Processing
PRDES Target Procedure /SAPSLL/PRDES CHAR 2 0
01 Transit
03 Presentation
04 Export / Reexport
05 Outward Processing
06 Free Circulation
08 Customs Warehouse
09 Inward Processing
10 Processing under Customs Control
11 Scrapping
12 Excise Duty Monitoring
13 Pre-Declaration
ADDD1 Additional Data 1 /SAPSLL/ADDDA1 CHAR 10 0
ADDD2 Additional Data 2 /SAPSLL/ADDDA2 CHAR 15 0
ADDD3 Additional Data 3 /SAPSLL/ADDDA3 CHAR 30 0
NETVA Net Price / Invoice Value /SAPSLL/NETVA CURR 17 2
STAVA Statistical Value /SAPSLL/STAVA CURR 17 2
CUSVA Customs Value /SAPSLL/CUSVA CURR 17 2
TCODU Third-Country Duty /SAPSLL/TCODU CURR 17 2
PREDU Preferential Customs Duty /SAPSLL/PREDU CURR 17 2
PHPDU Pharmaceutical Product Duty /SAPSLL/PHPDU CURR 17 2
SUSDU Suspension of Duty /SAPSLL/SUSDU CURR 17 2
ADUDU Anti-Dumping Duty /SAPSLL/ADUDU CURR 17 2
SUMDU Customs Total /SAPSLL/SUMDU CURR 17 2
CURCU Customs Duty Currency /SAPSLL/CURCU CUKY 5 0
PRRVA Preference Comparison Value /SAPSLL/PRRVA CURR 17 2
PRTVA Preference Threshold Value /SAPSLL/PRTVA CURR 17 2
CURPR Preference Currency /SAPSLL/CURPR CUKY 5 0
RESVA Export Refund /SAPSLL/RESVA CURR 17 2
CURRE Restitution Currency /SAPSLL/CURRE CUKY 5 0
QUANB Quantity in Base Unit of Measure /SAPSLL/QUANB QUAN 17 3
QUAUB Base Unit of Measure /SAPSLL/QUAUB UNIT 3 0
QUAND Quantity in Document Unit of Measure /SAPSLL/QUAND QUAN 17 3
QUAUD Document Unit of Measure /SAPSLL/QUAUD UNIT 3 0
WEIGR Gross Weight /SAPSLL/WEIGR QUAN 17 3
WEINE Net Weight /SAPSLL/WEINE QUAN 17 3
WEIDI Unit of Weight /SAPSLL/WEIDI UNIT 3 0
NUMIT Number of Items /SAPSLL/NUMIT DEC 17 3