TBLPEXT SAP (Transfer Loan Information) Structure details

Dictionary Type: Structure
Description: Transfer Loan Information




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




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

TBLPEXT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Transfer Loan Information" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_TBLPEXT TYPE TBLPEXT.

The TBLPEXT table consists of various fields, each holding specific information or linking keys about Transfer Loan Information data available in SAP. These include MANDT (Client), TLLONR (Document Number of Transfer/Loan), TLIND (Indicator for Transfer/Loan), POSNR_S (Sender WBS element).. 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: Can be enhanced (character-type or numeric)


SAP TBLPEXT structure 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 MANDTCLNT3Assigned to domainMANDT
TLLONRDocument Number of Transfer/Loan TBLP_BELNRNUMC10TBLP_BELNR
TLINDIndicator for Transfer/Loan TBLP_INDCHAR1TLINDTBLP_IND
POSNR_SSender WBS element POSNR_SNUMC8PRPSABPSPPS_POSNR
POSNR_RReceiver WBS element POSNR_RNUMC8PRPSABPSPPS_POSNR
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MATNR_RMaterial MATNR_RCHAR18Assigned to domainMATN1MATNRMATMAT1
ERFMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
ERFMEUnit of Entry ERFMEUNIT3Assigned to domainCUNITMEINS
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
WERKS_SPlant WERKS_SCHAR4Assigned to domainWERKSWRKH_T001W
LGORT_SStorage Location LGORT_SCHAR4Assigned to domainLGORTLAG
WERKS_RPlant WERKS_RCHAR4Assigned to domainWERKSWRKH_T001W
LGORT_RStorage Location LGORT_RCHAR4Assigned to domainLGORTLAG
MBLNR_TRMaterial Document Number of Transfer Posting/Loan MBLNR_TRCHAR10ALPHABELNRMBN
MJAHR_TRMaterial Document Year of Transfer Posting/Loan MJAHR_TRNUMC4GJAHRGJAHRMJA
BELNRPR_TRPrimary Costs Doc. Number for Transfer/Loan BELNRPR_TRCHAR10Assigned to domainALPHACO_BELNR
BELNRSE_TRSecondary Costs Doc. Number for Transfer/Loan BELNRSE_TRCHAR10Assigned to domainALPHACO_BELNR
BELNRCM_TRCommitment Doc. Number for Transfer Posting/Loan BELNRCM_TRCHAR10Assigned to domainALPHACO_BELNR
RRSNUMReservation Number of Receiving WBS Element (Loan) RRSNUMCHAR10DELNR
RRSPOSItem Number of Reservation / Dependent Requirements RRSPOSNUMC4RSPOSRPO
LPLNUMDocument Number of Planned Order Created Due to Loan LPLNUMCHAR10Assigned to domainALPHAPLNUMPAF
LRSNUMDocument Number of Reservation Created Due to Loan LRSNUMNUMC10Assigned to domainRSNUMRES
LRSPOSItem Number of Reservation / Dependent Requirements LRSPOSNUMC4RSPOSRPO
MBLNR_CACancellation Document Transfer/Loan MBLNR_CACHAR10ALPHABELNRMBN
MJAHR_CACancellation of Material Document Year of Transfer/Loan MJAHR_CANUMC4GJAHRGJAHRMJA
BELNRPR_CACancellation Document for Primary Costs BELNRPR_CACHAR10Assigned to domainALPHACO_BELNR
BELNRSE_CACancellation Document for Secondary Costs BELNRSE_CACHAR10Assigned to domainALPHACO_BELNR
BELNRCM_CACancellation Document for Commitment BELNRCM_CACHAR10Assigned to domainALPHACO_BELNR
BLDATDocument Date CO_BLDATDATS8DATUM
CBACKIndicator: Calculation in Background CBACKCHAR1CHAR1
CMSETIndicator for Commitment Posting CMSETCHAR1CHAR1
USNAMUser Name SYUNAMECHAR12SYCHAR12
KALNRCost Estimate Number - Product Costing TBLP_KALNR1NUMC12Assigned to domainTBLP_KALNRKNE
PRICEStandard price STPRSCURR11(2) WERT11V
WOCOSTTransfer without Costs WOCOSTCHAR1WOCOST
GRPSTransfer Posting on Grouping WBS Element Level GRPSCHAR1GRPS
EXPANDCheckbox XFELDCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure TBLPEXT using ABAP code?

As TBLPEXT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on TBLPEXT as there is no data to select.

How to access SAP table TBLPEXT

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