FLOG_SHPTSTGASND

Transparent Table Application Table

Draft table for entity R_FLDLOGSSHPTVOYASSGMTTP

FLOG_SHPTSTGASND is an SAP database table in S/4HANA. Draft table for entity R_FLDLOGSSHPTVOYASSGMTTP. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_FldLogsShptVoyItmAssgmtDraft view_entity from EXTENSION FldLog ShptVoyItmAssgmtDrft - Extension
R_FldLogsShptVoyItmAssgmtDraft view_entity from BASIC Draft View Shpt Voy Item Assignment

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY fldlogsshptvoyageuuid flog_shptvoyage_uuid Voyage UUID
KEY fldlogsvoystgeassgmtuuid flog_voyagestageassgmt_uuid Voy Stge Assgmt UUID
fldlogsvoystgeassgmtsqncid flog_voyagestageassgmt_sqncid Voy Stg Assgmt Sq ID
fldlogsshipmentitemtypecode flog_shpt_itemtype_code Shpt Item Type Code
fldlogsreferencedocumentnumber flog_doc Reference Doc Number
deliverydocument abap.char
deliverydocumentitem posnr_vl Item
fldlogssrceplnt werks_d Plant
fldlogsdestplnt werks_d Plant
fldlogsvoyagesrcestage flog_srcestage Source Stage
fldlogsvoyagedeststage flog_deststage Destination Stage
fldlogsshptassignmentstatus flog_shptassgmtstatus Assignment Status
fldlogsshptitemactualweight brgew Gross Weight
fldlogsshptitemactlweightunit meins Base Unit
fldlogsvoyassgmtchangedatetme abp_locinst_lastchange_tstmpl Changed On
fldlogsshptvoyassgmtcritlty abap.int1

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.

-- Draft table for entity R_FLDLOGSSHPTVOYASSGMTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FLOG_SHPTSTGASND (
    MANDT,                           -- Client [mandt]
    FLDLOGSSHPTVOYAGEUUID,           -- Voyage UUID [flog_shptvoyage_uuid]
    FLDLOGSVOYSTGEASSGMTUUID,        -- Voy Stge Assgmt UUID [flog_voyagestageassgmt_uuid]
    FLDLOGSVOYSTGEASSGMTSQNCID,      -- Voy Stg Assgmt Sq ID [flog_voyagestageassgmt_sqncid]
    FLDLOGSSHIPMENTITEMTYPECODE,     -- Shpt Item Type Code [flog_shpt_itemtype_code]
    FLDLOGSREFERENCEDOCUMENTNUMBER,  -- Reference Doc Number [flog_doc]
    DELIVERYDOCUMENT,                -- abap.char
    DELIVERYDOCUMENTITEM,            -- Item [posnr_vl]
    FLDLOGSSRCEPLNT,                 -- Plant [werks_d]
    FLDLOGSDESTPLNT,                 -- Plant [werks_d]
    FLDLOGSVOYAGESRCESTAGE,          -- Source Stage [flog_srcestage]
    FLDLOGSVOYAGEDESTSTAGE,          -- Destination Stage [flog_deststage]
    FLDLOGSSHPTASSIGNMENTSTATUS,     -- Assignment Status [flog_shptassgmtstatus]
    FLDLOGSSHPTITEMACTUALWEIGHT,     -- Gross Weight [brgew]
    FLDLOGSSHPTITEMACTLWEIGHTUNIT,   -- Base Unit [meins]
    FLDLOGSVOYASSGMTCHANGEDATETME,   -- Changed On [abp_locinst_lastchange_tstmpl]
    FLDLOGSSHPTVOYASSGMTCRITLTY,     -- abap.int1
    PRIMARY KEY (MANDT, FLDLOGSSHPTVOYAGEUUID, FLDLOGSVOYSTGEASSGMTUUID)
);