TRLIV_AD SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




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

TRLIV_AD 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 TRLIV_AD table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include PRODUCT_GROUP (Product Group), ACCOUNTING_CODE (Accounting Code), VALUATION_AREA (Valuation Area), PRODUCT_CATEGORY (Product Category).. 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 TRLIV_AD 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 MANDTCLNT3MANDT
PRODUCT_GROUPProduct Group TPM_PRODUCT_GROUPNUMC3TPM_PRODUCT_GROUP
ACCOUNTING_CODEAccounting Code TPM_ACC_CODECHAR4TRGC_TR_ACC_CODETPM_ACC_CODETPM_TACTRG_ACC_CODE
VALUATION_AREAValuation Area TPM_VAL_AREACHAR3TRGC_VAL_AREATPM_VAL_AREATPM_VAL_AREATRG_VALUATION_AREA
PRODUCT_CATEGORYProduct Category SANLFNUMC3TZAFVVSANLF
PRODUCT_TYPEProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
POS_MAN_PROCPosition Management Procedure TPM_POS_MAN_PROCCHAR4TRGC_PM_PROCTPM_POS_MAN_PROC
FLOWTYPE_INCOMEAccrual/Deferral: Update Type for Profit-Related Flow TPM_TRLI_FLOWTYPE_INCOMECHAR8TRDC_DFLOWTYPETPM_DIS_FLOWTYPE
METHODAccrual/Deferral Procedure TPM_TRLI_AD_METHODCHAR1TPM_TRLI_AD_METHOD
COMPENSATIONAccrual/Deferral: Taking Netting Account into Consideration TPM_TRLI_AD_COMPENSATIONCHAR1TPM_FLAG
FUNCTIONAccrual/Deferral Method TPM_TRLI_AD_FUNCTIONCHAR3TPM_TRLI_AD_FUNCTION
FT_ACCRUALUpdate Type Accrual TPM_TRLI_FLOWTYPE_ACCRUALCHAR8TRGC_DFTSOURCASSTPM_DIS_FLOWTYPE
FT_ACCRUAL_RESUpdate Type Accrual Reset TPM_TRLI_FLOWTYPE_ACCRUAL_RESCHAR8TRGC_DFTSOURCASSTPM_DIS_FLOWTYPE
FT_DEFERRALUpdate Type Deferral TPM_TRLI_FLOWTYPE_DEFERRALCHAR8TRGC_DFTSOURCASSTPM_DIS_FLOWTYPE
FT_DEFERRAL_RESUpdate Type Deferral Reset TPM_TRLI_FLOWTYPE_DEFERRAL_RESCHAR8TRGC_DFTSOURCASSTPM_DIS_FLOWTYPE
FT_AD_DIFF_METHUpdate Type for Accrual/Deferral Difference Procedure TPM_TRLI_FLOWTYPE_AD_DIFF_METHCHAR8TRGC_DFTSOURCASSTPM_DIS_FLOWTYPE
FT_AD_CORRUpdate Type for Accrual/Deferral Offsetting Flow TPM_TRLI_FLOWTYPE_CORRECTCHAR8TRGC_DFTSOURCASSTPM_DIS_FLOWTYPE
FT_AD_FX_INCUpdate Type: Forex Valuation Write-Up TPM_TRLI_FLOWTYPE_FX_INCRCHAR8TRGC_DFTSOURCASSTPM_DIS_FLOWTYPE
FT_AD_FX_DECUpdate Type: Forex Valuation Write-Down TPM_TRLI_FLOWTYPE_FX_DECRCHAR8TRGC_DFTSOURCASSTPM_DIS_FLOWTYPE
AGGREGATION_TERMAccrual/Deferral: Grouping Term TPM_AD_AGGREGATION_TERMCHAR8TPM_AD_AGGREGATION_TERM
EXCH_RATE_CATAccrual/Deferral: Exchange Rate Category TPM_AD_EXCH_RATE_CATCHAR2TPM_AD_EXCH_RATE_CAT
EXCH_DATE_CATAccrual/Deferral: Translation Date Category TPM_AD_EXCH_DATE_CATCHAR2TPM_AD_EXCH_DATE_CAT
ACC_CODE_TName of Accounting Code TPM_TR_ACC_CODE_NAMECHAR60TPM_DESCRIPTION
VALUATION_AREA_TName of the Valuation Area TPM_VAL_AREA_NAMECHAR60TPM_DESCRIPTION
PRODUCT_CAT_TText (30 Characters) TEXT30CHAR30TEXT30
PRODUCT_TYPE_TText (30 Characters) TEXT30CHAR30TEXT30
FT_AD_CC_POSTUpdate type posting after currency conversion TPM_TRLI_FLOWTYPE_CC_POSTCHAR8TRDC_DFLOWTYPETPM_DIS_FLOWTYPE
FT_AD_CC_CLEARUpdate type clearing after currency conversion TPM_TRLI_FLOWTYPE_CC_CLEARCHAR8TRDC_DFLOWTYPETPM_DIS_FLOWTYPE
FT_AD_CC_POST_NUpdate type posting after currency conversion TPM_TRLI_FLOWTYPE_CC_POSTCHAR8TRDC_DFLOWTYPETPM_DIS_FLOWTYPE
FT_AD_CC_CLEAR_NUpdate type clearing after currency conversion TPM_TRLI_FLOWTYPE_CC_CLEARCHAR8TRDC_DFLOWTYPETPM_DIS_FLOWTYPE
FLOWTYPE_EXPENSEAccrual/Deferral: Update Type for Expense-Related Flow TPM_TRLI_FLOWTYPE_EXPENSECHAR8TRDC_DFLOWTYPETPM_DIS_FLOWTYPE
OVERDUE_DAYSNumber of Days of Overdue Accrual TPM_DAYS_OVERDUEINT410

Key field Non-key field



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

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

SELECT SINGLE *
FROM TRLIV_AD
INTO CORRESPONDING FIELDS OF WA_TRLIV_AD
WHERE...

How to access SAP table TRLIV_AD

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