V50GALV8 SAP (Declarations to authorities: ALV: INTRASTAT issue list) Structure details

Dictionary Type: Structure
Description: Declarations to authorities: ALV: INTRASTAT issue list




ABAP Code to SELECT data from V50GALV8
Related tables to V50GALV8
Access table V50GALV8




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

V50GALV8 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Declarations to authorities: ALV: INTRASTAT issue list" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_V50GALV8 TYPE V50GALV8.

The V50GALV8 table consists of various fields, each holding specific information or linking keys about Declarations to authorities: ALV: INTRASTAT issue list data available in SAP. These include MANDT (Client), DATUMJAHR (Reporting year of declaration to authorities), DATUMMONA (Reporting month of declaration to authorities), ARRIVDEPA (Indicator: Goods direction for declarations to authorities).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP V50GALV8 structure 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 MANDTCLNT3T000MANDT
DATUMJAHRReporting year of declaration to authorities DATUMJAHRNUMC4GJAHRGJAHRGJR
DATUMMONAReporting month of declaration to authorities DATUMMONANUMC2MONAT
ARRIVDEPAIndicator: Goods direction for declarations to authorities VEREINUMC1VEREI
LFDNRVEIASequential number for Intrastat declaration LFDNR_VEIANUMC7NUM07
USERNNAMEName of Person who Created the Object ERNAMCHAR12USNAM
SATZERDATDate on Which Record Was Created ERDATDATS8DATUM
NUMMBUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
VERKAUFORSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
EIGENUINRID number of trader EIGENUINRCHAR20STCEG
EIGENBLNDFederal state of tax office EIGENBLNDCHAR2HERBL
BELEGNUMRDocument number BELEGNUMRCHAR10Assigned to domainALPHAVBELN
HAUPTPOSIItem HAUPTPOSINUMC6Assigned to domainPOSNR
MATERIALNMaterial Number MATNR_INTRCHAR6CHAR6
FAKTDATUMBilling date for billing index and printout FKDATDATS8DATUM
VERSENDERImporter HQ / Exporter HQ VERSENDERCHAR1VERSENDER
BESTILANDCountry of destination of material BESTILANDCHAR3T005LAND1LND
BESTIREGIDestination region BESTIREGICHAR3Assigned to domainREGIO
LIEFERBEDIncoterms (Part 1) INCO1CHAR3TINCINCO1
ARTGESCHABusiness Transaction Type for Foreign Trade EXARTCHAR2T605EXARTEXA
VERKEHRZWMode of Transport for Foreign Trade EXPVZCHAR1T618EXPVZ
EINLADFGHCustoms Office: Office of Exit/Entry for Foreign Trade DZOLLSCHAR6T615ZOLLS
STATWARENCommodity Code/Import Code Number for Foreign Trade STAWNCHAR17T604STAWN
URSPRSLNDCountry of origin of the material HERKLCHAR3T005LAND1LND
URSPRSREGRegion of origin URSPRSREGCHAR3Assigned to domainREGIO
VERFAHRENExport/Import Procedure for Foreign Trade EXPRFCHAR8T616EXPRF
EIGENMASSTare mass in kilograms EIGENMASSNUMC15NUMC15
BESONMASSSupplementary unit BESONMASSNUMC15NUMC15
RECHNWERTInvoice value RECHNWERTNUMC15NUMC15
KUNDEUINRCustomer VAT registration number KUNDEUINRCHAR20STCEG
LIEFRUINRVendor VAT registration number LIEFRUINRCHAR20STCEG
GRENZWERTStatistical value GRENZWERTNUMC15NUMC15
SPANIENIDIndicator: Domestic / Foreign INAUKZCHAR1CHAR01
LIEFERWAEDeclarations to the authorities: Currency key of the vendor LIEFERWAECUKY5TCURCWAERSFWS
ZUSATZNUMForeign Trade: Additional no. for decl. to authorities INZNRNUMC3NUM03
NLDBOCODEBOE code (only relevant for The Netherlands) NLDBOCODENUMC2NUM02
EINKAUFORPurchasing Organization EKORGCHAR4T024EEKORGEKO
BELEGIDENSD document category VBTYPCHAR1VBTYP
RETOURCODReturns ID for official declarations RETOURCODCHAR1XFELD
GESAMANZATotal number of items in a declaration GESAMANZANUMC5NUM05
NUMMWERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
WERKSLANDDeclaration to authorities: Country of Plant WERKSLANDCHAR3T005LAND1LND
THIERISCHID type for creating records THIERISCHCHAR1THIERISCH
IFREMDWERInvoice value in foreign currency IFREMDWERNUMC15NUMC15
ISESSIONEIndicator for normal business transactions and correction ISESSIONECHAR1ISESSIONE
IREFMONATReference month for correction IREFMONATNUMC2IREFMONAT
IREFEJAHRReference year for correction IREFEJAHRNUMC4GJAHRGJAHR
ICORFORTZPlus/minus for value field in correction ICORFORTZCHAR1ICORFORTZ
IREFBELEGReference document IREFBELEGCHAR10Assigned to domainALPHAVBELN
IREFPOSITReference item IREFPOSITNUMC6Assigned to domainPOSNR
IREFWERKSReference plant IREFWERKSCHAR4T001WWERKS
PREFPACODPreference code for foreign trade (decl.to author., import) PREFPACODCHAR3T604CPREFPACOD
RECHNWEAKInvoice value RECHNWEAKCURR15(2) WERTV8
RECHNWEEHCurrency Key WAERSCUKY5TCURCWAERSFWS
GRENZWEAKStatistical value GRENZWEAKCURR13(2) WERTV7
GRENZWEEHCurrency Key WAERSCUKY5TCURCWAERSFWS
EIGENMAAKTare mass EIGENMAAKQUAN13(3) MENG13
EIGENMAEHWeight Unit GEWEIUNIT3T006CUNITMEINS
BESONMAAKSpecial unit of measure BESONMAAKQUAN13(3) MENG13
BESONMAEHWeight Unit GEWEIUNIT3T006CUNITMEINS
IFREMDWAKInvoice value in foreign currency IFREMDWAKCURR15(2) WERTV8
IFREMDWEHCurrency Key WAERSCUKY5TCURCWAERSFWS
GENESData origin indicator for declarations to the authorities GENESCHAR1GENES
P_LANDKEYCountry key P_LANDKEYCHAR1XFELD
FLAGEUROCDeclarations to the authorities: Ind. for decl. crcy = Euro FTEURCHAR1XFELD
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
ORDPAClassification Key for Periodic Declarations in For. Trade ORDPACHAR10CHAR10
SERVICEITEMPeriodic Message: Service Item Ind. SERVICEITEMCHAR1XFELD
FI_NUMBERItaly - Number of Financial Accounting Document INTRA_FI_NUMBERCHAR15CHAR15
FI_DATEField of type DATS DATSDATS8DATS
SERVICE_CODEItaly - Code Number of Service INTRA_SERVICE_CODECHAR6INTRA_SERVICE_CODE
SUPPLY_CODEItaly - Type of Delivery with Services INTRA_SUPPLY_CODECHAR1INTRA_SUPPLY_CODE
PAYMENT_CODEItaly - Payment Method for Services INTRA_PAYMENT_CODECHAR1INTRA_PAYMENT_CODE
PAYER_COUNTRYCountry of the payer PLARGCHAR3Assigned to domainLAND1
PROT_NOSequence Number of Intrastat Declaration in this Period EXDANUMDNUMC6NUMC6
PROG_NOForeign Trade: Periodic Declarations: Sequence Number FTLFDNRNUMC6NUMC6
LFDNRClassification Key for Periodic Declarations in For. Trade ORDPACHAR10CHAR10
BELNRDocument number BELEGNUMRCHAR10Assigned to domainALPHAVBELN
POSNRItem HAUPTPOSINUMC6Assigned to domainPOSNR
MOREDForeign Trade: Periodic Declarations: Aggregated Entries FTMOREDCHAR8CHAR8
TABIXRow Index of Internal Tables SYTABIXINT410SYST_LONG
EIGENMAAK_DEC6Tare mass EIGENMAAK_DEC6QUAN14(6) MENG13_6

Key field Non-key field



How do I retrieve data from SAP structure V50GALV8 using ABAP code?

As V50GALV8 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on V50GALV8 as there is no data to select.

How to access SAP table V50GALV8

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