SAP VSRSADD_CN Version: Additional fields for reservation Table
Overview
VSRSADD_CN is a standard SAP S/4HANA table that stores Version: Additional fields for reservation data. There are total 40 fields in the VSRSADD_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VSRSADD_CN belongs to Simulation (PS-SIM) module and is located in the package R/3 Application development: Version Management (CNVS).
In addition, following links provide an overview of foreign key relationships, if any, that link VSRSADD_CN to other SAP tables and standard CDS views available based on VSRSADD_CN table in S/4HANA 2020.
Techincal Settings of VSRSADD_CN
Below are technical details of the table VSRSADD_CN
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VSRSADD_CN Fields
The following table gives you an overview of the fields available in VSRSADD_CN
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| VSNMR | Number or description of a version | VSNMR | CHAR | 12 | |
| RSNUM | Number of reservation/dependent requirements | RSNUM | NUMC | 10 | |
| RSPOS | Item Number of Reservation / Dependent Requirements | RSPOS | NUMC | 4 | |
| RSART | Record type | RSART | CHAR | 1 | |
| AFNAM | Name of requisitioner/requester | AFNAM | CHAR | 12 | |
| BEDNR | Requirement Tracking Number | BEDNR | CHAR | 10 | |
| KZFIX | Data of Purchasing Info Record Is Fixed | CN_KZFIX | CHAR | 1 | |
| KUNNR | Customer | EKUNNR | * | CHAR | 10 |
| EMLIF | Supplier to be Supplied/Who is to Receive Delivery | EMLIF | * | CHAR | 10 |
| ADRN2 | Address Number | AD_ADDRNUM | * | CHAR | 10 |
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | * | NUMC | 12 |
| KLVAR | Costing Variant | CK_KLVAR | * | CHAR | 4 |
| WKURS | Exchange Rate | WKURS | DEC | 9 | |
| RSCOMP | Spare Part Indicator | RSCOMP | CHAR | 1 | |
| MFLIC | Procurement indicator | CN_MFLIC | TCNMF | CHAR | 3 |
| FPLNR | Billing plan number / invoicing plan number | FPLNR | * | CHAR | 10 |
| FLIEF | Fixed vendor | FLIEF | * | CHAR | 10 |
| BSTLN | Bill of Material | STNUM | CHAR | 8 | |
| BSTLT | BOM category | STLTY | CHAR | 1 | |
| STKAN | Edge in the exploded BOM tree | STKAN | NUMC | 6 | |
| GUID | UUID in compressed form (22 character UUENCODEd) | SYSUUID_22 | CHAR | 22 | |
| GUID_16 | GUID in 'RAW' format | GUID_16 | RAW | 16 | |
| EKORG | Purchasing organization | EKORG | T024E | CHAR | 4 |
| SOBSL | Special procurement type | SOBSL | T460A | CHAR | 2 |
| STRECKE | Ind.: Third-party requisition | STRECKE | CHAR | 1 | |
| CREADAT | Date on which the record was created | ERDAT | DATS | 8 | |
| CREABY | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| PPE_EXTERN_KEY | Char63 | CHAR63 | CHAR | 63 | |
| CHANGEBY | Name of person who changed object | AENAM | CHAR | 12 | |
| CHANGEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| BRTDATE | Fixed Key Date | BRUTR | DATS | 8 | |
| IDNLF | Material Number Used by Supplier | IDNLF | CHAR | 35 | |
| MFRPN | Manufacturer Part Number | MFRPN | CHAR | 40 | |
| MFRNR | Manufacturer number | MFRNR | * | CHAR | 10 |
| CATALOGID | Identifier for allowed catalogs | KATALOGID | * | CHAR | 20 |
| CATALOG_PROD_ID | Product ID in Catalog | CATALOG_PROD_ID | CHAR | 40 | |
| EEW_RSADD_PS_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | |
| MCN33 | Single-Character Flag | CHAR1 | CHAR | 1 | |
| ADPIC_REF_RSPOS | Reference item | ADPIC_D_REF_RSPOS | NUMC | 4 |
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 VSRSADD_CN
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VSRSADD_CN | EKORG | 1: N | T024E |
| VSRSADD_CN | MFLIC | C: CN | TCNMF |
| VSRSADD_CN | SOBSL | C: CN | T460A |