SAP Service Layer (Purchases)Install

Overview

This node integrates with the SAP Service Layer to manage purchase-related entities, specifically here focusing on Purchase Down Payments. The "Get by Key (Select)" operation retrieves a single Purchase Down Payment document identified by its unique DocEntry key and allows selecting specific fields to return.

Typical use cases include:

• Fetching detailed information about a particular down payment in SAP for review or processing.
• Retrieving only certain fields of a down payment to optimize data transfer and processing.
• Integrating SAP purchase down payment data into workflows for reporting, auditing, or further automation.

For example, you might use this node to get the total amount and vendor code of a specific down payment by specifying those fields in the select parameter.

Properties

Example values for Select could be: DocEntry,CardCode,DocTotal.

Output

The node outputs JSON data representing the requested Purchase Down Payment record. The structure corresponds to the SAP Service Layer's response for the Purchase Down Payment entity, containing the fields specified in the Select property or all fields if none specified.

Output example snippet (simplified):

{
  "DocEntry": 123,
  "CardCode": "V1000",
  "DocTotal": 1500.00,
  ...
}

No binary data output is produced by this operation.

Dependencies

• Requires an active connection to SAP Business One Service Layer API.
• Needs credentials including base URL, username, password, and company database name.
• The node performs login to obtain session cookies before making requests.
• No additional external dependencies beyond the SAP Service Layer API.

Troubleshooting

• Authentication errors: If login fails, verify the SAP Service Layer credentials and network connectivity.
• Invalid DocEntry: If the specified DocEntry does not exist, the API will return an error; ensure the key is correct.
• Field selection issues: Specifying invalid field names in Select may cause errors or empty results; confirm field names match SAP entity properties.
• Network/SSL issues: The node disables SSL verification (rejectUnauthorized: false), but network problems or incorrect URLs can still cause failures.
• Error messages: Returned errors are included in the output JSON under an error key for easier debugging.

Links and References

• SAP Business One Service Layer Documentation
• OData Query Options ($select)
• n8n HTTP Request Node Documentation (for understanding request options)

This summary covers the static analysis of the node’s execute method for the Purchase Down Payment resource with the Get by Key (Select) operation.