/J7L/BI_DCL_TD SAP (REA Extraction Structure for Declarations) Structure details

Dictionary Type: Structure
Description: REA Extraction Structure for Declarations




ABAP Code to SELECT data from /J7L/BI_DCL_TD
Related tables to /J7L/BI_DCL_TD
Access table /J7L/BI_DCL_TD




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

/J7L/BI_DCL_TD 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 "REA Extraction Structure for Declarations" 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_/J7L/BI_DCL_TD TYPE /J7L/BI_DCL_TD.

The /J7L/BI_DCL_TD table consists of various fields, each holding specific information or linking keys about REA Extraction Structure for Declarations data available in SAP. These include VBELN (REA Declaration: Document Number), POSNR (REA Declaration: Line Item), UEPOS (REA Declaration: Higher-Level Line Item), AUDAT (Document Date (Date Received/Sent)).. 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 /J7L/BI_DCL_TD 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
UPDMODBW Delta Process: Record Mode RODMUPDMODCHAR1RODMUPDMOD
VBELNREA Declaration: Document Number J_7LVNR_ACHAR10Assigned to domainALPHAVBELNVF
POSNRREA Declaration: Line Item J_7LRPOS_ANUMC6NUMC6
UEPOSREA Declaration: Higher-Level Line Item J_7LUEPOSNUMC6NUMC6
AUDATDocument Date (Date Received/Sent) AUDATDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
BLTYPREA Document Category J_7LVBTYPCHAR1J_7LRVBTYP
BLARTDocument Type for Recycling Partner J_7LBLARTCHAR4Assigned to domainJ_7LBLARTJ6P
XBLNRReference Document Number XBLNR_VCHAR16XBLNR
SVBLNREA Declaration: Document of Canceled Declaration J_7LSVBLNCHAR10Assigned to domainALPHAVBELN
ENTNRRecycling Partner J_7LRENTCHAR10Assigned to domainALPHALIFNRLIF
ENTNARecycling Partner J_7LENTNAMCHAR6Assigned to domainJ_7LENTNAMJ_7LE01_F4
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
ZNEHMLicensee, Customer Number with Recycling Partner REA J_7LZNEHMCHAR12J_7LZNEH
DATABREA Settlement Period - Start J_7LRDATABDATS8DATS
DATBIREA Settlement Period, End J_7LRDATBIDATS8DATS
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
NETWRNet Value in Document Currency J_7LNETWRCURR17(2) J_7LWERTVX
BERWRCalculated Value in Document Currency (Output Value Formula) J_7LBERWRCURR17(2) J_7LWERTVX
PBERWRCalculated Value in Document Currency (Initial Value PF) J_7LPBERWRCURR17(2) J_7LWERTVX
WAERKSD Document Currency WAERKCUKY5Assigned to domainWAERSFWS
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
POSARDeclaration Item Type J_7LPOSARCHAR1J_7LPOSAR
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
VARIANTEVariant of Article J_7LAVARIANTECHAR18J_7LVARIANTE
MTARTMaterial Type MTARTCHAR4Assigned to domainMTARTMTA
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
GRUPPEGrouping of Characteristics in MM J_7LGRUPPECHAR4Assigned to domainJ_7LGRUPPE
PGAAWRTotal Value Absolute Article in Doc.Crcy from Price Formula J_7LPGAAWRCURR17(2) J_7LWERTVX
PKPEINCondition Pricing Unit J_7LKPEINDEC9J_7LKPEIN
PREISBPrice in Document Currency J_7LRSTPBCURR17(2) J_7LWERTVX
KPEINCondition Pricing Unit J_7LKPEINDEC9J_7LKPEIN
VRPNRPackaging J_7LVRPCHAR18Assigned to domainMATN1MATNRJ6L
VVARIANTEVariant of Packaging J_7LVVARIANTECHAR18J_7LVARIANTE
VPEBENEPackaging Level J_7LVEBENENUMC2Assigned to domainJ_7LVEBENE
KPEINVNumber of Sales Units in Packaging Bill of Material J_7LRKPEINDEC5KPEIN
VPARTGPackaging Type Weight-Dependent Fee J_7LVPARTGNUMC2Assigned to domainJ_7LRVPART
VPARTSPackaging Type Item-Dependent Fee J_7LVPARTSNUMC2Assigned to domainJ_7LRVPART
VRPKTPackaging Category Fraction J_7LVRPKTCHAR5Assigned to domainJ_7LVRPKT
FKIMPProportional Quantity (Sales / Entry Unit J_7LMNGPDEC17(6) J_7LDEC
VRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
STOFEPartner Fraction J_7LRSTOFECHAR6Assigned to domainJ_7LSTOFFE
STOFPFraction Price: Recycling Partner J_7LRSTOFPCHAR6Assigned to domainJ_7LSTOFFE
STGEWFraction Weight J_7LRGEWQUAN17(6) J_7LMENGV17_6
STGEWFFFraction Weight J_7LRGEWQUAN17(6) J_7LMENGV17_6
GEWEIWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
STGEWMFraction Weight J_7LRGEWQUAN17(6) J_7LMENGV17_6
GEWEIMWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
FMENGVComponent quantity KMPMGQUAN13(3) MENGV13
MEINSVComponent unit of measure KMPMEUNIT3Assigned to domainCUNITMEINS
KUNNRCustomer Numbers KUNNRCHAR10Assigned to domainALPHAKUNNRKUNC_KUNNR
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
MBRSHIndustry sector MBRSHCHAR1Assigned to domainMBRSHMTP
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
LLANDCountry of Destination LLANDCHAR3Assigned to domainLAND1VLL
INFOKAdditional Info Key J_7LINFOKCHAR5Assigned to domainJ_7LINFOK
FUELLGContent ID Key J_7LFUELLGCHAR5Assigned to domainJ_7LFUELLG
HDLSTTrade Level J_7LHDLSTNUMC5Assigned to domainJ_7LHDLST
VLFLKVolume/Area Class J_7LVFLKLCHAR6Assigned to domainJ_7LRVFLKL
VFLSTNumber of Pieces for Volume and Area Classes J_7LVFLSTQUAN17(6) J_7LMENGV17_6
VRPSTNumber of Pieces, Packaging J_7LVRPSTQUAN17(6) J_7LMENGV17_6
KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
KPROZHTrade Level Valuation Percentage J_7LKPROZHDEC5(2) DECV3_2
KPROZHFValuation Percentage for Trade Level Fraction J_7LKPROZHFDEC5(2) DECV3_2
EXPORTKZIndicator: Show Exports in Quantity Flow of Rec.Declaration J_7LKZEXPCHAR1XFELD
IMPORTKZIndicator: Show Imports in Quantity Flow of Recyc. Declarat. J_7LKZIMPCHAR1XFELD
INLANDKZIndicator: Filter Out Domestic Purchases in Declaration J_7LKZINLCHAR1XFELD
AEDATChanged On AEDATDATS8DATUM

Key field Non-key field



How do I retrieve data from SAP structure /J7L/BI_DCL_TD using ABAP code?

As /J7L/BI_DCL_TD 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 /J7L/BI_DCL_TD as there is no data to select.

How to access SAP table /J7L/BI_DCL_TD

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