SAUF

Transparent Table Application Table
25 Fields 1 CDS Views

SOP Orders

SAUF is an SAP database table in S/4HANA. SOP Orders. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SalesOperationsPlanningOrder view_entity from BASIC Sales Operations Planning Order

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY safnr SAFNR SOP Order
gstru GSTRU Table
fname STFNA Field name
plobj PLOBJ Planning object
matnr MATNR Material
werks WERKS_D Plant
vsnda VSNDA Prod. Version
vagrp VAGRP Planner Group
dispo DISPO MRP Controller
fhori FHORI Margin Key
vondat VONDAT Valid From
bisdat BISDAT Valid to
perkz PERKZ Period Ind.
periv PERIV FY Variant
perna PERNAME Period name
menge PRODU Production
meins MEINS Base Unit
bedid_1 BEDID Capacity Requirement
bedid_2 BEDID Capacity Requirement
bedid_3 BEDID Capacity Requirement
trmer_1 TRMER Schedul. Error
trmer_2 TRMER Schedul. Error
trmer_3 TRMER Schedul. Error
vrsio VRSIO Version

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.

-- SOP Orders
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SAUF (
    MANDT,    -- Client [MANDT]
    SAFNR,    -- SOP Order [SAFNR]
    GSTRU,    -- Table [GSTRU]
    FNAME,    -- Field name [STFNA]
    PLOBJ,    -- Planning object [PLOBJ]
    MATNR,    -- Material [MATNR]
    WERKS,    -- Plant [WERKS_D]
    VSNDA,    -- Prod. Version [VSNDA]
    VAGRP,    -- Planner Group [VAGRP]
    DISPO,    -- MRP Controller [DISPO]
    FHORI,    -- Margin Key [FHORI]
    VONDAT,   -- Valid From [VONDAT]
    BISDAT,   -- Valid to [BISDAT]
    PERKZ,    -- Period Ind. [PERKZ]
    PERIV,    -- FY Variant [PERIV]
    PERNA,    -- Period name [PERNAME]
    MENGE,    -- Production [PRODU]
    MEINS,    -- Base Unit [MEINS]
    BEDID_1,  -- Capacity Requirement [BEDID]
    BEDID_2,  -- Capacity Requirement [BEDID]
    BEDID_3,  -- Capacity Requirement [BEDID]
    TRMER_1,  -- Schedul. Error [TRMER]
    TRMER_2,  -- Schedul. Error [TRMER]
    TRMER_3,  -- Schedul. Error [TRMER]
    VRSIO,    -- Version [VRSIO]
    PRIMARY KEY (MANDT, SAFNR)
);

Learn More