SAP table EJVL (Yearly Advance Payment)

SAP table EJVL has 3 primary key fields being MANDT,OPBEL,VERTRAG.

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 MANDT
OPBEL Budget billing plan CHAR 12 0 ABPLANNR
VERTRAG Reference Specifications from Contract CHAR 20 0 VTREF_KK
SPARTE Division CHAR 2 0 SPART_KK
BUKRS Company Code CHAR 4 0 BUKRS
WAERS Currency Key CUKY 5 0 WAERS
JVLBASIS Base amount of yearly advance payment CURR 13 2 JVLBASIS
JVLBETR Yearly advance payment amount CURR 13 2 JVLBETR
JVLBETRTAX Tax amount of the YAP amount CURR 13 2 JVLBETRTAX
JVLBONUS Yearly advance payment bonus CURR 13 2 JVLBONUS
JVLBONUSTAX Tax amount of the YAP bonus CURR 13 2 JVLBONUSTAX
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
FAEDN YAP Due Date DATS 8 0 FAEDN_JVL
ZINSZ Interest Calculation Rule CHAR 10 0 T056G IRULE
JVLSTATUS Yearly advance payment status CHAR 1 0 JVLSTATUS
No advance payment
1 Advance payment offered
2 Advance payment accepted
3 Advance payment not accepted
4 Advance payment paid
JVLTE Participation in yearly advance payment procedure NUMC 1 0 JVLTE
0 No participation: No quotation proposed
1 Single part.: No further quotation with non-accept. of quot.
2 Permanent part.: Propose quotation for each periodic bill
AKTIV Yearly advance payment active CHAR 1 0 JVL_AKTIV
Not Active
1 Active
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
FDATE Lock valid from DATS 8 0 FDATE_KK
TDATE Lock valid to DATS 8 0 TDATE_KK
BON_HVORG Internal Main Transaction of YAP Bonus CHAR 4 0 BON_HVORG
BON_TVORG Internal Sub-Transaction of YAP Bonus at Time of Creation CHAR 4 0 BON_TVORG

EJVL foreign key relationships

Table Field Check Table Check Field
0 EJVL ZINSZ T056G Interest calculation rules MANDT
0 EJVL ZINSZ T056G Interest calculation rules IRULE