Redwood Documentation

Product Documentation

 

You are currently viewing the legacy RunMyJobs documentation site. This site will be taken down later this month.
All current and future RunMyJobs documentation, including versions 2023.3 and later, can be found here.
Please update your bookmarks. Use the version dropdown menu to select the documentation you need.

›Line Item-related

Finance AutomationGuides and Components

User Guides

  • Home User Guide
  • BSC User Guide
  • Data Extractor User Guide
  • Data Transformer User Guide
  • Document Editor User Guide
  • Inbox User Guide
  • Orchestrator User Guide
  • Runner User Guide
  • SAP Process Definition Generation User Guide
  • Table Editor User Guide
  • Workbench User Guide

Components

  • RFA Components
  • SE16
  • Utils_Amounts_Compare
  • Utils_Child_Run
  • Utils_Excel_Get_Cell_Value
  • Utils_Excel_Set_Cell_Value
  • Utils_File_Transfer
  • SE16
  • File_Write
  • Generic_Loop
  • Read_Layout

Asset-related

  • AS01
  • AS02
  • AR01
  • AR02
  • AR05
  • AR06
  • AR07
  • AR08
  • AR18
  • AR19
  • IM12
  • IM22
  • IM42

Line Item-related

  • KOB1
  • FBL1N
  • FBL3N
  • FAGLL03
  • FBL5N
  • RFEPOJ00
  • CJI3

Document-related

  • FB03
  • FBIC025
  • FBICA3
  • FBICS3
  • S_ALR_87012287
  • ME2N

Other Components

  • KO01
  • KO8G
  • KOK4
  • OKP1
  • AFAB
  • F.08
  • F.13
  • F.23
  • F110_Actions
  • F110
  • SAPFPAYM_SCHEDULE
  • FC10
  • GCAC
  • OB52
  • MMRV
  • CJ8G

Helper Programs

  • RKOSEL00
  • RKPSEL00
  • RF110SMS
  • RFKSLD00
  • RM07MMFI
← FAGLL03RFEPOJ00 →

finance-related topic FBL5N - Customer Line Item Display

Component Name and System Landscape

  • Name: FCA_SAP_Abap_RFITEMAR
  • Description: SAP - FI: Tran FBL5N, FBL6N - Customer Line item display
  • Application: FCA_SAP_Transactions
  • Type: SAPR3
  • Other Info: SAP Manual Program RFITEMAR, Transaction FBL5N

Brief Description

This program lists customer line items. You can also display the items from more than one debitor account cross-company code in a list.

Parameter Mapping - Generic Tabs

There are several tabs under this section. Some will be generic, and others are specific to the component. The generic tabs usually are:

  • Target: Requires SAP and Client information. You can also hard code the SAP username. For example:
    • SAP System: Redwood.SAP01
    • SAP Client:800
  • Infrastructure: Used for Action rules. See the Redwood Finance Automation Reference.
  • Recipient parameters: Generally left to default values.
  • Job output parameters: Defines the format of the required output. Defaults to RTX and Text. See Porgam Handling for more information.
note

Most of the time these tabs will be shown, but there are components where these differ and either do not appear at all, or they are specific tabs.

Parameter Mapping - Specific Tabs

This guide shows the minimum parameter values required for the component to run. Please refer to the Redwood Automation Engineering Training course for submission and monitoring activities.

TabTechnical NameDescriptionFormatMandatory FieldExample
ScreenSEL_DD_KUNNRCustomer Account (Sel)Contains Customer account number(s), refers to KUNNR field in SAP GUI.stringSingle value: [300476] Multiple values: [300476,YHTS_ACME] Empty value: >!<
ScreenSEL_DD_BUKRSCompany code (Sel)4 characters length, contains Company code(s), refers to BUKRS field in SAP GUI.stringSingle value: 1000 Multiple values: [1000,0005] [1000-2005] Empty value: >!<
ScreenRADIO_RAD1Line item selection (Radio Button)Select one of the available options in the drop down field. This field is mandatory and has to be filled with a valid value.X_AISEL – All items X_CLSEL – Cleared X_OPSEL – Open itemsX-AISEL
ScreenPAR_PA_STIDAOpen items – Open at key date (Par)SAP date format.date20230318
ScreenSEL_SO_AUGDTCleared Items - Clearing date (Sel)SAP date format.date[20230318]
ScreenPAR_PA_STID2Cleared Items - Open at key date (Par)SAP date format.date20230318`
ScreenSEL_SO_BUDATAll Items - Posting date (Sel)SAP date format.date[20230318]
ScreenPAR_X_NORMNormal items (Par)Either enter “X” to select normal items or leave the field blank to not select them.selectionX
ScreenPAR_X_SHBVSpecial G/L transactions (Par)Either enter “X” to select Special G/L transactions or leave the field blank to not select them.selectionX
ScreenPAR_X_MERKNoted items (Par)Either enter “X” to select noted items or leave the field blank to not select them.selectionX
ScreenPAR_X_PARKParked items (Par)Either enter “X” to select parked items or leave the field blank to not select them.selectionX
ScreenPAR_X_APARVendor items (Par)Either enter “X” to select vendor items or leave the field blank to not select them.selectionX
ScreenPAR_PA_NMAXMaximum number of items (Par)Enter a number value to limit the max. amount of selected itemsnumber10
VariantPAR_ALCURAlternative local currency (Par)Enter a currency name when item currency should be converted in the output.stringEUR
VariantPAR_XCDTTranslation date (Par)SAP date format. Leave the field to the default “00000000” value when the translation date is not relevant.date20230330
VariantPAR_PA_WLBUKCompany code worklist (Par)A Company Code or a list/range of Company CodesstringSingle value: 1000 Multiple values: [1000,0005] [1000-2005] Empty value: >!<
VariantPAR_PA_WLKUNCustomer worklist (Par)A Customer Number or a list/range of Customer NumbersstringSingle value: 317746 Multiple values: [317746,299138] [299138-317746] Empty value: >!<
Variant - DatasourcePAR_DD_USEASUse Archive (Par)Either enter “X” to use archiving or leave the field blank.selectionX
Variant - DatasourcePAR_DD_USEDBUse Database (Par)Either enter “X” to use database or leave the field blank.selectionX
Accounting: Secondary Index for CustomersFSL_BSID/AUGBLDocument Number of Clearing Document (Dyn Sel)Either enter a valid document number or enter >!< to select all.number[4000124316]
Accounting: Secondary Index for CustomersFSL_BSID/BELNRAccounting Document Number (Dyn Sel)Either enter a valid document number or enter >!< to select all.number[4000124316]
Accounting: Secondary Index for CustomersFSL_BSID/BLARTDocument Type (Dyn Sel)Either enter document type or enter >!< to select all.charSA
Accounting: Secondary Index for CustomersFSL_BSID/BLDATDocument Date (Dyn Sel)SAP date formatdate[20230705]
Accounting: Secondary Index for CustomersFSL_BSID/BSCHLPosting Key (Dyn Sel)Either enter a valid Posting Key or enter >!< to select all.string04
Accounting: Secondary Index for CustomersFSL_BSID/BUDATPosting Date (Dyn Sel)SAP date format, enter >!< if no date is required.date[20230705]
Accounting: Secondary Index for CustomersFSL_BSID/DMBTRAmount in Local Currency (Dyn Sel)Either enter an Amount or enter >!< to select all.number1580722.56
Accounting: Secondary Index for CustomersFSL_BSID/GSBERBusiness Area (Dyn Sel)Either enter a valid Business Area or enter >!< to select all.number[1003]
Accounting: Secondary Index for CustomersFSL_BSID/MANSPDunning Block (Dyn Sel)Select a Dunning Block.for example: >!< Freed for dunning, A - Manual bblock due to a telephone payment advice, B - Manual block due to complaints against vendor, D - Disputed item, H - Block reason H, R - Blocked by invoice verificationselectionA
Accounting: Secondary Index for CustomersFSL_BSID/UMSKZSpecial G/L Indicator (Dyn Sel)Either enter a valid G/L indicator, for example: 5 - Client Funds, 6 - Client Funds Named Account, A - Down Payment, B - Bill of exchange receivableselectionB
Accounting: Secondary Index for CustomersFSL_BSID/VBEWAFlow Type (Dyn Sel)Either enter a valid Flow Type or enter >!< to select all.charSE
Accounting: Secondary Index for CustomersFSL_BSID/VERTNContract Number (Dyn Sel)Either enter a valid Contract Number or enter >!< to select all.string[2000346228]
Accounting: Secondary Index for CustomersFSL_BSID/VERTTContract Type (Dyn Sel)Either enter a valid Contract Type, for example: 1 Loans, 2 Securities, 3 Lease-Out – Real Estate, 4 Foreign Exchange, 5 Money Market, V Contract Management – Consumer Products, X External Accounts, E Exposure PositioncharV
Accounting: Secondary Index for CustomersFSL_BSID/WAERSCurrency Key (Dyn Sel)Either enter a valid Currency Key, for example: EUR Euro, GBP British Pound, USD US DollarstringEUR
Accounting: Secondary Index for CustomersFSL_BSID/WRBTRAmount in Document Currency (Dyn Sel)Either enter an Amount or enter >!< to select all.number1580722.56
Accounting: Secondary Index for CustomersFSL_BSID/ZLSCHPayment Method (Dyn Sel)Either enter a valid Payment Method, for example:, C Pre-Numbered Cheques, E EFT Payment, F Foreign Bank Transfers, Y SEPA Direct DebitcharY
Accounting: Secondary Index for CustomersFSL_BSID/ZLSPRPayment Block Key (Dyn Sel)Either enter a valid Payment Block Key, for example: >!< - Free for Payment, * - Skip Account, A - Blocked for Payment, F - Fraud Management, P - Payment Request, R - Invoice Verification, V - Payment ClearingcharV
Accounting: Secondary Index for CustomersFSL_BSID/ZUONRAssignment Number (Dyn Sel)Either enter a valid Assignment Number or enter >!< to select all.number[0000000000013]
Accounting: Secondary Index for CustomersFSL_KNA1/BRSCHIndustry Key (Dyn Sel)Either enter a valid Industry Key, for example: AGRI - Agriculture, AIR - Airlines, AUTO - Automotive, CHEM - Chemical IndustrystringAUTO
Accounting: Secondary Index for CustomersFSL_KNA1/KONZSGroup Key (Dyn Sel)Either enter a valid Group Key or enter >!< to select all.stringACME AG
Accounting: Secondary Index for CustomersFSL_KNA1/LAND1Country Key (Dyn Sel)Either enter a valid Country Key or enter >!< to select all.stringDE
Accounting: Secondary Index for CustomersFSL_KNA1/ORT01City (Dyn Sel)Either enter a valid City or enter >!< to select all.stringSpringfield
Accounting: Secondary Index for CustomersFSL_KNA1/PSTLZPostal Code (Dyn Sel)Either enter a valid Postal Code or enter >!< to select all.string60190
Accounting: Secondary Index for CustomersFSL_KNA1/VBUNDCompany ID of trading partner (Dyn Sel)Either enter a valid Company ID of trading partner or enter >!< to select all.string[2201]
Accounting: Secondary Index for CustomersFSL_KNB1/AKONTReconciliation Account in General Ledger (Dyn Sel)Either enter a valid Reconciliation Account in General Ledger or enter >!< to select all.number[80089000]
Accounting: Secondary Index for CustomersFSL_KNB1/BUSABAccounting Clerk (Dyn Sel)Either enter a valid Accounting Clerk or enter >!< to select all.stringD1

See Also

Redwood Finance Automation Reference

financeTopic

← FAGLL03RFEPOJ00 →
  • Component Name and System Landscape
  • Brief Description
  • Parameter Mapping - Generic Tabs
  • Parameter Mapping - Specific Tabs
  • See Also
Docs
Getting StartedInstallationFinance InstallationConcepts
TroubleshootingArchiving
Learn and Connect
Support Portal
BlogEventsResources
ISO/ IEC 27001 Information Security Management
Automate to be human

2023 All Rights Reserved |

Terms of Service | Policies | Cookies | Glossary | Third-party Software | Contact | Copyright | Impressum |