OIGSS

Transparent Table Application Table
53 Fields 1 CDS Views

TD Shipment Stages

OIGSS is an SAP database table in S/4HANA. TD Shipment Stages. It contains 53 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BulkShipmentStage view from BASIC Bulk Shipment Stage

Fields (53)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY shnumber OIG_SHNUM Bulk shipment
KEY tsnum TSNUM Stage no.
tstyp TSTYP Stage category
tsrfo TSRFO Seq.stage
veh_nr OIG_VEHNR Vehicle Seq. No
elupd ELUPD Change
cre_name ERNAM Created By
cre_date ERDAT Created On
cre_time ERZET Time
cha_name AENAM Changed By
cha_date AEDAT Changed On
cha_time AEZET Time of change
route ROUTES Route for stage
vsart VERSARTS Shp.type: stage
laufk LAUFS Leg indicator
adrna ADRNA DepartureAddr.
knota KNOTA Departure point
vstel VSTELA ShpPtDeparture
lstel LSTELA Dep.load.point
werka WERKSA Plant dep.
lgorta LGORTA Dep.pnt st.loc.
kunna KUNNA Cust.depart.pt
lifna LIFNA Vendor dep.point
adrnz ADRNZ DestinAddr
knotz KNOTZ Dest.point
vstez VSTELZ ShPtDestination
lstez LSTELZ DestLoadPoint
werkz WERKSZ Plant dest.pnt
lgortz LGORTZ Dest: stor.loc.
kunnz KUNNZ Cust.dest.point
lifnz LIFNZ Vendor destin.pt
tdlnr TDLNRS Service agent
distz DISTZ Distance
medst MEDST UoM-Distance
oig_gesztd OIG_GESZTD Total time
oig_fahztd OIG_FAHZTD Travel time
meizt MEIZT Trav. times
adrknza ADRKNZA Dep.: Addr.ind.
kunabla KUNABLA Dep.:Unl.point
adrknzz ADRKNZZ Dest.:Addr.ind.
kunablz KUNABLZ Dest.:Unl.point
frkrl FRKRL ShpmntCostsRel.
skalsm KALSM_TRAB Procedure
fbsta FBSTA Shipm.Csts Cal
arsta ARSTA Shpmt Costs Set
veh_ind OIG_VEHIND Vehicle stg.
carr_rout OIG_CRROUT CR.cp
gesztd OIGGESZTDP Pl. total time
fahztd OIGEFFZTDP Plan. durat.
gesztda OIGGESZTDA Act. total time
fahztda OIGEFFZTDA Actual durat.
cont_dg ADGE_SCDG Contains DG

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- TD Shipment Stages
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIGSS (
    CLIENT,      -- Client [MANDT]
    SHNUMBER,    -- Bulk shipment [OIG_SHNUM]
    TSNUM,       -- Stage no. [TSNUM]
    TSTYP,       -- Stage category [TSTYP]
    TSRFO,       -- Seq.stage [TSRFO]
    VEH_NR,      -- Vehicle Seq. No [OIG_VEHNR]
    ELUPD,       -- Change [ELUPD]
    CRE_NAME,    -- Created By [ERNAM]
    CRE_DATE,    -- Created On [ERDAT]
    CRE_TIME,    -- Time [ERZET]
    CHA_NAME,    -- Changed By [AENAM]
    CHA_DATE,    -- Changed On [AEDAT]
    CHA_TIME,    -- Time of change [AEZET]
    ROUTE,       -- Route for stage [ROUTES]
    VSART,       -- Shp.type: stage [VERSARTS]
    LAUFK,       -- Leg indicator [LAUFS]
    ADRNA,       -- DepartureAddr. [ADRNA]
    KNOTA,       -- Departure point [KNOTA]
    VSTEL,       -- ShpPtDeparture [VSTELA]
    LSTEL,       -- Dep.load.point [LSTELA]
    WERKA,       -- Plant dep. [WERKSA]
    LGORTA,      -- Dep.pnt st.loc. [LGORTA]
    KUNNA,       -- Cust.depart.pt [KUNNA]
    LIFNA,       -- Vendor dep.point [LIFNA]
    ADRNZ,       -- DestinAddr [ADRNZ]
    KNOTZ,       -- Dest.point [KNOTZ]
    VSTEZ,       -- ShPtDestination [VSTELZ]
    LSTEZ,       -- DestLoadPoint [LSTELZ]
    WERKZ,       -- Plant dest.pnt [WERKSZ]
    LGORTZ,      -- Dest: stor.loc. [LGORTZ]
    KUNNZ,       -- Cust.dest.point [KUNNZ]
    LIFNZ,       -- Vendor destin.pt [LIFNZ]
    TDLNR,       -- Service agent [TDLNRS]
    DISTZ,       -- Distance [DISTZ]
    MEDST,       -- UoM-Distance [MEDST]
    OIG_GESZTD,  -- Total time [OIG_GESZTD]
    OIG_FAHZTD,  -- Travel time [OIG_FAHZTD]
    MEIZT,       -- Trav. times [MEIZT]
    ADRKNZA,     -- Dep.: Addr.ind. [ADRKNZA]
    KUNABLA,     -- Dep.:Unl.point [KUNABLA]
    ADRKNZZ,     -- Dest.:Addr.ind. [ADRKNZZ]
    KUNABLZ,     -- Dest.:Unl.point [KUNABLZ]
    FRKRL,       -- ShpmntCostsRel. [FRKRL]
    SKALSM,      -- Procedure [KALSM_TRAB]
    FBSTA,       -- Shipm.Csts Cal [FBSTA]
    ARSTA,       -- Shpmt Costs Set [ARSTA]
    VEH_IND,     -- Vehicle stg. [OIG_VEHIND]
    CARR_ROUT,   -- CR.cp [OIG_CRROUT]
    GESZTD,      -- Pl. total time [OIGGESZTDP]
    FAHZTD,      -- Plan. durat. [OIGEFFZTDP]
    GESZTDA,     -- Act. total time [OIGGESZTDA]
    FAHZTDA,     -- Actual durat. [OIGEFFZTDA]
    CONT_DG,     -- Contains DG [ADGE_SCDG]
    PRIMARY KEY (CLIENT, SHNUMBER, TSNUM)
);

Learn More