Scribd Logo
Upload

Welcome to Scribd!

  • 36 views

    Container Triangulation

    Uploaded by

    Kumud
    This document contains information about export and import quantities and sales orders. It also includes planned and actual dates for shipping container movements, with notes on container status including ones that are triangulated, on hold, or needing empty provisioning. Key details are pulled from custom tables to map container requirements and availability.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Container Triangulation

    Uploaded by

    Kumud
    36 views14 pages
    This document contains information about export and import quantities and sales orders. It also includes planned and actual dates for shipping container movements, with notes on container status including ones that are triangulated, on hold, or needing empty provisioning. Key details are pulled from custom tables to map container requirements and availability.

    Original Description:

    Container Triangulation Process

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains information about export and import quantities and sales orders. It also includes planned and actual dates for shipping container movements, with notes on container status including ones that are triangulated, on hold, or needing empty provisioning. Key details are pulled from custom tables to map container requirements and availability.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    36 views14 pages

    Container Triangulation

    Uploaded by

    Kumud
    This document contains information about export and import quantities and sales orders. It also includes planned and actual dates for shipping container movements, with notes on container status including ones that are triangulated, on hold, or needing empty provisioning. Key details are pulled from custom tables to map container requirements and availability.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 14

    Export 400-500 Sales Order

    OTR

    Import 2500-3000
    BL Free Days 14/21 Planned Dates Actual Date
    IMCN1 25.10.2020 24.10.2020
    IMCN2 28.10.2020 28.10.2020
    IMCN3 31.10.2020 01.11.2020
    IMCN4 01.11.2020 01.11.2020
    IMCN5 05.11.2020 05.11.2020
    IMCN6 08.11.2020 10.11.2020
    IMCN7 09.11.2020 15.11.2020
    IMCN8 15.11.2020 12.11.2020
    IMCN9 18.11.2020
    IMCN10 20.11.2020
    01.11.2020
    Delivery
    DTR FU-->CU-- Container Requirement

    Transit Days Submission of Container


    09.11.2020
    12.11.2020
    15.11.2020
    16.11.2020
    20.11.2020

    CN1 IMCN7 Container No. IMCN1


    CN2 IMCN2
    CN3 Hold IMCN3
    CN4 Hold IMCN4
    CN5 Request Empty Provisioning IMCN5
    IMCN6
    IMCN7 Traingulated
    IMCN8 Hold
    IMCN9 Hold
    IMCN10

    20ft / 40ft
    Source Location / Destination
    Selection Screen

    Source Location Mandatory No Interval

    Container Size 2Oft

    Date Mandatory

    Fetch container units Range

    Output Screen
    Direct Mapping Hold Empty Provisioning

    Containers Requirement

    CU Src Lo Des Loc Qty req date

    13-Nov
    Status Triangulated

    Available Containers
    Logic

    Direct Mapping Update Custom table


    Also Update the container number taking from selected available contai
    Custom table staus to be updated with - 01 (Triangulated)

    Hold Update Custom table


    Custom table staus to be updated with - 02 (Hold)

    Empty Provisioning Update Custom table


    Custom table staus to be updated with - 03 (Empty Provisioned)
    Create freight order for the record selected in the left side to bring the e

    POWL 1 (Overview TriReads all entries from custom table and displays

    Triangulati 1 Triangulated
    2 Hold
    3 Empty Provisioned
    4 Released
    Custom Table

    Primary Key Direct Mapping Hold

    X MANDT X X
    X CU To be Triangulated X X
    Container Size X X
    from selected available containers Source Location X X
    1 (Triangulated) Planned Date X X
    Source Container No X
    CU selected for Triangula X X
    Dest Location X X
    Planned Vessel Arrival DaX X
    Actual Vessel Arrival Date
    B/L Free Days X X
    3 (Empty Provisioned) Planned B/L Free days en X X
    d in the left side to bring the empty containers Actual B/L Free days end X X
    Target Container No X X
    Triangulation Status X X
    Freight Order No
    Created By X X
    Creation Date X X
    Creation time X X
    Changed By X X
    Changed Date X X
    Changed Time X X

    Technical Settings
    Change Log X
    Empty Provisioning

    X
    X
    X

    X
    X
    X
    X
    X
    X
    X
    X
    Direct Mapping
    Retrieval logic ZTM_MAPPING_STAT
    CU_NUMBER
    CONTAINER_SIZE
    STOP table with First (F) SRC_LOCATION

    STOP table with F record , Field = Plan Trans Time,


    Change the desc to Planned Date PLAN_ARVL_DATE
    From Item table of your right side container, Read SOURCE_CONT_NO
    CU_SELEC_TO_TRIAN
    STOP table with First (L) DEST_LOCATION
    PLAN_VESL_ARV_DT

    ACT_VESL_ARV_DT
    BL_FREE_DAYS
    PLAN_BL_FREE_DAYS
    ACT_BL_FREE_DAYS
    TARGET_CONT_NO
    TRIANGUL_STATUS
    FREIGHT_ORD_NO
    To be filled with
    Table Field Logic
    ZTMS_S_CONTAINER_TRIANG_CU CU_NUMBER
    ZTMS_S_CONTAINER_TRIANG CONTAINER_SIZE From selection screen input (20/40ft)
    ZTMS_S_CONTAINER_TRIANG SOURCE_LOC From selection screen input (20/40ft)

    ZTMS_S_CONTAINER_TRIANG_CU REQ_DATE
    ZTMS_S_CONTAINER_TRIANG_IMP_CO CONTAINER_NUMBER
    ZTMS_S_CONTAINER_TRIANG_IMP_CO CU_NUMBER
    ZTMS_S_CONTAINER_TRIANG_IMP_CO DEST_LOCATION
    ZTMS_S_CONTAINER_TRIANG_IMP_CO PLAN_ARVL_DATE

    Read EXEC associaton (Table -


    /SCMTMS/D_TOREXE)for
    'ZTMS_S_CONTAINER_TRIANG_IMP_C
    O-CU_SELEC_TO_TRAIN' and read
    Event data of Event -
    ZEM_CU_ARRIVAL_PRT, Actual Date
    and Time value to be picked up
    ZTMS_S_CONTAINER_TRIANG_IMP_CO BL_DAYS
    Add BL_DAYS to PLAN_ARVL_DATE
    Add BL_DAYS to ACT_VESL_ARV_DT if actual date is
    ZTMS_S_CONTAINER_TRIANG_IMP_CO CONTAINER_NUMBER
    01 for Direct mapping
    Empty for Direct Mapping. To be filled only for Emp
    ARV_DT if actual date is determined

    o be filled only for Empty provisioning


    ALL only 1 record should be selected for running this functionality
    SP5210 20 31.12.2020

    You might also like