SGT_DYNCAT

Transparent Table Application Table
30 Fields 10 CDS Views

Dynamic Segmentation

SGT_DYNCAT is an SAP database table in S/4HANA. Dynamic Segmentation. It contains 30 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
I_DfltSegmentationApplication view from BASIC Default Segmentation Application
Sgt_Dyncat_Ir_V view from Dynamic Segmentation view
Sgt_Dyncat_Ko_V view from Dynamic Segmentation view
Sgt_Dyncat_Plo_V view from Dynamic Segmentation view
Sgt_Dyncat_Po_V view from Dynamic Segmentation view
Sgt_Dyncat_Pr_V view from Dynamic Segmentation view
Sgt_Dyncat_Sb_V view from Dynamic Segmentation view
Sgt_Dyncat_So_V view from Dynamic Segmentation view
Sgt_Dyncat_Sto_V view from Dynamic Segmentation view
SGT_DYNCAT_STR_V view from Dynamic Segmentation view

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sgt_rnum SGT_RNUM Record No.
sgt_covs SGT_COVS Segment. Strategy
sgt_appl SGT_DYNAPPL Application
begda SGT_BEGDA Start date
endda SGT_ENDDA End Date
auart AUART Sales Doc. Type
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
spart SPART Division
vkgrp VKGRP Sales Group
kunnr KUNNR Customer
kdgrp KDGRP Customer Group
land1 LAND1 Country/Reg.
bsart BSART Order Type
ekorg EKORG Purchasing Org.
ekgrp EKGRP Purch. Group
lifnr LIFNR Supplier
reswk RESWK Supplying Plant
werks WERKS_D Plant
evart EVART Agreement Type
plwrk PLWRK Planning Plant
paart PAART Planned Order Type
berid BERID MRP Area
disgr DISGR MRP Group
beskz BESKZ Procurement
prgrp PRGRP Product group
matkl MATKL Material Group
sgt_catv SGT_CATV Seg. Value
sgt_dynsrc SGT_DYNSRC Dynamic Source

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.

-- Dynamic Segmentation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SGT_DYNCAT (
    MANDT,       -- Client [MANDT]
    SGT_RNUM,    -- Record No. [SGT_RNUM]
    SGT_COVS,    -- Segment. Strategy [SGT_COVS]
    SGT_APPL,    -- Application [SGT_DYNAPPL]
    BEGDA,       -- Start date [SGT_BEGDA]
    ENDDA,       -- End Date [SGT_ENDDA]
    AUART,       -- Sales Doc. Type [AUART]
    VKORG,       -- Sales Org. [VKORG]
    VTWEG,       -- Distr. Channel [VTWEG]
    SPART,       -- Division [SPART]
    VKGRP,       -- Sales Group [VKGRP]
    KUNNR,       -- Customer [KUNNR]
    KDGRP,       -- Customer Group [KDGRP]
    LAND1,       -- Country/Reg. [LAND1]
    BSART,       -- Order Type [BSART]
    EKORG,       -- Purchasing Org. [EKORG]
    EKGRP,       -- Purch. Group [EKGRP]
    LIFNR,       -- Supplier [LIFNR]
    RESWK,       -- Supplying Plant [RESWK]
    WERKS,       -- Plant [WERKS_D]
    EVART,       -- Agreement Type [EVART]
    PLWRK,       -- Planning Plant [PLWRK]
    PAART,       -- Planned Order Type [PAART]
    BERID,       -- MRP Area [BERID]
    DISGR,       -- MRP Group [DISGR]
    BESKZ,       -- Procurement [BESKZ]
    PRGRP,       -- Product group [PRGRP]
    MATKL,       -- Material Group [MATKL]
    SGT_CATV,    -- Seg. Value [SGT_CATV]
    SGT_DYNSRC,  -- Dynamic Source [SGT_DYNSRC]
    PRIMARY KEY (MANDT, SGT_RNUM)
);

Learn More