- Home
- Resources
- SAP Tables
- VZGPODEB - Tab. VZGPO + customer-relevant data
SAP Table VZGPODEB
Tab. VZGPO + customer-relevant data
VZGPODEB (Tab. VZGPO + customer-relevant data) 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 VZGPODEB to other SAP tables.
Source: VZGPODEB (Tab. VZGPO + customer-relevant data)
VZGPODEB table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
|
CLNT |
|
3 |
0 |
|
| SNUMOBJ |
Key for number range object |
VVNUMOBJ |
|
CHAR |
|
2 |
0 |
Possible values
| VI |
Real Estate |
| VD |
Loans |
| VW |
Securities |
| VO |
Loan collateral object |
| VS |
Loan collateral |
| VB |
Collateral value |
| VN |
Loan interested parties |
|
| SOBJEKT |
Internal key for object for business partner table |
VVSOBJGPO |
|
CHAR |
|
13 |
0 |
|
| PARTNR |
Business Partner Number |
BP_PARTNR |
|
CHAR |
|
10 |
0 |
|
| ROLETYP |
Business Partner Role Category |
BP_ROLETYP |
TPZ3
|
CHAR |
|
4 |
0 |
|
| DTRANS |
Flow data key: System date |
VVDTRANS |
|
DATS |
|
8 |
0 |
|
| DBEBEZ |
Date of start of relationship |
DBEBEZ |
|
DATS |
|
8 |
0 |
|
| DENBEZ |
Date of end of relationship |
DENBEZ |
|
DATS |
|
8 |
0 |
|
| EXTPARTNR |
External Business Partner ID |
BP_EXT_PNR |
|
CHAR |
|
15 |
0 |
|
| XROLETYP |
Name of Role Category |
BP_XROLTYP |
|
CHAR |
|
30 |
0 |
|
| XPARTNER |
Partner/address string |
VVXPAADR |
|
CHAR |
|
60 |
0 |
|
| KUNNR |
Customer Number |
KUNNR |
|
CHAR |
|
10 |
0 |
|
| ROLE |
Business Partner Role Type |
BP_ROLE |
|
CHAR |
|
4 |
0 |
|
| APPL |
Application Category |
BP_APPL |
|
CHAR |
|
4 |
0 |
|
| ADR_REF |
Address ID |
BP_ADR_REF |
|
CHAR |
|
10 |
0 |
|
| PBEZ |
Percentage rate of relationship |
PBEZ |
|
DEC |
|
10 |
7 |
|
| BBEZ |
Relationship amount |
BBEZ |
|
CURR |
|
13 |
2 |
|
| SBBEZ |
Currency Key |
WAERS |
|
CUKY |
|
5 |
0 |
|
| ZLSCH |
Payment Method |
DZLSCH |
|
CHAR |
|
1 |
0 |
|
| BVTYP |
Partner Bank Type |
BVTYP |
|
CHAR |
|
4 |
0 |
|
| MABER |
Dunning Area |
MABER |
|
CHAR |
|
2 |
0 |
|
| SDEBZUSA |
Customer indicator |
KZDEB |
|
CHAR |
|
1 |
0 |
Possible values
|
| KNRZE |
Head office account number (in branch accounts) |
KNRZE |
|
CHAR |
|
10 |
0 |
|
| SANTART |
Type of share in an object in partner role |
VVSANTART |
|
NUMC |
|
2 |
0 |
|
| NAME1 |
Name 1 |
NAME1_GP |
|
CHAR |
|
35 |
0 |
|
| XDEBFI |
Customer transferred from FI |
VVXDEBFI |
|
CHAR |
|
1 |
0 |
Possible values
|
| ROLE_ALLG |
Business Partner Role |
BP_ROLE_G |
|
CHAR |
|
4 |
0 |
|
| XROLE_ALLG |
Description of Role |
BP_XROLE_G |
|
CHAR |
|
30 |
0 |
|
| PAY_DATA_C |
Change payment method or bank cat. |
PAY_DATA_C |
|
CHAR |
|
1 |
0 |
Possible values
|
| SDUNNDOC |
Type of Dunning Letter |
SDUNNDOC |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
No dunning letter |
| O |
Original dunning letter |
| C |
Copy of dunning letter |
|
| SDUNNBUC |
Post Dunning Charges and Interest to This Partner |
SDUNNBUC |
|
CHAR |
|
1 |
0 |
Possible values
|
| LIFNR |
Account Number of Vendor or Creditor |
LIFNR |
|
CHAR |
|
10 |
0 |
|
| LIFBVTYP |
Partner Bank Type |
BVTYP |
|
CHAR |
|
4 |
0 |
|
VZGPODEB foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| VZGPODEB |
ROLETYP |
VZGPODEB |
MANDT |
TPZ3 |
BP: Business Partner - Role Category |
MANDT |
| VZGPODEB |
ROLETYP |
VZGPODEB |
ROLETYP |
TPZ3 |
BP: Business Partner - Role Category |
ROLETYP |
