1. Home
  2. Resources
  3. SAP Tables
  4. VFLAFGVD - Foreign Trade: PRE: Communication Structure SAPscript

SAP Table VFLAFGVD

Foreign Trade: PRE: Communication Structure SAPscript

VFLAFGVD (Foreign Trade: PRE: Communication Structure SAPscript) 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 VFLAFGVD to other SAP tables.

VFLAFGVD table fields

Field Data element Checktable Datatype Length Decimals
O_NAME1 Name 1 AD_NAME1 CHAR 40 0
O_NAME2 Name 2 AD_NAME2 CHAR 40 0
O_STREET Street AD_STREET CHAR 60 0
O_POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
O_CITY1 City AD_CITY1 CHAR 40 0
LANDX Text Field TEXT50 CHAR 50 0
DATHI Date DATUM DATS 8 0
DATLO Date DATUM DATS 8 0
L_NAME1 Name 1 AD_NAME1 CHAR 40 0
L_STREET Street AD_STREET CHAR 60 0
L_POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
L_CITY1 City AD_CITY1 CHAR 40 0
L_LANDX Country Name LANDX CHAR 15 0
MATNR Material Number MATNR CHAR 18 0
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
STAWN Commodity Code/Import Code Number for Foreign Trade STAWN CHAR 17 0
IDNLF Material Number Used by Vendor IDNLF CHAR 35 0
LAND1 Country of origin of the material HERKL CHAR 3 0
LANDA Alternative Country Key LANDA CHAR 3 0
INTCA Country ISO code INTCA CHAR 2 0
GZOLX Preference zone GZOLX CHAR 4 0
BEZEI30 Description BEZEI30 CHAR 30 0
TXNAM_ANF Text name of the vendor declaration request TXNAM_ANF CHAR 70 0
TXNAM_RHM Outline text name for vendor declarations TXNAM_RHM CHAR 70 0
LANGU Language Key LANGU LANG 1 0
DATUM Date DATUM DATS 8 0
LINES1 Counter NUM03 NUMC 3 0
MANCO_FIRST Preference: Dunning ID MANCO NUMC 1 0
0 Not yet dunned
1 First dunning level: Request vendor declaration
2 Second dunning level: Create 1st dunning vendor declaration
3 Third dunning level: Create 2nd dunning vendor declaration
4 Forth dunning level: Create 3rd dunning vendor declaration
5 Fifth dunning level: Create 4th dunning vendor declaration
6 Sixth dunning level: Create 5th dunning vendor declaration
7 Seventh dunning level: Create 6th dunning vendor declaration
8 Eighth dunning level: Create 7th dunning vendor declaration
9 Ninth dunning level: Create 8th dunning vendor declaration
MANCO_LIST Preference: Dunning ID MANCO NUMC 1 0
0 Not yet dunned
1 First dunning level: Request vendor declaration
2 Second dunning level: Create 1st dunning vendor declaration
3 Third dunning level: Create 2nd dunning vendor declaration
4 Forth dunning level: Create 3rd dunning vendor declaration
5 Fifth dunning level: Create 4th dunning vendor declaration
6 Sixth dunning level: Create 5th dunning vendor declaration
7 Seventh dunning level: Create 6th dunning vendor declaration
8 Eighth dunning level: Create 7th dunning vendor declaration
9 Ninth dunning level: Create 8th dunning vendor declaration
TITLE_P Form-of-Address Key AD_TITLE CHAR 4 0
NAME_FIRST First name AD_NAMEFIR CHAR 40 0
NAME_LAST Last name AD_NAMELAS CHAR 40 0
DEPARTMENT Department AD_DPRTMNT CHAR 40 0
TEL_NUMBER First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
TEL_EXTENS First Telephone No.: Extension AD_TLXTNS1 CHAR 10 0
FAX_NUMBER First fax no.: dialling code+number AD_FXNMBR1 CHAR 30 0
FAX_EXTENS First fax no.: extension AD_FXXTNS1 CHAR 10 0
NAME_TEXT Full Name of Person AD_NAMTEXT CHAR 80 0
PRENE Indicator: Vendor declaration exists PRENE CHAR 1 0
A Not checked
B Checked: OK
C Checked: Long-term declaration exists
D Checked: Not OK
PRENG Validity date of vendor declaration PRENG DATS 8 0
KDMAT Material belonging to the customer KDMAT CHAR 35 0
KDPTX Customer description of material KDPTX CHAR 40 0
PRENE_KTXT Foreign Trade: PRE: Vendor Declaration: ALV PRENE_KTXT CHAR 60 0
ZONES Text length 300 TEXT300 CHAR 300 0
PRENG_TXT 17-Char. Field CHAR17 CHAR 17 0
WERKSLAND Declaration to authorities: Country of Plant WERKSLAND CHAR 3 0
L_TITLE Form-of-Address Key AD_TITLE CHAR 4 0
L_NAME2 Name 2 AD_NAME2 CHAR 40 0
L_NAME3 Name 3 AD_NAME3 CHAR 40 0
L_NAME4 Name 4 AD_NAME4 CHAR 40 0
L_NAMETXT Converted name field (with form of address) AD_NAMETXT CHAR 50 0
L_CITY2 District AD_CITY2 CHAR 40 0
L_REGIOGROUP Regional structure grouping REGIOGROUP CHAR 8 0
L_POST_CODE2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
L_POST_CODE3 Company Postal Code (for Large Customers) AD_PSTCD3 CHAR 10 0
L_PST1XT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XT CHAR 10 0
L_PST2XT (Not Supported) PO Box Postal Code Extension AD_PST2XT CHAR 10 0
L_PST3XT (Not Supported) Major Customer Postal Code Extension AD_PST3XT CHAR 10 0
L_POBX PO Box AD_POBX CHAR 10 0
L_POBXLOC PO Box city AD_POBXLOC CHAR 40 0
L_POBXREG Region for PO Box (Country, State, Province, ...) AD_POBXREG CHAR 3 0
L_POBXCTY PO box country AD_POBXCTY CHAR 3 0
L_TLNMBR1 First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
L_TLXTNS1 First Telephone No.: Extension AD_TLXTNS1 CHAR 10 0
L_FXNMBR1 First fax no.: dialling code+number AD_FXNMBR1 CHAR 30 0
L_FXXTNS1 First fax no.: extension AD_FXXTNS1 CHAR 10 0
O_LAND1 Country Key LAND1 CHAR 3 0
L_HOUSE_NUM1 House Number AD_HSNM1 CHAR 10 0
L_HOUSE_NUM2 House number supplement AD_HSNM2 CHAR 10 0
L_HOUSE_NUM3 (Not supported) House Number Range AD_HSNM3 CHAR 10 0
O_HOUSE_NUM1 House Number AD_HSNM1 CHAR 10 0
O_HOUSE_NUM2 House number supplement AD_HSNM2 CHAR 10 0
O_HOUSE_NUM3 (Not supported) House Number Range AD_HSNM3 CHAR 10 0
O_POST_CODE2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
O_POST_CODE3 Company Postal Code (for Large Customers) AD_PSTCD3 CHAR 10 0
O_PST1XT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XT CHAR 10 0
O_PST2XT (Not Supported) PO Box Postal Code Extension AD_PST2XT CHAR 10 0
O_PST3XT (Not Supported) Major Customer Postal Code Extension AD_PST3XT CHAR 10 0
O_POBX PO Box AD_POBX CHAR 10 0
O_POBXLOC PO Box city AD_POBXLOC CHAR 40 0
O_POBXREG Region for PO Box (Country, State, Province, ...) AD_POBXREG CHAR 3 0
O_POBXCTY PO box country AD_POBXCTY CHAR 3 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
LIFNR_LIST Account Number of Vendor or Creditor LIFNR CHAR 10 0
KUNNR Customer Number KUNNR CHAR 10 0
KUNNR_LIST Customer Number KUNNR CHAR 10 0
FUNCTION Function AD_FNCTN CHAR 40 0