SAP table TVEPZ (Sales Document: Schedule Line Category Determination)

SAP table TVEPZ has 3 primary key fields being MANDT,PSTYV,DISMM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PSTYV Sales document item category CHAR 4 0 TVPT PSTYV
DISMM MRP Type CHAR 2 0 T438A DISMM
ETTYP Proposed schedule line category CHAR 2 0 TVEP ETTYD
ETTY1 Manual Schedule Line Category CHAR 2 0 TVEP ETTYM
ETTY2 Manual Schedule Line Category CHAR 2 0 TVEP ETTYM
ETTY3 Manual Schedule Line Category CHAR 2 0 TVEP ETTYM
ETTY4 Manual Schedule Line Category CHAR 2 0 TVEP ETTYM
ETTY5 Manual Schedule Line Category CHAR 2 0 TVEP ETTYM
ETTY6 Manual Schedule Line Category CHAR 2 0 TVEP ETTYM
ETTY7 Manual Schedule Line Category CHAR 2 0 TVEP ETTYM
ETTY8 Manual Schedule Line Category CHAR 2 0 TVEP ETTYM
ETTY9 Manual Schedule Line Category CHAR 2 0 TVEP ETTYM
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
BEDAE Requirements type CHAR 4 0 T459A BEDAE
BEDHK Origin of requirement type in requirement type determination NUMC 1 0 BEDHK
0 Material master strategy, then item category and MRP type
1 Item Category and MRP Type
2 as 1, with check for allowed requirement type
MSR_BEDAE Requirement Type for Posting to Non-Valuated Returns Stock CHAR 4 0 T459A MSR_BEDAE_NONVAL

TVEPZ foreign key relationships

Table Field Check Table Check Field
0 TVEPZ BEDAE T459A External requirements types MANDT
1 TVEPZ DISMM T438A MRP Type MANDT
1 TVEPZ DISMM T438A MRP Type DISMM
0 TVEPZ ETTY1 TVEP Sales Document: Schedule Line Categories ETTYP
1 TVEPZ ETTY2 TVEP Sales Document: Schedule Line Categories ETTYP
0 TVEPZ ETTY3 TVEP Sales Document: Schedule Line Categories ETTYP
1 TVEPZ ETTY4 TVEP Sales Document: Schedule Line Categories ETTYP
0 TVEPZ ETTY5 TVEP Sales Document: Schedule Line Categories ETTYP
1 TVEPZ ETTY6 TVEP Sales Document: Schedule Line Categories ETTYP
0 TVEPZ ETTY7 TVEP Sales Document: Schedule Line Categories ETTYP
1 TVEPZ ETTY8 TVEP Sales Document: Schedule Line Categories ETTYP
0 TVEPZ ETTY9 TVEP Sales Document: Schedule Line Categories ETTYP
1 TVEPZ ETTYP TVEP Sales Document: Schedule Line Categories ETTYP
0 TVEPZ MSR_BEDAE T459A External requirements types MANDT
1 TVEPZ PSTYV TVPT Sales Documents: Item categories MANDT
1 TVEPZ PSTYV TVPT Sales Documents: Item categories PSTYV