Process Definition Templates

The following template definitions are available:

• FCA_AdHoc_Process_Template - Template for submitting an ad hoc process
• FCA_SAP_AbapRun_Template - SAP - Template: AbapRun template
• FCA_SAP_Tran_Journal_Excel_Template_Create - SAP - FI: Create Excel Template with journal postings
• FCA_SAP_Tran_Journal_Excel_Template_Post - SAP - FI: Process Excel Template with journal postings
• FCA_SAP_Tran_Journal_Post - SAP - FI: Post journal postings

Excel-Related ApplicationCustomizing Parameters

You specify the following parameters in the ApplicationCustomizing table for definitions that handle Excel files:

Parameter	Description	Default
POI_Zip_Entry_Size	The maximum size of a compressed file in the ZIP archive, in MB.	50
POI_Zip_Ratio	Sets the minimum inflation ratio for ZIP files. The default value of 0.01 specifies that an inflated file might be up to 100 times larger than the compressed file. Setting this to 0 allows all possible ratios.	0.01
POI_Zip_Text_Size	The maximum size of a text file to be zipped, in millions of characters.	50

See POI ZipSecureFile for more information.

FCA_AdHoc_Process_Template

Template for submitting an ad hoc process

Parameters

Name	Description	Direction	Data Type
COMMENT	Comment	In	String
FILENAME	Filename	In	File

FCA_SAP_AbapRun_Template

SAP - Template: AbapRun template

Parameters

Name	Description	Direction	Data Type
SAP_SYSTEMS	SAP System	In Out	String
CLIENT	SAP Client	In Out	String
JOB_NAME	SAP Job name	In	String
JOBNAME	SAP Job Name	In	String
ABAP_PROGRAM_NAME	ABAP Program	In	String
ABAP_VARIANT_NAME	ABAP Variant	In Out	String
TEMPORARY_VARIANT	Create Temporary Variant?	In	String
SPA_PARAMETERS	SAP SPA Parameters	In	String
RUN_TYPE	Run Type of SAP Job	In	String
JOBCLASS	SAP Job Class	In	String
SAP_USER_NAME	SAP User Name	In Out	String
LANGUAGE	SAP Language for the Step	In Out	String
TARGET_SERVER	SAP Target Server Name	In Out	String
TARGET_GROUP	SAP Target Server Group Name	In	String
BDC_NAME	BatchInput session name	In	String
BDC_CREATOR	BatchInput session owner	In	String
BDC_QID	BatchInput session unique identifier	Out	String
RULE	Action Rule(s) to process	In	String
RULE_RESULT	Action Rule: Resulting value	Out	String
RULE_PRERUNNING	Pre-Running Action Rule(s) to process	Out	String
PRINT_ARMOD	Print/Archive Mode	In	String
PRINT_PDEST	Printer	In	String
PRINT_PRTXT	Cover Page Title	In	String
PRINT_PRCOP	Number of Copies	In	String
PRINT_PRNEW	New Spool?	In	String
PRINT_PLIST	Spool List Name	In	String
PRINT_PRIMM	Print Immediately?	In	String
PRINT_PRREL	Delete Spool After Print?	In	String
PRINT_PEXPI	Expiration in Days	In	String
PRINT_LICT	Print Lines per Page	In	String
PRINT_LISZ	Print Columns per Page	In	String
PRINT_PAART	Print Format	In	String
PRINT_PRBIG	Selection Cover Page?	In	String
PRINT_PRSAP	SAP Cover Page?	In	String
PRINT_PRREC	Spool List Recipient	In	String
PRINT_PRABT	Department on Cover Page	In	String
PRINT_PRBER	Authority for Printing	In	String
PRINT_PRDSN	Spool Dataset Name	In	String
PRINT_PTYPE	Spool Type	In	String
PRINT_FOOTL	Print Footer?	In	String
PRINT_PRUNX	OS Cover Page?	In	String
DRAFT_MODE	Draft Mode?	In	String
PAGE_ORIENTATION	Page Orientation	In	String
ARCHIVE_SAP_OBJECT	Archive SAP Object	In	String
ARCHIVE_AR_OBJECT	Document Type	In	String
ARCHIVE_INFO	Archive Information	In	String
ARCHIVE_ARCTEXT	Archive Text Information Field	In	String
REC_TYPE	Recipient Type	In	String
REC_RECIPIENT	Spool List Recipient	In	String
REC_COPY	Recipient Copy Flag	In	String
REC_BLIND_COPY	Recipient Blind Copy Flag	In	String
REC_EXPRESS	Recipient Express Flag	In	String
REC_NO_FORWARDING	Recipient No Forwarding Flag	In	String
REC_NO_PRINT	Recipient No Print Flag	In	String
REC_DELIVER	Report Send Status	In	String
REC_MAILSTATUS	Report Status By E-Mail	In	String
SHOWLOG	Retrieve Job Log?	In	String
SHOWSPOOL	Retrieve Spool Lists?	In	String
SHOWSTAT	Retrieve Job Statistics?	In	String
SHOWAPPLLOG	Retrieve Application Logs?	In	String
DELETE_JOB	Delete Job When Finished?	In	String
IGNORE_APPL_RC	Ignore Application Return Code?	In	String
JOBCOUNT	SAP Job Count	Out	String
FL_SHOWLOG	Retrieve Job Log? (see Logs for more information)	In	String
FL_SHOWSPOOL	Retrieve Spool Files? (see Spool Output for more information)	In	String
FL_SHOWAPPLLOG	Retrieve Application Logs? (see Application Logs for more information)	In	String
PARAMETER_TEMPLATE	Parameter Template to import	In	String
TASK_TITLE	Task description	In	String

FCA_SAP_Tran_Journal_Excel_Template_Create

This definition generates an Excel template to be used with FCA_SAP_Tran_Journal_Excel_Template_Post for journal posting. You use it in a chain together with FCA_SAP_Tran_Journal_Excel_Template_Post to post journal entries into SAP.

Natively supported journal transactions

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

note

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

Excel Files

This definition uses Excel files as templates stored in the following documents (Definitions > Documents):

• FCA_SAP_Tran_Journal_Posting_Template_1
• FCA_SAP_Tran_Journal_Posting_Template_2
• FCA_SAP_Tran_Journal_Posting_Template_3
• FCA_SAP_Tran_Journal_Posting_Template_4

If you need to change any, you duplicate them, change the application property to CUS_FCA_SAP, download the Excel file, adapt it and re-upload to your custom document. You use it by filling the Full Path property of the document in the Template Excel for Target parameter in the Excel parameter group. For example, doc:REDWOOD:/REDWOOD.CUS_FCA/REDWOOD.CUS_FCA_SAP/FCA_SAP_Tran_Journal_Posting_Template_Example.xlsx.

Parameters

Tab	Name	Description	Documentation	Default Expression	Values
Target	SAP_SYSTEMS	SAP System
Target	CLIENT	SAP Client
Target	SAP_USER_NAME	SAP User	SAP user used for posting. If the user is synchronized with SAP using FCA_SAP_UserDetails_Synchronize, the user's locale in SAP will be used for number and date formatting by default. If the user was not synchronized, then SAP defaults will be used. If this parameter is left empty and no credential was specified, the default user will be the default user of the client. If this user is not synchronized, the SAP defaults will be used.
Target	CREDENTIAL_USER	Credential User to be used for SAP access.	The credential to use to connect to SAP, this user is also used as a default for SAP User (SAP_USER_NAME) parameter.
Target	LANGUAGE	SAP Language for the Step
Infrastructure	RULE	Action Rule(s) to process	Action rules are deprecated, use the data transformer instead.
Infrastructure	RULE_RESULT_HEADER	List with Fields used in Resulting RTX	The value is a comma-separated list with field specifications. The field specifications is: <FieldName>[(<FlRtxType>[;<isKey>[;<len>[;<decimals>[;<description>]]]])] IsKey: X or empty FlRtxType: <any RTX Native Type>, SAP_Char, SAP_Num, SAP_Byte, SAP_Bcd, SAP_Int, SAP_Int1, SAP_Int2, SAP_Float, SAP_Date, SAP_Time, SAP_String, SAP_Xstring
Infrastructure	RULE_RESULT	Action Rule: Resulting value
Infrastructure	RULE_RESULT_RTX	Resulting RTX
Options	IN_NUMBER_LOCALE	Specific Number Locale(s) to be used	Comma-separated list with Locales. Entries can be quoted. Example: en-US
Excel	IN_TEMPLATE_XLS	Template Excel for Target	can be document		FCA_SAP_Tran_Journal_Posting_Template_1.xlsx =Type 1 (Single Line; Multiple Tran/Sheet) FCA_SAP_Tran_Journal_Posting_Template_2.xlsx =Type 2 (Separate Header; Single Tran/Sheet) FCA_SAP_Tran_Journal_Posting_Template_3.xlsx =Type 3 (Separate Header; Multiple Tran/Sheet) FCA_SAP_Tran_Journal_Posting_Template_4.xlsx =Type 4 (Recurring Journal)
Excel	IN_TEMPLATE_SHEET	Sheet in Template Excel for Results to use	Default Upload
Excel	OUT_XLS	Output Excel filename		Journal.xlsx
Excel	IN_EXCEL_EVALUATE	Evaluate formulas	For cells with formulas (values starting with =), the result is evaluated	true	true, false
Options	IN_NUMBER_FORMAT_VALUE	Use formatted value	For numeric cells, use formatted cell value instead of internal value from Excel		X
Options	IN_FORCE_PARK	Force Parking of Journal	Forces transaction to be FBV1 to force parking of the document		X
Options	IN_FORCE_CLEARING	Force Clearing of Journal	Forces transaction to be FB05/L to post with clearing		X
Options	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 DateTimeFormatter syntax). A comma separated list can be used to specify multiple values. Entries can be quoted.
Options	IN_FORCE_FB41	Force Transaction FB41	Forces transaction to be FB41 to force posting to without VAT indicator		X
Header	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		X
Header	BLART	Document Type
Header	COMPANY	Company
Header	BUDAT	Posting Date	The posting date; since this definition is designed to be used in a chain, this mandatory parameter is not displayed and needs to be mapped in a chain. You the function =toSapDate(Time.now()) to set this to the runtime date.
Header	BLDAT	Document Date	Document date is optional, when not specified, will be the same as Posting Date (BUDAT)
Header	XBLNR	Reference
Header	WAERS	Currency
Header	XMWST	Calculate Tax			X
Header	BKTXT	Document Header Text
Header	LDGRP	Ledger Group
Header	STGRD	Reversal Reason
Header	STODT	Reversal Date
Item - 1	NEWBS_1	Posting Key
Item - 1	NEWKO_1	Account
Item - 1	NEWUM_1	Special G/L Indicator
Item - 1	NEWBW_1	Asset Transaction Type
Item - 1	NEWBK_1	Company Code (Item)
Item - 1	WRBTR_1	Amount
Item - 1	MWSKZ_1	Tax Type
Item - 1	SGTXT_1	Item Text
Item - 1	ZUONR_1	Assignment
Item - 1	PRCTR_1	Profit Center
Item - 1	KOSTL_1	Cost Center
Item - 1	GSBER_1	Business Area
Item - 1	PS_POSID_1	WBS Element
Item - 1	PPRCTR_1	Partner Profit Center
Item - 1	VBUND_1	Trading Partner
Item - 1	AUFNR_1	Order
Item - 1	MATNR_1	Material
Item - 1	WERKS_1	Plant
Item - 1	TXJCD_1	Tax Jurisdiction Code
Item - 1	RMVCT_1	Transaction Type
Item - 1	MEINS_1	Unit of Measure
Item - 1	MENGE_1	Quantity
Item - 2	NEWBS_2	Posting Key
Item - 2	NEWKO_2	Account
Item - 2	NEWUM_2	Special G/L Indicator
Item - 2	NEWBW_2	Asset Transaction Type
Item - 2	NEWBK_2	Company Code (Item)
Item - 2	WRBTR_2	Amount
Item - 2	MWSKZ_2	Tax Type
Item - 2	SGTXT_2	Item Text
Item - 2	ZUONR_2	Assignment
Item - 2	PRCTR_2	Profit Center
Item - 2	KOSTL_2	Cost Center
Item - 2	GSBER_2	Business Area
Item - 2	PS_POSID_2	WBS Element
Item - 2	PPRCTR_2	Partner Profit Center
Item - 2	VBUND_2	Trading Partner
Item - 2	AUFNR_2	Order
Item - 2	MATNR_2	Material
Item - 2	WERKS_2	Plant
Item - 2	TXJCD_2	Tax Jurisdiction Code
Item - 2	RMVCT_2	Transaction Type
Item - 2	MEINS_2	Unit of Measure
Item - 2	MENGE_2	Quantity
Item - 3	NEWBS_3	Posting Key
Item - 3	NEWKO_3	Account
Item - 3	NEWUM_3	Special G/L Indicator
Item - 3	NEWBW_3	Asset Transaction Type
Item - 3	NEWBK_3	Company Code (Item)
Item - 3	WRBTR_3	Amount
Item - 3	MWSKZ_3	Tax Type
Item - 3	SGTXT_3	Item Text
Item - 3	ZUONR_3	Assignment
Item - 3	PRCTR_3	Profit Center
Item - 3	KOSTL_3	Cost Center
Item - 3	GSBER_3	Business Area
Item - 3	PS_POSID_3	WBS Element
Item - 3	PPRCTR_3	Partner Profit Center
Item - 3	VBUND_3	Trading Partner
Item - 3	AUFNR_3	Order
Item - 3	MATNR_3	Material
Item - 3	WERKS_3	Plant
Item - 3	TXJCD_3	Tax Jurisdiction Code
Item - 3	RMVCT_3	Transaction Type
Item - 3	MEINS_3	Unit of Measure
Item - 3	MENGE_3	Quantity
Bulk	IN_DATA	Bulk Input Data (MergeRecord)
Bulk	IN_DATA_HEADER	List with Fields used in the Input Record	The value is a comma separated list with field specifications. The field specifications is: <FieldName>[(<FlRtxType>[;<isKey>[;<len>[;<decimals>[;<description>]]]])] IsKey: X or empty FlRtxType: <any RTX Native Type>, SAP_Char, SAP_Num, SAP_Byte, SAP_Bcd, SAP_Int, SAP_Int1, SAP_Int2, SAP_Float, SAP_Date, SAP_Time, SAP_String, SAP_Xstring	${J:RULE_RESULT_HEADER}
Bulk	IN_DATA_RTX	Bulk Input Data (RTX)
Bulk	IN_DATA_OPTION_ITEM	Bulk Option Item-2/3 usage	Depending on how this option is set, the Item-2 and Item-3 tabs are being used or not. Either for each Bulk record, for each transaction or once at the end		=Ignore,I=for each bulk entry,T=for each transaction,L=at the end once
Header - Recurring	DBBDT	First Run date
Header - Recurring	DBEDT	Last run date
Header - Recurring	DBMON	Intv.Months
Header - Recurring	DBTAG	Run date
Header - Recurring	DBAKZ	Run Schedule

FCA_SAP_Tran_Journal_Excel_Template_Post

This definition is designed to post Excel files generated with FCA_SAP_Tran_Journal_Excel_Template_Create to SAP journals.

Natively supported journal transactions

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

note

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

Parameters

Tab	Name	Description	Documentation	Default Expression	Values
Excel	IN_XLS	Input Excel	Can be document
Blocking	IN_LIMIT	Maximum number of items		900
Blocking	IN_ACCOUNT	Technical Account
Blocking	IN_PRCTR	Technical ProfitCenter
Target	SAP_SYSTEMS	SAP System
Target	CLIENT	SAP Client
Target	CREDENTIAL_USER	Credential User to be used for SAP access.	The credential to use to connect to SAP, this user is also used as a default for SAP User (SAP_USER_NAME) parameter.
Target	SAP_USER_NAME	SAP User	SAP user used for posting. If the user is synchronized with SAP using FCA_SAP_UserDetails_Synchronize, the user's locale in SAP will be used for number and date formatting by default. If the user was not synchronized, then SAP defaults will be used. If this parameter is left empty and no credential was specified, the default user
Target	LANGUAGE	SAP Language for the Step
Infrastructure	RULE	Action Rule(s) to process
Infrastructure	RULE_RESULT	Result records
BatchInput	BDC_DOCUMENTS_CROSS_RTX	Created Cross Company Documents (RTX)
Infrastructure	RULE_RESULT_HEADER	List with Fields used in Resulting RTX	The value is a comma separated list with field specifications. The field specifications is: <FieldName>[(<FlRtxType>[;<isKey>[;<len>[;<decimals>[;<description>]]]])] IsKey: X or empty FlRtxType: <any RTX Native Type>, SAP_Char, SAP_Num, SAP_Byte, SAP_Bcd, SAP_Int, SAP_Int1, SAP_Int2, SAP_Float, SAP_Date, SAP_Time, SAP_String, SAP_Xstring
BatchInput	BDC_NAME	BatchInput map name		>CALL_CHECK<
BatchInput	BDC_CREATOR	BatchInput map owner
BatchInput	BDC_DOCUMENTS	Created Documents
BatchInput	BDC_DOCUMENTS_RTX	Created Documents (RTX)
BatchInput	BDC_DOCUMENTS_CROSS	Created Cross Company Documents
BatchInput	BDC_QID	BatchInput session unique identifier
Transaction	O_TRAN_RESULT	Transaction results
Transaction	O_TRAN_HEADER	Transaction results header
Transaction	O_TRAN_DETAILS	Transaction details	RTX with: <Debit Amount>;<Credit Amount>;<Tax Amount>;<Total Amount>;<Journal Items>
Infrastructure	TRAN_RESULT_MESSAGES	Resulting Transaction Messages (RTX)
Transaction	O_TRAN_DETAILS_COMPANY	Transaction details by company	RTX with: <Company>;<Debit Amount>;<Credit Amount>;<Tax Amount>;<Total Amount>;<Journal Items>
Excel	IN_SHEET	Sheet to process	When empty, all sheets are process. Or use a comma separated list to process specific sheets	Upload
Options	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 DateTimeFormatter syntax). A comma separated list can be used to specify multiple values. Entries can be quoted.
Options	IN_NUMBER_LOCALE	Specific Number Locale(s) to be used	Comma separated list with Locales. Entries can be quoted. Example: en-US
Excel	IN_EXCEL_EVALUATE	Evaluate formulas		true	true, false
BatchInput	IN_SIMULATION	Do Simulation before creation		true	true, false
Options	IN_ALLOWED_DOCTYPES	Allowed Document Types	Empty = All Document Types supported List with document types (comma) = Only those are allowed
Infrastructure	RULE_RESULT_RTX	Resulting RTX
Excel	IN_TEMPLATE_XLS	Template Excel for Results	can be document		FCA_SAP_Tran_Journal_Posting_Template_1.xlsx =Type 1 (Single Line; Multiple Tran/Sheet) FCA_SAP_Tran_Journal_Posting_Template_2.xlsx =Type 2 (Separate Header; Single Tran/Sheet) FCA_SAP_Tran_Journal_Posting_Template_3.xlsx =Type 3 (Separate Header; Multiple Tran/Sheet) FCA_SAP_Tran_Journal_Posting_Template_4.xlsx =Type 4 (Recurring Journal)
Excel	IN_TEMPLATE_SHEET	Sheet in Template Excel for Results to use	Default Upload
Options	IN_FORCE_PARK	Force Parking of Journal	Forces transaction to be FBV1 to force parking of the document		X
Options	IN_FORCE_CLEARING	Force Clearing of Journal	Forces transaction to be FB05(L) to post with clearing		X
Options	IN_NUMBER_FORMAT_VALUE	Use formatted value	For numeric cells, use formatted cell value instead of internal value from Excel		X
Options	IN_FORCE_FB41	Force Transaction FB41	Forces transaction to be FB41 to force posting to without VAT indicator		X

FCA_SAP_Tran_Journal_Post

Natively supported journal transactions

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

note

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

Parameters

Tab	Name	Description	Documentation	Default Expression	Values
Target	SAP_SYSTEMS	SAP System
Target	CLIENT	SAP Client
Target	SAP_USER_NAME	SAP User
Target	CREDENTIAL_USER	Credential User to be used for SAP access
Target	LANGUAGE	SAP Language for the Step
Infrastructure	RULE	Action Rule(s) to process
Infrastructure	RULE_RESULT_HEADER	List with Fields used in Resulting RTX	The value is a comma separated list with field specifications. The field specifications is: <FieldName>[(<FlRtxType>[;<isKey>[;<len>[;<decimals>[;<description>]]]])] IsKey: X or empty FlRtxType: <any RTX Native Type>, SAP_Char, SAP_Num, SAP_Byte, SAP_Bcd, SAP_Int, SAP_Int1, SAP_Int2, SAP_Float, SAP_Date, SAP_Time, SAP_String, SAP_Xstring
Infrastructure	RULE_RESULT	Action Rule: Resulting value
Infrastructure	RULE_RESULT_RTX	Resulting RTX
Blocking	IN_LIMIT	Maximum number of items		900
Blocking	IN_ACCOUNT	Technical Account
Blocking	IN_PRCTR	Technical ProfitCenter
BatchInput	BDC_NAME	BatchInput map name		>CALL_CHECK<
BatchInput	BDC_CREATOR	BatchInput map owner
BatchInput	BDC_DOCUMENTS	Created Documents
BatchInput	BDC_DOCUMENTS_RTX	Created Documents (RTX)
BatchInput	BDC_DOCUMENTS_CROSS	Created Cross Company Documents
BatchInput	BDC_DOCUMENTS_CROSS_RTX	Created Cross Company Documents (RTX)
BatchInput	BDC_QID	BatchInput session unique identifier
BatchInput	IN_SIMULATION	Do Simulation before creation		true	true, false
Transaction	O_TRAN_RESULT	Transaction results
Transaction	O_TRAN_HEADER	Transaction results header
Transaction	O_TRAN_DETAILS	Transaction details	RTX with: <Debit Amount>;<Credit Amount>;<Tax Amount>;<Total Amount>;<Journal Items>
Transaction	O_TRAN_DETAILS_COMPANY	Transaction details by company	RTX with: <Company>;<Debit Amount>;<Credit Amount>;<Tax Amount>;<Total Amount>;<Journal Items>
Infrastructure	TRAN_RESULT_MESSAGES	Resulting Transaction Messages (RTX)
Options	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 DateTimeFormatter syntax). A comma separated list can be used to specify multiple values. Entries can be quoted.
Options	IN_NUMBER_LOCALE	Specific Number Locale(s) to be used.	Comma separated list with Locales. Entries can be quoted. Example: en-US
Options	IN_ALLOWED_DOCTYPES	Allowed Document Types	Empty = All Document Types supported, List with document types (comma) = Only those are allowed
Options	IN_FORCE_PARK	Force Parking of Journal	Forces transaction to be FBV1 to force parking of the document		X
Options	IN_FORCE_CLEARING	Force Clearing of Journal	Forces transaction to be FB05(L) to post with clearing		X
Options	IN_FORCE_FB41	Force Transaction FB41	Forces transaction to be FB41 to force posting to without VAT indicator		X
Excel	IN_TEMPLATE_XLS	Template Excel for Results	can be document		FCA_SAP_Tran_Journal_Posting_Template_1.xlsx =Type 1 (Single Line; Multiple Tran/Sheet) FCA_SAP_Tran_Journal_Posting_Template_2.xlsx =Type 2 (Separate Header; Single Tran/Sheet) FCA_SAP_Tran_Journal_Posting_Template_3.xlsx =Type 3 (Separate Header; Multiple Tran/Sheet) FCA_SAP_Tran_Journal_Posting_Template_4.xlsx =Type 4 (Recurring Journal)
Excel	IN_TEMPLATE_SHEET	Sheet in Template Excel for Results to use	Default Upload
Options	IN_NUMBER_FORMAT_VALUE	Use formatted value	For numeric cells, use formatted cell value instead of internal value from Excel		X
Header	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		X
Header	BLART	Document Type
Header	COMPANY	Company
Header	BUDAT	Posting Date
Header	BLDAT	Document Date
Header	XBLNR	Reference
Header	WAERS	Currency
Header	XMWST	Calculate Tax			X
Header	BKTXT	Document Header Text
Header	LDGRP	Ledger Group
Header	STGRD	Reversal Reason
Header	STODT	Reversal Date
Item - 1	NEWBS_1	Posting Key
Item - 1	NEWKO_1	Account
Item - 1	NEWUM_1	Special G/L Indicator
Item - 1	NEWBW_1	Asset Transaction Type
Item - 1	NEWBK_1	Company Code (Item)
Item - 1	WRBTR_1	Amount
Item - 1	MWSKZ_1	Tax Type
Item - 1	SGTXT_1	Item Text
Item - 1	ZUONR_1	Assignment
Item - 1	PRCTR_1	Profit Center
Item - 1	KOSTL_1	Cost Center
Item - 1	GSBER_1	Business Area
Item - 1	PS_POSID_1	WBS Element
Item - 1	PPRCTR_1	Partner Profit Center
Item - 1	VBUND_1	Trading Partner
Item - 1	AUFNR_1	Order
Item - 1	MATNR_1	Material
Item - 1	WERKS_1	Plant
Item - 1	TXJCD_1	Tax Jurisdiction Code
Item - 1	RMVCT_1	Transaction Type
Item - 1	MEINS_1	Unit of Measure
Item - 1	MENGE_1	Quantity
Item - 2	NEWBS_2	Posting Key
Item - 2	NEWKO_2	Account
Item - 2	NEWUM_2	Special G/L Indicator
Item - 2	NEWBW_2	Asset Transaction Type
Item - 2	NEWBK_2	Company Code (Item)
Item - 2	WRBTR_2	Amount
Item - 2	MWSKZ_2	Tax Type
Item - 2	SGTXT_2	Item Text
Item - 2	ZUONR_2	Assignment
Item - 2	PRCTR_2	Profit Center
Item - 2	KOSTL_2	Cost Center
Item - 2	GSBER_2	Business Area
Item - 2	PS_POSID_2	WBS Element
Item - 2	PPRCTR_2	Partner Profit Center
Item - 2	VBUND_2	Trading Partner
Item - 2	AUFNR_2	Order
Item - 2	MATNR_2	Material
Item - 2	WERKS_2	Plant
Item - 2	TXJCD_2	Tax Jurisdiction Code
Item - 2	RMVCT_2	Transaction Type
Item - 2	MEINS_2	Unit of Measure
Item - 2	MENGE_2	Quantity
Item - 3	NEWBS_3	Posting Key
Item - 3	NEWKO_3	Account
Item - 3	NEWUM_3	Special G/L Indicator
Item - 3	NEWBW_3	Asset Transaction Type
Item - 3	NEWBK_3	Company Code (Item)
Item - 3	WRBTR_3	Amount
Item - 3	MWSKZ_3	Tax Type
Item - 3	SGTXT_3	Item Text
Item - 3	ZUONR_3	Assignment
Item - 3	PRCTR_3	Profit Center
Item - 3	KOSTL_3	Cost Center
Item - 3	GSBER_3	Business Area
Item - 3	PS_POSID_3	WBS Element
Item - 3	PPRCTR_3	Partner Profit Center
Item - 3	VBUND_3	Trading Partner
Item - 3	AUFNR_3	Order
Item - 3	MATNR_3	Material
Item - 3	WERKS_3	Plant
Item - 3	TXJCD_3	Tax Jurisdiction Code
Item - 3	RMVCT_3	Transaction Type
Item - 3	MEINS_3	Unit of Measure
Item - 3	MENGE_3	Quantity
One-Time Business Partner	OBP_TITLE	Title
One-Time Business Partner	OBP_LANGUAGE	Language
One-Time Business Partner	OBP_NAME	Name
One-Time Business Partner	OBP_NAME2	Name 2
One-Time Business Partner	OBP_NAME3	Name 3
One-Time Business Partner	OBP_NAME4	Name 4
One-Time Business Partner	OBP_STREET	Street
One-Time Business Partner	OBP_PO_BOX	PO Box
One-Time Business Partner	OBP_PO_BOX_NUM	PO Box without Number			X
One-Time Business Partner	OBP_POBOX_PCD	PO Box Postal Code
One-Time Business Partner	OBP_CITY	City
One-Time Business Partner	OBP_POSTAL_CODE	Postal code
One-Time Business Partner	OBP_COUNTRY	Country
One-Time Business Partner	OBP_REGION	Region
One-Time Business Partner	OBP_BANK_NO	Bank Key
One-Time Business Partner	OBP_BANK_CTRY	Bank Country
One-Time Business Partner	OBP_BANK_ACCT	Bank Account
One-Time Business Partner	OBP_CTRL_KEY	Bank Control Key
One-Time Business Partner	OBP_BKREF	Reference Details for Bank Details
One-Time Business Partner	OBP_INSTR_KEY	Instruction key for data medium exchange
One-Time Business Partner	OBP_DME_IND	DME Indicator
One-Time Business Partner	OBP_TAX_NO_1	Tax Number 1
One-Time Business Partner	OBP_TAX_NO_2	Tax Number 2
One-Time Business Partner	OBP_TAX_NO_3	Tax Number 3
One-Time Business Partner	OBP_TAX_NO_4	Tax Number 4
One-Time Business Partner	OBP_TAX_NO_5	Tax Number 5
One-Time Business Partner	OBP_FITYP	Tax Type
One-Time Business Partner	OBP_STCDT	Tax number Type
One-Time Business Partner	OBP_STKZN	Natural Person			X
One-Time Business Partner	OBP_EQUAL_TAX	Equalization Tax			X
One-Time Business Partner	OBP_J_1KFTBUS	Type of Business
One-Time Business Partner	OBP_TAX	Liable for VAT			X
One-Time Business Partner	OBP_J_1KFTIND	Type of Industry
One-Time Business Partner	OBP_J_1KFREPRE	Name of Representative
One-Time Business Partner	OBP_EMPFG	Payment Recipient Code
One-Time Business Partner	OBP_GLO_RE1_OT	Country specific Reference
One-Time Business Partner	OBP_INTAD	Internet address of partner company clerk
One-Time Business Partner	OBP_POBK_CURAC	PO Bank Current Acct No. or Building Society Ref. No.
Bulk	IN_DATA	Bulk Input Data (MergeRecord)
Bulk	IN_DATA_HEADER	List with Fields used in the Input Record	The value is a comma separated list with field specifications. The field specifications is: <FieldName>[(<FlRtxType>[;<isKey>[;<len>[;<decimals>[;<description>]]]])] IsKey: X or empty FlRtxType: <any RTX Native Type>, SAP_Char, SAP_Num, SAP_Byte, SAP_Bcd, SAP_Int, SAP_Int1, SAP_Int2, SAP_Float, SAP_Date, SAP_Time, SAP_String, SAP_Xstring	${J:RULE_RESULT_HEADER}
Bulk	IN_DATA_RTX	Bulk Input Data (RTX)
Bulk	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		=Ignore,I=for each bulk entry,T=for each transaction,L=at the end once
Header - Recurring	DBBDT	First Run date
Header - Recurring	DBEDT	Last run date
Header - Recurring	DBMON	Intv.Months
Header - Recurring	DBTAG	Run date
Header - Recurring	DBAKZ	Run Schedule

See Also

Process Definition Templates

financeTopic