FSH_MSO

Transparent Table Application Table
12 Fields 3 CDS Views

Sales Document

FSH_MSO is an SAP database table in S/4HANA. Sales Document. It contains 12 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
Fsh_Mso_Base_Status view from Fsh_mso table Base view to calculate status
Fsh_Mso_Child_Item_V view from MSO child orders item view
Fsh_Mso_Item_View view from fsh_mso view to calculate the status per item

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY vbeln VBELN_VA Sales Document
KEY posnr POSNR_VA Item
KEY fsh_msoshpto FSH_MSOSHPTO Ship-to Partner
fsh_msoptind FSH_MSOPTIND MSO Partner Type
fsh_msocdc FSH_MSOCDC Customer DC
fsh_msopid FSH_MSOPID CustID Partner
kwmeng KWMENG Order quantity
kbmeng KBMENG CumltvConfdQty
fsh_mso_vbeln FSH_MSO_VBELN MSO Ch. Doc
fsh_mso_posnr FSH_MSO_POSNR MSO Child Item
fsh_msoexcpt FSH_MSOEXCPT Excpt. Flag

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.

-- Sales Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FSH_MSO (
    MANDT,          -- Client [MANDT]
    VBELN,          -- Sales Document [VBELN_VA]
    POSNR,          -- Item [POSNR_VA]
    FSH_MSOSHPTO,   -- Ship-to Partner [FSH_MSOSHPTO]
    FSH_MSOPTIND,   -- MSO Partner Type [FSH_MSOPTIND]
    FSH_MSOCDC,     -- Customer DC [FSH_MSOCDC]
    FSH_MSOPID,     -- CustID Partner [FSH_MSOPID]
    KWMENG,         -- Order quantity [KWMENG]
    KBMENG,         -- CumltvConfdQty [KBMENG]
    FSH_MSO_VBELN,  -- MSO Ch. Doc [FSH_MSO_VBELN]
    FSH_MSO_POSNR,  -- MSO Child Item [FSH_MSO_POSNR]
    FSH_MSOEXCPT,   -- Excpt. Flag [FSH_MSOEXCPT]
    PRIMARY KEY (MANDT, VBELN, POSNR, FSH_MSOSHPTO)
);

Learn More