JHVCIC_ORDERITEM SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from JHVCIC_ORDERITEM
Related tables to JHVCIC_ORDERITEM
Access table JHVCIC_ORDERITEM




Table View field list including key, data, relationships and ABAP select examples

JHVCIC_ORDERITEM 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 JHVCIC_ORDERITEM table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include AVM_NR (IS-M/AM: Sales Document Number), POS_NR (IS-M: Order Item Number), GPAG (Business Partner: Sold-to Party), VKORG (Sales Organization).. 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 JHVCIC_ORDERITEM 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
MANDTClient MANDTCLNT3T000MANDT
AVM_NRIS-M/AM: Sales Document Number AVM_NRCHAR10JHAKALPHAAVM_NRJHAMJHA
POS_NRIS-M: Order Item Number POS_NRNUMC3AVM_PNR
GPAGBusiness Partner: Sold-to Party GPAGCHAR10JGTGPNRALPHAGPNR
VKORGSales Organization VKORGCHAR4TJHVBERVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TJHVBERVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TJHVBERSPARTSPAC_SPART
VKGRPSales Group VKGRPCHAR3TVBVKVKGRPVKG
VKBURSales Office VKBURCHAR4TVKBZVKBURVKB
AVM_HRKNFTIS-M/AM: Order Origin AVM_HRKNFTCHAR1AVM_HRKNFT
AUARTIS-M: Sales Document Type AUART_PAMCHAR4TJHAKAUART_PAMJHRMJHAUART_PAM
WAEHRGSD Document Currency WAERKCUKY5TCURCWAERSFWS
POS_ARTIS-M: Order-Publishing-Media - Item Type AVMPOS_ARTCHAR2TJH17AVMPOS_ART
STATUSKIS-M: Status STATUSKCHAR2PAM_STATUS
PSTYVIS-M: Item Category for Sales Document PSTYV_PAMCHAR4TJHAPPSTYV_PAM
WERBK_TYPIS-M: Combination Sale Type WKOMBI_TYPCHAR2TJH91WKOMBI_TYPMJHWKOMBI_TYP
WERBK_KNZIS-M: Combination Sale Indicator WERBK_KNZNUMC4WERBEKKNZ
BRAN_PAMIS-M/AM: Current Industry Sector Associated With Order Item BRAN_POSCHAR10TBRCBRACO
XAGENAUFTRIS-M: Agency order indicator XAGENAUFTRCHAR1XFELD
KAMPAGNEIS-M: Campaign (customer) KAMPAGNECHAR6TJJKAMPKAMPAGNE
SELDAT_VONIS-M: Start Date for Item SELDAT_VONDATS8DATUM
SELDAT_BISIS-M: End Date for Items SELDAT_BISDATS8DATUM
XSTORNIERTIS-M: Canceled Order Object Indicator XSTORNIERTCHAR1XFELD
STORNOGRNDIS-M: Cancellation Reason STOGRD_PAMCHAR3TJHSTOGSTOGRD_PAMMJHSTOGRD_PAM
ERFUSERCreated By ERFUSERCHAR12USNAM
ERFDATECreated On ERFDATEDATS8DATUM
AENUSERLast Changed By AENUSERCHAR12USNAM
AENDATEDate of Last Change AENDATEDATS8DATUM
XDELETED_LOGICALIndicator: Order Object is Logically Deleted ISM_XDELETED_LOGICALCHAR1XFELD
PACKAGE_IDPackage ISM_PACKAGE_IDCHAR10JJTPCALPHAISM_PACKAGE_ID
PK_REF_AVM_NROrder Number for Package Reference Order ISM_PK_REF_AVM_NRCHAR10ALPHAAVM_NR
PK_REF_POS_NRItem Number of Package Item to be Referenced ISM_PK_REF_POS_NRNUMC3AVM_PNR
PK_ELEMENT_IDPackage Element ID ISM_PK_ELEMENT_IDNUMC3ISM_PK_ELEMENT_ID
PACKAGE_TYPEPackage Type ISM_PACKAGE_TYPENUMC2ISM_PACKAGE_TYPE
PACKAGE_CATEGORYPackage Category ISM_PACKAGE_CATEGORYCHAR4ALPHAISM_PACKAGE_CATEGORY

Key field Non-key field



How do I retrieve data from SAP table JHVCIC_ORDERITEM using ABAP code

The following ABAP code Example will allow you to do a basic selection on JHVCIC_ORDERITEM to SELECT all data from the table
DATA: WA_JHVCIC_ORDERITEM TYPE JHVCIC_ORDERITEM.

SELECT SINGLE *
FROM JHVCIC_ORDERITEM
INTO CORRESPONDING FIELDS OF WA_JHVCIC_ORDERITEM
WHERE...

How to access SAP table JHVCIC_ORDERITEM

Within an ECC or HANA version of SAP you can also view further information about JHVCIC_ORDERITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!