FLOG_CTNASSGMTD

Transparent Table Application Table

Draft table for entity R_FLDLOGSSHPTVOYCTNASSGMTTP

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_FldLogsShptVoyCtnAssgmtDraft view_entity from EXTENSION FldLog ShptVoyCtnAssgmtDrft - Extension
R_FldLogsShptVoyCtnAssgmtDraft view_entity from BASIC Draft View Shpt Voy container 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
fldlogscontainerid flog_contid Container ID
fldlogssrceplnt werks_d Plant
fldlogsdestplnt werks_d Plant
fldlogsvoyagesrcestage flog_srcestage Source Stage
fldlogsvoyagedeststage flog_deststage Destination Stage
fldlogsshptassignmentstatus flog_shptassgmtstatus Assignment Status
fldlogsctnactualweight flog_container_actual_weight Ctn Actual Weight
fldlogsctnactualweightunit /sapapo/gewei Unit
fldlogsvoyassgmtchangedatetme abp_locinst_lastchange_tstmpl Changed On
fldlogsshptvoyassgmtcritlty abap.int1
isbusinesspurposecompleted cvp_xblck Purpose Completed
suplrcoisbusprpscmpltd cvp_xblck Purpose Completed

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_FLDLOGSSHPTVOYCTNASSGMTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FLOG_CTNASSGMTD (
    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]
    FLDLOGSCONTAINERID,             -- Container ID [flog_contid]
    FLDLOGSSRCEPLNT,                -- Plant [werks_d]
    FLDLOGSDESTPLNT,                -- Plant [werks_d]
    FLDLOGSVOYAGESRCESTAGE,         -- Source Stage [flog_srcestage]
    FLDLOGSVOYAGEDESTSTAGE,         -- Destination Stage [flog_deststage]
    FLDLOGSSHPTASSIGNMENTSTATUS,    -- Assignment Status [flog_shptassgmtstatus]
    FLDLOGSCTNACTUALWEIGHT,         -- Ctn Actual Weight [flog_container_actual_weight]
    FLDLOGSCTNACTUALWEIGHTUNIT,     -- Unit [/sapapo/gewei]
    FLDLOGSVOYASSGMTCHANGEDATETME,  -- Changed On [abp_locinst_lastchange_tstmpl]
    FLDLOGSSHPTVOYASSGMTCRITLTY,    -- abap.int1
    ISBUSINESSPURPOSECOMPLETED,     -- Purpose Completed [cvp_xblck]
    SUPLRCOISBUSPRPSCMPLTD,         -- Purpose Completed [cvp_xblck]
    PRIMARY KEY (MANDT, FLDLOGSSHPTVOYAGEUUID, FLDLOGSVOYSTGEASSGMTUUID)
);