/ECRS/WLEN - Worklist for Intrastat Declaration

Worklist for Intrastat Declaration information is stored in SAP table /ECRS/WLEN.
It is part of development package /ECRS/BL_TD in software component SLL-ITR-ISR. This development package consists of objects that can be grouped under "ECR: Business Logic - Transaction Data".

Fields for table /ECRS/WLEN

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
.INCLUDEPKX/ECRS/WLEN_PK_S0
MANDTClientXMANDTCLNT6T000
.INCLUDEKX/ECRS/WLEN_K_S0
GUID_WLENGUID in 'RAW' formatX/ECRS/GUID_16RAW16
.INCLUDES/ECRS/WLEN_S0
.INCLUDEDOC/ECRS/OBIT_DOC_S0
DOTYPDocument Type/ECRS/DOTYPCHAR2
DONUMDocument Number/ECRS/DONUMCHAR20
DOITMDocument Item Number/ECRS/DOITMNUMC12
.INCLUDEREF/ECRS/OBIT_DOC_REF_S0
RDTYPReference Document Type/ECRS/RDTYPCHAR2
RDNUMReference Document Number/ECRS/RDNUMCHAR20
RDITMReference Document Item Number/ECRS/RDITMNUMC12
.INCLUDEADF/ECRS/ADF_S0
ADDF1Additional Field 1/ECRS/ADDF1CHAR10
ADDF2Additional Field 2/ECRS/ADDF2CHAR20
ADDF3Additional Field 3/ECRS/ADDF3CHAR30
RPYEADeclaration Year/ECRS/RPYEANUMC8
RPMONDeclaration Month/ECRS/RPMONNUMC4
DIRECDirection (Receipt, Dispatch)/ECRS/DIRECCHAR2
ENTYPType of Entry/ECRS/ENTYPCHAR2
GENESData Origin/ECRS/GENESCHAR2
.INCLUDEPOI/ECRS/WLEN_POI_S0
POIIDProvider of Information ID/ECRS/POIIDCHAR20
GFPICCountry of Provider of Information/ECRS/GFPICCHAR6T005
GFPIRRegion in Country of Provider of Information/ECRS/GFPIRCHAR6T005S
.INCLUDEVFL/ECRS/WLEN_VFL_S0
VFPTVPartner VAT Registration Number/ECRS/VFPTVCHAR40
.INCLUDEGFL/ECRS/WLEN_GFL_S0
GFPTCPartner Country/ECRS/GFPTCCHAR6T005
GFPTRRegion in Partner Country/ECRS/GFPTRCHAR6T005S
.INCLUDEWLP/ECRS/WLEN_MAT_S0
MATNRMaterial NumberMATNRCHAR80
MAKTXDescription of Declaration Item/ECRS/MAKTXCHAR80
COMCDCommodity Code/ECRS/COMCDCHAR60
CTYOOCountry of Origin/ECRS/CTYOOCHAR6T005
REGOORegion of Origin/ECRS/REGOOCHAR6T005S
.INCLUDEWLC/ECRS/WLEN_CHA_S0
BTTYPBusiness Transaction TypeEXARTCHAR4*
PRCDRProcedureEXPRFCHAR16*
MOTABMode of Transport at the Border (Intrastat)EXPVZCHAR2*
NAOTVCountry of Means of Transport at the Border/ECRS/NAOTVCHAR6*
PORTIPort/Airport/ECRS/PORTICHAR8*
INCTMIncoterms/ECRS/INCTMCHAR6
INCZOPlace of Delivery/ECRS/INCZOCHAR2
SPMCOMovement Code/ECRS/SPMCOCHAR4*
.INCLUDEWLK/ECRS/WLEN_KEF_S0
INVALInvoice Value/ECRS/INVALCURR8
INCURCurrency Key for Invoice Value/ECRS/INCURCUKY10TCURC
STVALStatistical Value/ECRS/STVALCURR8
STCURCurrency Key for Statistical Value/ECRS/STCURCUKY10TCURC
NTWEINet Weight/ECRS/NTWEIQUAN7
NWUOMUnit of Measure for Net Weight/ECRS/NWUOMUNIT6T006
SPQUAQuantity in Supplementary Unit/ECRS/SPQUAQUAN7
SPUOMSupplementary Unit/ECRS/SPUOMUNIT6T006
IFVALInvoice Value in Foreign Currency/ECRS/IFVALCURR8
FCCURKey of Foreign Currency/ECRS/FCCURCUKY10*
.INCLUDEETS/ECRS/ETS_S0
CRTBYName of User Who Added Object/ECRS/CRTBYCHAR24USR02
CRTTSUTC Time Stamp When Object Was Added/ECRS/CRTTSDEC8
LCHBYName of User Who Changed Object/ECRS/LCHBYCHAR24USR02
LCHTSUTC Time Stamp When Object Was Changed/ECRS/LCHTSDEC8
WERKSPlantWERKS_DCHAR8
ITQUAQuantity/ECRS/ITQUAQUAN7
ITUOMUnit of Measure/ECRS/ITUOMUNIT6*
SRVITService Item Relevant/ECRS/SRVITCHAR2
ISVCOIntrastat Service Code/SAPSLL/ISVCOCHAR60
PYCTYCountry of Payment/ECRS/PYCTYCHAR6*
LOGSYLogical systemLOGSYSCHAR20*
Privacy Policy