/ECRS/WLEN

Worklist for Intrastat Declaration | #transactional | Component: Intrastat Reporting
Column Name Description
MANDT FK Client
GUID_WLEN GUID in 'RAW' format
Column Name Description
💲 Currency Key for Invoice Value (INCUR):
INVAL Invoice Value
💲 Currency Key for Statistical Value (STCUR):
STVAL Statistical Value
💲 Key of Foreign Currency (FCCUR):
IFVAL Invoice Value in Foreign Currency
Column Name Description
📏 Unit of Measure for Net Weight (NWUOM):
NTWEI Net Weight
📏 Supplementary Unit (SPUOM):
SPQUA Quantity in Supplementary Unit
📏 Unit of Measure (ITUOM):
ITQUA Quantity
Column Name Description
Column Name Description
DOTYP Document Type Show values
RDTYP Reference Document Type Show values
RPMON Declaration Month Show values
DIREC Direction (Receipt, Dispatch) Show values
ENTYP Type of Entry Show values
GENES Data Origin Show values
INCZO Place of Delivery Show values
SRVIT Service Item Relevant Show values
Column Name Description Domain name
DONUM Document Number /ECRS/DONUM
DOITM Document Item Number /ECRS/DOITM
RDNUM Reference Document Number /ECRS/DONUM
RDITM Reference Document Item Number /ECRS/DOITM
ADDF1 Additional Field 1 /ECRS/ADDF1
ADDF2 Additional Field 2 /ECRS/ADDF2
ADDF3 Additional Field 3 /ECRS/ADDF3
RPYEA Declaration Year /ECRS/CYEAR
POIID Provider of Information ID /ECRS/POIID
VFPTV Partner VAT Registration Number /ECRS/VATID
MATNR Material Number MATNR
MAKTX Description of Declaration Item TEXT40
COMCD Commodity Code /SAPSLL/CCNGN
NAOTV Country of Means of Transport at the Border LAND1
INCTM Incoterms CHAR03
CRTTS UTC Time Stamp When Object Was Added TZNTSTMPS
LCHTS UTC Time Stamp When Object Was Changed TZNTSTMPS
WERKS Plant WERKS
ISVCO Intrastat Service Code /SAPSLL/CCNGN
PYCTY Country of Payment LAND1
LOGSY Logical system LOGSYS
Master Data Relations Join Conditions
Name of User Who Added Object
  • /ECRS/WLEN.MANDT == USR02.MANDT
  • /ECRS/WLEN.CRTBY == USR02.BNAME
Country of Origin
  • Country of Origin
  • Client
  • /ECRS/WLEN.CTYOO == T005.LAND1
  • /ECRS/WLEN.MANDT == T005.MANDT
Country of Provider of Information
  • Country of Provider of Information
  • Client
  • /ECRS/WLEN.GFPIC == T005.LAND1
  • /ECRS/WLEN.MANDT == T005.MANDT
Region in Country of Provider of Information
  • Country of Provider of Information
  • Region in Country of Provider of Information
  • /ECRS/WLEN.MANDT == T005S.MANDT
  • /ECRS/WLEN.GFPIC == T005S.LAND1
  • /ECRS/WLEN.GFPIR == T005S.BLAND
Partner Country
  • Partner Country
  • Client
  • /ECRS/WLEN.GFPTC == T005.LAND1
  • /ECRS/WLEN.MANDT == T005.MANDT
Region in Partner Country
  • Partner Country
  • Region in Partner Country
  • /ECRS/WLEN.MANDT == T005S.MANDT
  • /ECRS/WLEN.GFPTC == T005S.LAND1
  • /ECRS/WLEN.GFPTR == T005S.BLAND
Currency Key for Invoice Value
  • /ECRS/WLEN.MANDT == TCURC.MANDT
  • /ECRS/WLEN.INCUR == TCURC.WAERS
Name of User Who Changed Object
  • /ECRS/WLEN.MANDT == USR02.MANDT
  • /ECRS/WLEN.LCHBY == USR02.BNAME
Client /ECRS/WLEN.MANDT == T000.MANDT
Unit of Measure for Net Weight
  • /ECRS/WLEN.MANDT == T006.MANDT
  • /ECRS/WLEN.NWUOM == T006.MSEHI
Region of Origin
  • Country of Origin
  • Region of Origin
  • /ECRS/WLEN.MANDT == T005S.MANDT
  • /ECRS/WLEN.CTYOO == T005S.LAND1
  • /ECRS/WLEN.REGOO == T005S.BLAND
Supplementary Unit
  • /ECRS/WLEN.MANDT == T006.MANDT
  • /ECRS/WLEN.SPUOM == T006.MSEHI
Currency Key for Statistical Value
  • /ECRS/WLEN.MANDT == TCURC.MANDT
  • /ECRS/WLEN.STCUR == TCURC.WAERS