SAP VDPOPO File item Table
Overview
VDPOPO is a standard SAP S/4HANA table that stores File item data. There are total 44 fields in the VDPOPO table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDPOPO belongs to Loans Management (FS-CML) module and is located in the package Treasury Loans (FVVD).
In addition, following links provide an overview of foreign key relationships, if any, that link VDPOPO to other SAP tables and standard CDS views available based on VDPOPO table in S/4HANA 2020.
Techincal Settings of VDPOPO
Below are technical details of the table VDPOPO
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDPOPO Fields
The following table gives you an overview of the fields available in VDPOPO
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| STYP | Activity Type | VVSTYP | TDP6 | CHAR | 1 |
| RHORD | Main file ID | VVRHORD | VDHOKO | CHAR | 10 |
| SVYM | Main file version (YYYYMM) | VVSVYM | ACCP | 6 | |
| SVNR | File Version Sequential Number | VVSVNR | * | NUMC | 3 |
| RORD | File name | VVRORD | VDPOKO | CHAR | 4 |
| RPNR | Activity number/rollover number | VVRPNR | NUMC | 8 | |
| RANL | Contract Number | RANL | CHAR | 13 | |
| SREG | Register indicator | VVSREG | TDP1 | CHAR | 2 |
| SLREG | Last register indicator | VVSLREG | TDP1 | CHAR | 2 |
| STBEA | Processing status | VVSTBEA | CHAR | 1 | |
| XDNINFO | Borrower information | VVDNINFO | CHAR | 55 | |
| DOFFAM | Offer creation date | VVDOFFAM | DATS | 8 | |
| DOFFBIS | Offer valid until | VVDOFFBIS | DATS | 8 | |
| DEFSZ | Date of fixed period end | VVDEFSZ | DATS | 8 | |
| DELFZ | End of Term | DELFZ | DATS | 8 | |
| DLSV | Date of last correspondence | VVDLSV | DATS | 8 | |
| PEFFZINS | Effective Interest Rate | PEFFZINS | DEC | 10 | |
| SBWHR | Position Currency (Currency of Position Amount) | SBWHR | * | CUKY | 5 |
| BVKWR | Contract Capital in Position Currency | VVBVKWR | CURR | 15 | |
| BVKW2 | Contract Capital in Alternative Currency | VVBVKW2 | CURR | 15 | |
| BZKWR | Current Commitment Capital in Position Currency | VVBZKWR | CURR | 15 | |
| BZKW2 | Current Commitment Capital in Alternative Currency | VVBZKW2 | CURR | 15 | |
| BRPWR | Rem. Capital Acc. to Debit Position in Position Currency | VVBRPWR | CURR | 15 | |
| BRPW2 | Rem. Capital Acc. to Debit Position in Alternative Currency | VVBRPW2 | CURR | 15 | |
| BRIWR | Effective Capital in Position Currency | VVBRIWR | CURR | 15 | |
| BRIW2 | Effective Capital in Alternative Currency | VVBRIW2 | CURR | 15 | |
| BMIWR | Capital Reduction in Position Currency | VVBMIWR | CURR | 15 | |
| BMIW2 | Capital Reduction in Alternative Currency | VVBMIW2 | CURR | 15 | |
| BATWR | Unsched. Repayment: Debit Position in Position Currency | VVBATSWR | CURR | 15 | |
| BATW2 | Unsched. Repayment: Debit Position in Alternative Currency | VVBATSW2 | CURR | 15 | |
| BATZWR | Unsched. Repayment: Incoming Payments in Position Currency | VVBATZWR | CURR | 15 | |
| BATZW2 | Unscheduled Repayment: Incoming Payments in Altern. Currency | VVBATZW2 | CURR | 15 | |
| BPTWR | Scheduled Repayment: Debit Position in Position Currency | VVBPTSWR | CURR | 15 | |
| BPTW2 | Scheduled Repayment: Debit Position in Alternative Currency | VVBPTSW2 | CURR | 15 | |
| BPTZWR | Scheduled Repayment: Incoming Payment in Position Currency | VVBPTZWR | CURR | 15 | |
| BPTZW2 | Sched. Repayment: Incoming Payment in Alternative Currency | VVBPTZW2 | CURR | 15 | |
| BAVWR | Disbursement Obligation in Position Currency | VVBAVWR | CURR | 15 | |
| BAVW2 | Disbursement Obligation in Alternative Currency | VVBAVW2 | CURR | 15 | |
| BVAWR | Value-Dated Capital in Position Currency | VVBVAWR | CURR | 15 | |
| BVAW2 | Value-Dated Capital in Alternative Currency (Posted Records) | VVBVAW2 | CURR | 15 | |
| TSTAMP | Time stamp | VVTSTAMP | CHAR | 14 | |
| DERFASS | First Entered On | DERF | DATS | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VDPOPO
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDPOPO | BUKRS | 1: CN | T001 |
| VDPOPO | MANDT | 1: CN | T000 |
| VDPOPO | RHORD | 1: CN | VDHOKO |
| VDPOPO | RORD | 1: CN | VDPOKO |
| VDPOPO | SLREG | 1: CN | TDP1 |
| VDPOPO | SREG | 1: CN | TDP1 |
| VDPOPO | STYP | 1: CN | TDP6 |