1. Home
  2. Resources
  3. SAP Tables
  4. VDBED - Selection conditions for loans

SAP Table VDBED

Selection conditions for loans

VDBED (Selection conditions for loans) 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 VDBED to other SAP tables.

VDBED table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
SNBNR Condition number VVSNBNR NUMC 8 0
SNBPOS Item Number VVSNBPOS NUMC 4 0
SNZBED Additional condition number VVSNZBED NUMC 4 0
NFELD Field number of a logical field VVNFELD NUMC 6 0
XLOW Field value "From" VVXLOW CHAR 45 0
XHIGH Field value "Upto" VVXHIGH CHAR 45 0
SOPT Selection Option VVSOPT CHAR 2 0
EQ Equal: Single value
NE Not Equal: Everything apart from the specified single value
BT Between: Range of values
NB Not Between: Everything outside the range
LE Less or Equal: Everything <= value in field LOW
GT Greater Than: Everything > value in field LOW
GE Greater or Equal >= value in field LOW
LT Less Than: Everything < value in field LOW
CP Contains Pattern: Masked input: Find pattern
NP Not Contains Pattern: Masked input: Reject pattern
SSIGN Selection sign VVSSIGN CHAR 1 0
I Select specified values
E Exclude specified values

VDBED foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VDBED BUKRS VDBED MANDT T001 Company Codes MANDT
VDBED BUKRS VDBED BUKRS T001 Company Codes BUKRS
VDBED MANDT VDBED MANDT T000 Clients MANDT