VIAK14 SAP (RA credit memo/receivable:now only used as structure!) Table details
Dictionary Type: Table
Description: RA credit memo/receivable:now only used as structure!
Description: RA credit memo/receivable:now only used as structure!
Table field list including key, data, relationships and ABAP select examples
VIAK14 is a standard SAP Table which is used to store RA credit memo/receivable:now only used as structure! data and is available within R/3 SAP systems depending on the version and release level.
The VIAK14 table consists of various fields, each holding specific information or linking keys about RA credit memo/receivable:now only used as structure! data available in SAP. These include MANDT (Client), BUKRS (Company Code), SMIVE (Lease-Out Number), SWENR (Site Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VIAK14 table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
| SMIVE | Lease-Out Number | SMIVE | CHAR | 13 | ALPHA | VVSMIVE | MIV | MRTA | |
| SWENR | Site Number | SWENR | CHAR | 8 | Assigned to domain | SWENR | SWENR | WEH | MCWE |
| SMENR | Number of Rental Unit | SMENR | CHAR | 8 | Assigned to domain | SMENR | SMENR | MEH | MCME |
| SBEWART | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
| DVONPER | Period start date | DVONPER | DATS | 8 | DATUM | ||||
| NPERSOND | Special period to post follow-up costs | VVNPERSOND | NUMC | 2 | NUMC2 | ||||
| SNKSL | Service Charge Key | SNKSL | CHAR | 4 | Assigned to domain | ALPHA | SNKSL | NKL | REFXCLSNKSL |
| DBISPER | Date of settlement period end | DBISPER | DATS | 8 | DATUM | ||||
| SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | Assigned to domain | SKOART | |||
| VVBKOPTG | Average costs per day for a condition type | VVBKOPTG | CURR | 13(2) | WRTV7 | ||||
| BNETTO | Net amount | BNETTO | CURR | 13(2) | WRTV7 | ||||
| BSTEUER | Tax amount | BSTEUER | CURR | 13(2) | WRTV7 | ||||
| BHWHR | Amount in local currency | BHWHR | CURR | 13(2) | WERTV7 | ||||
| BGUFO | Credit memo/receivable amount | BGUFO | CURR | 13(2) | WRTV7 | ||||
| BMWST | Value-added tax amount included | BMWST | CURR | 13(2) | WRTV7 | ||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
| DVZNEU | Valid-as-from date for new advance payment | DVZNEU | DATS | 8 | DDAT | ||||
| BVZNEU | New advance payment amount | BVZNEU | CURR | 13(2) | WRTV7 | ||||
| BKONDALT | Previous condition amount | BKONDALT | CURR | 13(2) | WRTV7 | ||||
| VVSKVZA | Reason why advance payment adjustment not carried out | VVSKVZA | CHAR | 1 | VVSKVZA | ||||
| DABRECH | Settlement date | DABRECH | DATS | 8 | DDAT | ||||
| VVABBLN | Settlement Identification ->Accounting Ref. Doc.Number | VVABBLN1 | CHAR | 16 | XBLNR1 | IAB | |||
| DMBTR | Amount of advance payments made for SCS | VVGELVZ | CURR | 13(2) | WERT7 | ||||
| MWSTS | Tax Amount in Local Currency | MWSTS | CURR | 13(2) | WERT7 | ||||
| BNAVST | Amount of non-deductible input tax share | VVBNAVST | CURR | 13(2) | WRTV7 | ||||
| BSTBAS | Base amount for tax calculation in incid.expenses sttlmnt | VVBSTBAS | CURR | 13(2) | WRTV7 | ||||
| BSTBTR | Output tax for customer posting in service charge settlement | VVBSTBTR | CURR | 13(2) | WRTV7 | ||||
| PERHVZ | Percentage of additional advance payment increase | VVPERHVZ | DEC | 4(2) | DEC2_2V | ||||
| BSTKORR | Tax adjustment for tenant service charge settlement | VVBSTKORR | CURR | 13(2) | WERTV7 | ||||
| ABREART | Settlement type for service charges after settlement perfor. | VVABREART | CHAR | 1 | VVABREART | ||||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
| MAXCOST | Maximum costs value for service charge settlement | VVMAXCOST | CURR | 13(2) | WERT7 | ||||
| REBKOPTG | Average costs per day for a condition type | REBKOPTG | DEC | 13(6) | |||||
| BNETTO_REAL | Net amount, original amount | REBNETTO_REAL | CURR | 13(2) | WRTV7 | ||||
| BSTBAS_REAL | Basic amount for tax calculation for SCS, orig. value | REBSTBAS_REAL | CURR | 13(2) | WRTV7 | ||||
| BSTBTR_REAL | Output tax for customer posting for SCS, original value | REBSTBTR_REAL | CURR | 13(2) | WRTV7 |
| Key field | Non-key field |
How do I retrieve data from SAP table VIAK14 using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIAK14 to SELECT all data from the tableDATA: WA_VIAK14 TYPE VIAK14.
SELECT SINGLE *
FROM VIAK14
INTO CORRESPONDING FIELDS OF WA_VIAK14
WHERE...
How to access SAP table VIAK14
Within an ECC or HANA version of SAP you can also view further information about VIAK14 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects