TCO43

Transparent Table Customizing Table

PP-SFC Order Profile

TCO43 is an SAP database table in S/4HANA. PP-SFC Order Profile. It contains 43 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProductionSchedulingProfile view from BASIC Production Scheduling Profile
P_MfgOrderEWMSynchronousPostg view inner BASIC

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY werks WERKS_D Plant
KEY co_prodprf CO_PRODPRF Prod. Sched. Profile
flg_rel_cr FLG_REL_CR Rel. at Opening
flg_pr_rel FLG_PR_REL Print Upon Rel.
flg_tm_rel FLG_TM_REL Schd. Upon Rel.
flg_wm_rel FLG_WM_REL WM Requisition
profile_id CY_GESPROF Overall profile
auart CO_AUFART_PP Make-to-stock
autyp AUFTYP Order category
flg_cr_rel FLG_CR_REL CR Upon Release
flg_com_qa CO_FLG_COM Avail. Prt. Qty
flg_quan_p CO_FLG_MEH No surplus
flg_quan_m CO_FLG_MIN No deficit
flg_quan_a CO_FLG_UPD QtyAdjustActualVals
flg_kap_tm CY_KAPTERM Finite sched.
flg_kap_tb CY_TBSTKZ Confirm cap.
flg_bom_ex CO_BOM_EXP New BOM
kzcla KZCLA Classif.batches
xkcfc XKCFC Ext. Classific.
kzbcr KZBCR Aut. batch creat.
autwe CO_AUTWE Aut.goods recpt
auart_kde CO_AUFART_SD Make to Order
auart_psp CO_AUFART_PS Eng.-to-order
auart_nom CO_AUFART_NO Without mat.
wm_kztbv KZTBV Complete TR
wm_kzbmg KZBMG Conf.Qty for TR
wm_kzpgi KZPGI GI via delivery
flg_dlm_cr FLG_DLM_CR Mat. doc.
flg_dlm_rel FLG_DLM_REL Mat. doc.
flg_dlb_cr FLG_DLB_CR BOM doc.
flg_dlb_rel FLG_DLB_REL BOM doc.
flg_split_batch FLG_SPLIT_BATCH Always Batch Split
mill_auart_uta MILL_CO_AUFART_UTA Segmentation Order
wm_kzkts KZKTS Kit to Stock in EWM
cfb_flg_bbd_calc CFB_FLG_BBD_CALC_NEW_AT_RESC Recalc.BBD if Resch.
cfb_flg_bbd_btch CFB_FLG_BBD_PPPI_IN_BATCH From Pr.Ord.to Batch
sync_gm_for_ewm PPWM_USE_SYNC_GM_FOR_EWM Post Sync. to Bin
hsdat_def_date HSDAT_DEF_DATE Date of Manuf.
hsdat_def_offset HSDAT_DEF_OFFSET Offset in Days
sync_pick_for_ewm PPWM_ASYNC_PICKING_FOR_EWM Pick Async. from Bin
flg_dlr_cr FLG_DLR_CR Rtg Doc.
flg_dlr_rel FLG_DLR_REL Rtg Doc.

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.

-- PP-SFC Order Profile
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TCO43 (
    MANDT,              -- Client [MANDT]
    WERKS,              -- Plant [WERKS_D]
    CO_PRODPRF,         -- Prod. Sched. Profile [CO_PRODPRF]
    FLG_REL_CR,         -- Rel. at Opening [FLG_REL_CR]
    FLG_PR_REL,         -- Print Upon Rel. [FLG_PR_REL]
    FLG_TM_REL,         -- Schd. Upon Rel. [FLG_TM_REL]
    FLG_WM_REL,         -- WM Requisition [FLG_WM_REL]
    PROFILE_ID,         -- Overall profile [CY_GESPROF]
    AUART,              -- Make-to-stock [CO_AUFART_PP]
    AUTYP,              -- Order category [AUFTYP]
    FLG_CR_REL,         -- CR Upon Release [FLG_CR_REL]
    FLG_COM_QA,         -- Avail. Prt. Qty [CO_FLG_COM]
    FLG_QUAN_P,         -- No surplus [CO_FLG_MEH]
    FLG_QUAN_M,         -- No deficit [CO_FLG_MIN]
    FLG_QUAN_A,         -- QtyAdjustActualVals [CO_FLG_UPD]
    FLG_KAP_TM,         -- Finite sched. [CY_KAPTERM]
    FLG_KAP_TB,         -- Confirm cap. [CY_TBSTKZ]
    FLG_BOM_EX,         -- New BOM [CO_BOM_EXP]
    KZCLA,              -- Classif.batches [KZCLA]
    XKCFC,              -- Ext. Classific. [XKCFC]
    KZBCR,              -- Aut. batch creat. [KZBCR]
    AUTWE,              -- Aut.goods recpt [CO_AUTWE]
    AUART_KDE,          -- Make to Order [CO_AUFART_SD]
    AUART_PSP,          -- Eng.-to-order [CO_AUFART_PS]
    AUART_NOM,          -- Without mat. [CO_AUFART_NO]
    WM_KZTBV,           -- Complete TR [KZTBV]
    WM_KZBMG,           -- Conf.Qty for TR [KZBMG]
    WM_KZPGI,           -- GI via delivery [KZPGI]
    FLG_DLM_CR,         -- Mat. doc. [FLG_DLM_CR]
    FLG_DLM_REL,        -- Mat. doc. [FLG_DLM_REL]
    FLG_DLB_CR,         -- BOM doc. [FLG_DLB_CR]
    FLG_DLB_REL,        -- BOM doc. [FLG_DLB_REL]
    FLG_SPLIT_BATCH,    -- Always Batch Split [FLG_SPLIT_BATCH]
    MILL_AUART_UTA,     -- Segmentation Order [MILL_CO_AUFART_UTA]
    WM_KZKTS,           -- Kit to Stock in EWM [KZKTS]
    CFB_FLG_BBD_CALC,   -- Recalc.BBD if Resch. [CFB_FLG_BBD_CALC_NEW_AT_RESC]
    CFB_FLG_BBD_BTCH,   -- From Pr.Ord.to Batch [CFB_FLG_BBD_PPPI_IN_BATCH]
    SYNC_GM_FOR_EWM,    -- Post Sync. to Bin [PPWM_USE_SYNC_GM_FOR_EWM]
    HSDAT_DEF_DATE,     -- Date of Manuf. [HSDAT_DEF_DATE]
    HSDAT_DEF_OFFSET,   -- Offset in Days [HSDAT_DEF_OFFSET]
    SYNC_PICK_FOR_EWM,  -- Pick Async. from Bin [PPWM_ASYNC_PICKING_FOR_EWM]
    FLG_DLR_CR,         -- Rtg Doc. [FLG_DLR_CR]
    FLG_DLR_REL,        -- Rtg Doc. [FLG_DLR_REL]
    PRIMARY KEY (MANDT, WERKS, CO_PRODPRF)
);