SAP Reports / Programs
RFVIDUV1 SAP ABAP Report - Sales Settlement
RFVIDUV1 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This report selects the reported sales for sales-based rental agreements and any advance payments on the basic rent that may have been made by the customers...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.
If you would like to execute this report or see the full code listing simply enter RFVIDUV1 into the relevant SAP transactions such as SE38 or SE80
Transaction Code(s):
Below is a list of transaction codes which are relevant to this SAP report
FOUA - Calculate sales settlement
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT RFVIDUV1. "Basic submit
SUBMIT RFVIDUV1 AND RETURN. "Return to original report after report execution complete
SUBMIT RFVIDUV1 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Selection Text: P_BLARTD = Doc.Type
Selection Text: P_BLDAT = Doc.Date
Selection Text: P_BUDAT = Posting Date
Selection Text: P_BUKRS = Company Code
Selection Text: P_DGAB = Adjustment Valid From
Selection Text: P_JVZOPN = Consider open AP receivables?
Selection Text: P_MONAT = Posting Period
Selection Text: P_ZFBDT = Due Date
Selection Text: SO_AVAR = Settlement Variants
Selection Text: S_SKOART = Sales Types
Selection Text: UMS_BEG = Start of Settlement Period
Selection Text: UMS_END = End of Settlement Period
Selection Text: WE_NR = Business Entity
Selection Text: P_BKTXT = Document Header Text
Selection Text: P_ABR = Execute adjustment
Selection Text: MV_NR = Lease-Out
Selection Text: ME_NR = Rental Unit
Selection Text: EMV_NR = Collective lease-out
Title: Sales Settlement
Text Symbol: NMV = No LOs found for settling
Text Symbol: OBJ = Select Real Estate Objects
Text Symbol: SFA = Errors Found:
Text Symbol: SGA = Records Changed:
Text Symbol: FET = Incorrect Data
Text Symbol: ERR = Sales Settlement
Text Symbol: ERM = Sales Reports
Text Symbol: EIN = Unit
Text Symbol: SGE = Records Checked:
Text Symbol: SGL = Records Read:
Text Symbol: SGS = Records Written:
Text Symbol: SNG = Records Unchanged:
Text Symbol: SVZ = Settlement Due to Planned Advance Payments
Text Symbol: EIH = Unit
Text Symbol: 001 = Company Code.......
Text Symbol: 002 = Tenant
Text Symbol: 003 = Stt. Identification
Text Symbol: 004 = Settlement Period
Text Symbol: 006 = Receiv.
Text Symbol: 007 = Credit
Text Symbol: 008 = Tenant
Text Symbol: 009 = Incl. STX
Text Symbol: 101 = RFVIDUV1/&1 Sales-Bsd Rent Stt. Time &2 Date &3
Text Symbol: 900 = Advance Payment
Text Symbol: ABU = Posting Data
Text Symbol: ANP = Adjustment Data
Text Symbol: BUK = Company Code
Text Symbol: UMJ = Sales Period
Text Symbol: UFZ = Error Messages
Text Symbol: UET = Lease-Outs Selected for Settlement
Text Symbol: UEF = Error Log
Text Symbol: UE3 = STx Clearing Amnt ClearAmnt inc.STx AP Basic Rent Bal. Bal.inc.STx
Text Symbol: UE2 = Settlement Period Sls Type Curr. Real Sales Relevant Sales
Text Symbol: UE1 = BE No RU No Lease-out Address
Text Symbol: SWA = Records with Warning:
INCLUDES used within this REPORT RFVIDUV1
INCLUDE RFVIDUV3TOP.
INCLUDE IFVIHKAB_ALV.
INCLUDE IFVIDUV1_DATA.
INCLUDE RFVICNNK.
INCLUDE RFVIDUV3F00.
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
DATE_CREATE CALL FUNCTION 'DATE_CREATE' EXPORTING ANZAHL_MONATE = ANZ_MON DATUM_EIN = SY-DATUM IMPORTING DATUM_AUS = P_DGAB.
MESSAGE_STORE * CALL FUNCTION 'MESSAGE_STORE' * EXPORTING * ARBGB = '62' * MSGTY = 'I' * MSGV1 = '1' * MSGV2 = MAPPENNAME * TXTNR = '577' * EXCEPTIONS * MESSAGE_TYPE_NOT_VALID = 01 * NOT_ACTIVE = 02.
MESSAGE_STORE CALL FUNCTION 'MESSAGE_STORE' EXPORTING ARBGB = '62' MSGTY = 'I' MSGV1 = P_XIDENT TXTNR = '578' EXCEPTIONS MESSAGE_TYPE_NOT_VALID = 01 NOT_ACTIVE = 02.
MESSAGES_STOP CALL FUNCTION 'MESSAGES_STOP' EXCEPTIONS A_MESSAGE = 01 E_MESSAGE = 02 I_MESSAGE = 03 W_MESSAGE = 04.
MESSAGES_SHOW CALL FUNCTION 'MESSAGES_SHOW' EXPORTING SHOW_LINNO = SPACE EXCEPTIONS INCONSISTENT_RANGE = 01 NO_MESSAGES = 02.
USERDATA_MAINTAIN CALL FUNCTION 'USERDATA_MAINTAIN' EXPORTING * HERKUNFT = E01 INUSER = UC_USER IMPORTING EXUSER = UC_USER.
MESSAGES_INITIALIZE CALL FUNCTION 'MESSAGES_INITIALIZE' EXPORTING * i_identification = sy-uzeit LINE_FROM = '$UMVBI' LINE_TO = '$UMVBI' EXCEPTIONS OTHERS = 0.
MESSAGE_STORE CALL FUNCTION 'MESSAGE_STORE' EXPORTING ARBGB = '62' MSGTY = 'I' MSGV1 = '1' MSGV2 = P_XIDENT TXTNR = '577' ZEILE = '$UMVBI' EXCEPTIONS MESSAGE_TYPE_NOT_VALID = 01 NOT_ACTIVE = 02.
MESSAGES_STOP CALL FUNCTION 'MESSAGES_STOP' EXCEPTIONS A_MESSAGE = 01 E_MESSAGE = 02 I_MESSAGE = 03 W_MESSAGE = 04.
MESSAGES_SHOW CALL FUNCTION 'MESSAGES_SHOW' EXPORTING SHOW_LINNO = SPACE LINE_FROM = '$UMVBI' LINE_TO = '$UMVBI' EXCEPTIONS INCONSISTENT_RANGE = 01 NO_MESSAGES = 02.
MESSAGES_INITIALIZE CALL FUNCTION 'MESSAGES_INITIALIZE' EXPORTING * i_identification = sy-uzeit LINE_FROM = '$UMVBI' LINE_TO = '$UMVBI' EXCEPTIONS OTHERS = 0.
ENQUEUE_EFVIMI28 CALL FUNCTION 'ENQUEUE_EFVIMI28' EXPORTING BUKRS = PAR_BUKRS MANDT = SY-MANDT EXCEPTIONS FOREIGN_LOCK = 01 SYSTEM_FAILURE = 02.
DEQUEUE_EFVIMI28 CALL FUNCTION 'DEQUEUE_EFVIMI28' EXPORTING BUKRS = PAR_BUKRS MANDT = SY-MANDT.
VIMI28_VERBUCHER CALL FUNCTION 'VIMI28_VERBUCHER' IN UPDATE TASK EXPORTING FUNKTION = XVIMI28-KZ I_VIMI28 = VIMI28 EXCEPTIONS DB_ERROR = 01.
VIMI28_VERBUCHER CALL FUNCTION 'VIMI28_VERBUCHER' IN UPDATE TASK EXPORTING FUNKTION = YVIMI28-KZ I_VIMI28 = VIMI28 EXCEPTIONS DB_ERROR = 01.
CHANGEDOCUMENT_PREPARE_TABLES CALL FUNCTION 'CHANGEDOCUMENT_PREPARE_TABLES' EXPORTING CHECK_INDICATOR = SPACE TABLENAME = TAB_NAME TABLES TABLE_NEW = XBEWEGTAB TABLE_OLD = YBEWEGTAB EXCEPTIONS NAMETAB_ERROR = 01.
ABR_RUNDUNGSDIFFERENZ CALL FUNCTION 'ABR_RUNDUNGSDIFFERENZ' EXPORTING BKTXT = P_BKTXT BLART = P_BLARTD BLDAT = P_BLDAT BUDAT = P_BUDAT KTOPL = PAR_T001-KTOPL MONAT = P_MONAT WAERS = PAR_T001-WAERS VVABBLN = VVABBLN TABLES TVIAK14 = LOC_VIAK14 changing lfdnr_beleg = lfdnr_beleg EXCEPTIONS OTHERS = 1.
ABR_FORDERUNG_DEBITOR_BUCHEN_N CALL FUNCTION 'ABR_FORDERUNG_DEBITOR_BUCHEN_N' EXPORTING BKTXT = P_BKTXT BLART = P_BLARTD BLDAT = P_BLDAT BUDAT = P_BUDAT KTOPL = PAR_T001-KTOPL * mappe = con_umv_mappe " Dummy ab 3.0
VORAUSZAHLUNGS_UMBUCHUNG CALL FUNCTION 'VORAUSZAHLUNGS_UMBUCHUNG' EXPORTING I_ABRECHNUNGS_ID = VVABBLN I_BUCHUNGSDATUM = P_BUDAT I_BELEGDATUM = P_BLDAT * I_NO_BTCI_CLOSE = CLOSE_IT I_KZ_OFFENE_VZ = P_JVZOPN i_bktxt = p_bktxt I_ZFBDT = P_ZFBDT i_dbisper = UMS_END i_dvonper = UMS_BEG * IMPORTING * E_MAPPE_ERZEUGT = MAPPE_ERZEUGT TABLES T_BEWEGUNGSART = BWA_TAB T_VIAK14 = LOC_VIAK14_BW T_VIAK17 = LOC_VIAK17_BW changing LFDNR_BELEG = LFDNR_BELEG EXCEPTIONS BUCHUNGSKREIS_UNDEFINIERT = 01 BUCHUNGSREGEL_FEHLT = 02 CLEARING_INTERF_ERR = 03 CUST_BEWEGUNGSTYP_FEHLT = 04 KONTENPLAN_UNDEFINIERT = 05 UNBEKANNTER_BEWEGUNGSTYP = 06 UNBEKANNTER_MIETVERTRAG = 07 BUCHUNGEN_INKONSISTENT = 08 ERROR_CLOSE_MAP = 09 ERROR_PLAN_MAP = 10 OTHERS = 11.
VV_UMSATZVZ_BERECHNEN CALL FUNCTION 'VV_UMSATZVZ_BERECHNEN' EXPORTING DGUELAB = DGUELAB BUKRS = BUKRS DBISPER = DATUM_BIS DVONPER = DATUM_VON SKOART = SKOART " Dummy-Parameter, orig. in viak14
FI_DOCUMENT_TYPE_CHECK CALL FUNCTION 'FI_DOCUMENT_TYPE_CHECK' EXPORTING I_BLART = BLART.
FI_PERIOD_DETERMINE CALL FUNCTION 'FI_PERIOD_DETERMINE' EXPORTING I_BUDAT = P_BUDAT I_PERIV = T001-PERIV I_MONAT = P_MONAT IMPORTING E_GJAHR = GJAHR E_MONAT = P_MONAT.
EXT_BELNR_TRAFO CALL FUNCTION 'EXT_BELNR_TRAFO' EXPORTING IMP_DATE = SY-DATUM IMP_EXTBELEGNR = VVABBLN IMP_OBJECT = 'FVVI_SOID' IMP_VISLID = PAR_VISLID NR_RANGE_NR = '01' IMPORTING EXP_EXTBELNR = VVABBLN EXP_VISLID = PAR_VISLID EXCEPTIONS INTERVAL_NOT_FOUND = 01 NO_ENTRY = 02 NUMBER_RANGE_NOT_INTERN = 03 OBJECT_NOT_FOUND = 04 QUANTTITY_IS_0 = 05.
ERROR_RULE_ACCOUNT_NEW CALL FUNCTION 'ERROR_RULE_ACCOUNT_NEW' EXPORTING ARBEITSGEBIET = 'X' CHANNEL = PROT_MODE NUR_IMPORT = TRUE MESSAGENUMMER = 'X' SEVERITY = 'X' SORTIERT = 'X' IMPORTING SPOOL_NR = SPOOL_NR TABLES FEHLER_IMPORT = TAB_MESG_FI.
VIAK17_BOOKING CALL FUNCTION 'VIAK17_BOOKING' IN UPDATE TASK EXPORTING VERBART = EINSETZ_KZ TABLES TVIAK17 = PAR_VIAK17.
VIAK20_BOOKING * CALL FUNCTION 'VIAK20_BOOKING' IN UPDATE TASK * EXPORTING * VERBART = EINSETZ_KZ * TABLES * TVIAK20 = LOC_VIAK20.
RESC_SAVE_SETTLEMENT_RESULTS call function 'RESC_SAVE_SETTLEMENT_RESULTS' * EXPORTING * IF_CHECKONLY = ' ' * IF_COMMIT4VIAK13 = ' ' * IF_CHANGEVIAK20 = 'X' tables * IT_VIAK13 = it_viak20 = loc_viak20[] * ET_VIAK16_SIM = * ET_VIAK16_ALL = exceptions err_duplicate_viak20 = 1 err_duplicate_viak13 = 2 others = 3.
CALL FUNCTION 'VV_VIAK16_BOOKING' IN UPDATE TASK EXPORTING E_VIAK16 = PAR_VIAK16 SATZ_KZ = EINSETZ_KZ EXCEPTIONS DB_OPERATION_UNKNOWN = 01 DELETE_FAILED = 02 INSERT_FAILED = 03 UPDATE_FAILED = 04.
VIMI16_BOOKING CALL FUNCTION 'VIMI16_BOOKING' IN UPDATE TASK EXPORTING VERBART = EINSETZ_KZ TABLES TVIMI16 = TAB_VIMI16.
VIMI17_BOOKING CALL FUNCTION 'VIMI17_BOOKING' IN UPDATE TASK EXPORTING VERBART = EINSETZ_KZ TABLES TVIMI17 = IVIMI17.
VISLID_BOOKING CALL FUNCTION 'VISLID_BOOKING' IN UPDATE TASK EXPORTING VERBART = EINSETZ_KZ TVISLID = PAR_VISLID.
MESSAGES_GIVE CALL FUNCTION 'MESSAGES_GIVE' TABLES T_MESG = TAB_FEHLER.
MESSAGES_STOP CALL FUNCTION 'MESSAGES_STOP' EXCEPTIONS A_MESSAGE = 01 E_MESSAGE = 02 I_MESSAGE = 03 W_MESSAGE = 04.
VV_MESSAGES_COMBINE CALL FUNCTION 'VV_MESSAGES_COMBINE' EXPORTING T_MESG_REFRESH = TRUE TABLES T_MESG = TAB_FEHLER T_SPROT_U = TAB_MESG_FI.
ERROR_RULE_ACCOUNT_FILL CALL FUNCTION 'ERROR_RULE_ACCOUNT_FILL' TABLES APPL_ERROR = TAB_MESG_FI.
MESSAGES_INITIALIZE CALL FUNCTION 'MESSAGES_INITIALIZE'.
TR_WRITE_LOG CALL FUNCTION 'TR_WRITE_LOG' EXPORTING IV_LOG_TYPE = 'MEMORY' IV_APPEND_MODE = 'X' IV_LOGNAME_MEMORY = SDICNAME TABLES IT_MSGS = P_T_MESG_FI EXCEPTIONS INVALID_INPUT = 1 FILE_ACCESS_ERROR = 2 DB_ACCESS_ERROR = 3 OTHERS = 4.
TR_READ_AND_DISPLAY_LOG CALL FUNCTION 'TR_READ_AND_DISPLAY_LOG' EXPORTING IV_LOG_TYPE = 'MEMORY' IV_LOGNAME_MEMORY = SDICNAME IV_DISPLAY_LEVEL = '2' IV_HEADING = HEADING EXCEPTIONS INVALID_INPUT = 1 ACCESS_ERROR = 2 OTHERS = 3.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name RFVIDUV1 or its description.