MARC_APS_EXT

Transparent Table Application Table
12 Fields 5 CDS Views

Enhancement of MARC for Advance Planning

MARC_APS_EXT is an SAP database table in S/4HANA. Enhancement of MARC for Advance Planning. It contains 12 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_ProductPlantAdvPlanEnhanced view from BASIC Master Data Extension
P_Prdscm_Locmap_Marc view left_outer Join of MARC, /SAPAPO/LOCMAP
ScmPrd_Locmap_Marc view left_outer Join of MARC, /SAPAPO/LOCMAP
ScmPrd_Matlotsz_Union view left_outer Union of MARC and MDMA
SDM_MARC_APS_EXT_DD view left_outer CDS view: migration status for marc_aps_ext for SDM

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
maxdos_pen PPO_MAXDOS_PENALTY Penalty MaxDoS
maxdos_flg PPO_MAXDOS_FLAG Is Max Dos Active
saftystock_method /SAPAPO/MSDP_SB_METHOD Safety Stock Method
target_stock_level_meth /SAPAPO/TARGET_METHOD Targ.Stk Lvl Md
auto_det_sftystk_meth SAFTY_STOCK_METH_DETN Sfty Stk Meth Detn
use_period_factor /SAPAPO/RRP_REQ_COVER_FLAG Use Period Fac.
period_factor_value /SAPAPO/RRP_REQ_COVER_TYPE Period Factor
period_factor_tds PERIOD_FACTOR_TDS Period Factor TDS
convh /SAPAPO/CONVH PP/DS Horizon

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.

-- Enhancement of MARC for Advance Planning
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MARC_APS_EXT (
    MANDT,                    -- Client [MANDT]
    MATNR,                    -- Material [MATNR]
    WERKS,                    -- Plant [WERKS_D]
    MAXDOS_PEN,               -- Penalty MaxDoS [PPO_MAXDOS_PENALTY]
    MAXDOS_FLG,               -- Is Max Dos Active [PPO_MAXDOS_FLAG]
    SAFTYSTOCK_METHOD,        -- Safety Stock Method [/SAPAPO/MSDP_SB_METHOD]
    TARGET_STOCK_LEVEL_METH,  -- Targ.Stk Lvl Md [/SAPAPO/TARGET_METHOD]
    AUTO_DET_SFTYSTK_METH,    -- Sfty Stk Meth Detn [SAFTY_STOCK_METH_DETN]
    USE_PERIOD_FACTOR,        -- Use Period Fac. [/SAPAPO/RRP_REQ_COVER_FLAG]
    PERIOD_FACTOR_VALUE,      -- Period Factor [/SAPAPO/RRP_REQ_COVER_TYPE]
    PERIOD_FACTOR_TDS,        -- Period Factor TDS [PERIOD_FACTOR_TDS]
    CONVH,                    -- PP/DS Horizon [/SAPAPO/CONVH]
    PRIMARY KEY (MANDT, MATNR, WERKS)
);

Learn More