| Data Mapping | ||||||||||||||
| Inbound EDI 857 - Customs Entry C | ||||||||||||||
| Mapping Definitions | Note: Each Invoice Deta | |||||||||||||
| Destination | Source | |||||||||||||
| EDI 857[1] | SAP IDOC /SAPSLL/CCECUS01 [2] | [3] | Valid Values[4] | Nullable? (N or Y or leave blank)[5] |
||||||||||
| Item | Table Name[6] | Field Name[7] | Position Number | Format | IDOC Name[8] | Format | Description | Sourcing Condition | EDI Business Rule Logic / Conversion Logic / Default[9] | GTS Function Module Procedures[10] | ||||
| 1 | 857 | ST01-143 | 010 | String(3) | /SAPSLL/E1CCEHD_CNTRL-CUMES | Transaction Set | MANDATORY | Conversion: If ST01-143 = '857', /SAPSLL/E1CCEHD_CNTRL-CUMES = 'Z857I'.[11] |
MANDATORY. Reject EDI transmission if blank or not = '857'. | |||||
| 1 | 857 | BHT01-1005 | 020 | Char(4) | No update in SAP needed. | Hierarchical Structure Code | No update in SAP needed. | |||||||
| 2 | 857 | BHT02-353 | 020 | Char(2) | /SAPSLL/E1CCEHD_CNTRL-MSGFN *See Conversion Logic | Transaction Set Purpose Code | MANDATORY | Conversion: If BHT02-353 = ' 00' Original, pass 'ORI'. If BHT02-353 = ' 03' Delete, pass 'CAN'. If BHT02-353 = ' 05' Replace, pass 'REP'. |
o 00 Original A new Customs
Shipment will be created (This will be Customs Entries created by Brokers;
Entry Number included) o 03 Delete Customs Shipment will be set to Cancelled o 05 Replace Customs Shipment data will be overlaid. Only co |
|||||
| 3 | 857 | BHT03-127 | 020 | Char(3) *Max 3 | /SAPSLL/E1CCEHPA-CUSTV | Char(40) *Max3 | LBI Division Code (Box 11) |
MANDATORY Qualifier: /SAPSLL/E1CCEHPA-PATYP='CUSHAV' Principal |
Validation: For GL2, only BBW, BTA & Division Code for the Limited Division on the Entry BBW Bath & Body Works (GL2) BTA Beauty |
Destination Field: /SAPSLL/CORPAR-PARNO Location: Customs Shipment-> Organization Tab -> Foreign Trade Org Unit IDOC function module modification(s): 1. Read table ZSLL_FTO_DIV with key DIVISION = /SAPSLL/E1CCEHPA-CUSTV (BHT03-127). 2. Field ZSLL_FTO_DIV |
||||
| 4 | 857 | HL01-628 | 030 | Char(12) | No update in SAP needed. | Hierarchical ID Number | No update in SAP needed. | |||||||
| 5 | 857 | HL03-735 | 030 | Char(2) | No update in SAP needed. | Hierarchical Level Code - 24 Customs Entry | No update in SAP needed. | |||||||
| 6 | 857 | TD502-66 | 050 | Char(2) | If '2' Importing Carrier/Vessel Name, | Identification Code Qualifier | MANDATORY | No update in SAP needed. | ||||||
| 7 | 857 | TD503-67 | 050 | Char(35) | /SAPSLL/E1CCEHD_TPR-VIDAR | Char(35) | Importing
Carrier - SCAC/IATA (Box 23) |
MANDATORY | Destination Field: /SAPSLL/LEGTPR-VIDAR Location: Customs Shipment -> Transport Tab -> MoT at Arrival IDOC function module modification(s): None. Error Handling: Free text. None. |
|||||
| 8 | 857 | TD507-309 | 050 | Char(2) | If "PE" Port of Entry (Port where customs is declared) | Location Qualifier : 'PE' Port of Entry | MANDATORY Qualifier: /SAPSLL/E1CCEHPA-PATYP='CUSEZS' Office of Entry |
This will create one IDOC /SAPSLL/E1CCEHPA record. | ||||||
| 9 | 857 | TD508-310 | 050 | Char(4) | /SAPSLL/E1CCEHPA-CUTID | Char(4) | Port of Entry (Box 5) |
MANDATORY | 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/ADRLRID (GTS: I |
|||||
| 10 | 857 | TD506-368 | 060 | Char(2) | If 'ZZ', see below | Shipment/ Order Status Code | No update in SAP needed. | |||||||
| 11 | 857 | TD507-309 | 060 | Char(2) | If 'PA' First US Port of Unlading | Location Qualifier: First US Port of Unlading | MANDATORY | No update in SAP needed. | ||||||
| 12 | 857 | TD508-310 | 060 | Char(4) | /SAPSLL/E1CCEHD_TPR-NODAR | Char(4) | First US Port of Unlading (Box 26) |
MANDATORY | Destination Field: /SAPSLL/LEGTPR-NODAR Location: Transport Tab-> Customs Offices -> Destination Connection Point IDOC function module modification(s): 1. Read /SAPSLL/CMDNOD (GTS: Transport Connection Point) with key NAME = /SAPSLL/E1CCEHD_TPR-NODA |
|||||
| 13 | 857 | DTM01-374 | 070 | Char(3) | If "813" Customs Entry Date | Date/Time Qualifier: Customs Entry Date | MANDATORY Qualifier: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDT036' (Entry Date)[12] |
This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 14 | 857 | DTM02-373 | 070 | Date (8) YYYYMMDD |
/SAPSLL/E1CCEHDO-PAPDT | Date(8) CCYYMMDD | Entry Date (Box 4) |
MANDATORY | Destination Field: /SAPSLL/LEGDOC-PAPDT Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT036' Entry Date) IDOC function module modification(s): None. Error Handling: Fatal Error if Entry Date is missing. |
|||||
| 15 | 857 | DTM03-337 | 070 | Time (6) HHMMSS | /SAPSLL/E1CCEHDO-PAPAD | Char(11) HH:MM:SS ET | Entry Time | Destination Field: /SAPSLL/LEGDOC-PAPAD Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT036' Entry Date) IDOC function module modification(s): None. Error Handling: None |
||||||
| 16 | 857 | DTM04-623 | 070 | Time Zone (2) | /SAPSLL/E1CCEHDO-PAPAD *Concatenate with above | Char(11) HH:MM:SS ET | Entry Time Zone | Destination Field: /SAPSLL/LEGDOC-PAPAD Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT036' Entry Date) IDOC function module modification(s): None. Error Handling: None |
||||||
| 17 | 857 | DTM01-374 | 070 | Char(3) | If "IMP" Date of Import | Date/Time Qualifier: Import Date | MANDATORY Qualifier: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDT002' (Import Date)[13] |
This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 18 | 857 | DTM02-373 | 070 | Date (8) YYYYMMDD | /SAPSLL/E1CCEHDO-PAPDT | Date(8) CCYYMMDD | Import Date (Box 27) |
MANDATORY | Destination Field: /SAPSLL/LEGDOC-PAPDT Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT002' Import Date) IDOC function module modification(s): None. Error Handling: Warning if Import Date is earlier than Export Date or Entry Da |
|||||
| 19 | 857 | DTM03-337 | 070 | Time (6) HHMMSS | /SAPSLL/E1CCEHDO-PAPAD | Char(11) HH:MM:SS ET | Import Time | Destination Field: /SAPSLL/LEGDOC-PAPAD Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT002' Import Date ) IDOC function module modification(s): None. Error Handling: None |
||||||
| 20 | 857 | DTM04-623 | 070 | Time Zone (2) | /SAPSLL/E1CCEHDO-PAPAD *Concatenate with above | Char(11) HH:MM:SS ET | Import Time Zone | Destination Field: /SAPSLL/LEGDOC-PAPAD Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT002' Import Date ) IDOC function module modification(s): None. Error Handling: None |
||||||
| 21 | 857 | DTM01-374 | 070 | Char(3) | If "EXP" Export Date | Date/Time Qualifier: Export Date | MANDATORY Qualifier: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDT030' (Export Date)[14] |
This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 22 | 857 | DTM02-373 | 070 | Date (8) YYYYMMDD | /SAPSLL/E1CCEHDO-PAPDT | Date(8) CCYYMMDD | Export Date (Box 14) |
MANDATORY | 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: Warning if Export Date is later than Import Date or Entry Date |
|||||
| 23 | 857 | DTM03-337 | 070 | Time (6) HHMMSS | /SAPSLL/E1CCEHDO-PAPAD | Char(11) HH:MM:SS ET | 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 |
||||||
| 24 | 857 | DTM04-623 | 070 | Time Zone (2) | /SAPSLL/E1CCEHDO-PAPAD *Concatenate with above | Char(11) HH:MM:SS ET | 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 |
||||||
| 25 | 857 | DTM01-374 | 070 | Char(3) | If "814" Entry Summary Date | Date/Time Qualifier: Entry Summary Date | MANDATORY Qualifier: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDT006' (Entry Summary Date)[15] |
This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 26 | 857 | DTM02-373 | 070 | Date (8) YYYYMMDD | /SAPSLL/E1CCEHDO-PAPDT | Date(8) CCYYMMDD | Entry Summary Date (Box 3) |
MANDATORY | Destination Field: /SAPSLL/LEGDOC-PAPDT Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT006' Entry Summary Date) IDOC function module modification(s): None. Error Handling: Warning if Entry Summary Date is earlier than Import D |
|||||
| 27 | 857 | DTM03-337 | 070 | Time (6) HHMMSS | /SAPSLL/E1CCEHDO-PAPAD | Char(11) HH:MM:SS ET | Entry Summary Time | Destination Field: /SAPSLL/LEGDOC-PAPAD Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT006' Entry Summary Date ) IDOC function module modification(s): None. Error Handling: None |
||||||
| 28 | 857 | DTM04-623 | 070 | Time Zone (2) | /SAPSLL/E1CCEHDO-PAPAD *Concatenate with above | Char(11) HH:MM:SS ET | Entry Summary Time Zone | Destination Field: /SAPSLL/LEGDOC-PAPAD Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT006' Entry Summary Date ) IDOC function module modification(s): None. Error Handling: None |
||||||
| 29 | 857 | N901-128 | 080 | Char(3) | If "6B" U.S. Customs Service (USCS) Entry Number | Reference Identification Code: Entry Number | MANDATORY Qualifier: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC002' (Entry Number)[16] |
MANDATORY | This will create one IDOC /SAPSLL/E1CCEHDO record. | |||||
| 30 | 857 | N902-127 | 080 | Numeric 11 | /SAPSLL/E1CCEHDO-PAPNO /SAPSLL/E1CCEHD-ZREGNR |
Numeric(11) | Entry
Number (Box 1) |
MANDATORY | The 11 digit alphanumeric code
that begins with the Broker File Number NOTE: This EDI 857 data element should populate 2 IDOC fields. |
Destination Field: /SAPSLL/LEGDOC-PAPNO; /SAPSLL/CORREF-REFNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC002' Entry Number) IDOC function module modification(s): None. An Inbound EDI 857 will either create or update one |
||||
| 31 | 857 | N903-369 | 080 | Char(1) | /SAPSLL/E1CCEHDO-PAPNO | Char(35)*Max(1) | Live Entry Flag (Box 2) |
OPTIONAL Qualifier: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZFL001' (Live Entry Flag Y/N)[17] |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZFL001' Live Entry Flag Y/N) IDOC function module modification(s): None. Note: This will create one IDOC /SAPSLL/E1CCEHDO record. Error Hand |
|||||
| 32 | 857 | N904-373 | 080 | Date (8) YYYYMMDD | /SAPSLL/E1CCEHDO-PAPDT | Date(8) CCYYMMDD | In-Transit
Date (Box 18) |
REQUIRED if
Port of Entry <> US Port of Unlading Qualifier: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDT001' (In Transit Number/Date)[18] |
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: None. |
|||||
| 33 | 857 | N907-C04001-128 | 080 | Char(3) | If "6C" - Entry Type Code | Reference Identification Qualifier: Entry Type Code | MANDATORY Qualifier: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC015' (Entry Type Code) |
This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 34 | 857 | N907-C04002-127 | 080 | Char(30) | /SAPSLL/E1CCEHDO-PAPNO | Char(35) | Entry Type
Code (Box 2) |
MANDATORY | Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC015' Entry Type Code) IDOC function module modification(s): 1. Select from /SAPSLL/CUCPRO (GTS: Place into a Customs Status) where C |
|||||
| 35 | 857 | N907-C04003-128 | 080 | Char(3) | If 'TJ' Federal Taxpayer's Identification Number | Reference Identification Qualifier: Federal Tax Identification Number | No update in SAP needed. | |||||||
| 36 | 857 | N907-C04004-127 | 080 | Char(30) | /SAPSLL/E1CCEHPA-CUTID | Federal Tax Identification
Number (Box 12) |
Qualifier: /SAPSLL/E1CCEHPA-PATYP='CUSHAV' Principal |
Destination Field: The IRS No transmitted by the Broker in the Inbound 857 must
be validated that it matches the Business Partner master IRS No
(/SAPSLL/ADRLRID-PINID). Location: Source: GTS Menu -> Customs Management -> Master Data -> Maintain Trader Ide |
||||||
| 37 | 857 | N907-C04005-128 | 080 | Char(3) | If "ZH" - In-Transit Number | Reference Identification Qualifier: In-Transit Number | REQUIRED if
Port of Entry <> US Port of Unlading Qualifier: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDT001' (In Transit Number/Date)[19] |
This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 38 | 857 | N907-C04006-127 | 080 | Char(30) Max 15 | /SAPSLL/E1CCEHDO-PAPNO | Char(35)*Max(15) | In-Transit Number (Box 17) |
REQUIRED if Port of Entry <> US Port of Unlading | Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Date (Type of Document 'HDOC', Type 'ZDT001' In Transit Number/Date) IDOC function module modification(s): None. Error Handling: None. |
|||||
| 39 | 857 | N901-128 | 080 | Char(3) | If "3Z"- Broker's File Reference Number | Reference Identification Qualifier: Broker's File Reference Number | OPTIONAL Qualifier: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC006' (Broker File Number )[20] |
This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 40 | 857 | N902-127 | 080 | Char(30) Max 15 | /SAPSLL/E1CCEHDO-PAPNO | Char(35)*Max(15) | Broker's File Reference
Number (Box 8) |
OPTIONAL | Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC006' Broker File Number ) IDOC function module modification(s): None. Error Handling: None. |
|||||
| 41 | 857 | N901-128 | 080 | Char(3) | If N901 = '8G' - ACH Statement Number | Reference Identification Qualifier: ACH Statement Number | OPTIONAL Qualifier: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC039' (ACH Statement Number )[21] |
This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 42 | 857 | N902-127 | 080 | Char(30) Max 15 | /SAPSLL/E1CCEHDO-PAPNO | Char(35)*Max(15) | ACH Statement Number | OPTIONAL | Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC039' ACH Statement Number) IDOC function module modification(s): None. Error Handling: None. |
|||||
| 41 | 857 | N901-128 | 080 | Char(3) | If "CR"- LBI's SAP GTS Customs Shipment Number | Reference Identification Qualifier: SAP GTS Customs Shipment Number | OPTIONAL | This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 42 | 857 | N902-127 | 080 | Char(30) | /SAPSLL/E1CCEHD-REFNO | Char(35) | LBI's SAP GTS Customs Shipment
Number |
OPTIONAL | NOTE: This
field is optional in the inbound 857. If field is present, map it. NOTE 2: For all outbound 857 from SAP GTS, LBI sends the Customs Shipment Number to Brokers. This should be referenced in the corresponding inbound 857 from the Brokers to faci |
Destination Field: Note: This value is used for matching the EDI 350
Transmission to the GTS Customs Shipment (/SAPSLL/CUHD-CORDER) and will only
be stored in the IDOC. Location: N/A. IDOC function module modification(s): An Inbound EDI 857 will eithe |
||||
| 43 | 857 | SAC01-248 | 110 | Char(1) | If "C"- Charge | Allowance or Charge Indicator | MANDATORY | Each SAC-110 record will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 44 | 857 | SAC02-1300 | 110 | Char(4) | /SAPSLL/E1CCEHDO-PAPTY | Char(6) | Service, Promotion, Allowance, or Charge Code | MANDATORY Qualifier: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY=*see below If B872, pass ZZB872 - Customs Duty; If D502, pass ZZD502 - Harbor Maintenance Fee; If E585, pass ZZE585 - Merchandise Processing Fee; If B880, pass[22] |
Destination Field: /SAPSLL/LEGDOC-PAPTY. Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZZxxxx' *see SAC02-1300 mapping ) IDOC function module modification(s): None. |
|||||
| 45 | 857 | SAC05-610 | 110 | Numeric(15 | /SAPSLL/E1CCEHDO-PAPNO | Numeric( | Amount | MANDATORY | Implied decimal value of
2. If value is $100, send value as
10000. When SAC 02 = "B872" - Total Ad Valorem or Specific Duty for Entry When SAC 02 = "D502" - Total Harbor Maintenance Fee for Entry When SAC 02 = "E585" - Total Merchandise Processing Fee f |
Destination Field: /SAPSLL/LEGDOC-PAPNO. Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZZxxxx' *see SAC02-1300 mapping ) IDOC function module modification(s): None. |
||||
| 46 | 857 | SAC13-127 | 110 | Char(30) Max 1 | /SAPSLL/E1CCEHDO-PAPNO | Char(35) * | Paperless Indicator | MANDATORY Qualifier: If SAC02-1300 = 'B872', /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZFL002' (Indicator: Paperless Entry (Y/N))[23] |
||||||
| 47 | 857 | N901-128 | 140 | Char(3) | If "BJ"- Carrier's Customs Bond Number | Reference Identification Code: Broker/Importer's Customs Bond Number | MANDATORY Default: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC016' (Bond Number, Bond Type Code) |
This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 48 | 857 | N902-127 | 140 | Char(30) | /SAPSLL/E1CCEHDO-PAPNO | Char(35) * | Bond Number (Box 6) |
MANDATORY | Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC016' (Bond Number, Bond Type Code) IDOC function module modification(s): None. Error Handling: None. |
|||||
| 49 | 857 | N903-369 | 140 | Char(45) | /SAPSLL/E1CCEHDO-PAPNO | Char(35) | Missing Documents
indicator (Box 16) |
MANDATORY Default: /SAPSLL/E1CCEHDO-QALDOC = 'HDOC' Submitted Documents (Header) /SAPSLL/E1CCEHDO-PAPTY ='ZDC003' (Missing Documents Y/N)[24] |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDT032' 120 File Opened Date) IDOC function module modification(s): None. Note: This will create one IDOC /SAPSLL/E1CCEHDO record. Error Han |
|||||
| 50 | 857 | N907-C04001-128 | 140 | Char(3) | If "1J"- FIRMS Code | Reference Identification Qualifier: Facility ID Number | MANDATORY Default: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC001' (Location of Goods (FIRMS Code))[25] |
This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 51 | 857 | N907-C04002-127 | 140 | Char(30) | /SAPSLL/E1CCEHDO-PAPNO | Char(35) | Facility ID
Number (Box 25) |
MANDATORY | 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: None. |
|||||
| 52 | 857 | N907-C04003-128 | 140 | Char(3) | If "XY" Bond Type Code | Reference Identification Qualifier: Bond Type Code | MANDATORY Default: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC016' (Bond Number, Bond Type Code) |
This will update the same IDOC /SAPSLL/E1CCEHDO record as N902-127 (N901 = 'BJ'). | ||||||
| 53 | 857 | N907-C04004-127 | 140 | Char(30) | /SAPSLL/E1CCEHDO-PAPAD | Char 4 *M | Bond Type
Code (Box 7) |
MANDATORY | Destination Field: /SAPSLL/LEGDOC-PAPAD Location: Documents/Evidence Tab-> Add.Data (Type of Document 'HDOC', Type 'ZDC016' Bond Number, Bond Type Code) IDOC function module modification(s): None. Error Handling: Fatal Error if Bond Type Code not in (0, |
|||||
| 54 | 857 | N907-C04005-128 | 140 | Char(3) | If "CO"- General Order Number | Reference Identification Qualifier: GO Number | OPTIONAL Default: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC018' (General Order Number)[26] |
This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 55 | 857 | N907-C04006-127 | 140 | Char(30) | /SAPSLL/E1CCEHDO-PAPNO | Char(35) | General Order
Number (Box 25) |
OPTIONAL | Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC018' General Order Number) IDOC function module modification(s): None. Error Handling: None. Free form text. |
|||||
| 56 | 857 | N901-128 | 150 | Char(3) | If 'ZZ', Customs Team Number for Entry | Reference Identification Code: Customs Team Number for the Entry | OPTIONAL | This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 57 | 857 | N902-127 | 150 | Char(30) | /SAPSLL/E1CCEHDO-PAPNO | Customs Team Number for the Entry | OPTIONAL Default: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC025' (Customs Team Number for the Entry)[27] |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC025' (Customs Team Number for the Entry) IDOC function module modification(s): None. Error Handling: None. Free form text. |
||||||
| 58 | 857 | N901-128 | 160 | Char(3) | If 'ED' Declaration Statement | Reference Identification Qualifier: 'ED' Declaration Statement | MANDATORY Default: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC023' (Declaration Statement)[28] |
This will create one IDOC /SAPSLL/E1CCEHDO record. | ||||||
| 59 | 857 | N902-127 | 160 | Char(30) * | /SAPSLL/E1CCEHDO-PAPNO | Declaration Statement ( '1A',
'1B') (Box 36) |
MANDATORY | Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC023' Declaration Statement) IDOC function module modification(s): None. Error Handling: None. |
||||||
| 60 | 857 | N907-C040 | 160 | No update in SAP needed. | Reference Identifier | No update in SAP needed. | ||||||||
| 61 | 857 | N907-C04001-128 | 160 | Char(3) | If 'ED' Declaration Statement | Reference Identification Qualifier: Declaration Statement | MANDATORY Default: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC023' (Declaration Statement)[29] |
NOTE: This will update the same IDOC /SAPSLL/E1CCEHDO record as N902-127 (N901 = 'ED'). | ||||||
| 62 | 857 | N907-C04002-127 | 160 | Char(30) * | /SAPSLL/E1CCEHDO-PAPAD | Declaration
Statement ('2A', '2B') (Box 36) |
MANDATORY | Destination Field: /SAPSLL/LEGDOC-PAPAD Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC023' Declaration Statement) IDOC function module modification(s): None. Error Handling: None. |
||||||
| 63 | 857 | MAN01-88 | 180 | Char(2) | If 'MC' Container Number | Reference Identification Qualifier: Container Number | REQUIRED if Mode of Transport '11' Ocean. | Note: Required if SAC15-352 = '11'. | This will create one IDOC /SAPSLL/E1CCEHDO record. | |||||
| 64 | 857 | MAN02-87 | 180 | Char(48) | /SAPSLL/E1CCEHDO-PAPNO | Container Number | if (MAN01 = 'MC' and MAN02
exists) {Map /SAPSLL/E1CCEHDO-QALDOC ='HDOC' /SAPSLL/E1CCEHDO-PAPTY = 'ZDC020' Container Number /SAPSLL/E1CCEHDO-PAPNO = MAN02} |
Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC020' Container Number) IDOC function module modification(s): None. Error Handling: None. |
||||||
| 65 | 857 | MAN03-87 | 180 | Char(48) | /SAPSLL/E1CCEHDO-PAPNO | Container Number | if (MAN01 = 'MC' and MAN03
exists) {Map /SAPSLL/E1CCEHDO-QALDOC ='HDOC' /SAPSLL/E1CCEHDO-PAPTY = 'ZDC020' Container Number /SAPSLL/E1CCEHDO-PAPNO = MAN03} |
If populated | Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC020' Container Number) IDOC function module modification(s): None. Error Handling: None. |
|||||
| 66 | 857 | MAN05-87 | 180 | Char(48) | /SAPSLL/E1CCEHDO-PAPNO | Container Number | if (MAN04 = 'MC' and MAN05
exists) {Map /SAPSLL/E1CCEHDO-QALDOC ='HDOC' /SAPSLL/E1CCEHDO-PAPTY = 'ZDC020' Container Number /SAPSLL/E1CCEHDO-PAPNO = MAN05} |
If populated | Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC020' Container Number) IDOC function module modification(s): None. Error Handling: None. |
|||||
| 67 | 857 | MAN06-87 | 180 | Char(48) | /SAPSLL/E1CCEHDO-PAPNO | Container Number | if (MAN04 = 'MC' and MAN06
exists) {Map /SAPSLL/E1CCEHDO-QALDOC ='HDOC' /SAPSLL/E1CCEHDO-PAPTY = 'ZDC020' Container Number /SAPSLL/E1CCEHDO-PAPNO = MAN06} |
If populated | Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC020' Container Number) IDOC function module modification(s): None. Error Handling: None. |
|||||
| 65 | 857 | HL01-628 | 190 | Char(12) | No update in SAP needed. | Hierarchical ID Number | No update in SAP needed. | |||||||
| 66 | 857 | HL03-735 | 190 | Char(2) | No update in SAP needed. | Hierarchical Level Code: 25 Invoice Header | No update in SAP needed. | |||||||
| 67 | 857 | N901-128 | 220 | Char(3) | If "4H"- Commercial Invoice Number | Reference Identification Qualifier: Commercial Invoice Number | MANDATORY Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC019' (Commercial Invoice Number)[30] |
This will create one IDOC /SAPSLL/E1CCEIDO record. | ||||||
| 68 | 857 | N902-127 | 220 | Char(30) | /SAPSLL/E1CCEIDO-PAPNO | Commercial Invoice
Number (Box 33sub) |
MANDATORY | 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): None. Error Handling: None. |
||||||
| 69 | 857 | N903-369 | 220 | Char(45) | /SAPSLL/E1CCEHDO-PAPNO | Related Party Indicator
(Y/N) (Box 33C) |
MANDATORY Default: /SAPSLL/E1CCEHDO-QALDOC ='HDOC' /SAPSLL/E1CCEHDO-PAPTY = 'ZFL003' Related Party Indicator (Y/N) |
Field /SAPSLL/E1CCEHDO is at Customs Shipment Header Level. Take the value from the 1st Invoice Header. | This will create one IDOC /SAPSLL/E1CCEHDO record. | |||||
| 70 | 857 | N907-C040 | 220 | No update in SAP needed. | Reference Identifier | No update in SAP needed. | ||||||||
| 71 | 857 | N907-C04001-128 | 220 | Char(3) | If "AW"- Master Air Waybill/Ocean Bill of Lading | Identifier: Master Air Waybill / Ocean Bill of Lading Number | MANDATORY Default: /SAPSLL/E1CCEHDO-QALDOC='HDOC' (Presented Document) /SAPSLL/E1CCEHDO-PAPTY='ZDC004' (Master Air Waybill/Ocean Bill of Lading) [31] |
Field /SAPSLL/E1CCEHDO is at Customs Shipment Header Level. Send all unique occurences of MAWB/OBOL's (N907-C04001-128). | This will create one IDOC /SAPSLL/E1CCEHDO record. | |||||
| 72 | 857 | N907-C04002-127 | 220 | Char(30) | /SAPSLL/E1CCEHDO-PAPNO | Char(35) | Master Air Waybill Number or
Ocean Bill of Lading Number (Box 19) |
MANDATORY | Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'HDOC', Type 'ZDC004' Master Air Waybill/Ocean Bill of Lading) IDOC function module modification(s): None. Error Handling: None. |
|||||
| 73 | 857 | CUR01-98 | 230 | Char(3) | If "ZZ" Currency Code | Entity Identifier Code | No update in SAP needed. | |||||||
| 74 | 857 | CUR02-100 | 230 | Char(3) | No mapping to SAP at Invoice Header level. Mapping moved to Invoice Detail. |
Char(3) | Currency Code | Destination Field: /SAPSLL/LEGCULC-CUR_CUS Location: Customs Shipment Item -> Customs Valuation -> Crcy IDOC function module modification(s): None. Error Handling: None. |
||||||
| 75 | 857 | TDS01-610 | 240 | Numeric(15) | No mapping to SAP at Invoice Header level. Mapping moved to Invoice Detail. | Gross Amount of Commercial
Invoice Value |
[32] | No update in SAP needed. | ||||||
| 76 | 857 | TDS02-610 | 240 | Numeric(15) | No mapping to SAP at Invoice Header level. Mapping moved to Invoice Detail. | Net Amount of
Commercial Invoice Value |
[33] | No update in SAP needed. | ||||||
| 77 | 857 | TDS03-610 | 240 | Numeric(15) | No mapping to SAP at Invoice Header level. Mapping moved to Invoice Detail. | Commercial Invoice Adjustment
Amount (+ or -), if applicable |
[34] | No update in SAP needed. | ||||||
| 78 | 857 | SAC01-248 | 250 | Char(1) | If "S" Service | Allowance or Charge Indicator | MANDATORY | No update in SAP needed. | ||||||
| 79 | 857 | SAC04-1301 | 250 | Char(10) | /SAPSLL/E1CCEIT-CTYDP_ISO | Char(3) | The ISO Country Code for the
Exporting Country (Box 13) |
MANDATORY | Destination Field: /SAPSLL/CUIT-CTYDP *see below Location: Line Item > Placement -> Country of Departure IDOC function module modification(s): 1. Select from T005 (Countries) where INTCA = SAC04-1301 (/SAPSLL/E1CCEIT-CTYDP_ISO) If found, /SAPSL |
|||||
| 80 | 857 | SAC09-355 | 250 | Char(2) | /SAPSLL/E1CCEIDO-PAPAD | Char(3) | Unit of Measure for the
Manifest Quantity (Box 31Sub) |
MANDATORY Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC013' (Manifest Quantity)[35] |
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 |
|||||
| 81 | 857 | SAC10-380 | 250 | Numeric(15 | /SAPSLL/E1CCEIDO-PAPNO | Numeric( | Manifest Quantity in
cartons (Box 31Sub) |
MANDATORY Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC013' (Manifest Quantity)[36] |
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 |
|||||
| 82 | 857 | SAC13-127 | 250 | Char(30) | /SAPSLL/E1CCEIDO-PAPNO | Char(35) | House AirWaybill or Forwarder's
Cargo Receipt (Box 31Sub) |
MANDATORY Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC008' (House Airway Bill Number / Forwarder's Cargo Receipt Number)[37] |
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) IDOC function module modification(s): None. Note: This wil |
|||||
| 83 | 857 | SAC14-770 | 250 | Char(20)*Max(3) | /SAPSLL/E1CCEHD_TPR-NODDP | Char(20)*Max(5) | Foreign Port of Lading (Box 24) |
REQUIRED if Mode of Transport '11' Ocean. | Field /SAPSLL/E1CCEHDO is at Customs Shipment Header Level. Take the value from the 1st Invoice Header. | Destination Field: /SAPSLL/LEGTPR-NODDP Location: Customs Shipment -> Transport Tab -> Dept. Connect. Point IDOC function module modification(s): 1. Read /SAPSLL/CMDNOD (GTS: Transport Connection Point) with key NAME = /SAPSLL/E1CCEHD_TPR-NODDP (SAC1 |
||||
| 84 | 857 | SAC15-352 | 250 | Char(80)*Max(4) | /SAPSLL/E1CCEHD_TPR-MOTBC | Char(2) | Mode of Transport ('11',
'30') (Box 20) |
MANDATORY | Field /SAPSLL/E1CCEHDO is at Customs Shipment Header Level. Take the value from the 1st Invoice Header. | 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 |
||||
| 85[38] | 857 | HL01-628 | 290 | Char(12) | No update in SAP needed. | Hierarchical ID Number | No update in SAP needed. | |||||||
| 86 | 857 | HL03-735 | 290 | Char(2) | No update in SAP needed. | Hierarchical Level Code - 26 Invoice Details | No update in SAP needed. | |||||||
| 87 | 857 | TD502-66 | 310 | Char(2) | If "38"- ISO Country Code for Country of Origin | Identification
Code Qualifier: ISO Country Code for Country of Origin (Box 28C) |
MANDATORY | |||||||
| 88 | 857 | TD503-67 | 310 | Char(80) | /SAPSLL/E1CCEIT-CUCOO_ISO | Char(3) | ISO Country Code for Country of Origin | MANDATORY | Destination Field: /SAPSLL/CUIT-CUCOO *see below Location: Line Item > Placement -> Cntry of Origin IDOC function module modification(s): None. 1. Select from T005 (Countries) where INTCA = TD503-67 (/SAPSLL/E1CCEIT-CUCOO_ISO) If found, /SAPSLL/ |
|||||
| 89 | 857 | CUR01-98 | 230 | Char(3) | If "ZZ" Currency Code | Entity Identifier Code | MANDATORY | No update in SAP needed. | ||||||
| 90 | 857 | CUR02-100 | 230 | Char(3) | /SAPSLL/E1CCEIT-CUCUR_ISO | Char(3) | Currency Code | MANDATORY | Destination Field: /SAPSLL/LEGCULC-CUR_CUS Location: Customs Shipment Item -> Customs Valuation -> Crcy IDOC function module modification(s): None. Error Handling: None. |
|||||
| 89 | 857 | TDS01-610 | 240 | Numeric(15 | /SAPSLL/E1CCEIDO-PAPNO | Numeric(15) Implied decimals 2 | Gross Amount of Commercial
Invoice Value (Box 39 Summary) |
MANDATORY Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZXGIV' (Gross Invoice Value) [39] |
Note: This segment will create
one IDOC /SAPSLL/E1CCEIDO record. Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZXGIV') IDOC function module modification(s): None. Error Handling: None. |
|||||
| 90 | 857 | TDS02-610 | 240 | Numeric(15 | /SAPSLL/E1CCEIDO-PAPNO | Numeric(15) Implied decimals 2 | Net Amount of
Commercial Invoice Value (Box 39 Summary) |
MANDATORY Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZXNIV' (Net (Adjusted) Invoice Value) [40] |
Note: This segment will create
one IDOC /SAPSLL/E1CCEIDO record. Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZXNIV') IDOC function module modification(s): None. Error Handling: None. |
|||||
| 91 | 857 | TDS03-610 | 240 | Numeric(15 | /SAPSLL/E1CCEIDO-PAPNO | Numeric(15) Implied decimals 2 | Commercial Invoice Adjustment
Amount (+ or -), if applicable (Box 39 Summary) |
MANDATORY Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZXADJ' (Adjustment Amount MMV + or NDC - )[41] |
Note: This segment will create
one IDOC /SAPSLL/E1CCEIDO record. Destination Field: /SAPSLL/LEGDOC-PAPNO Location: Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZXADJ') IDOC function module modification(s): None. Error Handling: None. |
|||||
| 92 | 857 | IT101-350 | 320 | Char(20) | No update in SAP needed. | No update in SAP needed. | ||||||||
| 93 | 857 | IT102-358 | 320 | Numeric(10 | /SAPSLL/E1CCEIT-QUANT | Numeric( | Quantity Invoiced (Box 32A) |
MANDATORY (Can be 0) | Destination Field: /SAPSLL/CUIT-QUANT_FLT Location: Line Item > General Data tab > Quantities and Weights > Item Quantity IDOC function module modification(s): None. Error Handling: None. |
|||||
| 94 | 857 | IT106-235 | 320 | Char(2) | If "MB"- Unit of Measure | Product/ Service ID Qualifier: "MB"- Unit of Measure | MANDATORY | No update in SAP needed. | ||||||
| 95 | 857 | IT107-234 | 320 | Char(48) | /SAPSLL/E1CCEIT-QUAUM_ISO | Char 3 *M | HTS Unit of Measure (Box 32A) |
MANDATORY | Destination Field: /SAPSLL/CUIT-QUAUM Location: Line Item > General Data tab > Quantities and Weights > Unit of Measure (Item Quantity) IDOC function module modification(s): 1. Select from T006I where ISOCODE = IT107-234 (/SAPSLL/E1CCEIT-QUAUM_ISO). |
|||||
| 96 | 857 | IT108-235 | 320 | Char(2) | If "ST"- Style Number | Product/ Service ID Qualifier: "ST"- Style Number | MANDATORY | No update in SAP needed. | ||||||
| 97 | 857 | IT109-234 | 320 | Char(48) | /SAPSLL/E1CCEIT-PRVSY | Char(40) * | Style Number (Box 29) |
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 |
|||||
| 98 | 857 | IT110-235 | 320 | Char(2) | If "ZZ"- Merchandise Description (Mutually Defined) | Product/ Service ID Qualifier: "ZZ" - Merchandise Description (Mutually Defined) | OPTIONAL | No update in SAP needed. | ||||||
| 99 | 857 | IT111-234 | 320 | Char(48) | /SAPSLL/E1CCEIT2-TDLINE | Char(132) | Product
Description from the Harmonized Tariff System (Box 29) |
OPTIONAL | Destination Field: N/A Location: Line Item > General Data tab > Description of Goods IDOC function module modification(s): Although this should be pulled in automatically from the Product Master / HTS data, we should take what's in the inbound 857 because |
|||||
| 100 | 857 | IT112-235 | 320 | Char(2) | If "PO"- Purchase Order | Product/Service ID Qualifier: "PO"- Purchase Order | MANDATORY Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC007' (Purchase Order Number)[42] |
This will create one IDOC /SAPSLL/E1CCEIDO record. | ||||||
| 101 | 857 | IT113-234 | 320 | Char(48) | /SAPSLL/E1CCEIDO-PAPNO | Char(35) | Purchase
Order (Box 31C) |
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 exists. 1. Select /SAPSLL/CORREF (Legal & |
|||||
| 102 | 857 | IT114-235 | 320 | Char(2) | If "A7"- Entry Line Number | Product/ Service ID Qualifier: "A7"- Entry Line Number | MANDATORY | No update in SAP needed. | ||||||
| 103 | 857 | IT115-234 | 320 | Char(48) | /SAPSLL/E1CCEIT-ITVSY | Char(10) | Entry Line Number (Box 28A) |
MANDATORY | Destination Field: /SAPSLL/CUIT-ITVSY Location: Line Item > General Data tab > Item Number IDOC function module modification(s): None. Error Handling: None. |
|||||
| 104 | 857 | TC201-23 | 330 | Char(1) | If "A" - Harmonized Tariff Schedule Number | Tariff Code Qualifier | MANDATORY | Qualifier code will not update anything in SAP. | ||||||
| 105 | 857 | TC202-22 | 330 | Char(30) | /SAPSLL/E1CCEIT-CCNCU | Char(30) * | Tariff Code (Box 30A) |
MANDATORY | Destination Field: /SAPSLL/CTSNUMC-CCNGN (key
/SAPSLL/CORCTSC-GUID_CTSNUMC) Location: Line item -> Line Item > General Data tab > Import Code Number IDOC function module modification(s): Background: GTS calculates duties on the Import Code HTS number spe |
|||||
| 106 | 857 | TC201-23 | 330 | Char(1) | If "Z" - Special Program Harmonized Tariff System Number | Special Trade Tariff Code Qualifier | OPTIONAL | Qualifier code will not update anything in SAP. | ||||||
| 107 | 857 | TC202-22 | 330 | Char(30 | /SAPSLL/E1CCEIT-CCNST | Char(30) * | Special Trade Tariff Code (Box 30B) |
OPTIONAL | Destination Field: /SAPSLL/CTSNUMC-CCNGN (key
/SAPSLL/CORCTSC-GUID_CTSNUMC) Location: Line Item > General Data tab > Commodity Code IDOC function module modification(s): Background: GTS calculates duties on the Import Code HTS number specified on the Cu |
|||||
| 108 | 857 | N901-128 | 340 | Char(3) | If "4Z"- AD/CV Case Number | Identifier: AD/CV Case Number | OPTIONAL Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC009' (Anti-Dumping/Countervailing Case Number) [43] |
This will create one IDOC /SAPSLL/E1CCEIDO record. | ||||||
| 109 | 857 | N902-127 | 340 | Char(30) | /SAPSLL/E1CCEIDO-PAPNO | Char(35) | AD/CV Case Number (Box 30C) |
OPTIONAL | 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): None. Error Handling: None. |
|||||
| 110 | 857 | N901-128 | 350 | Char(3) | If "8X"- Quota Category | Identifier: Quota Category | OPTIONAL Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC014' (Quota Category Number) [44] |
This will create one IDOC /SAPSLL/E1CCEIDO record. | ||||||
| 111 | 857 | N902-127 | 350 | Char(3) *Max 3 | /SAPSLL/E1CCEIDO-PAPNO | Char(35) | Quota Category Number (Box 30D) |
OPTIONAL | 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): None. Error Handling: None. |
|||||
| 112 | 857 | N901-128 | 360 | Char(3) | If "30"- US Govt Visa Number | Identifier: US Govt Visa Number | OPTIONAL Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC010' (Visa Number) [45] |
This will create one IDOC /SAPSLL/E1CCEIDO record. | ||||||
| 113 | 857 | N902-127 | 360 | Char(30) | /SAPSLL/E1CCEIDO-PAPNO | Char(35) | Visa Number (Box 34D) |
OPTIONAL | 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): None. Error Handling: None. |
|||||
| 114 | 857 | N901-128 | 370 | Char(3) | If "R6"- Tariff Rule Number | Identifier: Tariff Rule Number | OPTIONAL | |||||||
| 115 | 857 | N902-127 | 370 | Char(30) M | /SAPSLL/E1CCEIT-CCNA1 | Char(30) * | Special Trade Program
Indicator (Box 28A) |
OPTIONAL | Destination Field: /SAPSLL/CUIT-ADDDA1 Location: Line Item > General Data tab > Addit.Code 1 IDOC function module modification(s): None. Just take whatever Broker sends. Error Handling: None. |
|||||
| 116 | 857 | N901-128 | 380 | Char(3) | If "3R"- Binding Ruling Number | Identifier: Binding Ruling Number | OPTIONAL Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC011' (Binding Ruling Number) [46] |
This will create one IDOC /SAPSLL/E1CCEIDO record. | ||||||
| 117 | 857 | N902-127 | 380 | Char(30) | /SAPSLL/E1CCEIDO-PAPNO | Char(35) | Binding Ruling Number (Box 33D) |
OPTIONAL | 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): None. Error Handling: None. |
|||||
| 118 | 857 | N901-128 | 380 | Char(3) | If "3Q"- FDA Code | Identifier: FDA Code | OPTIONAL Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC024' (FDA Code)[47] |
This will create one IDOC /SAPSLL/E1CCEIDO record. | ||||||
| 119 | 857 | N902-127 | 380 | Char(30) | /SAPSLL/E1CCEIDO-PAPNO | Char(35) | FDA Code | OPTIONAL | 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): None. Error Handling: None. |
|||||
| 120 | 857 | N901-128 | 380 | Char(3) | If "GS"- Fish & Wildlife Service | Identifier: Fish & Wildlife Service | OPTIONAL Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC017' (Fish & Wildlife Service)[48] |
This will create one IDOC /SAPSLL/E1CCEIDO record. | ||||||
| 121 | 857 | N902-127 | 380 | Char(30) | /SAPSLL/E1CCEIDO-PAPNO | Char(35) | Identifier: Fish & Wildlife Service | OPTIONAL | 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): None. Error Handling: None. |
|||||
| 122 | 857 | N901-128 | 390 | Char(3) | If "ZM"- Manufacturer ID Number | Identifier: Manufacturer Number | MANDATORY Default: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC012' (Manufacturer Name and Identification (MID))[49] |
This will create one IDOC /SAPSLL/E1CCEIDO record. | ||||||
| 123 | 857 | N902-127 | 390 | Char(30) | /SAPSLL/E1CCEIDO-PAPNO | Char(20) | Manufacturer ID number (Box 21/32C) |
MANDATORY | 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): None. Error Handling: None. |
|||||
| 124 | 857 | MEA03-739 | 410 | Numeric(20 | /SAPSLL/E1CCEIT-WEIGRO | Numeric( | Gross Weight (Box 31A) |
OPTIONAL | Destination Field: /SAPSLL/CUIT-WEIGRO_FLT Location: Line Item > General Data tab > Quantities and Weights > Gross Weight IDOC function module modification(s): None. Error Handling: None. |
|||||
| 125 | 857 | MEA04-C00101-355 | 410 | Char(2) | /SAPSLL/E1CCEIT-WEIDIM | Char(3) | Unit of Measure: Gross
Weight (Box 31A) |
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: None. |
|||||
| 126 | 857 | MEA04-C00103-649 | 410 | Numeric(10 | /SAPSLL/E1CCEIT-WEINET | Numeric( | Net Weight (Box 32B) |
OPTIONAL | Destination Field: /SAPSLL/CUIT-WEINET_FLT Location: Line Item > General Data tab > Quantities and Weights > Net Weight IDOC function module modification(s): In GTS, Net Weight & Gross Weight need to have the same Unit of Measure (UoM). In the 857 IG, th |
|||||
| 127 | 857 | MEA04-C00104-355 | 410 | Char(2) | /SAPSLL/E1CCEIT-WEIDIM | Char(3) | Unit of Measure: Net
Weight (Box 32B) |
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: None. |
|||||
| 128 | 857 | SLN01-350 | 430 | Char(20) | /SAPSLL/E1CCEIDO-QALDOC, /SAPSLL/E1CCEIDO-PAPTY | Char(6) | Valid Expense Code | MANDATORY Qualifier: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY=*see below Line 1 - If 'ADVAL', /SAPSLL/E1CCEIDO-PAPTY = 'ZYA090'. Line 2 - If 'SPECIFIC', /SAPSLL/E1CCEIDO-PAPTY = 'ZYH215'. Line 3 - If 'CVAD', /SAPSLL/E1CCE[50] |
Each SLN01-350 record will create one IDOC /SAPSLL/E1CCEIDO record. | |||||
| 129 | 857 | SLN02-350 | 430 | Char(20) | /SAPSLL/E1CCEIDO-PAPAD | USC Code for the Expense Code | CONDITIONAL | |||||||
| 130 | 857 | SLN03-662 | 430 | Char(1) | If "I" Included | Relationship Code | ||||||||
| 131 | 857 | SLN06-212 | 430 | Numeric(17 | /SAPSLL/E1CCEIDO-PAPNO | Numeric(17v2) | Unit Price | CONDITIONAL | NOTES: Extended Amount For example: Ad Valorem Rate = 18%, Value for 1 style = $10.00, quantity = 500 (.18 * 10) * (500) = 1.8 * 500 = $900.00 Extended Amount = $900.00 |
|||||
| 132 | 857 | SAC01-248 | 460 | Char(1) | If "C"- Allowance or Charge | Allowance or Charge Indicator | Each SAC01-248 record will create one IDOC /SAPSLL/E1CCEIDO record. | |||||||
| 133 | 857 | SAC02-1300 | 460 | Char(4) | /SAPSLL/E1CCEIDO-QALDOC | Char(4) | Service, Promotion, Allowance, or Charge Code | MANDATORY Qualifier: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY=*see below If C530, pass ZZC530 - Line Item Duty; If B872 , pass ZZB872 - HTS Duty; If A090, pass ZZA090 - Ad Valorem (Ad Va[51] |
||||||
| 134 | 857 | SAC05-610 | 460 | Numeric(15 | /SAPSLL/E1CCEIDO-PAPNO | Numeric( | Amount | MANDATORY | Destination Field:
/SAPSLL/LEGDOC-PAPNO. Location: Documents/Evidence Tab-> Number (Type of Document 'PDOC', Type 'ZZxxxx' *see SAC02-1300 mapping ) IDOC function module modification(s): --------------- Read /SAPSLL/CUHD (Legal Services: Customs Document |
|||||
| 135 | 857 | SAC08-118 | 460 | Char(9) | /SAPSLL/E1CCEIDO-PAPAD | Char(35) | Rate | CONDITIONAL | ||||||
| 136 | 857 | SAC13-127 | 460 | Char(30) | If SAC 02 = "H215", Contenate '/' + SAC13 to /SAPSLL/E1CCEIDO-PAPAD | Char(3) | Unit of Measure | CONDITIONAL | When SAC 02 = "H215" - the unit of measure basis that relates to the Specific Duty calculation. For example: if the Specific Duty is .002997/KG - this value will be "KG". | |||||
| 137 | 857 | SAC15-460 | 460 | Char(80) | /SAPSLL/E1CCEIDO-PAPNO | Description | MANDATORY Qualifier: /SAPSLL/E1CCEIDO-QALDOC='PDOC' (Presented Document) /SAPSLL/E1CCEIDO-PAPTY='ZDC022' (OGA Applies Flag Y/N)[52] |
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): None. Note: This will create one IDOC /SAPSLL/E1CCEIDO recor |
||||||