JVVT685A_AJ0 SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
JVVT685A_AJ0 is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The JVVT685A_AJ0 table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include KVEWE (Usage of the condition table), KAPPL (Application), KSCHL (Condition Type), KOZGF (Access sequence).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP JVVT685A_AJ0 table view 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 | T000 | MANDT | |||
| KVEWE | Usage of the condition table | KVEWE | CHAR | 1 | T681V | KVEWE | KVW | ||
| KAPPL | Application | KAPPL | CHAR | 2 | T681Z | KAPPL | KAP | ||
| KSCHL | Condition Type | KSCHL | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
| KOZGF | Access sequence | KOZGF | CHAR | 4 | T682 | KOZGF | |||
| DATVO | Date proposed as valid-to date | DATVO | CHAR | 1 | DATVO | ||||
| DTVOB | Proposed starting date for the rebate validity period | DTVOB | CHAR | 1 | DTVOB | ||||
| KRECH | Calculation type for condition | KRECH | CHAR | 1 | KRECH | ||||
| KZBZG | Scale basis indicator | KZBZG | CHAR | 1 | KZBZG | ||||
| KNTYP | Condition category (examples: tax, freight, price, cost) | KNTYP | CHAR | 1 | KNTYP | ||||
| KMANU | Making manual entries | KMANU | CHAR | 1 | KMANU | ||||
| GRLNR | Routine number for creating group key | GRLNR | NUMC | 2 | NUM02 | ||||
| GRMEN | Scale unit | GRMEN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| GANZZ | Indicator: Currency Translation after Multiplication | GANZZ | CHAR | 1 | XFELD | ||||
| KGRPE | Group condition | KGRPE | CHAR | 1 | KGRPE | ||||
| KRELI | Condition for invoice list | KRELI | CHAR | 1 | KRELI | ||||
| KDUPL | Structure condition | KDUPL | CHAR | 1 | KDUPL | ||||
| KRUEK | Condition is Relevant for Accrual (e.g. Freight) | KRUEK | CHAR | 1 | XFELD | ||||
| KOUPD | Condition update | KOUPD | CHAR | 1 | XFELD | ||||
| KOFRS | Formula for scale base value | KOFRS | NUMC | 3 | KOFRM | ||||
| KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | Assigned to domain | KALSM | |||
| KZNEP | Condition exclusion indicator | KZNEP | CHAR | 1 | Assigned to domain | KZNEP | |||
| KOAID | Condition class | KOAID | CHAR | 1 | KOAID | ||||
| KKOPF | Condition applies to header | KKOPF | CHAR | 1 | XFELD | ||||
| KPOSI | Condition applies to items | KPOSI | CHAR | 1 | XFELD | ||||
| KNEGA | Plus/minus sign of the condition amount | KNEGA | CHAR | 1 | KNEGA | ||||
| TXPRF | Rounding rule | TXPRF | CHAR | 1 | TXPRF | ||||
| KSTPR | Checking rule for scale rates | KSTPR | CHAR | 1 | KSTPR | ||||
| KAEND_BTR | Condition rate of change for amount/percentage | KAEND_BTR | CHAR | 1 | XFELD | ||||
| KAEND_WRT | Scope for changing the value | KAEND_WRT | CHAR | 1 | XFELD | ||||
| KAEND_UFK | Scope for changing conversion factors | KAEND_UFK | CHAR | 1 | XFELD | ||||
| KAEND_RCH | Calculation type can be changed | KAEND_RCH | CHAR | 1 | XFELD | ||||
| KAEND_LOE | Delete the scope for changing rate | KAEND_LOE | CHAR | 1 | XFELD | ||||
| IDXUP | Update condition index | IDXUP | CHAR | 1 | XFELD | ||||
| RUKOR | Rebate: Accruals correction procedure | RUKOR | CHAR | 1 | RUKOR | ||||
| BOVER | Rebate procedure | BOVER | CHAR | 1 | BOVER | ||||
| KPRDT | Pricing date | KPRDT | CHAR | 1 | KPRDT | ||||
| STFKZ | Scale Type | STFKZ | CHAR | 1 | STFKZ | ||||
| PRECH | Period Condition Calculation Rule | PRECH | CHAR | 1 | KRECH | ||||
| BNKWE | Enter vendor for delivery costs in goods receipt document | BNKWE | CHAR | 1 | BNKWE | ||||
| AKTKO | Condition Type for Promotions | AKTKO | CHAR | 1 | XFELD | ||||
| VKKAL | Sales Price Calculation: Relevant to pricing | VKKAL | CHAR | 1 | XFELD | ||||
| VKOBL | SP Calculation: 'Relevant to pricing' ID can be changed | VKOBL | CHAR | 1 | XFELD | ||||
| RKAPPL | Reference application | RKAPPL | CHAR | 2 | T681A | KAPPL | |||
| RKSCHL | Reference condition type | RKSCHL | CHAR | 4 | Assigned to domain | KSCHL | |||
| BERGL | Calculation Base | BERGL | CHAR | 1 | BERGL | ||||
| VHART | Packaging Material Type | VHIART | CHAR | 4 | Assigned to domain | TRATY | |||
| RDIFA | Rounding difference comparison | RDIFA | CHAR | 1 | XFELD | ||||
| KFKIV | Condition for inter-company billing | KFKIV | CHAR | 1 | XFELD | ||||
| KVARC | Condition for configuration | KVARC | CHAR | 1 | XFELD | ||||
| KMENG | Quantity conversion | KMENG | CHAR | 1 | XFELD | ||||
| MDFLG | Indicator: Matrix maintenance | MDFLG | CHAR | 1 | MDFLG | ||||
| KTREL | Relevance for account assignment | KTREL | CHAR | 1 | KTREL | ||||
| BNKTK | Copy delivery costs from shipment costs document | VF_BNKTK | CHAR | 1 | VF_BNKTK | ||||
| KFRST | Release status | KFRST | CHAR | 1 | KFRST | ||||
| TXTGR | Text determination procedure | TXTGR | CHAR | 2 | Assigned to domain | TXTGR | |||
| TDID | Text ID for text edit control | TDID_TEC | CHAR | 4 | Assigned to domain | TDID | |||
| KDELE | Condition records should be deleted from the database | KDELE | CHAR | 1 | KDELE | ||||
| KBFLAG | Bit encrypted flags in Pricing | KBFLAG | RAW | 2 | KBFLAG | ||||
| VTEXT1 | Name | VTXTK | CHAR | 20 | TEXT20 | ||||
| VTEXT | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
| TDTEXT | Short Text | TDTEXT | CHAR | 30 | TDTEXT |
| Key field | Non-key field |
How do I retrieve data from SAP table JVVT685A_AJ0 using ABAP code
The following ABAP code Example will allow you to do a basic selection on JVVT685A_AJ0 to SELECT all data from the tableDATA: WA_JVVT685A_AJ0 TYPE JVVT685A_AJ0.
SELECT SINGLE *
FROM JVVT685A_AJ0
INTO CORRESPONDING FIELDS OF WA_JVVT685A_AJ0
WHERE...
How to access SAP table JVVT685A_AJ0
Within an ECC or HANA version of SAP you can also view further information about JVVT685A_AJ0 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