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
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 Simple Date Format 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 emptyFlRtxType: <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 emptyFlRtxType: <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 Simple Date format 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 emptyFlRtxType: <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 Simple Date format 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 emptyFlRtxType: <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
financeTopic