J_1I_STR_SANDTL SAP (Structure for Shipment Advice note Details) Structure details

Dictionary Type: Structure
Description: Structure for Shipment Advice note Details




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




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

J_1I_STR_SANDTL 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 "Structure for Shipment Advice note Details" 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_J_1I_STR_SANDTL TYPE J_1I_STR_SANDTL.

The J_1I_STR_SANDTL table consists of various fields, each holding specific information or linking keys about Structure for Shipment Advice note Details data available in SAP. These include MANDT (Client), DOC_NO (Document Number), DOC_ITEM (Document Item Number), DOC_TYPE (Document ID).. 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 (Deep)


SAP J_1I_STR_SANDTL 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 MANDTCLNT3T000MANDT
DOC_NODocument Number J_1I_DOC_NONUMC10J_1I_PM_DOCHDRJ_1I_DOC_NO
DOC_ITEMDocument Item Number J_1I_DOC_ITEMNUMC6J_1I_DOC_ITEM
DOC_TYPEDocument ID J_1I_EXIM_DOCIDCHAR4Assigned to domainJ_1I_EXIM_DOCUMENT_ID
REFDOC_NOReference Document Number J_1I_REFDOC_NOCHAR10CHAR10
REFDOC_ITEMReference Document Item J_1I_REFDOC_ITMNUMC6NUMC6
REFDOC_DTReference Document Date J_1I_REFDOC_DTDATS8DATUM
REFDOC_TYPReference Document Type J_1I_REFDOC_TYPCHAR4CHAR4
REFDOC1_NOReferencing Document1 Number J_1I_REFDOC1_NOCHAR10CHAR10
REFDOC1_ITEMReferencing Document1 Item J_1I_REFDOC1_ITMNUMC6NUMC6
REFDOC1_TYPReference Document1 Category J_1I_REFDOC1_TYPCHAR4CHAR4
VALUEReference Document Value in Document Currency J_1I_REFDOC_VALCURR15(2) WERTV8
DOC_ITEMCURCurrency J_1IEXCCURCUKY5TCURCWAERS
WKURSExchange Rate WKURSDEC9(5) EXCRTKURSP
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
MENGEQuantity of Materials J_1ILICMENGEQUAN13(3) MENG13
MEINSUnit of Measure J_1IMEINSUNIT3T006CUNITMEINS
FOB_VALFree on Board Value J_1I_FOB_VALCURR15(2) WERTV8
REF_INV_FRT_VALFreight Value J_1I_FRT_VALCURR13(2) WERT7
REF_INV_INS_VALInsurance Value J_1I_INS_VALCURR13(2) WERT7
REF_INV_COMM_VALCommision Value J_1I_COMM_VALCURR13(2) WERT7
REF_INV_DISC_VALDiscount Value J_1I_DISC_VALCURR13(2) WERT7
REF_INV_OTH_VALOthers Value J_1I_OTH_VALCURR13(2) WERT7
REF_INV_DED_VALDeductions Value J_1I_DED_VALCURR13(2) WERT7
EXP_TAR_NOExport Tariff Item Number J_1I_TARIFF_SHPCHAR30CHAR30
MARK_NOMark Number J_1I_MARK_NOCHAR20CHAR20
PACK_KINDKind of Pack J_1I_PACK_KINDCHAR20CHAR20
CONTAINER_NOContainer Number J_1I_CONT_NOCHAR10CHAR10
CONT_SIZEContainer Size J_1I_CONT_SIZENUMC5NUMC5
EXCISE_SL_NOExcise Seal Number J_1I_EXCISE_NOCHAR16CHAR16
NO_PACKPack Number J_1I_PACK_NOINT25INT2
EXCISE_DTExcise Date J_1I_EXCISE_DTDATS8DATUM
ASS_VALAssessable Value J_1I_ASS_VALCURR13(2) WERT7
DUTY_RATEDuty Rate J_1I_DUTY_RATEDEC5(2) J_1I_RATE_ENTT
DUTY_VALDuty Value J_1I_DUTY_VALCURR13(2) WERT7
CESS_RATECess Rate J_1I_CESS_RATEDEC5(2) J_1I_RATE_ENTT
CESS_VALCess Value J_1I_CESS_VALCURR13(2) WERT7
DBK_QTYDuty Drawback Quantity J_1I_DBK_QTYQUAN13(3) MENG13
DBK_FOB_VALFree on Board Value J_1I_FOB_VALCURR15(2) WERTV8
DBK_VALDuty Drawback Value J_1I_DBK_VALCURR15(2) WERTV8
DBK_POST_VALDuty Drawback Posting Value in Local Currency J_1I_DBK_POSTVALCURR15(2) WERTV8
DBK_POST_VAL_FDuty Drawback Posting Value in Local Currency J_1I_DBK_POSTVALCURR15(2) WERTV8
DBK_CUS_RATEDuty Drawback Custom Rate J_1I_DBK_CUST_RATEDEC5(2) J_1I_RATE_ENTT
DBK_CUST_VALDuty Drawback Custom Value J_1I_DBK_CUST_VALCURR13(2) WERT7
DBK_EXC_RATEDuty Drawback Excise Rate J_1I_DBK_EXC_RTDEC5(2) J_1I_RATE_ENTT
DBK_EXC_VALDuty Drawback Excise Value J_1I_DBK_EXC_VALCURR13(2) WERT7
LCURRLocal Currency J_1I_LCURRCUKY5TCURCWAERS
SHPL_TYPEShipper's Letter of Instruction Type J_1ISHPL_TYPECHAR3J_1ISHPL_TYPE
DIMENSIONDimension J_1IDIMENSIONCHAR20CHAR20
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
BOL_NOBill of Lading Number J_BOL_NOCHAR10CHAR10
BOL_DTBill of Lading Date J_1I_BOL_DTDATS8DATUM
EXP_RELZ_DATEExport Realisation Date J_1I_EXP_RELZ_DATEDATS8DATUM
BNK_REF_NOBank Reference Number J_1I_BNK_REFCHAR15CHAR15
REF_CURRCurrency Key WAERSCUKY5TCURCWAERSFWS
CREA_DATE_TIMECreated Time J_1I_CRTD_ATCHAR14TIMESTAMP
CREA_UNAMECreated by J_1I_CRTD_BYCHAR12UNAME
LCHG_DATE_TIMEChanged Time J_1I_CHNGD_ATCHAR14TIMESTAMP
LCHG_UNAMEChanged By J_1I_CHNGD_BYCHAR12UNAME
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
SAN_READ_ONLY_REFGeneral Flag FLAGCHAR1FLAG

Key field Non-key field



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

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

How to access SAP table J_1I_STR_SANDTL

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