Data Mapping Worksheet (EDI 315 -> GTS IDOC)     EDI 315 will update a corresponding Customs Shipment in GTS using the Ocean Bill of Lading Number and  Container Number as the matching key. If the other data elements are not mapped, no need to send IDOC to GTS.              
EDI 315 - Status Details (Ocean) Create one IDOC per 315 Transaction.
Mapping Definitions  
  Source       Destination   Functional Comments
  EDI 315 Status Details (Ocean)[1]       SAP IDOC /SAPSLL/CCECUS01 [2]     EDI Sourcing Condition[3] Valid Values[4] Nullable?
(N or Y or leave blank)[5]		 GTS Function Module Procedures[6]
Item Table Name[7] Field Name[8] Position Number Format Description IDOC Name[9] Description Business Rule Logic / Conversion Logic / Default[10]      
1 315 ST01  010 String(3) Transaction Set /SAPSLL/E1CCEHD_CNTRL-CUMES Message Type Conversion:
If ST01 = '315', /SAPSLL/E1CCEHD_CNTRL-CUMES = 'Z315I'.		   MANDATORY. Reject EDI transmission if blank or not = '315'.
2 315 N902  031 String(3) Importer of Record No Mapping. Just used for filter. Importer of Record For GL2- If N901 = 'IC' (Importer or Record), filter N902 by:
    BBW Bath & Body Works
    VSB Victoria Secret Beauty
    BTA Beauty Avenues 
For GL3- additional division codes:
    MST = Mast Industries
    MFE = Mast Far East
    MII = Mast Industries		 MANDATORY. Used for filter. No update in GTS.   
3 315 N902  031 String(30) Max 11 Ocean Bill of Lading /SAPSLL/E1CCEHDO-PAPNO Ocean Bill of Lading Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY= 'ZDC004' (Master Air Waybill Number  / Ocean Bill of Lading Number)[11]		 If N901 = 'BM' (Ocean Bill of Lading OBOL) Destination Field: /SAPSLL/LEGDOC-PAPNO
Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type  'ZDC004' Master Air Waybill Number  / Ocean Bill of Lading Number)
IDOC function module modification(s): An EDI 315 uses the OBOL & Container		 Per Carol, there will only be one House Bill  (HAWB) per Customs Shipment. The HAWB, as well as the Master Airway Bill (MAWB),  will be posted at the header level (Document/Evidence Tab) and will apply for each Customs Shipment item. A Customs Shipment ca
4 315 Concatenate B407 + B408  020 String(30)   Container Number /SAPSLL/E1CCEHDO-PAPNO Container Number Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY= 'ZDC020' (Container Number)[12]		   Destination Field: /SAPSLL/LEGDOC-PAPNO
Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type  'ZDC020' (Container Number)
IDOC function module modification(s): An EDI 315 uses the OBOL & Container Number to match against Customs Shipme		 1/12/2006 - Per Marilyn Magin / EDI Summit, use all B401 qualifiers (CC, CF, CH, ZZ).
5 315 N902  031 String(30) Max 11 Reference Identification: In Transit Number /SAPSLL/E1CCEHDO-PAPNO In Transit Number Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY='ZDT001' (In Transit Number/Date)[13]		 If N901 = 'IB' In Transit Number Destination Field: /SAPSLL/LEGDOC-PAPNO
Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type  'ZDT001' In Transit Number/Date)
IDOC function module modification(s): None.
Error Handling: Optional. If N901 = 'IB' In Transit Number, In-T		  
6 315 N904  030 String(8) CCYYMMDD In-Transit Date /SAPSLL/E1CCEHDO-PAPDT In Transit Date Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY='ZDT001' (In Transit Number/Date)[14]		 If N901 = 'IB' In-Transit Date Destination Field: /SAPSLL/LEGDOC-PAPDT
Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT001' In Transit Number/Date)
IDOC function module modification(s): None.
Error Handling: Optional. Field format is YYYYMMDD.		 8/18/2005 Mapping per Sree Veerapalli.
1/12/2006 Per Carol Marteney, no mapping for Time & Time zone.
7 315 N902  031 String(30) Max 30 FIRMS Code /SAPSLL/E1CCEHDO-PAPNO Location of Goods (FIRMS Code) Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY='ZDC001' (Location of Goods (FIRMS Code))[15]		 If N901 = 'ALC' FIRMS Code Destination Field: /SAPSLL/LEGDOC-PAPNO
Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC001' Location of Goods (FIRMS Code))
IDOC function module modification(s): None.
Error Handling: Optional. If N901 = 'ALC', FIRMS Code is 		 8/18/2005 Per Marilyn Magin, Will provide identification qualifier.
12/12/2005 Per Sree Veerapalli, use code 'ALC' for FIRMS Code.
8 315 B404  020 String(8) CCYYMMDD Arrival DATE of vessel at stateside Port of Discharge /SAPSLL/E1CCEHDO-PAPDT Import Date Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY='ZDT002' (Import Date)[16]		 If B403 = 'VA' (Vessel Arrival) then B404 = Import Date  Destination Field: /SAPSLL/LEGDOC-PAPDT
Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', 'ZDT002' Import Date)
IDOC function module modification(s): None.
Error Handling: Optional.If B403 = 'VA' (Vessel Arrival) then B404 Import Date is r		  
9 315 B405 020 String(8) HHMMSS Arrival Time of vessel at stateside Port of Discharge /SAPSLL/E1CCEHDO-PAPAD Import Time See above See above Destination Field: /SAPSLL/LEGDOC-PAPAD
Location: Documents/Evidence Tab-> Add. Data (Type of Document 'HDOC', 'ZDT002' Import Date)
IDOC function module modification(s): None.
Error Handling: Optional. Format HHMMSS TZ.		 1/12/2006 Added to mapping per Carol Marteney
10 315 *Port code look up table in GIS/XI to populate time zone field 020 String(2)
Example 'ET', 'CT', 'PT', etc		 Arrival Time Zone of vessel at stateside Port of Discharge /SAPSLL/E1CCEHDO-PAPAD *Note: Concatenate with above. Import Time Zone See above See above Destination Field: /SAPSLL/LEGDOC-PAPAD
Location: Documents/Evidence Tab-> Add. Data (Type of Document 'HDOC', 'ZDT002' Import Date)
IDOC function module modification(s): None.
Error Handling: Optional. Format HHMMSS TZ.		 1/12/2006 Added to mapping per Carol Marteney.
1/19/2006 Per Sree Veerapalli, use port code look up table in GIS/XI to populate time zone field.
11 315 B404  020 String(8) CCYYMMDD Actual Arrival Date at Port of Entry /SAPSLL/E1CCEHDO-PAPDT Actual Arrival Date at Port of Entry Default:
/SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document)
/SAPSLL/E1CCEHDO-PAPTY='ZDT004' (Actual Arrival Date at Port of Entry)[17]		 If B403 = 'K' (Arrived at Customs) then B404 = Actual Arrival Date at Port of Entry Destination Field: /SAPSLL/LEGDOC-PAPDT
Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', 'ZDT004' Actual Arrival Date)
IDOC function module modification(s): None.
Error Handling:  Optional. If B403 = 'K' then B404 Actual Arrival Date at P		 1/12/2006 - Per Carol Marteney, use new qualifier if B403 = 'K' .
12 315 B405 020 String(8) HHMMSS Actual Arrival Time at Port of Entry /SAPSLL/E1CCEHDO-PAPAD Actual Arrival Time at Port of Entry See above See above Destination Field: /SAPSLL/LEGDOC-PAPAD
Location: Documents/Evidence Tab-> Add. Data (Type of Document 'HDOC', 'ZDT004' Actual Arrival Date)
IDOC function module modification(s): None.
Error Handling: Optional.  If B403 = 'K' then B404 Actual Arrival Time		 1/12/2006 Added to mapping per Carol Marteney
13 315 *Port code look up table in GIS/XI to populate time zone field 020 String(2)
Example 'ET', 'CT', 'PT', etc		 Actual Arrival Time Zone at Port of Entry /SAPSLL/E1CCEHDO-PAPAD *Note: Concatenate with above. Actual Arrival Time Zone at Port of Entry See above See above Destination Field: /SAPSLL/LEGDOC-PAPAD
Location: Documents/Evidence Tab-> Add. Data (Type of Document 'HDOC', 'ZDT004' Actual Arrival Date)
IDOC function module modification(s): None.
Error Handling: Optional.  If B403 = 'K' then B404 Actual Arrival Time		 1/12/2006 Added to mapping per Carol Marteney.
1/19/2006 Per Sree Veerapalli, use port code look up table in GIS/XI to populate time zone field.
Note: Per Marilyn Magin 1/12/2006, ETA is not in 315. Use 856 ETA.
[1]
Aaron Rorstrom:
"Required"
Record the name of the source system
[2]
Aaron Rorstrom:
"Required"
Record the name of the destination system
[3]
Aaron Rorstrom:
"Required" if applicable
Record the condition, if any, in which the source will upate the destination.
[4]
Aaron Rorstrom:
"Required" if applicable
Record the list of acceptable values or a document that specifies the accaptable values.
[5]
Aaron Rorstrom:
"Required" if applicable
[6]
Aaron Rorstrom:
"Optional"
[7]
Aaron Rorstrom:
"Required"
[8]
Aaron Rorstrom:
"Required"
A field name recorded in this column should be defined on one of the DB & Fld Defs worksheets.
[9]
Aaron Rorstrom:
"Required"
[10]
Aaron Rorstrom:
"Optional"
[11]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[12]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[13]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[14]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[15]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[16]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.
[17]
Jan Michael Bundalian:
Structure /SAPSLL/E1CCEHDO has the following fields:
QALDOC - ECC Type of Document
PAPTY - ECC: Type of (Preliminary) Document
PAPNO - ECC: Number of (Preliminary) Document
PAPAD - ECC: Additional (Previous) Document
PAPDT - ECC: Date of (Preliminary) Document
PAPIT - ECC: Item of (Preliminary) Document
PAPPC - ECC: Quantity of (Preliminary) Document

Fields QALDOC, PAPTY and PAPDT are required. Field PAPDT is optional. Default PAPIT & PAPPC to blank.