| Data Mapping Worksheet ( | |||||||||||||||
| EDI 856 (Events 3 & 4) - Advanced Shipping Notification / Manifest | |||||||||||||||
| Mapping Definitions | |||||||||||||||
| Source | Destination | ||||||||||||||
| EDI 856[1] | SAP IDOC /SAPSLL/CCECUS01)[2] | 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 | Format | Description | IDOC Name[9] | Format | GTS Table-Field Name | Business Rule Logic / Conversion Logic / Default[10] | ||||||
| 1 | 856 | ST01-143 | 010 | String(3) | Transaction Set | /SAPSLL/E1CCEHD_CNTRL-CUMES | Conversion: If ST01-143 = '856', /SAPSLL/E1CCEHD_CNTRL-CUMES = 'Z856I'.[11] |
MANDATORY. Reject EDI transmission if blank or not = '856'. | MANDATORY. Reject EDI transmission if blank or not = '856'. | ||||||
| 2 | 856 | ISA06 | String(20) | Freight Forwarder / Consolidator | /SAPSLL/E1CCEHPA-CUSTV | Default: /SAPSLL/E1CCEHPA-PATYP='CUSFRW' Freight Forwarder |
MANDATORY. | Destination Field: /SAPSLL/CORPAR-PARNO Location: Customs Shipment-> Partner Tab -> 'CUSFRW' Business Partner (Freight Forwarder/Consolidator) IDOC function module modification(s): 1. Convert legacy EDI Code -> legacy Partner Code -> R3 Vendor Number -> |
|||||||
| 3 | 856 | BSN01 | 020 | ID 2/2 | Transaction Set Purpose Code | /SAPSLL/E1CCEHD_CNTRL-MSGFN | Conversion: If BSN01 = ' 00' Original, /SAPSLL/E1CCEHD_CNTRL-MSGFN = 'ORI'. If BSN01 = ' 03' Delete, /SAPSLL/E1CCEHD_CNTRL-MSGFN = 'CAN'. If BSN01 = ' 05' Replace, /SAPSLL/E1CCEHD_CNTRL-MSGFN = 'REP'. |
MANDATORY.
Code identifying purpose of transaction set. Reject if not in the following
list of valid codes: 00 Original 03 Delete 05 Replace |
Per
EDI Summit on 1/12/2006 EDI 856 Transaction Set Purpose Codes and corresponding processes in GTS: o 00 Original A new Customs Shipment will be created o 03 Delete Customs Shipment will be set to Cancelled o 05 Replace Customs Shipment |
||||||
| 4 | 856 | HL01-628 | 010 | AN 1/12 | Hierarchical ID Number-1 | No update in SAP | |||||||||
| 5 | 856 | TD502-66 | 120 | ID 1/2 | Identification Code
Qualifier: Importing Carrier IATA Code |
Event 3:
Ignore. Event 4: If TD502-66 = '4' (IATA), see below. |
Qualifier | ||||||||
| 6 | 856 | TD503-67 | 120 | AN 2/80 | Identification Code: Importing Carrier IATA Code |
Event 3:
Ignore. Event 4: /SAPSLL/E1CCEHD_TPR-VIDAR |
Char(35) | Event 3: Ignore. Event 4: /SAPSLL/LEGTPR-VIDAR |
Event 3:
Ignore. Event 4: If TD502-66 = '4' (IATA), then /SAPSLL/E1CCEHD_TPR-VIDAR = TD503-67 |
Event 3:
Ignore. Event 4: MANDATORY. |
Destination Field: /SAPSLL/LEGTPR-VIDAR Location: Customs Shipment -> Transport Tab -> MoT at Arrival (Importing Carrier IDOC function module modification(s): None. Error Handling: Event 4 (TD504-91 = 'A' Air or 'SE' Sea/Air or 'ZZ' deferred Air) - Fatal |
||||
| 7 | 856 | TD504-91 | 120 | ID 1/2 | Transportation Method/Type
Code (Mode of Transportation) |
/SAPSLL/E1CCEHD_TPR-MOTBC | Char(2) | /SAPSLL/LEGTPR-MOTBC | Event 3:
If TD504-91 = 'S' (Sea), then /SAPSLL/E1CCEHD_TPR-MOTBC = '11' (Vessel,
container). Event 4: If TD504-91 = 'A' (Air) or 'SE' (Sea/Air) or 'ZZ' (Deferred Air), then /SAPSLL/E1CCEHD_TPR-MOTBC = '40' (Air, non-container). |
Event 3: MANDATORY. Event 4: MANDATORY. |
Destination Field: /SAPSLL/LEGTPR-MOTBC Location: Customs Shipment -> Transport Tab -> Type (across 'MoT Border') IDOC function module modification(s): Validation 1. Select /SAPSLL/CUCMOT (SLL: Type of Means of Transport) where CUSCS = 'CUSUS' MOT |
||||
| 8 | 856 | TD507-309 | 120 | ID 1/2 | Location Qualifier: Port of Entry Foreign Port of Lading US Port of Unlading |
See below | Qualifier | ||||||||
| 9 | 856 | TD508-310 | 120 | AN 1/30 | Location Identifier: Port of Entry ------------------------ Foreign Port of Lading ------------------------ US Port of Unlading |
Port of Entry:
/SAPSLL/E1CCEHPA-CUTID ------------------------ Foreign Port of Lading: /SAPSLL/E1CCEHD_TPR-NODDP ------------------------ US Port of Unlading: /SAPSLL/E1CCEHD_TPR-NODAR |
Char 5 Max | Port of Entry:
/SAPSLL/ADRLRID-PINID ------------------------------ Foreign Port of Lading: /SAPSLL/LEGTPR-NODDP ------------------------------ US Port of Unlading: /SAPSLL/LEGTPR-NODAR |
Port of Entry if TD504-91 = "S" (Ocean) and TD507-309= "PE", then TD508-310 = Schedule K Port Code (populate /SAPSLL/E1CCEHPA-CUTID); if TD504-91 = 'A' (Air) or 'SE' (Sea/Air) or 'ZZ' (Deferred Air) and TD507-309= "PE", then TD508-310 = IATA Port Code (p |
Port of Entry: MANDATORY ------------------------------ Foreign Port of Lading: MANDATORY ------------------------------ US Port of Unlading: MANDATORY |
Port of Entry Destination Field: /SAPSLL/CORPAR-PARNO Location: Customs Shipment-> Transport Tab-> Customs Offices -> Inbound. (Actual Port Code is maintained in Customs Office Number transaction.) IDOC function module modification(s): 1. Read /SAPSLL/AD |
||||
| 10 | 856 | TD302-206 | 130 | AN 1/4 | Equipment Initial: Container Number Prefix | Event 3: /SAPSLL/E1CCEHDO-PAPNO Event 4: Ignore.[12] |
Char(15), First 4 digits | /SAPSLL/LEGDOC-PAPNO | Event 3: If TD504-91 not = 'S', then no mapping for TD302-206 & TD302-207. If TD504-91 = 'S' (Sea), then /SAPSLL/E1CCEHDO-PAPNO = Concatenated TD302-206 & TD303-207 (Container Number). Default: /SAPSLL/E1CCEHDO-QALDOC = 'HDOC' /SAPSLL/E1CCEHDO-PAPTY = 'Z |
Event 3: MANDATORY. Reject EDI transmission if blank. Event 4: Ignore. |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC020' Container Number) IDOC function module modification(s): Allow multiple container numbers. Error Handling: Event 3(TD504-91 = 'S' Sea) |
||||
| 11 | 856 | TD303-207 | 130 | AN 1/10 | Equipment Number: Container Number | Event 3: /SAPSLL/E1CCEHDO-PAPNO Event 4: Ignore.[13] |
Char(15), last 11 digits | /SAPSLL/LEGDOC-PAPNO | Event 3: If TD504-91 not = 'S', then no mapping for TD302-206 & TD302-207. If TD504-91 = 'S' (Sea), then /SAPSLL/E1CCEHDO-PAPNO = Concatenated TD302-206 & TD303-207 (Container Number). Default: /SAPSLL/E1CCEHDO-QALDOC = 'HDOC' /SAPSLL/E1CCEHDO-PAPTY = 'Z |
Event 3: MANDATORY. Reject EDI transmission if blank. Event 4: Ignore. |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC020' Container Number) IDOC function module modification(s): Allow multiple container numbers. Error Handling: Event 3(TD504-91 = 'S' Sea) |
||||
| 12 | 856 | REF01-128 | 150 | ID 2/3 | Event 3:
Ignore. Event 4: Reference Identification Qualifier: HAWB / MAWB |
Event 3:
Ignore. Event 4: See Business Rule logic. |
Event 3: Ignore. Event 4 - Air: See below ---------------- House Air Waybill Number If TD504-91 = 'A' (Air) or 'SE' (Sea/Air) or 'ZZ' (deferred Air) and REF01-128 = "AW", default: /SAPSLL/E1CCEIDO-QALDOC = 'PDOC' /SAPSLL/E1CCEIDO-PAPTY = 'ZDC008' HAWB/FCR |
Event 3:
Ignore. Event 4: MANDATORY.Reject EDI transmission if blank. |
Qualifier | ||||||
| 13 | 856 | REF02-127 | 150 | AN 1/30 | Event 3:
Ignore. Event 4: Reference Identification: HAWB / MAWB |
Event 3: Ignore. Event 4: /SAPSLL/E1CCEHDO-PAPNO, /SAPSLL/E1CCEIDO-PAPNO (See business rule logic)[14] |
Char(35) | /SAPSLL/LEGDOC-PAPNO | Event 3: Ignore. Event 4 - Air: See below ---------------- House Air Waybill Number If TD504-91 = 'A' (Air) or 'SE' (Sea/Air) or 'ZZ' (deferred Air) and REF01-128 = "AW", SAPSLL/E1CCEIDO-PAPNO = REF02-127 (HAWB). Master Air Waybill Number If TD504-91 = ' |
Event 3:
Ignore. Event 4: MANDATORY. Reject EDI transmission if blank. |
House Air Waybill (HAWB) /
Forwarder's Cargo Receipt (FCR) Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC008' House Airway Bill Number / Forwarder's Cargo Receipt Number) |
||||
| 14 | 856 | DTM01-374 | 200 | ID 3/3 | Date/Time Qualifier | See Business Rule logic. | Export Date If DTM01-374 = '370' (Actual Departure Date) then: /SAPSLL/E1CCEHDO-QALDOC = 'HDOC' /SAPSLL/E1CCEHDO-PAPTY = 'ZDT030' Export Date ---------------- Estimated Arrival Date If DTM01-374 = '371' (Estimated Arrival Date) then: /SAPSLL/E1CCEHDO-QAL |
Export Date:
MANDATORY ---------------- Estimated Arrival Date: MANDATORY |
Qualifier | ||||||
| 15 | 856 | DTM02-373 | 200 | DT 8/8 | Date 8 YYYYMMDD | /SAPSLL/E1CCEHDO-PAPDT | Numeric (YYYYMMDD) | /SAPSLL/LEGDOC-PAPNO | Export Date If DTM01-374 = '370' (Actual Departure Date) then: ----SAPSLL/E1CCEHDO-PAPDT = DTM02-373 (Export Date) ---------------- Estimated Arrival Date If DTM01-374 = '371' (Estimated Arrival Date) then: ----SAPSLL/E1CCEHDO-PAPDT = DTM02-373 (Estima |
Export Date:
MANDATORY ---------------- Estimated Arrival Date: MANDATORY |
Export Date Destination Field: /SAPSLL/LEGDOC-PAPDT Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT030' Export Date) IDOC function module modification(s): None. Error Handling: Fatal error if Export Date is missing. ----------- |
||||
| 16 | 856 | DTM03-337 | 200 | TM 4/8 | Time | /SAPSLL/E1CCEHDO-PAPAD | Numeric (HHMMSS) | /SAPSLL/LEGDOC-PAPAD | Export Time Destination Field: /SAPSLL/LEGDOC-PAPAD Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT030' Export Date) IDOC function module modification(s): None. Error Handling: None. Export Time is optional. ------------------- |
||||||
| 17 | 856 | DTM04 | 200 | ID 2/2 | Time Code | /SAPSLL/E1CCEHDO-PAPAD | Character(2) | /SAPSLL/LEGDOC-PAPAD | Concatenate with Event Time DTM03-337 (see above) | Export Time zone Destination Field: /SAPSLL/LEGDOC-PAPAD Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT030' Export Date ) IDOC function module modification(s): None. Error Handling: None. Export Time zone is optional. ------- |
|||||
| 18 | 856 | N101-98 | 220 | ID 2/3 | Entity Identifier Code: Vessel Name : Importing Carrier | Event 3: See
below. (Importing Carrier) Event 4: Ignore. |
Event 3. If
N101-98 = 'VS' Vessel Name, see below mapping. Event 4. Ignore |
Event 3. MANDATORY Event 4. Ignore |
Qualifier | ||||||
| 19 | 856 | N102-93 | 220 | AN 1/60 | Vessel Name : Importing Carrier | Event 3:
/SAPSLL/E1CCEHD_TPR-VIDAR Event 4: Ignore. (Used to be Importer of Record but moved to Order Level per EDI Summit 1/12/2006) |
Event 3: If N101-98 = 'VS' Vessel Name, /SAPSLL/E1CCEHD_TPR-VIDAR.
Event 4: Ignore. |
Event 3.
MANDATORY Event 4. Ignore |
Destination Field: /SAPSLL/LEGTPR-VIDAR Location: Customs Shipment -> Transport Tab -> MoT at Arrival IDOC function module modification(s): None. Error Handling: Event 3(TD504-91 = 'S' Sea)- Fatal error if missing or blank. |
||||||
| 20 | 856 | HL01-628 | 010 | AN 1/12 | Hierarchical ID Number-2 Order | No update in SAP | |||||||||
| 21 | 856 | PRF01-324 | 050 | AN 1/22 | Purchase Order Number | /SAPSLL/E1CCEIDO-PAPNO [15] |
Char(10) | /SAPSLL/LEGDOC-PAPNO | Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' /SAPSLL/E1CCEIDO-PAPTY='ZDC007' (Purchase Order)[16] |
MANDATORY | Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type'ZDC007' Purchase Order Number) IDOC function module modification(s): Validate that PO is a valid number in SAP (= GTS Customs Do |
||||
| 22 | 856 | TD101-103 | 110 | AN 3/5 | Packaging Code (Manifest Qty UoM) | /SAPSLL/E1CCEIDO-PAPAD[17] | Char 3 Max | /SAPSLL/LEGDOC-PAPAD | If TD101-103 = 'CTN90'
(CTN=Carton, 90=Standard) then default 3 fields: ----/SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) ----/SAPSLL/E1CCEIDO-PAPTY='ZDC013' (Manifest Quantity / UOM) ----/SAPSLL/E1CCEIDO-PAPAD='CT' (Manifest Quantity / UOM)[18] |
MANDATORY | Destination Field: /SAPSLL/LEGDOC-PAPAD Location: Line item -> Documents/Evidence Tab-> Add.Data (Type of Document 'PDOC', Type 'ZDC013' (Manifest Quantity) IDOC function module modification(s): None. Note: This will create one IDOC /SAPSLL/E1CCEIDO recor |
||||
| 23 | 856 | TD102-80 | 110 | N0 1/7 | Lading Quantity (Manifest Qty) | /SAPSLL/E1CCEIDO-PAPNO[19] | Numeric 10 | /SAPSLL/LEGDOC-PAPNO | If TD101-103 = 'CTN90'
(CTN=Carton, 90=Standard) then default 3 fields: ----/SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) ----/SAPSLL/E1CCEIDO-PAPTY='ZDC013' (Manifest Quantity / UOM) ----/SAPSLL/E1CCEIDO-PAPAD='CT' (Manifest Quantity / UOM)[20] |
MANDATORY | Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC013' (Manifest Quantity) IDOC function module modification(s): None. Note: This will update the same IDOC /SAPSLL/E1CCEIDO re |
||||
| 24 | 856 | TD107-81 | 110 | R 1/10 | Gross Weight | /SAPSLL/E1CCEIT-WEIGRO | Numeric 19(3decimals) | /SAPSLL/CUIT-WEIGRO_FLT | If TD106-187
= 'G' (Gross Weight), then /SAPSLL/E1CCEIT-WEIGRO = TD107-81. Need to translate in GTS. |
MANDATORY | Destination Field: /SAPSLL/CUIT-WEIGRO_FLT Location: Line Item > General Data tab > Quantities and Weights > Gross Weight IDOC function module modification(s): Convert to KG. See further details on Net Weight conversion (down below). Error Handling: None. |
||||
| 25 | 856 | TD108-355 | 110 | ID 2/2 | Unit or Basis for Measurement Code | /SAPSLL/E1CCEIT-WEIDIM | Char(3) | /SAPSLL/CUIT-WEIDIM | Need to translate in GTS. | MANDATORY | Destination Field: /SAPSLL/CUIT-WEIDIM Location: Line Item > General Data tab > Quantities and Weights > Unit of Measure of Net Weight IDOC function module modification(s): None. Error Handling: Fatal error if weight Unit of Measure is missing. * Note: Th |
||||
| 26 | 856 | REF01-128 | 150 | ID 2/3 | Reference Identification
Qualifier: OBOL / FCR |
Event 3: See Business Rule logic. Event 4: Ignore. |
Event 3 - Ocean. Forwarder's Cargo Receipt Number If TD504-91 = 'S' (Ocean) and REF01-128 = "AW", default: /SAPSLL/E1CCEIDO-QALDOC = 'PDOC' /SAPSLL/E1CCEIDO-PAPTY = 'ZDC008' HAWB/FCR ---------------------- Ocean Bill of Lading Number If TD504-91 = 'S' (Oc[21] |
Event 3: OBOL/FCR- MANDATORY. Reject EDI
transmission if blank. Event 4: Ignore. |
Qualifier | ||||||
| 27 | 856 | REF02-127 | 150 | AN 1/30 | Reference Identification: OBOL / FCR |
Event 3: /SAPSLL/E1CCEHDO-PAPNO, /SAPSLL/E1CCEIDO-PAPNO (See business
rule logic). Event 4: Ignore.[22] |
Char(35) | /SAPSLL/LEGDOC-PAPNO | Event 3 - Ocean. Forwarder's Cargo Receipt Number If TD504-91 = 'S' (Ocean) and REF01-128 = "AW", SAPSLL/E1CCEIDO-PAPNO = REF02-127 (HAWB/FCR). ---------------------- Ocean Bill of Lading Number If TD504-91 = 'S' (Ocean) and REF01-128 = "AO", SAPSLL/E1CC[23] |
Event 3: OBOL/FCR- MANDATORY. Reject EDI
transmission if blank. Event 4: Ignore. |
House Air Waybill (HAWB) /
Forwarder's Cargo Receipt (FCR) Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC008' House Airway Bill Number / Forwarder's Cargo Receipt Number) |
||||
| 28 | 856 | N101-98 | 220 | ID 2/3 | Entity Identifier Code | /SAPSLL/E1CCEHPA-PATYP | If N103-66 = 'IM', /SAPSLL/E1CCEHPA-PATYP = 'CUSHAV' (Principal) | Qualifier | |||||||
| 29 | 856 | N104-67 | 220 | AN 2/80 | Identification Code | /SAPSLL/E1CCEHPA-CUSTV | If N103-66 = 'IM', /SAPSLL/E1CCEHPA-CUSTV = N104-67 | Events 3 & 4: MANDATORY For GL2- If N101-98 = 'IM' Importer or Record, filter N104 by: BBW Bath & Body Works BTA Beauty Avenues --------------------------------------------- For GL3, the EDI Hub must consolidate Divi |
Destination Field: /SAPSLL/CORPAR-PARNO Location1: Customs Shipment-> Organization Tab -> Foreign Trade Org Unit 'CUSHAV' Business Partner (Importer of Record) Location2: Customs Shipment-> Partner Tab -> 'CUSEMP' Consignee (Required for ZR202 CF7501 Ent |
||||||
| 30 | 856 | HL01-628 | 010 | AN 1/12 | Hierarchical ID Number-3 Pack | No update in SAP | |||||||||
| 31 | 856 | PRF01-324 | 050 | AN 1/22 | Purchase Order Number | No update in SAP | |||||||||
| 32 | 856 | HL03-735 | 010 | ID 1/2 | Hierarchical Level Code-4 ITEM | No update in SAP | |||||||||
| 33 | 856 | LIN02-235 | 020 | ID 2/2 | Product/Service ID Qualifier: Article Number | If LIN02-235 = 'ST' (Style Number), see below. | MANDATORY | Qualifier | |||||||
| 34 | 856 | LIN03-234 | 020 | AN 1/48 | Product/Service ID: Article Number | /SAPSLL/E1CCEIT-PRVSY | Char(40) | /SAPSLL/CUIT-PRVSY | If LIN02-235 = 'ST', /SAPSLL/E1CCEIT = LIN03-234 | MANDATORY | Destination Field: /SAPSLL/CUIT-GUID_PR Location: Line Item > General Data tab > Product IDOC function module modification(s): 1. Need to get GUID number for the Article number and attach to Customs Shipment line item. Call function module /SAPSLL |
||||
| ***** | |||||||||||||||
| IDOC posting function module in SAP GTS will get the data elements below from other sources (SAP R3 Inbound Delivery, lookup tables). | |||||||||||||||
| 36 | Mandatory. Read from Purchase Order | EKPO-NETPR | Price per Unit | /SAPSLL/E1CCEIQU-ECC_VALUE | Numeric 19(3decimals) | /SAPSLL/LEGCULC-AMNT_ORI | Destination Field: /SAPSLL/LEGCULC-AMT_ORI (POBJT = 'O2', TLC_AART = 'A001',
VALTY = '001') Location: Line Item > Customs Val. Tab > Value of Goods IDOC function module modification(s): Pull Net Price from Purchase Order line item (EKPO-NETPR). 2/20/6 Ca |
||||||||
| 35 | Optional. Read from Inbound Delivery line item. | Text data | Country of Origin | /SAPSLL/E1CCEIT-CUCOO | Char(2) | /SAPSLL/CUIT-CUCOO | Destination Field: /SAPSLL/CUIT-CUCOO *see below Location: Line Item > Placement -> Cntry of Origin IDOC function module modification(s): Pull Country of Origin from Inbound Delivery line item Text Object STXH-TDOBJECT: VBBP Text Object Name S |
||||||||
| 37 | Optional. Read from Inbound Delivery line item. | Text data | Visa Number | /SAPSLL/E1CCEIDO-PAPNO[24] | Char(10) | /SAPSLL/LEGDOC-PAPNO | Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC010' (Visa Number) [25] |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC010' (Visa Number) IDOC function module modification(s): Pull Visa Number from Inbound Delivery line item Text Object ST |
|||||||
| 54 | Optional. Read from Inbound Delivery line item. | Text data | Commercial Invoice | /SAPSLL/E1CCEIDO-PAPNO[26] | Char(10) | /SAPSLL/LEGDOC-PAPNO | Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC019' (Commercial Invoice Number) |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC019' Commercial Invoice Number) IDOC function module modification(s): Pull Commercial Invoice Number from Inbound Delivery |
|||||||
| 38 | Optional. Read from Inbound Delivery. | LIPS-LGMNG, LIPS-MEINS | Unit Quantity, UoM | /SAPSLL/E1CCEIT-QUAUM_ISO | /SAPSLL/CUIT-QUANT, /SAPSLL/CUIT-QUAUM | Destination Field: /SAPSLL/CUIT-QUANT_FLT Location: Line Item > General Data tab > Quantities and Weights > Item Quantity IDOC function module modification(s): Pull Unit Quantity from Inbound Delivery line item fields LIPS-LGMNG, LIPS-MEINS. Convert to |
|||||||||
| 39 | Optional. Read from Inbound Delivery. | LIPS-NTGEW, LIPS-GEWEI | Net Weight | /SAPSLL/E1CCEIT-WEINET | Numeric 19(3decimals) | /SAPSLL/CUIT-WEINET_FLT, /SAPSLL/CUIT-WEIDIM | Destination Field: /SAPSLL/CUIT-WEINET_FLT Location: Line Item > General Data tab > Quantities and Weights > Net Weight / Unit of Measure IDOC function module modification(s): Pull Net Weight from Inbound Delivery line item fields LIPS-NTGEW, UoM LIPS-GE |
||||||||
| 40 | Optional. Read from ZXPARAM | ZXPARAM-VALUE1 | Binding Ruling Number | /SAPSLL/E1CCEIDO-PAPNO[27] | Char(10) | /SAPSLL/LEGDOC-PAPNO | Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC011' (Binding Ruling Number) |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC011' Binding Ruling Number) IDOC function module modification(s): Pull Binding Ruling Number from ZXPARAM using Article Num |
|||||||
| 41 | Optional. Read from ZXPARAM | ZXPARAM-VALUE1 | Cotton Flag | /SAPSLL/E1CCEIDO-PAPNO [28] |
Char(10) | /SAPSLL/LEGDOC | Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC021' (Cotton Flag) |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC021' Cotton Flag) IDOC function module modification(s): Pull Cotton Fee Flag from ZXPARAM using Article Number as key: P |
|||||||
| 42 | Optional. Read from ZXPARAM | ZXPARAM-VALUE1 | Anti-Dumping / Countervailing Case Number | /SAPSLL/E1CCEIDO-PAPNO [29] |
Char(10) | /SAPSLL/LEGDOC-PAPNO | Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC009' (Anti-Dumping/Countervailing Case Number) |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC009' Anti-Dumping/Countervailing Case Number) IDOC function module modification(s): Pull Anti-Dumping/Countervailing Case N |
|||||||
| 43 | Optional. Read from ZXPARAM | ZXPARAM-VALUE1 | Fish & Wildlife Service Flag | /SAPSLL/E1CCEIDO-PAPNO [30] |
Char(10) | /SAPSLL/LEGDOC-PAPNO | Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC017' (Fish and Wildlife Service Flag) |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC017' FWS Code) IDOC function module modification(s): Pull Fish and Wildlife Flag from ZXPARAM using Article Number as key: |
|||||||
| 44 | Defaulted based on HTS Classification in Product Master | /SAPSLL/CORCTSC-CCNGN | Import Code Tariff Number | /SAPSLL/E1CCEIT-CCNCU | Char(30) | Background: Each Article Number in GTS has a corresponding Tariff Number. If an Article Number is qualified for Special Duty Rate (/SAPSLL/PREVD record exists), it may also have a second Tariff Number called the Special Trade Tariff Number (which results |
IDOC posting Function Module
will retrieve the Customs Tariff Number. Getting the Customs Tariff Number involves 3 steps: 1. Get Product GUID - Call function module /SAPSLL/PRODUCT_GEN_SELECTION Input Parameter 1: /IS_OBJ_CRIT-PNTPR-PRSVY = A |
||||||||
| 45 | OPTIONAL. Read from /SAPSLL/PREVD, /SAPSLL-PREVDITM | /SAPSLL/CORCTSC-CCNGN | Commodity Code Tariff Number | /SAPSLL/E1CCEIT-CCNST | Char(30) | See explanation for Import Code Tariff Number (above). | IDOC posting Function Module
will retrieve the Special Trade Tariff Number. Getting the Special Trade Tariff Number A second Customs Tariff number may exist for an Article Number. This is stored in table /SAPSLL/PREVD SLL: Preference: Long-Term Vendor D |
||||||||
| 46 | OPTIONAL. Read from /SAPSLL/PREVD, /SAPSLL-PREVDITM | /SAPSLL/PREVD-VDNO Vendor Declaration Number, /SAPSLL-PREVDITM-ZSPCTRD Special Trade Program Indicator | Pref Determination | /SAPSLL/E1CCEIDO-PAPNO [31] |
Char(10) | /SAPSLL/LEGDOC-PAPNO | Default: /SAPSLL/E1CCEIDO-QALDOC='CUIP' (Preference Document) /SAPSLL/E1CCEIDO-PAPTY='D' (US: Use Preferential Duty Rate) |
Populate ONLY if an entry in
/SAPSLL/PREVD exists. See 'Getting Special Trade Tariff Number.' 2.3.4.1.6 Determine Special Trade Program eligibility (STP) of the Article Number, Vendor and Country of Origin; Get the STP HTS number if it exists. 2.3.4.1. |
|||||||
| 47 | OPTIONAL. Read from HTS Master | Text from HTS master table /SAPSLL/CTSNUMCT | Quota Category Number | /SAPSLL/E1CCEIDO-PAPNO[32] | Char(10) | /SAPSLL/LEGDOC-PAPNO | Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC014' (Quota Category) /SAPSLL/E1CCEIDO-PAPNO = <Quota Category Number> |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC014' (Quota Category Number) IDOC function module modification(s): To get HTS text / quota category (in /SAPSLL/CTSNUMCT)- |
|||||||
| 48 | Defaulted | Bond Type = '8'; Bond Number = '891' | Bond Type / Number | /SAPSLL/E1CCEHDO-PAPNO /SAPSLL/E1CCEHDO-PAPAD[33] |
CHAR(35) | /SAPSLL/LEGDOC-PAPNO /SAPSLL/LEGDOC-PAPAD |
Default: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC016' (Bond Number, Bond Type Code) /SAPSLL/E1CCEHDO-PAPNO = '891' LBI Bond Number /SAPSLL/E1CCEHDO-PAPAD = '8' (Continuous) LBI Bond Type |
Destination Field: /SAPSLL/LEGDOC-PAPNO, PAPAD Location: Documents/Evidence Tab-> Number & Addl Data (Type of Document 'HDOC', Type 'ZDC016' (Bond Number, Bond Type Code) IDOC function module modification(s): Default values- /SAPSLL/LEGDOC-QALDOC = 'H |
|||||||
| 49 | MANDATORY. Read from ZSLL_CHARGES | ZSLL_CHARGES-AMOUNT (Pro-rated by weight) | Charges | /SAPSLL/E1CCEHAA-AMNT_ORI | Curr 19 decimals 2 | /SAPSLL/LEGCULC-AMNT_ORI | Default: /SAPSLL/E1CCEHAA-AARTY='A002' (Transportation Costs) /SAPSLL/E1CCEHAA-CUR_ORI=ZSLL_CHARGES-AMOUNT_CUR |
Destination Field: /SAPSLL/LEGCULC-AMT_ORI (POBJT = 'O2', TLC_AART = 'A001',
VALTY = '001') Location: Line Item > Customs Val. Tab > Value of Goods IDOC function module modification(s): Per CM 3/21/6, for Ocean, compute Charges based on gross weight (lik |
|||||||
| 50 | MANDATORY. Read from Purchase Order & the Business Partner Master in GTS | /SAPSLL/BUT0ID-IDNUMBER | Manufacturer ID | /SAPSLL/E1CCEIDO-PAPNO[34] | Char(35) | /SAPSLL/LEGDOC-PAPNO | Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC012' (Manufacturer Name and Identification (MID)) /SAPSLL/E1CCEIDO-PAPNO = <Manufacturer ID> *see logic below |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC012' (Manufacturer Name and Identification (MID)) IDOC function module modification(s): MID Determination Logic per Carol |
|||||||
| 51 | MANDATORY. Read from table ZSLL_BROKER_DET | ZSLL_BROKER_DET-BROKER | Broker | /SAPSLL/E1CCEHPA-CUSTV | Char(26) | /SAPSLL/CORPAR-PARNO | Default: /SAPSLL/E1CCEHPA-PATYP='BROKER' Customs Broker |
Destination Field: /SAPSLL/CORPAR-PARNO Location: Customs Shipment-> Partner Tab -> 'BROKER' Business Partner (Broker) IDOC function module modification(s): 1. Create table ZSLL_BROKER_DET 'GTS: Mapping - Foreign Trade Organization to Division Code': |
|||||||
| 52 | MANDATORY. Defaulted to current date. | SY-DATUM | Calculation Date | Date YYYYMMDD | /SAPSLL/CUHDDAT-CLCTS | Destination Field: /SAPSLL/CUHDDAT-CLCTS Date of Customs Duty Calculation for
GTS Location: Line item -> Logistics Cost Tab-> Calculation Date IDOC function module modification(s): Default to Current Date & Time (date/time stamp YYMMDDHHMMSS) Error Ha |
|||||||||
| 53 | Optional. From ZXPARAM | ZXPARAM-VALUE1 | FDA Code | /SAPSLL/E1CCEIDO-PAPNO[35] | Char(15) | /SAPSLL/LEGDOC-PAPNO | Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC024' (FDA Code) |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC024' FDA Code) IDOC function module modification(s): Pull FDA Code from ZXPARAM using Article Number as key. PARAMTYPE |
|||||||
| 54 | Defaulted | 1A', '2B' | Declaration Type | /SAPSLL/E1CCEHDO-PAPNO /SAPSLL/E1CCEHDO-PAPAD[36] |
CHAR(35) | /SAPSLL/LEGDOC-PAPNO /SAPSLL/LEGDOC-PAPAD |
Default: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC023' (Declaration Type) /SAPSLL/E1CCEHDO-PAPNO = '1A' /SAPSLL/E1CCEHDO-PAPAD = '2B' |
Destination Field: /SAPSLL/LEGDOC-PAPNO, PAPAD Location: Documents/Evidence Tab-> Number & Add. Data (Type of Document 'HDOC', Type 'ZDC023' Declaration Statement) IDOC function module modification(s): Default values- /SAPSLL/LEGDOC-QALDOC='HDOC' (Pres |
|||||||
| 55 | Defaulted | 'Y' or 'N' | OGA Flag | /SAPSLL/E1CCEIDO-PAPNO [37] | CHAR(35) | /SAPSLL/LEGDOC-PAPNO | Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC022' OGA Applies (Y/N) /SAPSLL/E1CCEIDO-PAPNO = 'Y' or 'N' |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Line item -> Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC022' OGA Applies Flag Y/N) IDOC function module modification(s): * NOTE: OGA applies if FDA Code is found or FWS Flag is Yes |
|||||||
| 56 | Defaulted | 'N' | Related Flag Indicator | /SAPSLL/E1CCEHDO-PAPNO [38] | CHAR(35) | /SAPSLL/LEGDOC-PAPNO | Default: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZFL003' ' (33. Related Party Indicator (Y/N)) /SAPSLL/E1CCEHDO-PAPNO = 'N' |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZFL003' ' Related Party Indicator (Y/N)) IDOC function module modification(s): Default values- /SAPSLL/LEGDOC-QALDOC='HDOC' (Presented Doc |
|||||||
| 57 | Purchase Order partner function 'OA' Ordering Address LFA1-STRAS LFA1-REGIO LFA1-PSTLZ LFA1-LAND1 | Seller Name and Address information | /SAPSLL/E1CCEIDO-PAPNO, PAPAD [39] | /SAPSLL/LEGDOC-PAPNO, PAPAD | Default: /SAPSLL/E1CCEIDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC042' 'ZDC043' 'ZDC044' |
Destination Field: /SAPSLL/LEGDOC-PAPNO, PAPAD Location: Item - Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC042' 'ZDC043' 'ZDC044' IDOC function module modification(s): Default values- /SAPSLL/LEGDOC-QALDOC='PDOC' (Presented Docu |
|||||||||
| 58 | Purchase Order partner function 'VN(LF)' Vendor LFA1-STRAS LFA1-REGIO LFA1-PSTLZ LFA1-LAND1 | Manufacturer Name and Address Information | /SAPSLL/E1CCEIDO-PAPNO, PAPAD [40] | /SAPSLL/LEGDOC-PAPNO, PAPAD | Default: /SAPSLL/E1CCEIDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC045' 'ZDC046' 'ZDC047' |
Destination Field: /SAPSLL/LEGDOC-PAPNO, PAPAD Location: Item - Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZDC045' 'ZDC046' 'ZDC047' IDOC function module modification(s): Default values- /SAPSLL/LEGDOC-QALDOC='PDOC' (Presented Docu |
|||||||||