SAP VDSUBFACILITY Sub-facility data Table
Overview
VDSUBFACILITY is a standard SAP S/4HANA table that stores Sub-facility data data. There are total 9 fields in the VDSUBFACILITY table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDSUBFACILITY belongs to Loans Management (FS-CML) module and is located in the package Package For Facilities (FVVD_FACILITIES).
In addition, following links provide an overview of foreign key relationships, if any, that link VDSUBFACILITY to other SAP tables and standard CDS views available based on VDSUBFACILITY table in S/4HANA 2020.
Techincal Settings of VDSUBFACILITY
Below are technical details of the table VDSUBFACILITY
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDSUBFACILITY Fields
The following table gives you an overview of the fields available in VDSUBFACILITY
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 |
| COMPANY_CODE | Company Code | BUKRS | T001 | CHAR | 4 |
| FACILITY_NUMBER | Contract Number | RANL | VDARL | CHAR | 13 |
| VALID_FROM | Valid-From Date for Subfacility | TB_SUBFACILITY_VALID_FROM | DATS | 8 | |
| LIMIT_AMOUNT | Subfacility Limit Amount | TB_SUBFACILITY_AMOUNT | CURR | 13 | |
| CURRENCY | Currency | SWHR | CUKY | 5 | |
| SUBFACILITY_TEXT | Subfacility Description | TB_FACILITY_SUBFAC_TEXT | CHAR | 50 | |
| DD_PROD_GROUP | Grouping of Drawdown Product Types for Facility | TB_DRAWDOWN_PROD_GROUP | TDDDPRODGROUP | CHAR | 3 |
| RESERVED_AMOUNT | Reserved amount | TB_FACILITY_RES_AMT_CMLCHN | CURR | 13 |
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 VDSUBFACILITY
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDSUBFACILITY | CLIENT | : | T000 |
| VDSUBFACILITY | COMPANY_CODE | : | T001 |
| VDSUBFACILITY | DD_PROD_GROUP | : | TDDDPRODGROUP |
| VDSUBFACILITY | FACILITY_NUMBER | : | VDARL |