TCO43
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ProductionSchedulingProfile | view | from | BASIC | Production Scheduling Profile |
| P_MfgOrderEWMSynchronousPostg | view | inner | BASIC |
Fields (43)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA