TVAP SAP (Sales Document: Item Categories) Table details

Dictionary Type: Table
Description: Sales Document: Item Categories




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




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

TVAP is a standard SAP Table which is used to store Sales Document: Item Categories data and is available within R/3 SAP systems depending on the version and release level.

The TVAP table consists of various fields, each holding specific information or linking keys about Sales Document: Item Categories data available in SAP. These include PSTYV (Sales document item category), FKREL (Relevant for Billing), PRSFD (Carry out pricing), POSGR (Screen sequence group for document header & item).. 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: G - Customising table which is protected against SAP Update
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP TVAP 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
MANDTClient MANDTCLNT3T000MANDT
PSTYVSales document item category PSTYVCHAR4TVPTPSTYV
FKRELRelevant for Billing FKRELCHAR1FKREL
PRSFDCarry out pricing PRSFDCHAR1PRSFD
POSGRScreen sequence group for document header & item BIFGRCHAR4TVHBBIFGR
PARGRPartner Determination Procedure PARGRCHAR4TVPGPARGR
PSGRPApplication CAPIDCHAR4TC04CAPIDCSA
STULIMaterial structure STULICHAR1STULI
ASWPAManual selection for BOM alternatives ASWPACHAR1XFELD
STRUMStructural scope of a material with bill of material STRUMCHAR1STRUM
EVRWRDetermine cost EVRWRCHAR1XFELD
KOWRRStatistical values KOWRRCHAR1KOWRR
FELDPField selection for item FELDPCHAR4TVHFFAWGR
FAKSPBlock FAKSPCHAR2TVFSFAKSP
SHELLBill of material in foreground SHELLCHAR1SHELL
ERLRECompletion rule for quotation / contract ERLRECHAR1ERLRE
TXN08Number of the standard text TXN08CHAR8TXN08
DIAFMDialog for short quantity DIAFMCHAR1XFELD
KDERLBusiness data allowed at item level? KDERLCHAR1XFELD
TXTGRText determination procedure TXTGRCHAR2TTXGTXTGR
POSARItem type POSARCHAR1POSAR
LFRELItem is relevant for delivery LFREL_APCHAR1XFELD
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ETERLSchedule lines allowed ETERLCHAR1XFELD
GWRELRelevant for weight/volume GWRELCHAR1XFELD
KOMPPForm delivery group and correlate BOM components KOMPPCHAR1KOMPP
FEHGRIncompletion procedure for sales document FEHGRCHAR2TVUVFEHGR
SHKZGReturns Item SHKZG_VACHAR1XFELD
EQMATMaterial block indicator EQMATCHAR1XFELD
STGAPStatistics group for the item category STGAPCHAR2TVSFALPHASTGVB
KALSMProcedure for item output KALSMBPCHAR6T683KALSM
SOBKZSpecial Stock Indicator SOBKZCHAR1T148SOBKZ
CMPNTID: Item with active credit function / relevant for credit CMPNTCHAR1XFELD
STRATForm of configuration processing STRATCONCHAR2T476STRAT2
STSMAStatus Profile J_STSMACHAR8TJ20J_STSMA
MENG1Order quantiy for each item is limited to 1 MENG1CHAR1XFELD
ALEKZCreate purchase order automatically ALEKZCHAR1XFELD
FPARTBilling/Invoicing Plan Type FPARTCHAR2TFPLAFPART
CHAUTAutomatic batch determination CHAUTCHAR1XFELD
EXCOPCarry out legal control for item category EXCOPCHAR1EXCOP
SVGNGActivity category for controlling of technical objects SVGNGCHAR4SVGNG
TYPFDCarry out variant matching TYPFDCHAR1XFELD
LTYPAAction when material variant determined during configuration LTYPACHAR1LTYPA
LTYPVRun ATP check on material variants LTYPVCHAR1LTYPV
WKMATValue contract material WKMATCHAR18MARAMATN1MATNR
RKTIOResponse on reaching release order value in value contract RKTIOCHAR1RKTIO
SEGALExclusion/Inclusion indicator for declara. to authorities SEGALCHAR2T609ASEGAL
STDTEDetermine date for bill of materials configuration STDTECHAR1STDTE
RDERLRounding permitted? RDERLCHAR1XFELD
EFFECIndicator: Assign values for parameter effectivities EFFECCHAR1XFELD
FFPRFDynamic Item Processor Profile AD01PROFNRCHAR8AD01C_PROFAD01PROFNRAD0DIP_PROFILE
SCHEME_RMARepair procedure: Procedure RMA_SCHEMACHAR4TVRMASRMA_SCHEMA
SCHEME_VFVariant matching procedure: procedure VF_SCHEMACHAR4TVVFSVF_SCHEMA
FAKTFBilling form FAKTFCHAR2FAKTF
RRRELRevenue recognition category RR_RELTYPCHAR1RR_RELTYP
ACDATVProposed start date for accrual period RR_ACDATVCHAR1RR_ACDATV
UVEIBDoc. pricing procedure for incomplete export/import data UVEIBCHAR3T609BUVEIB
OIBOMUse of item category as part of an Oil bill of material(BOM) OIB_BOMCHAR1OIB_BOM
OIBCSTOil BoM cost.(X=..from BoM header;' '=..from BoM components) OIB_CSTCHAR1XFELD
OIUSEREXITNumber of the routine used for copying GRPNONUMC3Assigned to domainGRPNO
REVSPRevenue Distribution Type RR_REVSPCHAR1RR_REVSP
REVEVTYPRevenue Event Type (Customizing) RR_REVEVTYP_CUSTCHAR1RR_REVEVTYP_CUST
MILL_BATCH_REFMP Returns with Batch Reference MILL_BATCH_REFCHAR1XFELD
MILL_BATCH_SEL_DDefault Value for Indicator: Batch Selction Control MILL_BATCH_SEL_DEFCHAR1MILL_BATCH_SEL_FLG
RBACONTROLControl of Rules-Based ATP Check RBACONTROLCHAR1RBACONTROL
.INCLU--AP 0
LVARTBill of services type LVARTCHAR2LVART
.INCLU--AP 0
ISM_SE_PLANNINGIS-M: Planning Data ISMPLANNINGCHAR2JPLANNING
.INCLU--AP 0
MILL_SE_KKNMTIndicator for characteristic transfer frm cust-mat-info-rcd MILL_SE_KKNMTCHAR1CHAR1

Key field Non-key field



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

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

SELECT SINGLE *
FROM TVAP
INTO CORRESPONDING FIELDS OF WA_TVAP
WHERE...

How to access SAP table TVAP

Within an ECC or HANA version of SAP you can also view further information about TVAP 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!