Programme SAP RVEXDEIF - EXTRASTAT: File Creation for Import/Export

DOCUMENTATION

Description This report generates a list and/or file of export and import billingdocument data for an EXTRASTAT declaration for submission to thestatistical authorities. Structure Reports RVEXEX00 (for exports) and RVEXEX01 (for imports) write the data relevant for EXTRASTAT intable VEXAV. Country-specific reports (such as this one, RVEXDEIF) process therelevant data according to the corresponding regulations and save themin a UNIX file. Report RVEXDEIF creates a UNIX file. The system enters its path as aparameter. If you select the First declaration field, the first data recordis provided with general information on the person who created thedeclaration. The following records always contain declaration data on goodsexchange. (Déclarations d'Échanges de Biens - D.E.B.) Report RVEXNAID creates a diskette version of the list so that you cansend it to the authorities. Official Data Record Description -> HEADER DATA Data record for first declaration: max. 1 \| Number \| Length \| Category \| Description \| ------------------------------------------------------------------- \| 01 \| 8 \| C \| Nom du Fichier = SAISUNIC \| \| \| \| \| EXTRASTAT \| ------------------------------------------------------------------- \| 02 \| 4 \| C \| Numero notifie par la DNSC \| \| \| \| \| Company number \| ------------------------------------------------------------------- \| 03 \| 2 \| N \| Periode de declaration (MM) \| \| \| \| \| Reference month of declaration \| ------------------------------------------------------------------- \| 04 \| 1 \| N \| Modele de declaration \| \| \| \| \| Declaration type \| \| \| \| \| IMPORT = 1 \| \| \| \| \| EXPORT = 2 \| \| \| \| \| IMPORT+EXPORT = 3 \| ------------------------------------------------------------------- \| 05 \| 1 \| N \| Numero de sequence \| \| \| \| \| File number \| ------------------------------------------------------------------- \| 06 \| 7 \| C \| Filler \| ------------------------------------------------------------------- \| 07 \| 4 \| N \| Date de constitution du fichier \| \| \| \| \| Declaration date \| ------------------------------------------------------------------- \| 08 \| 14 \| N \| SIREN / SIRET \| \| \| \| \| VAT registration number \| ------------------------------------------------------------------- \| 09 \| 20 \| C \| Numero telecopie \| ------------------------------------------------------------------- \| 10 \| 20 \| C \| Numero telephone \| \| \| \| \| Telephone number \| ------------------------------------------------------------------- \| 11 \| 20 \| C \| Nom du correspondant \| \| \| \| \| Contact person \| ------------------------------------------------------------------- \| 12 \| 8 \| C \| Mot de passe \| \| \| \| \| Password \| ------------------------------------------------------------------- \| 13 \| 201 \| C \| Filler/Espace (to adapt the \| \| \| \| \| data record length to v_satz) \| ------------------------------------------------------------------- Individual Data Record -> V_SATZ Data record for import and export; n occurences possiblycumulated \| Number \| Length \| Category \| Description \| --------------------------------------------------------------------- \| 01 \| 22 \| C \| Filler \| --------------------------------------------------------------------- \| 02 \| 4 \| N \| Date D'enregistrement \| \| \| \| \| Declaration date \| --------------------------------------------------------------------- \| 03 \| 6 \| N \| numero de declaration \| \| \| \| \| Declaration number \| --------------------------------------------------------------------- \| 04 \| 6 \| N \| numero de ligne \| \| \| \| \| Record number \| --------------------------------------------------------------------- \| 05 \| 13 \| C \| numero d'assujetti \| \| \| \| \| VAT registration number \| --------------------------------------------------------------------- \| 06 \| 5 \| N \| complement etablissement \| \| \| \| \| Additional number \| --------------------------------------------------------------------- \| 07 \| 5 \| C \| numero d'agrement du commissionaire \| \| \| \| \| en douane \| \| \| \| \| Approval number \| --------------------------------------------------------------------- \| 08 \| 5 \| C \| filler \| --------------------------------------------------------------------- \| 09 \| 14 \| C \| code tva du client etranger \| \| \| \| \| VAT registration number \| --------------------------------------------------------------------- Customers --------------------------------------------------------------------- \| 10 \| 8 \| C \| filler \| --------------------------------------------------------------------- \| 11 \| 1 \| N \| code flux \| \| \| \| \| Goods direction \| \| \| \| \| Import = 1 / Export = 2 \| --------------------------------------------------------------------- \| 12 \| 3 \| C \| filler \| --------------------------------------------------------------------- \| 13 \| 2 \| C \| regime \| \| \| \| \| Procedure \| --------------------------------------------------------------------- \| 14 \| 3 \| C \| filler \| --------------------------------------------------------------------- \| 15 \| 1 \| N \| niveau d'obligation \| \| \| \| \| Obligation level \| --------------------------------------------------------------------- \| 16 \| 8 \| N \| nomenclature \| \| \| \| \| Commodity code \| --------------------------------------------------------------------- \| 17 \| 2 \| C \| filler \| --------------------------------------------------------------------- \| 18 \| 1 \| N \| developpement statistique (NGP) \| \| \| \| \| Statistical development \| --------------------------------------------------------------------- \| 19 \| 33 \| C \| filler \| --------------------------------------------------------------------- \| 20 \| 2 \| C \| departement \| \| \| \| \| Region of origin (export) / \| \| \| \| \| Region of destination (import) \| --------------------------------------------------------------------- \| 21 \| 2 \| N \| nature de la transaction \| \| \| \| \| Business transaction type \| --------------------------------------------------------------------- \| 22 \| 3 \| C \| filler \| --------------------------------------------------------------------- \| 23 \| 4 \| C \| condition de livraison \| \| \| \| \| Terms of delivery: \| \| \| \| \| Incoterms Part 1 \| --------------------------------------------------------------------- \| 24 \| 3 \| N \| pays de provenance \| \| \| \| \| Country of origin \| --------------------------------------------------------------------- \| 25 \| 3 \| N \| pay d'origine à l'introduction ou de \| \| \| \| \| destination finale a l'expedition \| \| \| \| \| Country of origin (import) / \| \| \| \| \| Country of destination (export) \| --------------------------------------------------------------------- \| 26 \| 10 \| C \| filler \| --------------------------------------------------------------------- \| 27 \| 11 \| N \| valeur fiscale \| \| \| \| \| Invoice value \| --------------------------------------------------------------------- \| 28 \| 11 \| N \| valeur statistique de l'article \| \| \| \| \| Statistical value \| \| \| \| \| (value of goods when goods \| \| \| \| \| cross the border) \| --------------------------------------------------------------------- \| 29 \| 10 \| N \| masse nette \| \| \| \| \| Tare mass in KG \| --------------------------------------------------------------------- \| 30 \| 10 \| N \| unites supplementaires \| \| \| \| \| Special unit of measure \| --------------------------------------------------------------------- \| 31 \| 33 \| C \| filler \| --------------------------------------------------------------------- \| 32 \| 1 \| N \| mode de transport a la frontier \| \| \| \| \| Domestic mode of transport \| --------------------------------------------------------------------- \| 33 \| 65 \| C \| filler \| --------------------------------------------------------------------- SAP Source \| Number \| SAP source \| ----------------------------------- \| 01 \| Constant 'SAISUNIC' \| ----------------------------------- \| 02 \| Parameter P_FIRMNR \| ----------------------------------- \| 03 \| Parameter DATUMMON \| ----------------------------------- \| 04 \| Parameter ARRIVDEP \| ----------------------------------- \| 05 \| Parameter P_FOLGNR \| ----------------------------------- \| 06 \| Empty \| ----------------------------------- \| 07 \| SY-DATUM \| ----------------------------------- \| 08 \| VEXAV-EIGENUINR \| ----------------------------------- \| 09 \| SADR-TELFX \| ----------------------------------- \| 10 \| SADR-TELF1 \| ----------------------------------- \| 11 \| Parameter P_ANSPRP \| ----------------------------------- \| 12 \| Parameter P_BETREF \| ----------------------------------- \| 13 \| Empty \| ----------------------------------- \| Number \| SAP source \| ---------------------------------------------------------------------- \| 01 \| Empty \| ---------------------------------------------------------------------- \| 02 \| VEXAV-DATUMMONA + VEXAV-DATUMJAHR \| ---------------------------------------------------------------------- \| 03 \| Parameter P_MELDNR \| ---------------------------------------------------------------------- \| 04 \| Variable SATZNR \| ---------------------------------------------------------------------- \| 05 \| Constant "FR" + VEXAV-EIGENUINR \| ---------------------------------------------------------------------- \| 06 \| VEXAV-FIRMENNUM \| ---------------------------------------------------------------------- \| 07 \| VEXAV-BEWINUMME \| ---------------------------------------------------------------------- \| 08 \| Empty \| ---------------------------------------------------------------------- \| 09 \| VEXAV-PLISO + VEXAV-KUNDEUINR \| ---------------------------------------------------------------------- \| 10 \| Empty \| ---------------------------------------------------------------------- \| 11 \| Parameter ARRIVDEP \| ---------------------------------------------------------------------- \| 12 \| Empty \| ---------------------------------------------------------------------- \| 13 \| VEXAV-VERFAHREN \| ---------------------------------------------------------------------- \| 14 \| Empty \| ---------------------------------------------------------------------- \| 15 \| Parameter P_NIVEAU \| ---------------------------------------------------------------------- \| 16 \| VEXAV-STATWAREN \| ---------------------------------------------------------------------- \| 17 \| Empty \| ---------------------------------------------------------------------- \| 18 \| Empty (optional) \| ---------------------------------------------------------------------- \| 19 \| Empty \| ---------------------------------------------------------------------- \| 20 \| VEXAV-URSPRSREG (export) or VEXAV-BESTIREGI (import) \| ---------------------------------------------------------------------- \| 21 \| VEXAV-ARTGESCHA \| ---------------------------------------------------------------------- \| 22 \| Empty \| ---------------------------------------------------------------------- \| 23 \| VEXAV-LIEFERBED + VEXAV-SPANIENID \| ---------------------------------------------------------------------- \| 24 \| VEXAV-URSPRSLND \| ---------------------------------------------------------------------- \| 25 \| VEXAV-VERSENDLAND (import) or VEXAV-BESTILAND (export) \| ---------------------------------------------------------------------- \| 26 \| Empty \| ---------------------------------------------------------------------- \| 27 \| VEXAV-RECHNWERT \| ---------------------------------------------------------------------- \| 28 \| VEXAV-GRENZWERT \| ---------------------------------------------------------------------- \| 29 \| VEXAV-EIGENMASS \| ---------------------------------------------------------------------- \| 30 \| VEXAV-BESONMASS \| ---------------------------------------------------------------------- \| 31 \| Empty \| ---------------------------------------------------------------------- \| 32 \| VEXAV-INLAIEVER \| ---------------------------------------------------------------------- \| 33 \| Empty \| ---------------------------------------------------------------------- Output When you create a diskette version, you create it on two levels withthe following steps: You create the file from the export and/or import billing documents that you created before. You transfer the file to a diskette or the hard drive of your PC. If you select Issue as log, the system lists the data on the screen. You can also send this data to a printer. If you want the data to be issued as a file, the system creates a file with the name that you assign.

STechno

Programme SAP RVEXDEIF - EXTRASTAT: File Creation for Import/Export - France