TRQV_LOT_ATTR SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




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

TRQV_LOT_ATTR 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 TRQV_LOT_ATTR table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include OS_GUID (Lot), POSITION_DATE (Position Value Date), ORIGIN_DATE (Original Position Acquisition Date), BUSTRANSID (Identifier of the Distributor Business Transaction).. 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 TRQV_LOT_ATTR 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
OS_GUIDLot TPM_POSITION_LOTCHAR32TPM_DB_OS_GUID
POSITION_DATEPosition Value Date TPM_POSITION_DATEDATS8TPM_POSITION_DATE
ORIGIN_DATEOriginal Position Acquisition Date TPM_ORIGIN_DATEDATS8TPM_ORIGIN_DATE
BUSTRANSIDIdentifier of the Distributor Business Transaction TPM_BUSTRANSIDRAW16SYSUUID
LOT_IDIdentifier of the Lot TPM_LOT_IDRAW16SYSUUID
COMPANY_CODECompany Code BUKRSCHAR4T001BUKRSBUKC_T001
VALUATION_AREAValuation Area TPM_VAL_AREACHAR3TRGC_VAL_AREATPM_VAL_AREATPM_VAL_AREATRG_VALUATION_AREA
DEAL_NUMBERFinancial Transaction TB_RFHACHAR13VTBFHAALPHAT_RFHAFANVTBA
BUSTRANSCATBusiness Transaction Category TPM_BUSTRANSCATNUMC4TRDTS_BT_CATTPM_BUSTRANSCAT
PRODUCT_GROUPProduct Group TPM_PRODUCT_GROUPNUMC3TPM_PRODUCT_GROUP
PRODUCT_CATEGORYProduct Category SANLFNUMC3TZAFVVSANLF
BUSTRANS_STATEStatus of Distributor Business Transaction TPM_BUSTRANS_STATECHAR1TPM_BUSTRANS_STATE
CREATE_DATECreation Date of the Operative Business Transaction TPM_BT_CREATE_DATEDATS8DATUM
CREATE_TIMECreation Time of the Operative Business Transaction TPM_BT_CREATE_TIMETIMS6UZEIT
RLDEPOSecurities Account VRLDEPOCHAR10TWD01RLDEPODEP
RANLSecurity ID Number VVRANLWCHAR13ALPHAWP_RANLRANSECURITY_F4
POSACCFutures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUTCHAR10TRFT_POS_ACCOUNTTPM_POS_ACCOUNT_FUTTRF_PACTRFC_F4_POS_ACCOUNT
SGSARTProduct Type VVSARTCHAR3TZPAVVSARTSANVVSART_APPL_BAS
KONTRHBusiness Partner Number TB_KUNNR_NEWCHAR10ALPHABU_PARTNERBPABUPA
ZUONDAssignment TB_ZUONDCHAR18TEXT18
REFERInternal Reference TB_REFERCHAR16CHAR16
MERKMCharacteristics TB_MERKMCHAR25CHAR25
RCOMVALCLGeneral Valuation Class TPM_COM_VAL_CLASSNUMC4TRGC_COM_VALCLTPM_COM_VAL_CLASSCVC
CRUSEREntered by TB_CRUSERCHAR12SYCHAR12

Key field Non-key field



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

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

SELECT SINGLE *
FROM TRQV_LOT_ATTR
INTO CORRESPONDING FIELDS OF WA_TRQV_LOT_ATTR
WHERE...

How to access SAP table TRQV_LOT_ATTR

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