VMDS_LFB1_S SAP (Company Code Data) Structure details

Dictionary Type: Structure
Description: Company Code Data




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




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

VMDS_LFB1_S 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 "Company Code Data" 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_LFB1_S TYPE VMDS_LFB1_S.

The VMDS_LFB1_S table consists of various fields, each holding specific information or linking keys about Company Code Data data available in SAP. These include MANDT (Client), LIFNR (Account Number of Vendor or Creditor), BUKRS (Company Code), PERNR (Personnel Number).. 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_LFB1_S 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
OLD_DATA 0
MANDTClient MANDTCLNT3MANDT
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10ALPHALIFNRLIFKRED_C
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
ERDATDate on which the Record Was Created ERDAT_RFDATS8DATUM
ERNAMName of Person who Created the Object ERNAM_RFCHAR12USNAM
SPERRPosting block for company code SPERB_BCHAR1XFELD
LOEVMDeletion Flag for Master Record (Company Code Level) LOEVM_BCHAR1XFELD
ZUAWAKey for sorting according to assignment numbers DZUAWACHAR3ZUAWA
AKONTReconciliation Account in General Ledger AKONTCHAR10ALPHASAKNR
BEGRUAuthorization Group BRGRUCHAR4BRGRU
VZSKZInterest calculation indicator VZSKZCHAR2VZSKZ
ZWELSList of the Payment Methods to be Considered DZWELSCHAR10ZWELS
XVERRIndicator: Clearing between customer and vendor? XVERR_LFB1CHAR1XFELD
ZAHLSBlock Key for Payment DZAHLSCHAR1ZAHLS
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
EIKTOOur account number with the vendor EIKTO_KCHAR12CHAR12
ZSABEClerk at vendor DZSABE_KCHAR15TEXT15
KVERMMemo KVERMCHAR30TEXT30
FDGRVPlanning group FDGRVCHAR10ALPHAFDGRP
BUSABAccounting clerk BUSABCHAR2BUSAB
LNRZEHead office account number LNRZECHAR10ALPHALIFNR
LNRZBAccount number of the alternative payee LNRZBCHAR10ALPHALIFNR
ZINDTKey date of the last interest calculation DZINDTDATS8DATUM
ZINRTInterest calculation frequency in months DZINRTNUMC2ZINRT
DATLZDate of the last interest calculation run DATLZDATS8DATUM
XDEZVIndicator: Local processing? XDEZVCHAR1XFELD
WEBTRBill of exchange limit (in local currency) WEBTRCURR13(2) WERT7
KULTGProbable time until check is paid KULTGDEC3PACK2
REPRFCheck Flag for Double Invoices or Credit Memos REPRFCHAR1XFELD
TOGRUTolerance group for the business partner/G/L account TOGRUCHAR4TOGRU
HBKIDShort Key for a House Bank HBKIDCHAR5HBKID
XPOREIndicator: Pay all items separately ? XPORECHAR1XFELD
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
QSZDTValidity Date for Withholding Tax Exemption Certificate QSZDTDATS8DATUM
QSSKZWithholding Tax Code QSSKZCHAR2QSSKZ
BLNKZSubsidy indicator for determining the reduction rates BLNKZCHAR2BLNKZ
MINDKMinority Indicators MINDKCHAR3MINDK
ALTKNPrevious Master Record Number ALTKNCHAR10CHAR10
ZGRUPKey for Payment Grouping DZGRUPCHAR2ZGRUP
MGRUPKey for dunning notice grouping MGRUPCHAR2MGRUP
UZAWEPayment Method Supplement UZAWECHAR2UZAWE
QSRECVendor Recipient Type QSRECCHAR2QSREC
QSBGRAuthority for Exemption from Withholding Tax QSBGRCHAR1QSBGR
QLANDWithholding Tax Country Key QLANDCHAR3QLAND
XEDIPIndicator: Send Payment Advices by EDI XEDIPCHAR1XFELD
FRGRPRelease Approval Group FRGRPCHAR4FRGRP
TOGRRTolerance group; Invoice Verification TOGRRCHAR4TOGRR
TLFXSAccounting clerk's fax number at the customer/vendor TLFXSCHAR31TEXT31
INTADInternet address of partner company clerk INTADCHAR130TXT130
XLFZBIndicator: Alternative payee using account number XLFZBCHAR1XFELD
GUZTEPayment Terms Key for Credit Memos GUZTECHAR4ZTERM
GRICDActivity Code for Gross Income Tax J_1AGICD_DCHAR2J_1AGICD2
GRIDTDistribution Type for Employment Tax J_1ADTYP_DCHAR2J_1ADTYP
XAUSZIndicator for periodic account statements XAUSZCHAR1AUSZG
CERDTCertification date CERDTDATS8DATUM
CONFSStatus of Change Authorization (Company Code Level) CONFS_BCHAR1CHAR1
UPDATDate on Which the Changes Were Confirmed UPDAT_RFDATS8DATUM
UPTIMTime of Last Change Confirmation UPTIM_RFTIMS6AS4TIME
NODELDeletion bock for master record (company code level) NODEL_BCHAR1XFELD
TLFNSAccounting clerk's telephone number at business partner TLFNSCHAR30CHAR30
AVSNDIndicator: Send Payment Advice by XML AVSNDCHAR1AVSND
AD_HASHE-Mail Address for Avis: Hash Value ADHASHCHAR10ADHASH
.INCLU--AP 0
J_SC_SUBCONTYPESubcontractor Type /SAPNEA/J_SC_SUBCONTYPECHAR1/SAPNEA/J_SC_SUBCONTYPE
J_SC_COMPDATECompletion Date Of Inspection /SAPNEA/J_SC_COMPLETIONDATENUMC3/SAPNEA/J_SC_COMPLETIONDATE
J_SC_OFFSMOffset Method /SAPNEA/J_SC_OFFSMCHAR1/SAPNEA/J_SC_OFFSM
J_SC_OFFSROffset Percentage /SAPNEA/J_SC_OFFSRNUMC3/SAPNEA/J_SC_OFFSR
.INCLU--AP 0
BASIS_PNTAverage daily basis points for purchase cards FMBASIS_POINTSDEC6(3) FMBASIS_POINTS
.INCLU--AP 0
GMVKZKVendor is in execution GMVKZKCHAR1XFELD
.INCLU--AP 0
PREPAY_RELEVANTPrepayment Relevance (Vendor Master) WRF_PREPAY_RELEVANTCHAR1WRF_PREPAY_RELEVANT
ASSIGN_TESTAssignment Test Group WRF_MRM_ASSIGN_GROUPCHAR4WRF_MRM_ASSIGN_GROUP
NEW_DATA 0
MANDTClient MANDTCLNT3MANDT
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10ALPHALIFNRLIFKRED_C
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
ERDATDate on which the Record Was Created ERDAT_RFDATS8DATUM
ERNAMName of Person who Created the Object ERNAM_RFCHAR12USNAM
SPERRPosting block for company code SPERB_BCHAR1XFELD
LOEVMDeletion Flag for Master Record (Company Code Level) LOEVM_BCHAR1XFELD
ZUAWAKey for sorting according to assignment numbers DZUAWACHAR3ZUAWA
AKONTReconciliation Account in General Ledger AKONTCHAR10ALPHASAKNR
BEGRUAuthorization Group BRGRUCHAR4BRGRU
VZSKZInterest calculation indicator VZSKZCHAR2VZSKZ
ZWELSList of the Payment Methods to be Considered DZWELSCHAR10ZWELS
XVERRIndicator: Clearing between customer and vendor? XVERR_LFB1CHAR1XFELD
ZAHLSBlock Key for Payment DZAHLSCHAR1ZAHLS
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
EIKTOOur account number with the vendor EIKTO_KCHAR12CHAR12
ZSABEClerk at vendor DZSABE_KCHAR15TEXT15
KVERMMemo KVERMCHAR30TEXT30
FDGRVPlanning group FDGRVCHAR10ALPHAFDGRP
BUSABAccounting clerk BUSABCHAR2BUSAB
LNRZEHead office account number LNRZECHAR10ALPHALIFNR
LNRZBAccount number of the alternative payee LNRZBCHAR10ALPHALIFNR
ZINDTKey date of the last interest calculation DZINDTDATS8DATUM
ZINRTInterest calculation frequency in months DZINRTNUMC2ZINRT
DATLZDate of the last interest calculation run DATLZDATS8DATUM
XDEZVIndicator: Local processing? XDEZVCHAR1XFELD
WEBTRBill of exchange limit (in local currency) WEBTRCURR13(2) WERT7
KULTGProbable time until check is paid KULTGDEC3PACK2
REPRFCheck Flag for Double Invoices or Credit Memos REPRFCHAR1XFELD
TOGRUTolerance group for the business partner/G/L account TOGRUCHAR4TOGRU
HBKIDShort Key for a House Bank HBKIDCHAR5HBKID
XPOREIndicator: Pay all items separately ? XPORECHAR1XFELD
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
QSZDTValidity Date for Withholding Tax Exemption Certificate QSZDTDATS8DATUM
QSSKZWithholding Tax Code QSSKZCHAR2QSSKZ
BLNKZSubsidy indicator for determining the reduction rates BLNKZCHAR2BLNKZ
MINDKMinority Indicators MINDKCHAR3MINDK
ALTKNPrevious Master Record Number ALTKNCHAR10CHAR10
ZGRUPKey for Payment Grouping DZGRUPCHAR2ZGRUP
MGRUPKey for dunning notice grouping MGRUPCHAR2MGRUP
UZAWEPayment Method Supplement UZAWECHAR2UZAWE
QSRECVendor Recipient Type QSRECCHAR2QSREC
QSBGRAuthority for Exemption from Withholding Tax QSBGRCHAR1QSBGR
QLANDWithholding Tax Country Key QLANDCHAR3QLAND
XEDIPIndicator: Send Payment Advices by EDI XEDIPCHAR1XFELD
FRGRPRelease Approval Group FRGRPCHAR4FRGRP
TOGRRTolerance group; Invoice Verification TOGRRCHAR4TOGRR
TLFXSAccounting clerk's fax number at the customer/vendor TLFXSCHAR31TEXT31
INTADInternet address of partner company clerk INTADCHAR130TXT130
XLFZBIndicator: Alternative payee using account number XLFZBCHAR1XFELD
GUZTEPayment Terms Key for Credit Memos GUZTECHAR4ZTERM
GRICDActivity Code for Gross Income Tax J_1AGICD_DCHAR2J_1AGICD2
GRIDTDistribution Type for Employment Tax J_1ADTYP_DCHAR2J_1ADTYP
XAUSZIndicator for periodic account statements XAUSZCHAR1AUSZG
CERDTCertification date CERDTDATS8DATUM
CONFSStatus of Change Authorization (Company Code Level) CONFS_BCHAR1CHAR1
UPDATDate on Which the Changes Were Confirmed UPDAT_RFDATS8DATUM
UPTIMTime of Last Change Confirmation UPTIM_RFTIMS6AS4TIME
NODELDeletion bock for master record (company code level) NODEL_BCHAR1XFELD
TLFNSAccounting clerk's telephone number at business partner TLFNSCHAR30CHAR30
AVSNDIndicator: Send Payment Advice by XML AVSNDCHAR1AVSND
AD_HASHE-Mail Address for Avis: Hash Value ADHASHCHAR10ADHASH
.INCLU--AP 0
J_SC_SUBCONTYPESubcontractor Type /SAPNEA/J_SC_SUBCONTYPECHAR1/SAPNEA/J_SC_SUBCONTYPE
J_SC_COMPDATECompletion Date Of Inspection /SAPNEA/J_SC_COMPLETIONDATENUMC3/SAPNEA/J_SC_COMPLETIONDATE
J_SC_OFFSMOffset Method /SAPNEA/J_SC_OFFSMCHAR1/SAPNEA/J_SC_OFFSM
J_SC_OFFSROffset Percentage /SAPNEA/J_SC_OFFSRNUMC3/SAPNEA/J_SC_OFFSR
.INCLU--AP 0
BASIS_PNTAverage daily basis points for purchase cards FMBASIS_POINTSDEC6(3) FMBASIS_POINTS
.INCLU--AP 0
GMVKZKVendor is in execution GMVKZKCHAR1XFELD
.INCLU--AP 0
PREPAY_RELEVANTPrepayment Relevance (Vendor Master) WRF_PREPAY_RELEVANTCHAR1WRF_PREPAY_RELEVANT
ASSIGN_TESTAssignment Test Group WRF_MRM_ASSIGN_GROUPCHAR4WRF_MRM_ASSIGN_GROUP
UPDSingle-Character Indicator CHAR1CHAR1CHAR1

Key field Non-key field



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

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

How to access SAP table VMDS_LFB1_S

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