VMDS_EI_EXTRACT SAP (Complex Internal Interface for Vendors) Structure details

Dictionary Type: Structure
Description: Complex Internal Interface for Vendors




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




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

VMDS_EI_EXTRACT 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 "Complex Internal Interface for Vendors" 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_VMDS_EI_EXTRACT TYPE VMDS_EI_EXTRACT.

The VMDS_EI_EXTRACT table consists of various fields, each holding specific information or linking keys about Complex Internal Interface for Vendors data available in SAP. These include LFA1 (), MANDT (Client), LIFNR (Account Number of Vendor or Creditor), LAND1 (Country Key).. 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 (Deep)


SAP VMDS_EI_EXTRACT 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
LFA1 0
MANDTClient MANDTCLNT3Assigned to domainMANDT
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10ALPHALIFNRLIFKRED_C
LAND1Country Key LAND1_GPCHAR3LAND1C_LAND1
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
NAME3Name 3 NAME3_GPCHAR35NAME
NAME4Name 4 NAME4_GPCHAR35NAME
ORT01City ORT01_GPCHAR35TEXT35
ORT02District ORT02_GPCHAR35TEXT35
PFACHPO Box PFACHCHAR10PFACH
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
PSTLZPostal Code PSTLZCHAR10PSTLZ
REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
SORTLSort field SORTLCHAR10CHAR10
STRASHouse number and street STRAS_GPCHAR35TEXT35
ADRNRAddress ADRNRCHAR10Assigned to domainALPHAADRNR
MCOD1Search term for matchcode search MCDK1CHAR25CHAR25
MCOD2Search term for matchcode search MCDK2CHAR25CHAR25
MCOD3Search term for matchcode search MCDK3CHAR25CHAR25
ANREDTitle ANREDCHAR15TEXT15
BAHNSTrain station BAHNSCHAR25BAHNH
BBBNRInternational location number (part 1) BBBNRNUMC7NUM07
BBSNRInternational location number (Part 2) BBSNRNUMC5NUM05
BEGRUAuthorization Group BRGRUCHAR4Assigned to domainBRGRU
BRSCHIndustry key BRSCHCHAR4Assigned to domainBRSCH
BUBKZCheck digit for the international location number BUBKZNUMC1NUM01
DATLTData communication line no. DATLTCHAR14TEXT14
DTAMSIndicator for Data Medium Exchange DTAMSCHAR1DTAMS
DTAWSInstruction key for data medium exchange DTAWSCHAR2Assigned to domainDTAWS
ERDATDate on which the Record Was Created ERDAT_RFDATS8DATUM
ERNAMName of Person who Created the Object ERNAM_RFCHAR12USNAM
ESRNRISR Subscriber Number ESRNRCHAR11ESRNR
KONZSGroup key KONZSCHAR10KONZS
KTOKKVendor account group KTOKKCHAR4Assigned to domainKTOKKKGK
KUNNRCustomer Numbers KUNNRCHAR10ALPHAKUNNRKUNC_KUNNR
LNRZAAccount Number of the Alternative Payee LNRZACHAR10Assigned to domainALPHALIFNR
LOEVMCentral Deletion Flag for Master Record LOEVM_XCHAR1XFELD
SPERRCentral posting block SPERB_XCHAR1XFELD
SPERMCentrally imposed purchasing block SPERM_XCHAR1XFELD
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
STCD1Tax Number 1 STCD1CHAR16STCD1
STCD2Tax Number 2 STCD2CHAR11STCD2
STKZAIndicator: Business Partner Subject to Equalization Tax? STKZACHAR1STKZA
STKZULiable for VAT STKZUCHAR1XFELD
TELBXTelebox number TELBXCHAR15TEXT15
TELF1First telephone number TELF1CHAR16TEXT16
TELF2Second telephone number TELF2CHAR16TEXT16
TELFXFax Number TELFXCHAR31TEXT31
TELTXTeletex number TELTXCHAR30TEXT30
TELX1Telex number TELX1CHAR30TEXT30
XCPDKIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
XZEMPIndicator: Alternative payee in document allowed ? XZEMPCHAR1XFELD
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
FISKNAccount number of the master record with fiscal address FISKN_KCHAR10Assigned to domainALPHALIFNR
STCEGVAT Registration Number STCEGCHAR20STCEG
STKZNNatural Person STKZNCHAR1STKZN
SPERQFunction That Will Be Blocked QSPERRFKTCHAR2Assigned to domainQSPERRFKT
GBORTPlace of birth of the person subject to withholding tax GBORT_QCHAR25TEXT25
GBDATDate of birth of the person subject to withholding tax GBDAT_QDATS8DATUM
SEXKZKey for the Sex of the Person Subject to Withholding Tax SEXKZCHAR1SEXKZ
KRAUSCredit information number KRAUS_CMCHAR11CHAR11
REVDBLast review (external) REVDB_CMDATS8DATUM
QSSYSVendor's QM system QSSYS_ISTCHAR4Assigned to domainQSSYSFAM
KTOCKReference Account Group for One-Time Account (Vendor) KTOCKCHAR4Assigned to domainKTOKK
PFORTPO Box city PFORT_GPCHAR35TEXT35
WERKSPlant (Own or External) WERKS_EXTCHAR4WERKSWRKSH_T001W_EXTS
LTSNAIndicator: vendor sub-range relevant LTSNACHAR1XFELD
WERKRIndicator: plant level relevant WERKRCHAR1XFELD
PLKALFactory calendar key FABKLCHAR2Assigned to domainWFCID
DUEFLStatus of Data Transfer into Subsequent Release DUEFL_BKPFCHAR1DUEFL_BKPF
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
SPERZPayment Block SPERZCHAR1XFELD
SCACDStandard carrier access code SCACDCHAR4SCACD
SFRGRForwarding agent freight group SFRGRCHAR4Assigned to domainSFRGR
LZONETransportation zone to or from which the goods are delivered LZONECHAR10Assigned to domainZONE
XLFZAIndicator: Alternative payee using account number XLFZACHAR1XFELD
DLGRPService agent procedure group DLGRPCHAR4Assigned to domainDLGRP
FITYPTax type J_1AFITP_DCHAR2Assigned to domainJ_1AFITP
STCDTTax Number Type J_1ATOIDCHAR2Assigned to domainJ_1ATOID
REGSSRegistered for Social Insurance J_1AREGSSCHAR1XFELD
ACTSSActivity Code for Social Insurance J_1AACTSSCHAR3Assigned to domainJ_1AACTSS
STCD3Tax Number 3 STCD3CHAR18CHAR18
STCD4Tax Number 4 STCD4CHAR18CHAR18
STCD5Tax Number 5 STCD5CHAR60CHAR60
IPISPTax Split J_1BINDEQUCHAR1XFELD
TAXBSTax Base in Percentage TAXBSNUMC1TAXBS
PROFSProfession PROFSCHAR30TEXT30
STGDLShipment: statistics group, transportation service agent STGDLCHAR2Assigned to domainSTGDL
EMNFRExternal manufacturer code name or number EMNFRCHAR10CHAR10
LFURLUniform Resource Locator URLCHAR132TEXT132
J_1KFREPREName of Representative REPRESCHAR10REPRES
J_1KFTBUSType of Business GESTYPCHAR30Assigned to domainGESTYP
J_1KFTINDType of Industry INDTYPCHAR30Assigned to domainINDTYP
CONFSStatus of Change Authorization (Central) CONFS_XCHAR1CHAR1
UPDATDate on Which the Changes Were Confirmed UPDAT_RFDATS8DATUM
UPTIMTime of Last Change Confirmation UPTIM_RFTIMS6AS4TIME
NODELCentral deletion block for master record NODEL_XCHAR1XFELD
QSSYSDATValidity date of certification QQSSYSDATDATS8QQSSYSDAT
PODKZBVendor indicator relevant for proof of delivery PODKZBCHAR1PODKZB
FISKUAccount Number of Master Record of Tax Office Responsible FISKUCHAR10Assigned to domainALPHALIFNR
STENRTax Number at Responsible Tax Authority STENRCHAR18CHAR18
CARRIER_CONFCarrier confirmation is expected /SPE/CARRIER_CNFCHAR1/SPE/CARRIER_CONF
MIN_COMPMicro company indicator J_1BMICRO_COMPCHAR1XFELD
TERM_LITerms of Liability J_1BTERMS_LIABCHAR1XFELD
CRC_NUMCRC number J_1BCRC_NUMCHAR25CHAR25
RGRG Number J_1BRGCHAR11J_1BRG
EXPIssued by J_1BEXPCHAR3J_1BEXP
UFState J_1BUFCHAR2J_1BUF
RGDATERG Issue Date J_1BRGDATEDATS8DATUM
RICRIC Number J_1BRICNUMC11J_1BRIC
RNEForeign National Registration J_1BRNECHAR10J_1BRNE
RNEDATERNE Issue Date J_1BRNEDATEDATS8DATUM
CNAECNAE J_1BCNAECHAR7Assigned to domainJ_1BCNAE
LEGALNATLegal Nature J_1BLEGALNATNUMC4Assigned to domainJ_1BLEGALNAT
CRTNCRT Number J_1BCRTNCHAR1J_1BCRTN
ICMSTAXPAYICMS Taxpayer J_1BICMSTAXPAYCHAR2Assigned to domainJ_1BICMSTAXPAY
INDTYPIndustry Main Type J_1BINDTYPCHAR2Assigned to domainJ_1BINDTYP
TDTTax Declaration Type J_1BTDTCHAR2Assigned to domainJ_1BTDT
COMSIZECompany Size J_1BCOMSIZECHAR2Assigned to domainJ_1BCOMSIZE
DECREGPCDeclaration Regimen for PIS/COFINS J_1BDECREGPCCHAR2Assigned to domainJ_1BDECREGPC
.INCLU--AP 0
DUNSP4DUNS+4 number (the last four digit) /SAPHT/RN_DUNSP4CHAR4CHAR4
.INCLU--AP 0
J_SC_CAPITALCapital Amount /SAPNEA/J_SC_CAPITALCURR15(2) /SAPNEA/J_SC_CAPITAL
J_SC_CURRENCYCurrency /SAPNEA/J_SC_CURRENCYCUKY5Assigned to domainWAERS
.INCLU--AP 0
ALCAgency Location Code FMFG_ALCCHAR8Assigned to domainFMFG_ALCFMFG_ALC
PMT_OFFICEPayment Office FMFG_PMT_OFFCHAR5Assigned to domainFMFG_PMT_OFFFMFG_PMT_OFFICE
PPA_RELEVANTVendor is PPA relevant FMFG_PPA_RELEVANTCHAR1XFELD
.INCLU--AP 0
PSOFGProcessor group PSOFGCHAR10Assigned to domainPSOFG
PSOISSubledger acct preprocessing procedure PSOISCHAR20CHAR20
PSON1Name 1 NAME1_GPCHAR35NAME
PSON2Name 2 NAME2_GPCHAR35NAME
PSON3Name 3 NAME3_GPCHAR35NAME
PSOVNFirst Name PSOVNCHAR35NAME
PSOTLTitle PSOTLCHAR20FMPSOTL
PSOHSHouse number: is no longer used from Release 4.6B PSOHSCHAR6CHAR06
PSOSTStreet: No longer used from Release 4.6B PSOSTCHAR28PSOST
.INCLU--AP 0
BORGR_DATUNDate Limit for External Document Identification BORGR_DATUNDATS8DATE
BORGR_YEAUNAnnual Repetition of Date Limit BORGR_YEAUNCHAR1XFELD
.INCLU--AP 0
TRANSPORT_CHAINTransportation Chain WRF_PSCD_TC_IDCHAR10WRF_PSCD_TC_ID
STAGING_TIMEStaging Time in Days WRF_PSCD_MSTDEC3WRF_PSCD_MST
SCHEDULING_TYPEScheduling Procedure WRF_PSCD_SCHED_TYPECHAR1WRF_PSCD_SCHED_TYPE
SUBMI_RELEVANTCross Docking: Relevant for Collective Numbering WRF_SUBMI_RELEVANTCHAR1XFELD
.INCLU--AP 0
PERREF 0
RATING 0
MOBILE 0
LFAS 0
LFAT 0
LFBK 0
LFA1_TEXT 0
IBAN 0
KNVK 0
WYT1 0
WYT1T 0
LFB1 0
LFB5 0
LFBW 0
LFB1_TEXT 0
LFM1 0
WYT3 0
LFM1_TEXT 0
LFM2 0
T1_ADRC 0
T1_ADR2 0
T1_ADR3 0
T1_ADR4 0
T1_ADR5 0
T1_ADR6 0
T1_ADR7 0
T1_ADR8 0
T1_ADR9 0
T1_ADR10 0
T1_ADR11 0
T1_ADR12 0
T1_ADR13 0
T1_ADRCT 0
T1_ADRT 0
T2_ADRC 0
T2_ADRP 0
T2_ADR2 0
T2_ADR3 0
T2_ADR4 0
T2_ADR5 0
T2_ADR6 0
T2_ADR7 0
T2_ADR8 0
T2_ADR9 0
T2_ADR10 0
T2_ADR11 0
T2_ADR12 0
T2_ADR13 0
T2_ADRCT 0
T2_ADRT 0
T3_ADCP 0
T3_ADRP 0
T3_ADRC 0
T3_ADR2 0
T3_ADR3 0
T3_ADR4 0
T3_ADR5 0
T3_ADR6 0
T3_ADR7 0
T3_ADR8 0
T3_ADR9 0
T3_ADR10 0
T3_ADR11 0
T3_ADR12 0
T3_ADR13 0
T3_ADRT 0

Key field Non-key field



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

As VMDS_EI_EXTRACT 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 VMDS_EI_EXTRACT as there is no data to select.

How to access SAP table VMDS_EI_EXTRACT

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