Journal Definitions

The following definitions are used by the posting journal extension.

Supported journal transactions:

• FB01 - Journals
• FB01L - Journals for Ledger Group
• FBS1 - Journals with Reversal information
• FBV1 - Parked Journals
• FB05 - Post with Clearing
• FB05L - Post with Clearing for Ledger Group
• FB41 - Post Tax Payable
• FBD1 - Recurring journals
• FB50L - Park with Ledger Group

note

String cell values are formated/parsed using SAP Formatting rules if no specific date/number format locale is specified

FCA_SAP_Tran_Journal_Excel_Template_Post

Parameters

Name	Description	Documentation	Data Type	Direction	Default Expression	Values
IN_XLS	Input Excel	Can be document	String	In
IN_LIMIT	Maximum number of items		String	In	900
IN_ACCOUNT	Technical Account		String	In
IN_PRCTR	Technical ProfitCenter		String	In
SAP_SYSTEMS	SAP System		String	InOut
CLIENT	SAP Client		String	InOut
SAP_USER_NAME	SAP User		String	In
CREDENTIAL_USER	Credential User to be used for SAP access		String	In
LANGUAGE	SAP Language for the Step		String	InOut
RULE	Action Rule(s) to process		String	In
RULE_RESULT	Result records		String	Out
BDC_DOCUMENTS_CROSS_RTX	Created Cross Company Documents (RTX)		Table	Out
RULE_RESULT_HEADER	Result records header		String	InOut
BDC_NAME	BatchInput map name		String	InOut	>CALL_CHECK<	>BDC< - replace with target Batch Input name >CALL_BAPI< - Call Bapi (errors in Batch Input) >CALL_CHECK< - Simulation only >CALL_TRAN< - Call Transaction (errors in Batch Input)
BDC_CREATOR	BatchInput map owner		String	In
BDC_DOCUMENTS	Created Documents		String	Out
BDC_DOCUMENTS_RTX	Created Documents (RTX)		Table	Out
BDC_DOCUMENTS_CROSS	Created Cross Company Documents		String	Out
BDC_QID	BatchInput session unique identifier		String	Out
O_TRAN_RESULT	Transaction results		String	Out
O_TRAN_HEADER	Transaction results header		String	Out
O_TRAN_DETAILS	Transaction details	RTX with: <Debit Amount>;<Credit Amount>;<Tax Amount>;<Total Amount>;<Journal Items>	Table	Out
TRAN_RESULT_MESSAGES	Resulting Transaction Messages (RTX)		Table	Out
O_TRAN_DETAILS_COMPANY	Transaction details by company	RTX with <Company>;<Debit Amount>;<Credit Amount>;<Tax Amount>;<Total Amount>;<Journal Items>	Table	Out
IN_SHEET	Sheet to process	When empty, all sheets are processed. Or use a comma separated list to process specific sheets	String	In	Upload
IN_DATE_FORMAT	Specific Date Format	By default, the Batch Date format and the current users format are used to determine a date field. Use this parameter to specify a different format (Java Simple Date format syntax) A comma separated list can be used to specify multiple values. Entries can be quoted.	String	In
IN_NUMBER_LOCALE	Specific Number Locale(s) to be used	Comma separated list with Locales. Entries can be quoted. Example: en-US	String	In
IN_EXCEL_EVALUATE	Evaluate formulas		String	In	true	true,false
IN_SIMULATION	Do Simulation before creation		String	In	true	true,false
IN_ALLOWED_DOCTYPES	Allowed Document Types		String	In		Empty - All Document Types supported List with document types (comma-separated) = Only those are allowed
RULE_RESULT_RTX	Resulting RTX		Table	Out
IN_TEMPLATE_XLS	Template Excel for Results	can be document	String	In		doc:$:/$.FCA/$.FCA_SAP/FCA_SAP_Tran_Journal_Posting_Template_1.xlsx Type 1 (Single Line; Multiple Tran/Sheet) doc:$:/$.FCA/$.FCA_SAP/FCA_SAP_Tran_Journal_Posting_Template_2.xlsx Type 2 (Separate Header; Single Tran/Sheet) doc:$:/$.FCA/$.FCA_SAP/FCA_SAP_Tran_Journal_Posting_Template_3.xlsx Type 3 (Separate Header; Multiple Tran/Sheet)
IN_TEMPLATE_SHEET	Sheet in Template Excel for Results to use	Default Upload	String	In
IN_FORCE_PARK	Force Parking of Journal	Forces transaction to be FBV1 to force parking of the document	String	In		X
IN_FORCE_CLEARING	Force Clearing of Journal	Forces transaction to be FB05(L) to post with clearing	String	In		X
IN_NUMBER_FORMAT_VALUE	Use formatted value	For numeric cells, use formatted cell value instead of internal value from Excel	String	In		X
IN_FORCE_FB41	Force Transaction FB41	Forces transaction to be FB41 to force posting to without VAT indicator	String	In		X

FCA_SAP_Tran_Journal_Post

Parameters

Name	Description	Documentation	Data Type	Direction	Default Expression	Values
SAP_SYSTEMS	SAP System		String	InOut
CLIENT	SAP Client		String	InOut
SAP_USER_NAME	SAP User		String	In
CREDENTIAL_USER	Credential User to be used for SAP access		String	In
LANGUAGE	SAP Language for the Step		String	InOut
RULE	Action Rule(s) to process		String	In
RULE_RESULT_HEADER	Result records header		String	InOut
RULE_RESULT	Action Rule: Resulting value		String	Out
RULE_RESULT_RTX	Resulting RTX		Table	Out
IN_LIMIT	Maximum number of items		String	In	900
IN_ACCOUNT	Technical Account		String	In
IN_PRCTR	Technical ProfitCenter		String	In
BDC_NAME	BatchInput map name		String	InOut	>CALL_CHECK<	>BDC< - replace with target Batch Input name >CALL_BAPI< - Call Bapi (errors in Batch Input) >CALL_CHECK< - Simulation only >CALL_TRAN< - Call Transaction (errors in Batch Input)
BDC_CREATOR	BatchInput map owner		String	In
BDC_DOCUMENTS	Created Documents		String	Out
BDC_DOCUMENTS_RTX	Created Documents (RTX)		Table	Out
BDC_DOCUMENTS_CROSS	Created Cross Company Documents		String	Out
BDC_DOCUMENTS_CROSS_RTX	Created Cross Company Documents (RTX)		Table	Out
BDC_QID	BatchInput session unique identifier		String	Out
IN_SIMULATION	Do Simulation before creation		String	In	true	true,false
O_TRAN_RESULT	Transaction results		String	Out
O_TRAN_HEADER	Transaction results header		String	Out
O_TRAN_DETAILS	Transaction details	RTX with:<Debit Amount>;<Credit Amount>;<Tax Amount>;<Total Amount>;<Journal Items>	Table	Out
O_TRAN_DETAILS_COMPANY	Transaction details by company	RTX with:<Company>;<Debit Amount>;<Credit Amount>;<Tax Amount>;<Total Amount>;<Journal Items>	Table	Out
TRAN_RESULT_MESSAGES	Resulting Transaction Messages (RTX)		Table	Out
IN_DATE_FORMAT	Specific Date Format	By default, the Batch Date format and the current users format are used to determine a date field. Use this parameter to specify a different format (Java Simple Date format syntax). A comma separated list can be used to specify multiple values. Entries can be quoted.	String	In
IN_NUMBER_LOCALE	Specific Number Locale(s) to be used.	Comma separated list with Locales. Entries can be quoted. Example: en-US	String	In
IN_ALLOWED_DOCTYPES	Allowed Document Types		String	In		Empty - All Document Types supported. List with document types (comma-separated) - Only those are allowed
IN_FORCE_PARK	Force Parking of Journal	Forces transaction to be FBV1 to force parking of the document	String	In		X
IN_FORCE_CLEARING	Force Clearing of Journal	Forces transaction to be FB05(L) to post with clearing	String	In		X
IN_FORCE_FB41	Force Transaction FB41	Forces transaction to be FB41 to force posting to without VAT indicator	String	In		X
IN_TEMPLATE_XLS	Template Excel for Results	can be document	String	In		doc:$:/$.FCA/$.FCA_SAP/FCA_SAP_Tran_Journal_Posting_Template_1.xlsx Type 1 (Single Line; Multiple Tran/Sheet) doc:$:/$.FCA/$.FCA_SAP/FCA_SAP_Tran_Journal_Posting_Template_2.xlsx Type 2 (Separate Header; Single Tran/Sheet) doc:$:/$.FCA/$.FCA_SAP/FCA_SAP_Tran_Journal_Posting_Template_3.xlsx Type 3 (Separate Header; Multiple Tran/Sheet)
IN_TEMPLATE_SHEET	Sheet in Template Excel for Results to use	Default Upload	String	In
IN_NUMBER_FORMAT_VALUE	Use formatted value	For numeric cells, use formatted cell value instead of internal value from Excel	String	In		X
IN_DATA_NEW_HDR	Start new Transaction	Only required if input data records are passed. For Journal processing not only X (start a new transaction) can be used, but also a key string. When the key changes, a new transaction is created	String	In		X
BLART	Document Type		String	In
COMPANY	Company		String	In
BUDAT	Posting Date		String	In
BLDAT	Document Date		String	In
XBLNR	Reference		String	In
WAERS	Currency		String	In
XMWST	Calculate Tax		String	In		X
BKTXT	Document Header Text		String	In
LDGRP	Ledger Group		String	In
STGRD	Reversal Reason		String	In
STODT	Reversal Date		String	In
NEWBS_1	Posting Key		String	In
NEWKO_1	Account		String	In
NEWUM_1	Special G/L Indicator		String	In
NEWBW_1	Asset Transaction Type		String	In
NEWBK_1	Company Code (Item)		String	In
WRBTR_1	Amount		String	In
MWSKZ_1	Tax Type		String	In
SGTXT_1	Item Text		String	In
ZUONR_1	Assignment		String	In
PRCTR_1	Profit Center		String	In
KOSTL_1	Cost Center		String	In
GSBER_1	Business Area		String	In
PS_POSID_1	WBS Element		String	In
PPRCTR_1	Partner Profit Center		String	In
VBUND_1	Trading Partner		String	In
AUFNR_1	Order		String	In
MATNR_1	Material		String	In
WERKS_1	Plant		String	In
TXJCD_1	Tax Jurisdiction Code		String	In
RMVCT_1	Transaction Type		String	In
MEINS_1	Unit of Measure		String	In
MENGE_1	Quantity		String	In
NEWBS_2	Posting Key		String	In
NEWKO_2	Account		String	In
NEWUM_2	Special G/L Indicator		String	In
NEWBW_2	Asset Transaction Type		String	In
NEWBK_2	Company Code (Item)		String	In
WRBTR_2	Amount		String	In
MWSKZ_2	Tax Type		String	In
SGTXT_2	Item Text		String	In
ZUONR_2	Assignment		String	In
PRCTR_2	Profit Center		String	In
KOSTL_2	Cost Center		String	In
GSBER_2	Business Area		String	In
PS_POSID_2	WBS Element		String	In
PPRCTR_2	Partner Profit Center		String	In
VBUND_2	Trading Partner		String	In
AUFNR_2	Order		String	In
MATNR_2	Material		String	In
WERKS_2	Plant		String	In
TXJCD_2	Tax Jurisdiction Code		String	In
RMVCT_2	Transaction Type		String	In
MEINS_2	Unit of Measure		String	In
MENGE_2	Quantity		String	In
NEWBS_3	Posting Key		String	In
NEWKO_3	Account		String	In
NEWUM_3	Special G/L Indicator		String	In
NEWBW_3	Asset Transaction Type		String	In
NEWBK_3	Company Code (Item)		String	In
WRBTR_3	Amount		String	In
MWSKZ_3	Tax Type		String	In
SGTXT_3	Item Text		String	In
ZUONR_3	Assignment		String	In
PRCTR_3	Profit Center		String	In
KOSTL_3	Cost Center		String	In
GSBER_3	Business Area		String	In
PS_POSID_3	WBS Element		String	In
PPRCTR_3	Partner Profit Center		String	In
VBUND_3	Trading Partner		String	In
AUFNR_3	Order		String	In
MATNR_3	Material		String	In
WERKS_3	Plant		String	In
TXJCD_3	Tax Jurisdiction Code		String	In
RMVCT_3	Transaction Type		String	In
MEINS_3	Unit of Measure		String	In
MENGE_3	Quantity		String	In
IN_DATA	Bulk Input Data (MergeRecord)		String	In
IN_DATA_HEADER	List with Fields used in the Input Record		String	InOut	${J:RULE_RESULT_HEADER}
IN_DATA_RTX	Bulk Input Data (RTX)		Table	In
IN_DATA_OPTION_ITEM	Bulk Option Item-2/3 usage	Depending on how this option is set, the Item-2 and Item-3 tab are being used or not. Either for each Bulk record, for each transaction or once at the end	String	In		- Ignore I - for each bulk entry T - for each transaction L - at the end once

financeTopic