SAP Table JHFREV4

IS-M/AM: Billing Document Revenue Recognition Key Date Qties

JHFREV4 (IS-M/AM: Billing Document Revenue Recognition Key Date Qties) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link JHFREV4 to other SAP tables.

Source: JHFREV4 (IS-M/AM: Billing Document Revenue Recognition Key Date Qties)

JHFREV4 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
COUNT_JHFREV2 IS-M/AM: Counter for Billing Key Date Logic COUNT_JHFREV2 NUMC 18 0
EOBPO IS-M/AM: Revenue Object Document Item EOBPO NUMC 6 0
EVMETYP IS-M/AM: Quantity Type for Revenue Distribution EVMETYP CHAR 1 0
BW_STICHTAG IS-M/AM: Key Date For BW Key Date Logic BW_STICHTAG DATS 8 0
REF_BELID IS-M/AM: Doc.Number of Rev.Distributed Document Object EOREF_BELID CHAR 10 0
REF_POSID IS-M: Item Number of Revenue Distributed Document Object EOREF_POSID NUMC 6 0
REF_BELTYP IS-M: Document Category for which Revenue Dist.is Performed EOBELTYP CHAR 1 0
UVEVB IS-M: Incompleteness Status for Revenue Object Document JH_UVEVB CHAR 1 0
EVOBJ IS-M/AM: Revenue Object EVOBJ CHAR 10 0
PFOBJ IS-M/AM: Partner Object PFOBJ CHAR 10 0
BDJPOPER IS-M: Posting Year and Posting Period Format YYYYMMM) EV_BDJPOPER NUMC 7 0
AUFNR Order Number AUFNR CHAR 12 0
KOSTL Cost Center KOSTL CHAR 10 0
FKIMG_EV Actual Invoiced Quantity FKIMG QUAN 13 3
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
STATUS IS-M: Status STATUSK CHAR 2 0
01 Cancelled (logically deleted)
10 Created incompletely
20 Complete, reserved
30 Complete, fixed posting, still to be released
40 Complete, fixed posting, released, modifiable
50 Complete, released, partially processed
60 Processing complete, no longer modifiable
99 Initial value
MEINS Base Unit of Measure MEINS UNIT 3 0
KOKRS Controlling Area KOKRS CHAR 4 0
PERIV Fiscal Year Variant PERIV CHAR 2 0
STORNO_KZ IS-M: Reversal BW (0Recordmode) XSTORNO_KZ CHAR 1 0
X Yes
NULL No
VBELN IS-M/AM: Billing Document JJBELNR CHAR 10 0
POSNR IS-M/AM: Item (number) in settlement document JJPOSNR NUMC 6 0
FKART IS-M/AM: Billing/Settlement Document Type FKART_PAM CHAR 4 0
FKTYP IS-M/AM: Billing Category JHFKTYP CHAR 1 0
BUKRS Company Code BUKRS CHAR 4 0
KUNRG IS-M: Payer REGULIERER CHAR 10 0
KUNRE IS-M: Business Partner - Bill-To Party GPNR_RECH CHAR 10 0
VKORG Sales Organization VKORG CHAR 4 0
EKORG Purchasing Organization EKORG CHAR 4 0
KREZE IS-M: Payee JHKREZE CHAR 10 0
KRERS IS-M: Invoicing Party JHKRERS CHAR 10 0
VNR IS-M: Media Sales Agent Contract Number JVMVVNR CHAR 10 0
VTYP IS-M: Contract Category for Media Sales Agent Contract JVERMVTYP CHAR 1 0
2 Sales Agent
1 Occasional Sales Agent
VTNR IS-M: Contract Number ABS_VTNR NUMC 6 0
FKDAT IS-M: Actual Billing/Settlement Date JHFKDAT DATS 8 0
ZLSCH Payment Method SCHZW_BSEG CHAR 1 0
STTYP IS-M: Reversal Type STORNOTYP CHAR 1 0
X Full Reversal
F Charged Off Receivable
NULL Not Reversed
T Partial Reversal
VBTYP IS-M/AM: Sales Document Category ISPVBTYP CHAR 1 0
A Inquiry
B Offer
C Order
K Credit Memo Request
M Invoice
N Reverse Invoice
O Credit Memo
P Debit Memo
S Reverse Credit Memo
U Pro Forma Invoice (Not Used)
2 External Transaction
KUNAG Business Partner: Sold-to Party GPAG CHAR 10 0
FBUDA Date on which services rendered FBUDA DATS 8 0
BEINH IS-M/AM: Booking Unit BELEGEINH CHAR 10 0
BEINH_BAS IS-M: Basic Booking Unit BE_BASIS CHAR 10 0
VTWEG Distribution Channel VTWEG CHAR 2 0
SPART Division SPART CHAR 2 0
KDGRP Customer group KDGRP CHAR 2 0
DRERZ IS-M: Publication JHDRERZ CHAR 8 0
PVA Edition PVA CHAR 8 0
IHKOMP IS-M: Content component for pricing call IKO_PREIS CHAR 8 0
INHK_KFM IS-M: Business Content Component INHK_KFM CHAR 8 0
INHK_TECH2 IS-M: Special Publication Content Component INHK_SOVER CHAR 8 0
VKBUR Sales Office VKBUR CHAR 4 0
VKGRP Sales Group VKGRP CHAR 3 0
WERKS Plant WERKS_D CHAR 4 0
POSAR IS-M: Order-Publishing-Media - Item Type AVMPOS_ART CHAR 2 0
PRODH IS-M/AM: Product Hierarchy J_PRODH CHAR 18 0
PSTYV IS-M: Item Category for Sales Document PSTYV_PAM CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
VKORG_AUFT IS-M: Sales Organization for Customer Order JHVKORGAUF CHAR 4 0
PRSDT Date for pricing and exchange rate PRSDT DATS 8 0
SHKZG IS-M: Debit/Credit indicator JHSHKZG CHAR 1 0
NULL Normal sign
X Reversed sign
A Minus sign normal
B Minus sign reversed
ERFDATE Created On ERFDATE DATS 8 0
AENDATE Date of Last Change AENDATE DATS 8 0
AUBEL IS-M/AM: Sales Document Number AVM_NR CHAR 10 0
AUPOS IS-M: Order Item Number POS_NR NUMC 3 0
AUGRP IS-M/AM: Billing Dataset GRUPPABRNR NUMC 3 0
RRREL IS-M/AM: Revenue Recognition Category ISMRR_RELTYP CHAR 1 0
NULL Standard - No Revenue Recognition Process
B Service-Related, Order-Dependent Revenue Recognition
F Order-Dependent Revenue Recognition by Periods
E Service-Related, Billing-Dependent Revenue Recognition
CAMPAIGN IS-M: Marketing Campaign ISM_MARKETING_CAMPAIGN RAW 16 0
CAMPAIGN_PSP Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
INSERENT IS-M: Advertiser INSERENT CHAR 10 0
PACKAGE_ID Package ISM_PACKAGE_ID JJTPC CHAR 10 0
PK_REF_AVM_NR Order Number for Package Reference Order ISM_PK_REF_AVM_NR CHAR 10 0
PK_REF_POS_NR Item Number of Package Item to be Referenced ISM_PK_REF_POS_NR NUMC 3 0

JHFREV4 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JHFREV4 PACKAGE_ID SYST MANDT JJTPC Bundle MANDT
JHFREV4 PACKAGE_ID JHFREV4 PACKAGE_ID JJTPC Bundle PACKAGE_ID