J_1I_STR_SHIPHDR SAP (Structure for Shipping bill header) Structure details
Description: Structure for Shipping bill header
Related tables to J_1I_STR_SHIPHDR
Access table J_1I_STR_SHIPHDR
Structure field list including key, data, relationships and ABAP select examples
J_1I_STR_SHIPHDR 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 Shipping bill header" 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_SHIPHDR TYPE J_1I_STR_SHIPHDR.
The J_1I_STR_SHIPHDR table consists of various fields, each holding specific information or linking keys about Structure for Shipping bill header data available in SAP. These include MANDT (Client), DOC_NO (Document Number), DOC_TYPE (Document ID), DOC_DT (Document Date).. 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_SHIPHDR 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
DOC_NO | Document Number | J_1I_DOC_NO | NUMC | 10 | J_1I_DOC_NO | ||||
DOC_TYPE | Document ID | J_1I_EXIM_DOCID | CHAR | 4 | Assigned to domain | J_1I_EXIM_DOCUMENT_ID | |||
DOC_DT | Document Date | J_1I_DOC_DATE | DATS | 8 | DATS | ||||
DOC_EXT_NO | External Document Number | J_1I_DOC_EXT_NO | CHAR | 35 | CHAR35 | ||||
GUID | Application GUID | J_1I_EXIM_APPGUID | CHAR | 22 | SYSUUID_22 | ||||
SHIPTYPE | Document Type | J_1I_EXIM_DOCTYPE | CHAR | 3 | J_1I_EXIM_DOC_TYPE | ||||
EXPORTER | Exporter | J_1I_EXPORTER | CHAR | 4 | T001 | BUKRS | |||
CONSIGNEE | Consignee | J_1I_CONSIGNEE | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
DOCCUR | Currency | J_1IEXCCUR | CUKY | 5 | TCURC | WAERS | |||
KKURS | Exchange Rate | J_1I_KKURS | DEC | 9(2) | J_1I_KKURS | ||||
INV_VAL | Invoice Value | J_1I_INV_VAL | CURR | 15(2) | WERTV8 | ||||
FOB_VAL | Free on Board Value | J_1I_FOB_VAL | CURR | 15(2) | WERTV8 | ||||
DBK_VAL | Duty Drawback Value | J_1I_DBK_VAL | CURR | 15(2) | WERTV8 | ||||
DBK_POST_VAL | Duty Drawback Posting Value in Local Currency | J_1I_DBK_POSTVAL | CURR | 15(2) | WERTV8 | ||||
SHP_TY | Shipping Bill Type | J_1I_SHP_TY | CHAR | 3 | J_1I_SHP_TY | ||||
STATUS | Shipping Bill Status | J_1IDOCSTAT | CHAR | 1 | Assigned to domain | J_1I_APP_STAT | |||
REJ_REASON | Description of EXIM | J_1I_EXIM_DESCR | CHAR | 255 | J_1I_EXIM_DESCR | ||||
SCHM_CODE | Scheme Code | J_1I_SCHM_CODE | CHAR | 5 | J_1I_SCHM_MASTER | J_1I_SCHM_CODE | |||
REG_PORT | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
PORT_LOAD | Loading Port | J_1I_PORT_LOAD | CHAR | 4 | T001W | WERKS | H_T001W | ||
PORT_DISCH | Discharging Port | J_1I_PORT_DISCH | CHAR | 4 | T001W | WERKS | H_T001W | ||
CHA_NO | Custom House Agent Number | J_1I_CHA_NO | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
EXP_DT | Export Date | J_1I_EXP_DATE | DATS | 8 | DATS | ||||
LEO_DT | Export Order Date | J_1I_LEO_DATE | DATS | 8 | DATS | ||||
PRNT_DT | Document Print Date | J_1I_PRNT_DATE | DATS | 8 | DATS | ||||
TRNS_TY | Transport Type | J_1I_TRNS_TY | CHAR | 4 | J_1I_TRNS_TY | ||||
LAND1 | Country of Destination | LLAND | CHAR | 3 | Assigned to domain | LAND1 | VLL | ||
FAWREF | Accounting Document | J_1IFAWREF | CHAR | 10 | ALPHA | AWREF | |||
FAWTYP | Object type of calling application (FI) | J_1IFAWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
FABLART | Document Type | BLART | CHAR | 2 | Assigned to domain | BLART | BAR | ||
FAYEAR | Financial posting year | J_1IFAYEAR | NUMC | 4 | NUMC4 | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
VESSEL | Bill of Lading Vessel | J_1I_BILVESSEL | CHAR | 100 | CHAR100 | ||||
BILLAD_DATE | Bill of Lading Date | J_1I_BILDATE | DATS | 8 | DATUM | ||||
FREIGHT_DATE | Date | DATUM | DATS | 8 | DATUM | ||||
FREIGHT_ADV | EXIM: PM Bill of lading Freight Advance | J_1I_FREIGHTADV | CURR | 13(2) | WERT7 | ||||
FREIGHTPAY | Freight Payable | J_1I_FRTPAYAT | CHAR | 30 | CHAR30 | ||||
BSLNO | Bills of Lading Number | J_1I_BSLNO | CHAR | 15 | CHAR15 | ||||
EXCUR | Currency | J_1IEXCCUR | CUKY | 5 | TCURC | WAERS | |||
CO_TYPE | Certificate of Origin Type | J_1ICO_TYPE | CHAR | 1 | J_1ICO_TYPE | ||||
MAT_PROD_IN | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
COUNTRY_IMP | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
CREA_DATE_TIME | Created Time | J_1I_CRTD_AT | CHAR | 14 | TIMESTAMP | ||||
CREA_UNAME | Created by | J_1I_CRTD_BY | CHAR | 12 | UNAME | ||||
LCHG_DATE_TIME | Changed Time | J_1I_CHNGD_AT | CHAR | 14 | TIMESTAMP | ||||
LCHG_UNAME | Changed By | J_1I_CHNGD_BY | CHAR | 12 | UNAME | ||||
BOE_TYPE | Bill of Exchange Type | J1I_BOETYP | CHAR | 1 | J1I_BOETYP | ||||
HOUSE_BANK_ID | Short Key for a House Bank | HBKID | CHAR | 5 | T012 | HBKID | |||
EXCHNG_RATE | Exchange Rate | WKURS | DEC | 9(5) | EXCRT | KURSP | |||
EXCHNG_RATE_DATE | Exhange Rate Date | J_1I_EXCHNG_DATE | DATS | 8 | DATUM | ||||
REF_CURR | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
CONT_NO | Comment | CHAR50 | CHAR | 50 | TEXT50 | ||||
CONT_SIZE | Comment | CHAR50 | CHAR | 50 | TEXT50 | ||||
EXCS_SEAL_NO | Comment | CHAR50 | CHAR | 50 | TEXT50 | ||||
CONT_DT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
DATA1 | 0 | ||||||||
DATA2 | 0 | ||||||||
DATA3 | 0 | ||||||||
DATA4 | 0 | ||||||||
DATA5 | 0 | ||||||||
DATA6 | 0 | ||||||||
DATA7 | 0 | ||||||||
DATA8 | 0 | ||||||||
DATA9 | 0 | ||||||||
DATA10 | 0 | ||||||||
EXPORTER_C | Exporter | J_1I_EXPORTER | CHAR | 4 | T001 | BUKRS | |||
EXPORTER_N | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
EXP_ADD1 | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
EXP_ADD2 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
EXP_ADD3 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
EXP_ADD4 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
EXP_CITY | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
EXP_PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
EXP_CNTY | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
EXP_ADDRESS | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
CONSIGNEE_C | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
CONSIGNEE_N | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
CONSG_ADD1 | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
CONSG_ADD2 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
CONSG_ADD3 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
CONSG_ADD4 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
CONSG_ADD5 | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
CONSG_CITY | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
CONSG_PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
CONSG_CNTY | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
CONSG_ADDRESS | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
CHA_C | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
CHA_N | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
CHA_ADD1 | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
CHA_ADD2 | Name 2 | AD_NAME2 | CHAR | 40 | TEXT40 | ||||
CHA_CITY | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
CHA_PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
CHA_CNTY | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
BANK_C | Name of bank | BANKA | CHAR | 60 | TEXT60 | ||||
BANK_N | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
BANK_ADD1 | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
BANK_ADD2 | Name 2 | AD_NAME2 | CHAR | 40 | TEXT40 | ||||
BANK_CITY | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
BANK_PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
BANK_CNTY | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
EXPORTER_ADD | 0 | ||||||||
CONSIGNEE_ADD | 0 | ||||||||
FORM | Attribute Value | J_1I_EXIM_VALUE | CHAR | 50 | CHAR50 | ||||
INV_NO | Character 100 | CHAR100 | CHAR | 100 | CHAR100 | ||||
INV_DT | Character 100 | CHAR100 | CHAR | 100 | CHAR100 | ||||
SB_NO | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
SB_DT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
AR4_NO | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
AR4_DT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
QCERT_NO | Character Field Length = 10 | CHAR10 | CHAR | 10 | CHAR10 | ||||
QCERT_DT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
ETC | Comment | CHAR50 | CHAR | 50 | TEXT50 | ||||
LICNO | 30 Characters | CHAR30 | CHAR | 30 | CHAR30 | ||||
PRE_CRG | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
PLACE_PRE_CRG | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
FLIGHT_NO | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
ROTATION_NO | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
DEST_CNTRY | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
CONTR_NAT_CIF | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
CONTR_NAT_CFR | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
CONTR_NAT_FOB | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
CONTR_NAT_OTH | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
CONTR_NAT_OTH_T | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
IEC_NO | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
RBI_NO | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
RBI_APPR_NO | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
RBI_APPR_DT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
EXP_UND2 | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
EXP_UND3 | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
EXP_UND4 | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
NET_WT | Net weight | NTGEW_15 | QUAN | 15(3) | MENG15 | ||||
GROSS_WT | Total Weight | GSGEW | QUAN | 15(3) | MENG15 | ||||
GEWEI | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
TOT_FOB_WORDS | 0 | ||||||||
INS_RATE | Entitlement Rate | J_1I_RATE_ENTT | DEC | 5(2) | J_1I_RATE_ENTT | ||||
COMM_RATE | Entitlement Rate | J_1I_RATE_ENTT | DEC | 5(2) | J_1I_RATE_ENTT | ||||
DISC_RATE | Entitlement Rate | J_1I_RATE_ENTT | DEC | 5(2) | J_1I_RATE_ENTT | ||||
OTH_RATE | Entitlement Rate | J_1I_RATE_ENTT | DEC | 5(2) | J_1I_RATE_ENTT | ||||
DED_RATE | Entitlement Rate | J_1I_RATE_ENTT | DEC | 5(2) | J_1I_RATE_ENTT | ||||
CURR | Currency | J_1IEXCCUR | CUKY | 5 | TCURC | WAERS | |||
FRT_VAL | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
INS_VAL | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
COMM_VAL | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
DISC_VAL | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
OTH_VAL | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
DED_VAL | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
TOT_DUTY_CESS_WORDS | 0 | ||||||||
TOT_DBK_WORDS | 0 | ||||||||
DOC_SG | Shipping Bill/GR Form | J_1I_DOC_SG | CHAR | 2 | J_1I_DOC_SG | ||||
STATUS_DT | Application Status Date | J_1I_STATUS_DATE | DATS | 8 | DATS | ||||
WI_ID | Work item ID | SWW_WIID | NUMC | 12 | Assigned to domain | SWW_WIID | WID | ||
SHP_TY1 | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
SHP_TY2 | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
SHP_TY3 | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
SHP_TY_T | Char 20 | CHAR20 | CHAR | 20 | CHAR20 | ||||
EXCH_RATE | Entitlement Rate | J_1I_RATE_ENTT | DEC | 5(2) | J_1I_RATE_ENTT | ||||
SCHM_DESC | Scheme Description | J_1I_SCHM_DESCR | CHAR | 50 | J_1I_SCHM_DESCR | ||||
PLANT_DESC | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
PORT_LOAD_NAME | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
PORT_DISC_NAME | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
NOTES | 0 | ||||||||
LENGTH | iSeries: Table field length | LENGTH | INT4 | 10 | QINT4 |
Key field | Non-key field |
How do I retrieve data from SAP structure J_1I_STR_SHIPHDR using ABAP code?
As J_1I_STR_SHIPHDR 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_SHIPHDR as there is no data to select.How to access SAP table J_1I_STR_SHIPHDR
Within an ECC or HANA version of SAP you can also view further information about J_1I_STR_SHIPHDR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects