Sample It Company Profile - Excel

Document Sample
Sample It Company Profile - Excel Powered By Docstoc
					                  16f3462d-ac40-46a1-8745-0ef6137be2a2.xls



                 Sample 856 mapping document
           X12 Transaction                  856
           X12 Version                     4010
           Idoc Type                    DELVRY01
           Message Type                  DESADV
           Direction to SAP              Outbound
           Created by                  Kevin Wilson
           System ID                     SAPDEV
           Sender Port                    SAPEDI
           Logical System              LOGSYS005
           Client                           005
           Partner Number                10000111
           Remit To                Sample Company Name
           Order Type                       OR
           Sales Org                       0010
           Dist Channel                     10
           Division                         10
           Unit of Measure                  EA
           Language                          E
           Currency                        USD
           Sender ID                    <senderid>
           Sender ID Qual                   01
           Receiver ID                 <receiverid>
           Receiver ID Qual                 08
           GS02                         <sendergs>
           GS03                        <receivergs>




Overview                  Wella Corp. Confidential           Page 1
16f3462d-ac40-46a1-8745-0ef6137be2a2.xls                                                                                                                                               856 Mapping Template
                                               ANSI X12 Detail                                                                        SAP Idoc Detail
      Segment                     Data Element Name              Codes and comments                  Idoc Segment   Field      Constant           Qual Field   Qual Value   Notes on Mapping Document
      ISA - Interchange Header
      ISA01        Authorization Information Qualifier           "00" No Authorization information
      ISA02        Authorization information                     Ten Blank Positions
      ISA03        Security information Qualifier                "00" No Security Information
      ISA04        Security information                          Ten Blank Positions
      ISA05        Interchange ID Qualifier                      01
      ISA06        Interchange Sender ID                         <senderid>
      ISA07        Interchange ID Qualifier                      08
      ISA08        Intechange Receiver ID                        <receiverid>
      ISA09        Interchange Date
      ISA10        Interchange Time
      ISA11        Interchange Standards Identifier              X
      ISA12        Interchange version ID                        00401
      ISA13        Interchange Control Number
      ISA14        Acknowledgement Requested                     0
      ISA15        Test Indicator                                P
      ISA16        Component Element Separator                   >

      GS - Functional Group Header
      GS01       Functional ID                                   "SH" Delivery
      GS02       Application Senders Code                        <sendergs>
      GS03       Application Receiver's Code                     <receivergs>
      GS04       Date
      GS05       Time
      GS06       Group Control Number
      GS07       Responsible agency code                         X
      GS08       Version                                         4010

      ST -Transaction Header
      ST01       Transaction Set ID                              856
      ST02       Transaction Set Control Number

      BSN - Shipment Begining Segment (MANDATORY)
      01        Transaction Set Purpose Code                                                                                   "00"                                         ORI = Original
      02        Shipment Identification                                                              E1EDL20        VBELN                                                   Delivery no.
      03        Date                                                                                                                                                        CCYYMMDD - Current system date
      04        Time                                                                                                                                                        HHMMSS - Current system time
      05        Hierarchical Structure Code                                                                                    "0001"                                       Pick and Pack Format

      HL - Shipment Level (MANDATORY)
      01        Hierarchical ID Number                                                                                         <HL_COUNT1>                                  Store as <HL_SHIP>
      02        Hierarchical Parent ID Number                                                                                  ""                                           Blank for shipment
      03        Hierarchical Level Code                                                                                        "S"                                          Shipment

      TD1 - Carrier Detail (MANDATORY)
      01        Packaging Code                                                                                                 "PLT94"                                      PLT94 = Wood Pallet
      02        Lading Quantity                                                                      E1EDL20        ANZPK                                                   Number of outer pallets
      06        Weight Qualifier                                                                                               "G"                                          Gross Weight
      07        Weight                                                                               E1EDL20        BTGEW
      08        UOM                                                                                  E1EDL20        GEWEI      "LB"

      TD5 - Carrier Details (Routing) (MANDATORY)
      01        Routing sequence code                                                                                          "B"                                          Origin / Delivery Carrier (Any mode)
      02        Id code qualifier                                                                                              "2"                                          SCAC
                                                                                                                                                                            SCAC Code Value. E1ADRM1-PARTNER_Q
      03          ID code                                                                            E1ADRE1        EXTEND_D                      EXTEND_Q     "304"        = "SP"
      04          Transportation Method                                                                                        "M"                                          Standard Carrier (Motor)
      05          Routing                                                                            E1ADRM1        NAME1                         PARTNER_Q    "SP"
      10          Transit time direction qualifier                                                                             "CD"                                         Calendar days
      11          Transit Time                                                                                                 "1"                                          Number of days transit time

      REF - Reference Identifiaction - BOL (MANDATORY)
                                                                                                           Page 2 of 8
                          16f3462d-ac40-46a1-8745-0ef6137be2a2.xls                                                                                                  856 Mapping Template
                                                                   ANSI X12 Detail                               SAP Idoc Detail
                                01        Reference ID Qualifier                                          "BM"                                          Bill of Lading
                                02        Reference ID                               E1EDL20     BOLNR                                                  BOL Number

                                REF - Reference Identifiaction - Carriers Ref No
                                                                                                                                                        Carriers Reference Number. Usually same as
                                01        Reference ID Qualifier                                          "CN "                                         BOL
                                02        Reference ID                               E1EDL20     BOLNR                                                  Carrier Reference number

                                DTM - Date \ Time Reference - Shipped (MANDATORY)
                                01        Date \ Time Qualifier                                           "011"                                         Ship date
                                02        Date                                       E1EDT13     NTANF                       QUALF              "006"   CCYYMMDD

                                N1 - Name - ST - Ship To (MANDATORY)
                                01       Entity ID Code                                                   "ST"                                          Ship To
                                03       ID Code Qualifier                                                "92"                                          Assigned by Buyer

                                04        ID Code                                    E1ADRM1     TZDESC                      PARTNER_Q          "WE"    Ship to code sent in N104 where N101 = BY

                                N4 - Location - ST - Ship To Location
                                01         City                                      E1ADRM1     CITY1                       PARTNER_Q          "WE"
                                02         State                                     E1ADRM1     REGION                      PARTNER_Q          "WE"
                                03         Zip                                       E1ADRM1     POSTL_COD1                  PARTNER_Q          "WE"
                                04         Country                                   E1ADRM1     COUNTRY1                    PARTNER_Q          "WE"

                                HL - Order Level (MANDATORY)
                                01        Hierarchical ID Number                                          <HL_COUNT1>                                   Store as <HL_ORDER>
                                02        Hierarchical Parent ID Number                                   <HL_SHIP>
                                03        Hierarchical Level Code                                         "O"                                           Order. We assume 1 order per shipment.

                                PRF - PO Reference (MANDATORY)
                                01       PO Number                                   E1EDL41     BSTNR                       QUALI              "001"   PO Number
                                02       Release Number                              E1TXTP8     TDLINE                      "BEG04:Release:"           PO Release

                                TD1 - Carrier Detail
                                01        Packaging Code                                                  "PLT94"                                       PLT94 = Wood Pallet
                                02        Lading Quantity                                                                                               Number of outer pallets
                                06        Weight Qualifier                                                "G"                                           Gross Weight
                                07        Weight                                     E1EDL20     BTGEW
Shipment Level




                                08        UOM                                        E1EDL20     GEWEI    "LB"

                                REF - Reference Identifiaction - DP
                                01        Reference ID Qualifier                                          "DP"                                          Department
                                02        Reference ID                               E1TXTP8     TDLINE                      TDLINE             "DP:"   Text qualifier

                                REF - Reference Identifiaction - IA
                                01        Reference ID Qualifier                                          "IA"                                          Internal Vendor Number
                                02        Reference ID                               E1TXTP8     TDLINE                      TDLINE             "IA:"   Text qualifier

                                N1 - Name - BY - Buying Party (MANDATORY)
                                01       Entity ID Code                                                   "BY"                                          Buying party
                                03       ID Code Qualifier                                                "92"                                          Assigned by Buyer

                                04        ID Code                                    E1ADRM1     TZDESC                      PARTNER_Q          "WE"    Ship to code sent in N104 where N101 = BY

                                HL - Tare Level (Pallet)
                                01         Hierarchical ID Number                                         <HL_COUNT1>                                   Store as <HL_TARE>
                                02         Hierarchical Parent ID Number                                  <HL_ORDER>
                                03         Hierarchical Level Code                                        "T"                                           Tare is equivalent to a pallet

                                MAN - Marks and Numbers
                                01       Marks and Numbers Qualifier                                      "GM"                                          SSCC-18 and Application Identifier
                 r Loop




                                                                                         Page 3 of 8
                           16f3462d-ac40-46a1-8745-0ef6137be2a2.xls                                                                                                                                                   856 Mapping Template
                                                                                        ANSI X12 Detail                                                              SAP Idoc Detail
                                                      02         Marks and Numbers                                                        E1EDL37     EXIDV                                                Pallet barcode
Order Loop




                                                      HL - Pack Level (Carton) (MANDATORY)
                                                      01        Hierarchical ID Number                                                                        <HL_COUNT1>                                  Store as <HL_PACK>
                                                      02        Hierarchical Parent ID Number                                                                 <HL_TARE>
                                                      03        Hierarchical Level Code                                                                       "P"                                          Pack is equivalent to Carton

                                                      PO4 - Item Physical Details (MANDATORY)
                                                      01        Pack                                                                      E1EDL44     VEMNG                      VELIN    "3"              Number of inner containers
                                                      06        Gross weight per Pack                                                     E1EDL44     PARID                      VELIN    "3"
                                                      07        UOM                                                                                           "LB"                                         Pounds
                                                      10        Length
                                                      11        Width
                                                      12        Height
                                                      13        UOM                                                                                           "IN"                                       Inches
                                                                                                                                                                                                         Text Qualifier. Note that the inner pack
             Pallet Loop




                                                                                                                                                                                                         comes in the PO at the line item level. This
                                                                                                                                                                                                         mapping is at the carton level. Ie. All the
                                                      14         Inner Pack                                                               E1EDL44     CHARG                      TDLINE   "INNER PACK: " items in this carton need the same detail
                           Carton Loop




                                                      MAN - Marks and Numbers (MANDATORY)
                                                      01       Marks and Numbers Qualifier                                                                    "GM"                                         SSCC-18 and Application Identifier
                                                      02       Marks and Numbers                                                          E1EDL44     EXIDV                                                Carton barcode

                                                      HL - Item Level (MANDATORY)
                                                      01         Hierarchical ID Number                                                                       <HL_COUNT1>
                                                      02         Hierarchical Parent ID Number                                                                <HL_PACK>
                                                      03         Hierarchical Level Code                                                                      "I"                                          Item

                                                      LIN - Item ID (MANDATORY)
                                                      01         Assigned ID                                                                                  "6"
                                                      02         Product ID Qualifier                                                                         "CB"                                         Buyer's catolog number
                                         Item Level




                                                      03         Product ID                                                               E1EDL44     MATNR                      TDLINE   "CB:"            User exit pulls data to E1EDL44
                                                      04         Product ID Qualifier                                                                         "UP"                                         UPC Package Code (1-5-5-1)
                                                      05         Product ID                                                               E1EDL44     KDMAT                      TDLINE   "UP:"            User exit pulls data to E1EDL44

                                                      SN1 - Item detail (Shipment) (MANDATORY)
                                                      02        Number of units shipped                                                   E1EDL24     LFIMG
                                                      03        UOM                                                                                           "EA"                                         Eaches or cases can be used

                                                      PO4 - Item Physical details (Only mandatory if PO4 not present at the PACK level)
                                                      01        Pack                                                                      E1EDL44     VEMNG                                             Number of eaches inside the item
                                                      14        Inner Pack                                                                E1EDL44     CHARG                      TDLINE   "INNER PACK:" User exit pulls data to E1EDL44

                                                      CTT - Transaction Totals (MANDATORY)
                                                      01        Number of line items                                                                          <HL_COUNT1>                                  Number of HL segments




                                                                                                                                              Page 4 of 8
Inbound EDI Schedule Release Set-up


Action
WE20 - Partner Profile 1: Customer 1000111, Partner Type: KU, Partner
Function: SP, Message Type: DESADV, Receiver Port: GENTRAN, Basic Type:
DELVRY01. Message Control: App: V2, Message: Z856, Process Code ZDEP.
EDI Standard: X, Message: 856PAL, Version:004010
WE20 - Partner Profile 2: Customer 1000111, Partner Type: KU, Partner
Function: SP, Message Code: CTN, Message Type: DESADV, Receiver Port:
GENTRAN, Basic Type: DELVRY01. Message Control: App: V2, Message:
Z856, Process Code ZDEC. EDI Standard: X, Message: 856CTN,
Version:004010
XK02 - Vendor master needs SCAC code loaded in the SCAC code field
located on the control screen
XD02 - Customer master 1000111 requires the ship to codes listed in the
partner description field on the Partner functions fields found in the sales area
link of the customer master
VOE4 - Ship to codes 0551 … linked to applicable ship to customer numbers in
SAP
CMOD - Activate project ZEDI
BD55 - Link to DESADV:
LS DEV200YPCC KU 1000111 SP E1ADRM1 N104
LS DEV200YPCC KU 1000111 SP E1EDL44 PACKING




16f3462d-ac40-46a1-8745-0ef6137be2a2.xls - Config Notes                             5
Inbound EDI Schedule Release Set-up


Considerations
Pallet processing partner profile



Carton processing partner profile




Note: The DEV200YPCC is linked to the client you are in. Switch to the applicable Logical System for the client
you are configuring for.




16f3462d-ac40-46a1-8745-0ef6137be2a2.xls - Config Notes                                                           6
Sample Data                Testing



 Order   Delivery   Date




                                7
Date    Name            Version Nature of Change
03/27/03 Kevin Wilson      1    Created document

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:35
posted:8/2/2011
language:English
pages:8
Description: Sample It Company Profile document sample