Site Payments Process API - Implementation Template
Developer guide
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables. It can be used by developers seeking a solution to process site payments using Veeva CTMS and SAP S/4HANA.
| Module | Description |
|---|---|
| createSAPJournalEntryRequest | Convert Veeva Payment Request to SAP System API Journal Entry request. |
createSAPJournalEntryRequest
Convert Veeva Payment Request to SAP System API Journal Entry request.
Source:
.src/main/resources/dwl/createSAPJournalEntryRequest.dwl
Mapping Tables
Maps Veeva Payment Request to SAP System API Create Journal Entry Request. Implements required fields to create a Journal Entry in SAP and can be extended as necessary.
| SAP Field Name | CTMS Field Name | Description |
|---|---|---|
| SenderSystemId | N/A | Configuration value senderSystemId from properties file |
| messageHeader.recipientSystemId | N/A | Configuration value recipientSystemId from properties file |
| journalEntry.referenceDocumentType | N/A | Configuration value referenceDocumentType from properties file |
| journalEntry.referenceDocumentSystemName | N/A | Configuration value referenceDocumentSystemName from properties file |
| journalEntry.referenceDocumentId | payment__v.id | Veeva CTMS Payment Request Id |
| journalEntry.transactionType | N/A | Configuration value transactionType from properties file |
| journalEntry.accountingDocumentType | N/A | Configuration value accountingDocumentType from properties file. Constant value "KR" for Vendor Invoice |
| journalEntry.documentHeaderText | N/A | Configuration value documentHeaderText from properties file |
| journalEntry.createdBy | N/A | Configuration value createdBy from properties file |
| journalEntry.companyCode | payable_items__vr.project_code__v | Veeva CTMS Payable Item Project Code |
| journalEntry.documentDate | payment__v.modified_date__v | Veeva CTMS Payment Request Last Modified Date |
| journalEntry.postingDate | N/A | Current Date. Ex: now() |
| item.glAccount | payable_items__vr.account_code__v | Veeva CTMS Payable Item Account Code |
| item.amount.amount | payable_items__vr.amount__v | Sum of all CTMS Payable Items |
| item.amount.currencyCode | payable_items__vr.local_currency__sysr.name__v | Veeva CTMS Payable Item Local Currency |
| creditorItem.creditor | payable_items__vr.payee_name__vr.debtor__c | Veeva CTMS Payee Debtor Code |
| creditorItem.amount.amount | payable_items__vr.amount__v | Sum of all CTMS Payable Items to be credited. Credits are negative values |
| creditorItem.amount.currencyCode | payable_items__vr.local_currency__sysr.name__v | Veeva CTMS Payable Item Local Currency |