Docstoc

System Application Overview Template - Excel

Document Sample
System Application Overview Template - Excel Powered By Docstoc
					                                                 693d1b7c-40d1-475f-b22d-135fb905f59f.xls



           856 Mapping Template
  X12 Transaction                     856
  X12 Version                        4010
  Idoc Type                      DELVRY02
  Extension Type                  ZLVRY02
  Message Type                    DESADV
  Direction to SAP               Outbound
  Created by                    Kevin Wilson
  System ID                       SAPP20
  Sender Port                      SAPEDI
  Logical System                LOGSYS300
  Client                              300
  Partner Number                 12345678
  Remit To                      Company X
  Order Type                        ZORD
  Sales Org                          1000
  Dist Channel                         10
  Division                             20
  Unit of Measure                     CS
  Language                             E
  Currency                           USD
  Sender ID                     0111222333
  Sender ID Qual                       01
  Receiver ID                   2223334445
  Receiver ID Qual                     01
  GS02                                123
  GS03                              54321

  Comments:             Please log all changes to this document in the Change Log worksheet of this, explaining reason for changes.
  There is requirement for one purchase order per delivery
  SAP configuration must restrict combining of orders on deliveries
  BOL number (Mandatory) - Populate BOL Number on Transport relevant screen of delivery
  Carrier reference number - Populate the external delivery number on the overview screen of the delivery
  SCAC ID code (Mandatory) - Assumed that SCAC is entered into ROUTE field on transport relevant screen on the delivery




Overview                                                  Wella Corp. Confidential                                                    Page 1
                                                                                           693d1b7c-40d1-475f-b22d-135fb905f59f.xls

                                              ANSI Detail                                                                                 Idoc Detail
         Seg               Data Element Name                Codes and comments                         Constant       Idoc Segment      Field       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                         0111222333
        ISA07 Interchange ID Qualifier                      01
        ISA08 Intechange Receiver ID                        2223334445
        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" Shipping Advice
        GS02 Application Senders Code                       123
        GS03 Application Receiver's Code                    54321
        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 - Beginning segment for ship notice(Mandatory)
        01 Transaction Set Purpose Code                                                                   OO                                                               ORI = Original
        02 Shipment Identification                                                                                     E1EDL20          VBELN                              Delivery no.
        03 Date                                   System date                                        System date                                                           CCYYMMDD - Current system date
        04 Time                                   System time                                        System time                                                           HHMMSS - Current system time

       HL - Hierarchial level - Shipment Level (Mandatory)
        01 Hierarchical ID Number                    HL segment sequential number                                                                                          Sequential accumulator HL
        03 Hierarchical Level Code                   1 Occurrence                                    S = Shipment

       TD1 - Carrier details - Quantity and Weight (Mandatory)
                                                            BOX = Box
                                                            BXI = Box with inner cntnr
                                                                                                      Pallets = PLT
         01    Packaging Code                               CTN = Carton
                                                                                                      Boxes = BOX
                                                                                                                       Z1HEAD         PACK_CODE
                                                            PLT = Pallet
                                                            90 = Standard
         02    Lading Quantity                              Number of Pieces in Shipment                               E1EDL20          ANZPK                              Number of pieces relating to TD101
         06    Weight qualifier                             G = Gross weight                               G
         07    Weight                                                                                                  E1EDL20         BTGEW
                                                            KGM = Kilogram                            KG = Kilogram
         08    UOM                                          LBR = Pounds                               LB = Pounds
                                                                                                                       E1EDL20          GEWEI

       TD5 - Carrier details - Routing sequence / Transit time (Mandatory)
                                                            2 = SCAC
         02    Identification Code Qualifier                4 = IATA                                       2                                                               SCAC Qualifier
                                                            92 = Assigned by Buyer
         03    Identification Code                                                                                     E1EDL20         ROUTE


856 Template                                                                                 The Wella Corporation Confidential                                                                         Page 2
                                                                                      693d1b7c-40d1-475f-b22d-135fb905f59f.xls

        Seg               Data Element Name             Codes and comments                        Constant     Idoc Segment      Field    Qual Field   Qual Value Notes on Mapping Document
                                                        A = Air
                                                        D = Parcel post
                                                        H = Customer pickup
         04    Transportation Method/Type Code          M = Motor (common Carrier)
                                                                                                     M
                                                        AE = Air Express
                                                        LT = less than trailer load
                                                        CC = Shipment complete
                                                        CP = Partial shipment, No backorder
                                                        PD = PO complete
         06    Shipment / Order status code             PR = Partial shipment
                                                                                                    CC                                                           Shipment status
                                                        SH = Shipped
                                                        SJ = Shipped as indicated


       TD3 - Carrier details -Equipment
         01 Equipment description code                                                                                                                           Any valid ANSI X12 Code
         02 Equipment initial                                                                                                                                    Prefix of unit’s identifying number
         03 Equipment number                                                                                                                                     Unit’s identifying number

       REF - Shipment Reference number - Carrier reference number
        01 Reference Identification Qualifier         CN=Carrier Reference #                        CN
        02 Reference Identification                                                                              E1EDL20         LIFEX

       REF - Shipment Reference number - Bill of lading (Mandatory)
        01 Reference Identification Qualifier       BM = Bill of Lading no.                         BM
        02 Reference Identification                                                                              E1EDL20         BOLNR

       DTM - Date time reference for shipment - Shipped (Mandatory)
        01 Date\Time Qualifier                      011 = Shipped                                   011
        02 Date                                                                                                  E1EDT13         IEDD      QUALF          006    Goods issue date
        03 Time

       DTM - Date time reference for shipment - Current scheduled delivery
        01 Date\Time Qualifier                         067 = Current scheduled delivery             067
        02 Date
        03 Time

       N1 - Name (Mandatory)
        01 Entity Identifier Code                       SF = Ship from                               SF
        02 Name                                         Location Name of shipment origin                        E1ADRM1          NAME1   PARTNER_Q       OSP     Shipping point

       N4 - Geographic location (Mandatory)
        01 City name                                                                                            E1ADRM1          CITY1   PARTNER_Q       OSP     City
        02 State or province code                                                                               E1ADRM1         REGION   PARTNER_Q       OSP     State
        03 Postal code                                                                                          E1ADRM1       POSTL_COD1 PARTNER_Q       OSP     ZIP

       HL - Hierarchial level - Order Level (Mandatory)
        01 Hierarchical ID Number                     HL segment sequential number                                                                               Sequential accumulator HL
        03 Hierarchical Level Code                    O = Order                                      O                                                           Max 1 occurrence

       PRF - Purchase Order Reference (Mandatory)

                                                                                                                                                                 Rite Aid's PO #. This is stored at the line
         01    Purchase Order Number                                                                             Z1HEAD          BSTKD                           item level in segment E1EDL41 but was
                                                                                                                                                                 included in Z1HEAD for ease of mapping


       TD5 - Carrier details - Routing sequence / Transit time (Mandatory)




856 Template                                                                            The Wella Corporation Confidential                                                                       Page 3
                                                                                                     693d1b7c-40d1-475f-b22d-135fb905f59f.xls

                         Seg               Data Element Name            Codes and comments                       Constant     Idoc Segment       Field   Qual Field   Qual Value Notes on Mapping Document
                                                                        CC = Shipment complete
                                                                        CP = Partial shipment, No backorder
                                                                        PD = PO complete
                          06   Shipment / Order status code             PR = Partial shipment
                                                                                                                   CC                                                           Order Status
                                                                        SH = Shipped
                                                                        SJ = Shipped as indicated


                        HL - Hierarchial level - Tare Level
                         01 Hierarchical ID Number                      HL segment sequential number                                                                            Sequential accumulator HL
           Tare Level




                         03 Hierarchical Level Code                     T = Tare                                    T

                        MAN - Markings and Numbers
                          01   Marks and Numbers Qualifier                                                         GM                                                           UCC-128 Serial shipping container code
                          02   Marks and Numbers                                                                               Z1PACK1          EXIDV                           Corresponding number to MAN01

                        HL - Hierarchial level - Pack Level
                         01 Hierarchical ID Number                      HL segment sequential number                                                                            Sequential accumulator HL
                         03 Hierarchical Level Code                     P = Pack                                    P
           Pack Level




                        MAN - Markings and Numbers
                                                                        UC = UPC Shipping Container Code
                          01   Marks and Numbers Qualifier              GM = UCC-128 Serial shipping container     UC                                                           UPC Shipping container code
                                                                        code
                          02   Marks and Numbers                                                                                Z1ITEM1         EAN11                           Corresponding number to MAN01

                        HL - Hierarchial level - Item Level (Mandatory)
                         01 Hierarchical ID Number                      HL segment sequential number                                                                            Sequential accumulator HL
                         03 Hierarchical Level Code                     I = Item                                     I

                        LIN - Item Identification (Mandatory)
                                                                                                                                                                                Rite Aid's Item Number. Only 1 of these
                          02   Product/Service ID Qualifier             Preferred qualifer = IN                     IN
                                                                                                                                                                                is required
                          03   Product/Service ID                                                                               Z1ITEM1         KDMAT
                          04   Product/Service ID Qualifier                                                        UA                                                           UPC/EAN Case Code (2-5-5)
                          05   Product/Service ID                                                                               Z1ITEM1         EAN11B
                          06   Product/Service ID Qualifier                                                         UI                                                          UPC CPC (1-5-5)
                          07   Product/Service ID
                          08   Product/Service ID Qualifier                                                        VN                                                           Vendor's MFI Number
                          09   Product/Service ID
                          10   Product/Service ID Qualifier                                                        ND                                                           NDC Number
                          11   Product/Service ID
 Package




                        SN1 - Item Detail (Mandatory)
                         02 Number of Units Shipped                                                                             Z1ITEM1         VEMNG
                         03 Unit or Basis for Measurement Code          Each or Case                             EA or CA       Z1ITEM1         VEMEH
                         04 Quantity shipped to date
                         05 Quantity ordered
                         06 UOM                                         Each or Case                             EA or CA
           Item Level




856 Template                                                                                            The Wella Corporation Confidential                                                                    Page 4
 Pa
                                                                                       693d1b7c-40d1-475f-b22d-135fb905f59f.xls

                    Seg              Data Element Name   Codes and comments                        Constant     Idoc Segment        Field    Qual Field   Qual Value Notes on Mapping Document

                                                         AC Accepted and Shipped
                                                         BP Accepted, Partial, Balance
      Item Level                                         Backordered
                                                         IA Item Accepted
                                                         IB Item Backordered
                                                         IC Item Accepted, Changes Made
                                                         ID Item Deleted
                                                         IE Item Accepted, Price Pending
                                                         IF Item on Hold, Incomplete Description
                     08   Line item status code          IH Item on Hold
                                                                                                     AC
                                                         IP Item Accepted, Price Changed
                                                         IQ Item Accepted, Quantity Changed
                                                         IR Item Rejected
                                                         IS Item Accepted, Substitution Made
                                                         IW Item on Hold, Waiver Required
                                                         R2 Rejected, Invalid Item Product
                                                         Number
                                                         R3 Rejected, Invalid Unit of Issue



                   P04 - Item Physical Details
                     01 Pack                                                                                      Z1ITEM1          UMVKZ
                     02 Size
                     03 UOM
                     04 Inner Pack

                   PID - Item Description (Mandatory)
                     01 Description type                 Free form                                    F
                     05 Description                                                                               Z1ITEM1          ARKTX

                   DTM - Date \ Time Reference
                    01 Date \ Time Qualifier             Expiration date                             036
                    02 Date                                                                                       Z1ITEM1         EXP_DATE




856 Template                                                                              The Wella Corporation Confidential                                                                     Page 5
                                                                     693d1b7c-40d1-475f-b22d-135fb905f59f.xls



Step Trans     Action                                                                                   Considerations
     Code
  1   VD02     Maintain the customer master data for the ship-to:                                       Output in IDoc field E1ADRE1-EXTEND_D where E1ADRE1-EXTEND_Q =
               Enter sold-to customer number.                                                           '300' and E1ADRM1-PARTNER_Q = 'WE'
               Click on [Sales area data].
               On the Sales view, enter the Acct. at Cust. (KNVV-EIKTO) - This value must be returned
               to the customer in the N104 field where N101=SE.
  2   XK02     Maintain the vendor master data for the carrier (forwarding agent) partner:              Output in IDoc field E1ADRE1-EXTEND_D where E1ADRE1-EXTEND_Q =
               Select General Data, Control view.                                                       '304' and E1ADRM1-PARTNER_Q = 'SP' (external code 'CR')
               Enter Reference data - SCAC value.
  3   WE20     Create a partner profile for the sold-to partner:
               Partner type: KU
               Make an Outbound parmtrs. record for Message type 'DESADV' -
               1. Outbound Options -
                  Receiver Port: ??
                  Syntax check: x
                  Basic type: DELVRY03
                 Transfer Immediately: x
               2. Message Control -
                 Application: V2
                 Message type: Z856
                 Process Code: ZDEL
  4   SPRO     Configure an output type for EDI ASNs….                                                  Copy LAVA to Z856
  5   VHAR     Packaging material types:
               Check for values to cross-reference in map

               The following are required in the delivery creation process to enable the various
               components of the 856:
               BOL number (Mandatory) - Populate BOL Number on Transport relevant screen of
               delivery
               Carrier reference number - Populate the external delivery number on the overview
               screen of the delivery
               SCAC ID code (Mandatory) - Assumed that SCAC is entered into ROUTE field on
               transport relevant screen on the delivery
               The expiration date has not been implemented




Config Notes                                                            The Wella Corporation Confidential                                                               Page 6
                                                           693d1b7c-40d1-475f-b22d-135fb905f59f.xls



 Trading Partner   Delivery    IDoc Number                               Notes

     Company Y     80000075 1223012 (DELVRY02) See Screendump for packing detail
     Company Y     80000075 1223013 (DESADV01) See Screendump for packing detail
     Company Y     80000075       1226028      Idoc type: DELVRY02, Extension type: ZLVRY02. See
                                               Screendump 1 for packing detail




DEV Testing                                                   The Wella Corporation Confidential      Page 7
                                      693d1b7c-40d1-475f-b22d-135fb905f59f.xls
Delivery: 80000075




Materials: PS1003    "E" Containers
           PS1040    Pallet
           PS1041    UPS Box

       Screendump                       The Wella Corporation Confidential       Page 8
              693d1b7c-40d1-475f-b22d-135fb905f59f.xls




Screendump1     The Wella Corporation Confidential       Page 9
                       693d1b7c-40d1-475f-b22d-135fb905f59f.xls


Date         Name   Version RevisionNature of Change




Change Log               The Wella Corporation Confidential       Page 10
                                                                                  693d1b7c-40d1-475f-b22d-135fb905f59f.xls

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                 0111222333
ISA07           Interchange ID Qualifier              01
ISA08           Intechange Receiver ID                2223334445
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                         "IN" Invoice
GS02            Application Senders Code              123
GS03            Application Receiver's Code           54321
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
01                                                                                        E1EDL18        QUALF        "00"                                     ORI = Original
02                                                                                        E1EDL20        VBELN                                                 Delivery no.
03                                                                                                                                                             CCYYMMDD - Current system date
04                                                                                                                                                             HHMMSS - Current system time

DTM
01                                                                                                                    "011"                                    Shipped
02                                                                                        E1EDT13        IEDD                        QUALF        "006"        CCYYMMDD - Goods Issue final date
                                                                                                                                                               HHMMSS - Goods Issue final time
                                                                                                                                                               (If no time in IDoc, map must use current
03                                                                                        E1EDT13        IEDZ                        QUALF        "006"        system time)
                                                                                                                                                               CT = Central time
                                                                                                                                                               ET = Eastern time
                                                                                                                                                               GM = Greenwich Mean time
                                                                                                                                                               MT = Mountain time
04                                                                                                                    "PT"                                     PT = Pacific time

HL
01              Hierarchical ID Number                HL segment sequential number
02              Hierarchical Parent ID Number         HL01 of parent level
03              Hierarchical Level Code               (Max 1 occurrence for CUST X)                                   S = Shipment
04              Hierarchical Child Code               Indicates if child exists

TD1




      Sample                                                                          The Wella Corporation Confidential                                                                       Page 11
                                                                                  693d1b7c-40d1-475f-b22d-135fb905f59f.xls

                                                    BOX = Box
                                                    BXI = Box with inner cntnr                                       Pallets = PLT
                                                    CTN = Carton                                                     Cartons = CTN
                                                    PLT = Pallet                                                     Boxes = BOX
01             Packaging Code                       90 = Standard                        E1EDL38        VHART_BEZ    Other = 71                          Packaging material type descriptions
                                                                                                                                                         Ship quantity in PCE - sum of E1EDL24-
02             Lading Quantity                                                           Z1EDS01        SUMME                           SUMID      004   LGMNG (check E1EDL24-MEINS = 'PCE')
06             Weight qualifier                                                                                      G = Gross weight


                                                                                                                                                         Sum of E1EDL37-BRGEW. (The gross
                                                                                                                                                         weight in E1EDL20-BTGEW does not include
07             Weight qualifier                                                          Z1EDS01        SUMME                           SUMID      022   packaging material.) Follows E1EDL20
                                                    KG = Kilogram                                                    KGM = Kilogram
08             UOM                                  LB = Pound                           Z1EDS01        GEWEI        LBS = Pounds                        Weight UoM - take first 2-char of SAP value

TD5
01             Routing Sequence Code                O = Origin carrier                                               O
                                                    2 = SCAC
                                                    4 = IATA
02             Identification Code Qualifier        92 = Assigned by Buyer                                           2
                                                                                                                                                         ID code - Assumed that SCAC is entered into
03             Identification Code                                                       E1ADRE1        EXTEND_D                        EXTEND_Q   304   SCAC field on carrier vendor master
                                                    A = Air
                                                    D = Parcel post
                                                    H = Customer pickup
                                                    M = Motor (common Carrier)
                                                    AE = Air Express
04             Transportation Method/Type Code      LT = less than trailer load          E1EDL28        VSART
05             Routing                                                                   E1ADRM1        NAME1                           PARTNER_Q SP     Carrier name

REF
01             Reference Identification Qualifier   AW = Air Waybill no.                                             AW
                                                                                                                                                         May be multiple - comma-separated in IDoc
02             Reference Identification                                                  E1EDL20        LIFEX                                            field

REF
01             Reference Identification Qualifier   BM = Bill of Lading no.                                          AW
02             Reference Identification                                                  E1EDL20        BOLNR

REF
01             Reference Identification Qualifier   PK = Packing List no.                                            AW
02             Reference Identification                                                  E1EDL20        VBELN                                            SAP delivery no.

N1
01             Entity Identifier Code                                                    E1EDKA1        PARVW        SE                                  SE = Selling party
02             Name                                                                      E1ADRM1        NAME1                           PARTNER_Q OSO
03             Identification Code Qualifier                                                                         92                                  92 = Assigned by Buyer
                                                                                                                                        E1ADRM1-
                                                                                                                                        PARTNER_Q
                                                                                                                                        = 'AG' and       CUST X vendor number (from Acct. at Cust.,
04             Identification Code                                                       E1ADRE1        EXTEND_D                        EXTEND_Q 300     VNVV-EIKTO, on ship-to customer master)

HL
01             Hierarchical ID Number               HL segment sequential number
02             Hierarchical Parent ID Number        HL01 of parent level
03             Hierarchical Level Code              (Max 1 occurrence for CUST X)                                    I = Item
04             Hierarchical Child Code              Indicates if child exists

LIN



      Sample                                                                        The Wella Corporation Confidential                                                                  Page 12
                                                                693d1b7c-40d1-475f-b22d-135fb905f59f.xls

                                                                                                                              Custom code reads VBEH with key:
                                                                                                                              scheduling agreement no. = E1EDL43-
                                                                                                                              BELNR and item no. = E1EDL43-POSNR
                                                                                                                              (where E1EDL43-QUALF='E') and delivery
                                                                                                                              date = E1EDL24-ABRDT. Note that the
                                                                                                                              delivery line item may be from a sales order
                                                                                                                              instead of a scheduling agreement - in this
                                                                                                                              case, the PO number would be found in the
                                                                                                                              E1EDL41-BSTNR field and line item in
                                                                                                                              E1EDL41-POSEX (where E1EDL41-
01             Assigned Identification                                 Z1SUBITEM      POSEX                                   QUALI='001').
02             Product/Service ID Qualifier                                                        BP                         BP = Buyer's part no.
03             Product/Service ID                                      E1EDL24        KDMAT35                                 mandatory
04             Product/Service ID Qualifier                                                        EC                         EC = Eng. Change level
05             Product/Service ID                                      N/A                                                    Optional - not used by UTY
06             Product/Service ID Qualifier                                                        VP                         VP = Vendor's part no.
07             Product/Service ID                                      E1EDL24        MATNR
08             Product/Service ID Qualifier                                                        COO                        Country of Origin
09             Product/Service ID                                      Z1SUBITEM      STABE                                   mandatory

SN1
                                                                                                                              Custom code must combine qtys for all L37
                                                                                                                              segs for this item for this country of origin -
02             Number of Units Shipped                                 Z1SUBITEM      LFIMG                                   sum of E1EDL44-VEMNG
                                                                                                                              If not PCE, custom code must calculate
03             Unit or Basis for Measurement Code   EA = Each          E1EDL44        VEMEH        PCE or ROL                 correct EA qty

PRF
                                                                                                                              See LIN01 - from VBLB-USR01 linked via
01             Purchase Order Number                                   Z1SUBITEM      EBELN                                   VBEH
                                                                                                                              Number assigned by orderer to identify a
                                                                                                                              specific change or revision to a previous
03             Change Order Sequence Number                                                                                   transaction set - not used

CTT
01             Number of Line Items                                    Z1EDS01        SUMME                     SUMID   001   Count of ZSUBITEM segs.




      Sample                                                      The Wella Corporation Confidential                                                             Page 13

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:8
posted:8/17/2011
language:French
pages:13
Description: System Application Overview Template document sample