TVEPZ
Sales Document: Schedule Line Category Determination
TVEPZ is an SAP database table in S/4HANA. Sales Document: Schedule Line Category Determination. It contains 19 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ScheduleLineCategoryDetn | view | from | BASIC | Schedule Line Category Determination |
Fields (19)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | pstyv | PSTYV | Item Category | |||
| KEY | dismm | DISMM | MRP Type | |||
| ettyp | ETTYD | PropSchdLneCat. | ||||
| etty1 | ETTYM | ManSchedLineCat | ||||
| etty2 | ETTYM | ManSchedLineCat | ||||
| etty3 | ETTYM | ManSchedLineCat | ||||
| etty4 | ETTYM | ManSchedLineCat | ||||
| etty5 | ETTYM | ManSchedLineCat | ||||
| etty6 | ETTYM | ManSchedLineCat | ||||
| etty7 | ETTYM | ManSchedLineCat | ||||
| etty8 | ETTYM | ManSchedLineCat | ||||
| etty9 | ETTYM | ManSchedLineCat | ||||
| ernam | ERNAM | Created By | ||||
| bedae | BEDAE | Reqmts type | ||||
| bedhk | BEDHK | Source | ||||
| msr_bedae | MSR_BEDAE_NONVAL | RqTp NV-Stock | ||||
| msr_immval | MSR_BEDAE_IMMVAL | RqTp Imm-GV | ||||
| msr_bedae_drts | MSR_BEDAE_DRTS | RqTp DR- Supplier |
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.
-- Sales Document: Schedule Line Category Determination
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVEPZ (
MANDT, -- Client [MANDT]
PSTYV, -- Item Category [PSTYV]
DISMM, -- MRP Type [DISMM]
ETTYP, -- PropSchdLneCat. [ETTYD]
ETTY1, -- ManSchedLineCat [ETTYM]
ETTY2, -- ManSchedLineCat [ETTYM]
ETTY3, -- ManSchedLineCat [ETTYM]
ETTY4, -- ManSchedLineCat [ETTYM]
ETTY5, -- ManSchedLineCat [ETTYM]
ETTY6, -- ManSchedLineCat [ETTYM]
ETTY7, -- ManSchedLineCat [ETTYM]
ETTY8, -- ManSchedLineCat [ETTYM]
ETTY9, -- ManSchedLineCat [ETTYM]
ERNAM, -- Created By [ERNAM]
BEDAE, -- Reqmts type [BEDAE]
BEDHK, -- Source [BEDHK]
MSR_BEDAE, -- RqTp NV-Stock [MSR_BEDAE_NONVAL]
MSR_IMMVAL, -- RqTp Imm-GV [MSR_BEDAE_IMMVAL]
MSR_BEDAE_DRTS, -- RqTp DR- Supplier [MSR_BEDAE_DRTS]
PRIMARY KEY (MANDT, PSTYV, DISMM)
);
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