TVEP

Transparent Table Customizing (protected)
31 Fields 8 CDS Views

Sales Document: Schedule Line Categories

TVEP is an SAP database table in S/4HANA. Sales Document: Schedule Line Categories. It contains 31 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
arun_i_sl_so_sel view inner SO selection at Date level
ARUN_I_SO_VBEP_FIELD view inner Date level information for SO
I_AlignSalesSchedLineCat view from BASIC Sale Account assignment type indicator
I_ExcessRqmtQtyPerSlsItm view inner BASIC Aggregated Quantity Per Sales Item
I_ScheduleLineCategory view from BASIC Schedule Line Category
I_SupDmndAllDocSDItmBsc view inner BASIC Basic View for Sales Document
P_ABOPFieldCatalog view left_outer BASIC
P_SupDmndAllDocSDRqmtType view inner BASIC

Fields (31)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ettyp ETTYP Sched.Line Cat.
aswet ASWET Order item hist
lfrel LFREL Item rel.f.dlv.
bdart BDART RequirementType
plart PLART Planning type
entlg ENTLG Sched.line type
ebanf EBANF Create purch.rq
bsart BSART Order Type
bstyp BSTYP Doc. Category
bwart BWART Movement Type
aubst AUBST P.req.del.sched
lifsp LIFSP Delivery Block
txn08 TXN08 Standard Text
ernam ERNAM Created By
fehgr FEHGR Incompl.Proced.
pstyp PSTYP Item Category
knttp KNTTP Acct Assgmt Cat
atppr VFPPR Availability
bedsd BEDSD Requirements
bwa1s BWA1S Movement Type
quota QUOTA Prod.allocation
msr_bwart_free MSR_MOVTYP_FREE MvT Free Avail.
msr_bwart_spec MSR_MOVTYP_SPECIFIED MvtT Specified
sitbw SITBW MvT Iss. Val. SiT
sitkz SITKZ Spec.Iss. Val. SiT
bwa1b BWA1B MvT SC
msr_bwart_ro MSR_MOVTYP_RO MvT Repair Stck
updsc UPDSC Update Schedule
updsc_ext UPDSC_EXT Upd. Sch. Lines
capex CAPEX Ext.capa. planning

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 Categories
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVEP (
    MANDT,           -- Client [MANDT]
    ETTYP,           -- Sched.Line Cat. [ETTYP]
    ASWET,           -- Order item hist [ASWET]
    LFREL,           -- Item rel.f.dlv. [LFREL]
    BDART,           -- RequirementType [BDART]
    PLART,           -- Planning type [PLART]
    ENTLG,           -- Sched.line type [ENTLG]
    EBANF,           -- Create purch.rq [EBANF]
    BSART,           -- Order Type [BSART]
    BSTYP,           -- Doc. Category [BSTYP]
    BWART,           -- Movement Type [BWART]
    AUBST,           -- P.req.del.sched [AUBST]
    LIFSP,           -- Delivery Block [LIFSP]
    TXN08,           -- Standard Text [TXN08]
    ERNAM,           -- Created By [ERNAM]
    FEHGR,           -- Incompl.Proced. [FEHGR]
    PSTYP,           -- Item Category [PSTYP]
    KNTTP,           -- Acct Assgmt Cat [KNTTP]
    ATPPR,           -- Availability [VFPPR]
    BEDSD,           -- Requirements [BEDSD]
    BWA1S,           -- Movement Type [BWA1S]
    QUOTA,           -- Prod.allocation [QUOTA]
    MSR_BWART_FREE,  -- MvT Free Avail. [MSR_MOVTYP_FREE]
    MSR_BWART_SPEC,  -- MvtT Specified [MSR_MOVTYP_SPECIFIED]
    SITBW,           -- MvT Iss. Val. SiT [SITBW]
    SITKZ,           -- Spec.Iss. Val. SiT [SITKZ]
    BWA1B,           -- MvT SC [BWA1B]
    MSR_BWART_RO,    -- MvT Repair Stck [MSR_MOVTYP_RO]
    UPDSC,           -- Update Schedule [UPDSC]
    UPDSC_EXT,       -- Upd. Sch. Lines [UPDSC_EXT]
    CAPEX,           -- Ext.capa. planning [CAPEX]
    PRIMARY KEY (MANDT, ETTYP)
);

Learn More