SAP Business ByDesign connection for LinkyFlow

SAP Business ByDesign connection for LinkyFlow

LinkyFlow brings SAP Business ByDesign ecommerce data into Excel so teams can browse, edit, validate, and publish from the spreadsheet.

Resources

135

Read requests

57

Write actions

83

Documented fields

1491

Workflows you can move into Excel

Each resource below maps to a practical spreadsheet workflow. Read actions bring useful columns into Excel; create and edit actions show what can be reviewed in rows before sending changes.

Analytics reports

Report Fields

The fields of one report: dimensions to group by, measures to total (exact decimals), their texts and currencies, and the parameters the report is run with — mandatory ones flagged, with how each takes values and its format.

Read

Report Fields

The fields of one report: dimensions to group by, measures to total (exact decimals), their texts and currencies, and the parameters the report is run with — mandatory ones flagged, with how each takes values and its format.

Route: GET /reportFields

Excel formula: =LF.sapbyd.reportFields("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
reportIdstringYesThe report id, as the reports read answers it — e.g. FINGLAU01_Q0001 (trial balance).
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

role
default

string

—

-

filterable
default

boolean

—

-

mandatory
default

boolean

—

-

selection
default

string

—

-

format
default

string

—

-

Report Rows

Runs one report, read-only: the columns in select, grouped by the dimensions among them, filtered — mandatory parameters included — by filters. Measures are exact decimal strings, each with its currency; a dimension comes with its text.

Read

Report Rows

Runs one report, read-only: the columns in select, grouped by the dimensions among them, filtered — mandatory parameters included — by filters. Measures are exact decimal strings, each with its currency; a dimension comes with its text.

Route: GET /reportRows

Excel formula: =LF.sapbyd.reportRows("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
reportIdstringYesThe report id, as the reports read answers it — e.g. FINGLAU01_Q0001 (trial balance).
selectstringYesComma-separated field ids from reportFields: the dimensions to group by and the measures to total, e.g. CGLACCT,KCENDING_BALANCE_CURRCOMP.
filtersstringNoOne line of FIELD=value clauses separated by ";" — FIELD=a|b for several values, FIELD=from..to for a range — e.g. "PARA_COMPANY=1000; PARA_...
per_pagenumberNoRows per page (max 1000) Default: 100
pagenumberNoPage number, starting at 1
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Reports

The analytics reports this connection’s user may run — SAP’s standard reports and the tenant’s own, from the work centres the user is assigned. Search them, read one report’s fields with reportFields, run it with reportRows.

Read

Reports

The analytics reports this connection’s user may run — SAP’s standard reports and the tenant’s own, from the work centres the user is assigned. Search them, read one report’s fields with reportFields, run it with reportRows.

Route: GET /reports

Excel formula: =LF.sapbyd.reports("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
searchstringNoWords of the report id or name, e.g. "trial balance", "VAT", FINGLAU01. Every word must match.
per_pagenumberNoReports per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

name
default

string

—

-

service

string

—

-

Finance

Accounting Document Lines

The lines of the posted accounting documents: G/L account, debit or credit, the amount in the line and in the company currency, the profit centre and segment, and whether a reversal cancelled the line.

Read

Accounting Document Lines

The lines of the posted accounting documents: G/L account, debit or credit, the amount in the line and in the company currency, the profit centre and segment, and whether a reversal cancelled the line.

Route: GET /accountingDocumentLines

Excel formula: =LF.sapbyd.accountingDocumentLines("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ParentObjectIDstringNoThe lines of this document, by its ObjectID.
CompanyUUIDstringNo-
ChartOfAccountsCodestringNoA code of the AccountingDocumentItemChartOfAccountsCode code list.
ChartOfAccountsItemCodestringNoe.g. 613200.
DebitCreditCodestringNo1 debit, 2 credit.
CancelledIndicatorbooleanNotrue for a line a reversal cancelled: CancellationAccountingDocumentUUID names the reversal.
accountingDocumentIdstringNoThe lines of this document, by its ID (470000000001) or its ObjectID. Several documents share an ID across companies or years: address it by...
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

ParentObjectID
default

string

→ accountingDocuments

-

CancelledIndicator
default

boolean

—

-

ChartOfAccountsItemCode
default

string

—

-

ChartOfAccountsItemCodeText
default

string

—

-

DebitCreditCodeText
default

string

—

-

ID
default

string

—

-

LineItemCurrencyAmount
default

number

—

-

currencyCode
default

string

—

-

LocalCurrencyAmount
default

number

—

-

currencyCode2
default

string

—

-

Accounting Documents

The documents the general ledger holds, posted (SAP AccountingDocument), read-only: company, set of books, fiscal year and period, posting date, type, and whether it reverses another. Every posting — a journal entry, an invoice, a payment — lands here; their lines are accountingDocumentLines.

Read

Accounting Documents

The documents the general ledger holds, posted (SAP AccountingDocument), read-only: company, set of books, fiscal year and period, posting date, type, and whether it reverses another. Every posting — a journal entry, an invoice, a payment — lands here; their lines are accountingDocumentLines.

Route: GET /accountingDocuments

Excel formula: =LF.sapbyd.accountingDocuments("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
AccountingDocument_IDstringNoe.g. 470000000001. Unique per company and fiscal year only.
AccountingDocument_CompanyUUIDstringNoThe company's UUID, as companies answers it.
AccountingDocument_SetOfBooksIDstringNoe.g. 3000. Choose one: a document exists per set of books.
AccountingDocument_FiscalYearIDstringNoe.g. 2026.
AccountingDocument_AccountingPeriodIDstringNoe.g. 10.
AccountingDocument_TypeCodestringNoA code of the AccountingDocumentAccountingDocument_TypeCode code list.
AccountingDocument_CancellationDocumentIndicatorbooleanNotrue for the documents that reverse another. Keep both: an original is never removed for its reversal.
AccountingDocument_OriginalEntryDocumentPartnerIDstringNoThe ID of the document it was posted from (a journal entry, an invoice…).
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

AccountingDocument_PostingDate
default

date

—

-

AccountingDocument_TypeCodeText
default

string

—

-

AccountingDocument_FiscalYearID
default

string

—

-

AccountingDocument_ID
default

string

—

-

AccountingDocument_CancellationDocumentIndicator
default

boolean

—

-

AccountingDocument_SetOfBooksID
default

string

—

-

AccountingDocument_AccountingPeriodID
default

string

—

-

Note
default

string

—

-

Bank Statements

The bank statements of the house bank accounts: date, account, opening and closing balance, debit and credit totals, currency, status. The closing balance of a day is the statement’s; successive statements are never added up.

Read

Bank Statements

The bank statements of the house bank accounts: date, account, opening and closing balance, debit and credit totals, currency, status. The closing balance of a day is the statement’s; successive statements are never added up.

Route: GET /bankStatements

Excel formula: =LF.sapbyd.bankStatements("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
HouseBankStatement_IDstringNo-
HouseBankStatement_BankAccountInternalIDstringNoAs houseBankAccounts names it.
HouseBankStatement_CurrencyCodestringNoA code of the HouseBankStatementHouseBankStatement_CurrencyCode code list.
HouseBankStatement_LifeCycleStatusCodestringNoA code of the HouseBankStatementHouseBankStatement_LifeCycleStatusCode code list.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

HouseBankStatement_Date
default

date

—

-

HouseBankStatement_ID
default

string

—

-

HouseBankStatement_ClosingBalanceAmount
default

number

—

-

HouseBankStatement_LifeCycleStatusCodeText
default

string

—

-

HouseBankStatement_OpeningBalanceAmount
default

number

—

-

HouseBankStatement_CurrencyCode
default

string

—

-

HouseBankStatement_BankAccountInternalID
default

string

—

-

Cancel Journal Entry

Reverses a posted voucher: SAP posts the reversal on the date given (PostingStatusCode 4 Canceled, a reversal document with the amounts inverted). Never a delete: the original and its reversal both stay.

Create

Cancel Journal Entry

Cancel Journal Entry

Route: POST /mutation/journalEntryCancel

Inputs you can set
NameTypeRequiredDescription
AccountingClosingStepCodestringYes-
ididYes-
NotestringYes-
Note_languageCodestringYes-
PostingDatestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Companies

The companies of the tenant, by ID and UUID: what a journal entry, a document or a payment is booked for. A company ID can differ from the ID of its intercompany business partner.

Read

Companies

The companies of the tenant, by ID and UUID: what a journal entry, a document or a payment is booked for. A company ID can differ from the ID of its intercompany business partner.

Route: GET /companies

Excel formula: =LF.sapbyd.companies("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
IDstringNoe.g. 1000.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

UUID
default

string

—

-

ID
default

string

—

-

ObjectID

string

—

-

Cost Centres

The cost centres, by ID and UUID: what an expense line is assigned to.

Read

Cost Centres

The cost centres, by ID and UUID: what an expense line is assigned to.

Route: GET /costCentres

Excel formula: =LF.sapbyd.costCentres("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
IDstringNoe.g. S1111.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

UUID
default

string

—

-

ObjectID

string

—

-

ID
default

string

—

-

Finance Code Lists

The valid values of the codes finance publishes — types, statuses, units, accounts — so a code is never guessed. A contextual list (a G/L account per chart of accounts) answers each code with its Context.

Read

Finance Code Lists

The valid values of the codes finance publishes — types, statuses, units, accounts — so a code is never guessed. A contextual list (a G/L account per chart of accounts) answers each code with its Context.

Route: GET /financeCodeLists

Excel formula: =LF.sapbyd.financeCodeLists("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
codeListenumYesWhich list to read. Values: AccountingDocumentAccountingDocument_TypeCode, AccountingDocumentItemChartOfAccountsCode, AccountingDocumentItemChartOfAccountsItemCode, AccountingDocumentItemDebitCreditCode, AccountingEntryAccountingClosingStepCode
Data returned in Excel
Field
Type
Relations
Description
Code
default

string

—

-

Description
default

string

—

-

Context
default

string

—

-

House Bank Accounts

The companies’ own bank accounts: bank account ID and IBAN, currency, house bank, blocked or not, and the minimum, maximum and overdraft thresholds — thresholds, never balances.

Read

House Bank Accounts

The companies’ own bank accounts: bank account ID and IBAN, currency, house bank, blocked or not, and the minimum, maximum and overdraft thresholds — thresholds, never balances.

Route: GET /houseBankAccounts

Excel formula: =LF.sapbyd.houseBankAccounts("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
HouseBankAccount_InternalIDstringNo-
HouseBankAccount_CurrencyCodestringNoA code of the HouseBankAccountHouseBankAccount_CurrencyCode code list.
HouseBankAccount_BlockedIndicatorbooleanNo-
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

HouseBankAccount_CompanyHouseBankID
default

string

—

-

HouseBankAccount_BankAccountID
default

string

—

-

HouseBankAccount_BlockedIndicator
default

boolean

—

-

HouseBankAccount_CurrencyCode
default

string

—

-

HouseBankAccount_InternalID
default

string

—

-

HouseBankAccount_BankAccountStandardID
default

string

—

-

Journal Entries

Journal entry vouchers (SAP AccountingEntry), newest first: what a user drafts and posts to the general ledger — company, posting date, currency, reference and three statuses (posting, life cycle, approval). Their lines are journalEntryLines; once posted, the ledger holds an accounting document of its own number (accou...

Read

Journal Entries

Journal entry vouchers (SAP AccountingEntry), newest first: what a user drafts and posts to the general ledger — company, posting date, currency, reference and three statuses (posting, life cycle, approval). Their lines are journalEntryLines; once posted, the ledger holds an accounting document of its own number (accou...

Route: GET /journalEntries

Excel formula: =LF.sapbyd.journalEntries("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
IDstringNoExactly this journal entry ID, e.g. 475.
CompanyUUIDstringNoThe company's UUID, as companies answers it.
PostingStatusCodestringNo1 Not Posted, 2 Voided, 3 Posted, 4 Canceled, 5 Not Relevant, 6 Posting not relevant
LifeCycleStatusCodestringNo1 In Preparation, 2 Void, 3 In Revision, 4 In Approval, 5 Posted, 6 Canceled
AccountingDocumentTypeCodestringNoA code of the AccountingEntryAccountingDocumentTypeCode code list.
ExternalIDstringNoText contained in the external reference (case-sensitive).
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

CompanyUUID
default

string

—

-

AccountingDocumentTypeCodeText
default

string

—

-

ExternalID
default

string

—

-

ID
default

string

—

-

PostingDate
default

date

—

-

TransactionCurrencyCode
default

string

—

-

ApprovalStatusCodeText
default

string

—

-

LifeCycleStatusCodeText
default

string

—

-

PostingStatusCode
default

string

—

-

PostingStatusCodeText
default

string

—

-

Create

Create Journal Entry

Create Journal Entry

Route: POST /mutation/journalEntries

Inputs you can set
NameTypeRequiredDescription
AccountingClosingStepCodestringNo-
AccountingDocumentTypeCodestringNo-
BusinessTransactionTypeCodestringNo-
companyIdstringNo-
CompanyUUIDstringNo-
CurrencyConversionDatestringNo-
EntryDatestringNo-
ExternalIDstringNo-
itemsstringYes-
languageCodestringNo-
NotestringNo-
PostingDatestringYes-
setsOfBooksstringYes-
TransactionCurrencyCodestringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Journal Entry Lines

The lines of the journal entry vouchers: G/L account, debit or credit, and the signed amounts in the transaction and the company currency. Two measures, never added together.

Read

Journal Entry Lines

The lines of the journal entry vouchers: G/L account, debit or credit, and the signed amounts in the transaction and the company currency. Two measures, never added together.

Route: GET /journalEntryLines

Excel formula: =LF.sapbyd.journalEntryLines("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ParentObjectIDstringNoThe lines of this voucher, by its ObjectID.
ChartOfAccountsCodestringNoe.g. ZFR1.
ChartOfAccountsItemCodestringNoe.g. 471000.
DebitCreditCodestringNo1 debit, 2 credit.
currencyCode3stringNoA code of the AccountingEntryItemcurrencyCode3 code list.
journalEntryIdstringNoThe lines of this voucher, by its ID (475) or its ObjectID.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

ParentObjectID
default

string

→ journalEntries

-

ChartOfAccountsItemCode
default

string

—

-

ChartOfAccountsItemCodeText
default

string

—

-

DebitCreditCodeText
default

string

—

-

ID
default

string

—

-

LocalCurrencyAmount
default

number

—

-

currencyCode
default

string

—

-

TransactionCurrencyAmount
default

number

—

-

currencyCode3
default

string

—

-

Payments

Incoming and outgoing payments of the companies: business partner, amounts in the transaction and the cash-location currency, value and due dates, payment form and transaction status. A payment confirmed is not yet allocated to an invoice.

Read

Payments

Incoming and outgoing payments of the companies: business partner, amounts in the transaction and the cash-location currency, value and due dates, payment form and transaction status. A payment confirmed is not yet allocated to an invoice.

Route: GET /payments

Excel formula: =LF.sapbyd.payments("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
Payment_DocumentIDstringNo-
Payment_CompanyIDstringNoe.g. 1000.
Payment_BusinessPartnerIDstringNoThe customer or supplier ID.
Payment_PaymentTransactionStatusCodestringNoA code of the PaymentPayment_PaymentTransactionStatusCode code list.
Payment_ExternalReferencestringNo-
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

Payment_TransactionCurrencyCode
default

string

—

-

Payment_BusinessPartnerName
default

string

—

-

Payment_ValueDate
default

date

—

-

Payment_CompanyID
default

string

—

-

Payment_DocumentID
default

string

—

-

Payment_BusinessPartnerID
default

string

—

-

Payment_TransactionCurrencyAmount
default

number

—

-

Payment_PaymentTransactionStatusCodeText
default

string

—

-

Post Journal Entry

Posts a submitted voucher to the general ledger: PostingStatusCode becomes 3 Posted and the ledger holds a new accounting document. A posted entry is corrected by Cancel Journal Entry, which posts its reversal. Answers the voucher read back.

Create

Post Journal Entry

Post Journal Entry

Route: POST /mutation/journalEntryPost

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Profit Centres

The profit centres, by ID and UUID: what a line of the ledger is reported on.

Read

Profit Centres

The profit centres, by ID and UUID: what a line of the ledger is reported on.

Route: GET /profitCentres

Excel formula: =LF.sapbyd.profitCentres("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
IDstringNo-
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

UUID
default

string

—

-

ObjectID

string

—

-

ID
default

string

—

-

Simulate Journal Entry

Checks a Not Posted voucher the way posting would — balance, accounts, assignments, open period — and posts nothing. SAP runs it with its cleanup in one changeset; a refusal carries SAP’s reason. Answers the voucher read back.

Create

Simulate Journal Entry

Simulate Journal Entry

Route: POST /mutation/journalEntrySimulate

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Submit Journal Entry

Submits a Not Posted voucher for posting — the step SAP requires before Post. It stays Not Posted. Answers the voucher read back.

Create

Submit Journal Entry

Submit Journal Entry

Route: POST /mutation/journalEntrySubmit

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Void Journal Entry

Discards a Not Posted voucher (life cycle 2 Void): nothing was posted, so nothing is reversed. Answers the voucher read back.

Create

Void Journal Entry

Void Journal Entry

Route: POST /mutation/journalEntryVoid

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Logistics

Acknowledge Delivery Note

Records the receipt of the supplier’s delivery note (2 Received). Moves no stock. Answers the delivery read back.

Create

Acknowledge Delivery Note

Acknowledge Delivery Note

Route: POST /mutation/inboundDeliveryAcknowledgeNote

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Approve Return

Approves a customer return In Approval. Answers it read back.

Create

Approve Return

Approve Return

Route: POST /mutation/customerReturnApprove

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Cancel Outbound Delivery

Cancels an outbound delivery. Its goods issue is reversed by SAP.

Create

Cancel Outbound Delivery

Cancel Outbound Delivery

Route: POST /mutation/outboundDeliveryCancel

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Customer Returns

Customer returns: customer, date, amount, and their statuses kept apart — life cycle, approval, inbound (goods received back) and credit memo. A return proves neither a refund nor a cancelled invoice; the quantity credited is not the quantity received.

Read

Customer Returns

Customer returns: customer, date, amount, and their statuses kept apart — life cycle, approval, inbound (goods received back) and credit memo. A return proves neither a refund nor a cancelled invoice; the quantity credited is not the quantity received.

Route: GET /customerReturns

Excel formula: =LF.sapbyd.customerReturns("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
CustomerReturn_IDstringNo-
CustomerReturn_NamestringNo-
CustomerReturn_BuyerParty_PartyIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
CustomerReturn_LifeCycleStatusCodestringNo1 Open, 2 In Process, 3 Completed
CustomerReturn_ApprovalStatusCodestringNo1 Not Started, 2 Approval not Necessary, 3 In Approval, 4 Approved, 5 Rejected, 6 In Revision, 7 Withdrawn
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

CustomerReturn_ID
default

string

—

-

CustomerReturn_CurrencyCode
default

string

—

-

CustomerReturn_LifeCycleStatusCodeText
default

string

—

-

CustomerReturn_GrossAmount
default

number

—

-

CustomerReturn_Name
default

string

—

-

CustomerReturn_DateTime
default

date

—

-

CustomerReturn_BuyerParty_PartyID
default

string

—

-

Inbound Deliveries

Inbound deliveries: what a supplier announced or delivered, with its processing, release, delivery-note and cancellation statuses kept apart. Stock moves when its goods receipt is posted, not before.

Read

Inbound Deliveries

Inbound deliveries: what a supplier announced or delivered, with its processing, release, delivery-note and cancellation statuses kept apart. Stock moves when its goods receipt is posted, not before.

Route: GET /inboundDeliveries

Excel formula: =LF.sapbyd.inboundDeliveries("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
InboundDelivery_IDstringNo-
InboundDelivery_SenderParty_PartyIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
InboundDelivery_DeliveryProcessingStatusCodestringNo1 Not Started, 2 In Process, 3 Finished, 4 Not Relevant, 5 Interrupted
InboundDelivery_ReleaseStatusCodestringNo1 Not Released, 2 Partially Released, 3 Released, 4 Release Discarded, 5 Release Canceled, 6 Not Relevant, 7 Release Cancellation Requested,...
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

InboundDelivery_DeliveryProcessingStatusCodeText
default

string

—

-

InboundDelivery_CreationDateTime
default

date

—

-

InboundDelivery_ID
default

string

—

-

InboundDelivery_ReleaseStatusCodeText
default

string

—

-

InboundDelivery_ProcessingTypeCodeText
default

string

—

-

InboundDelivery_SenderParty_PartyID
default

string

—

-

Inbound Delivery Requests

What is expected to arrive, from a purchase order: its source document. A request announces nothing to the warehouse and moves no stock.

Read

Inbound Delivery Requests

What is expected to arrive, from a purchase order: its source document. A request announces nothing to the warehouse and moves no stock.

Route: GET /inboundDeliveryRequests

Excel formula: =LF.sapbyd.inboundDeliveryRequests("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
InboundDeliveryRequest_BaseBusinessTransactionDocumentIDstringNoThe purchase order ID.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

InboundDeliveryRequest_BaseBusinessTransactionDocumentID
default

string

—

-

UUID

string

—

-

InboundDeliveryRequest_BaseBusinessDocumentTypeCode

string

—

-

InboundDeliveryRequest_BaseBusinessDocumentTypeCodeText
default

string

—

-

ObjectID

string

—

-

Logistics Code Lists

The valid values of the codes logistics publishes — types, statuses, units, accounts — so a code is never guessed. A contextual list (a G/L account per chart of accounts) answers each code with its Context.

Read

Logistics Code Lists

The valid values of the codes logistics publishes — types, statuses, units, accounts — so a code is never guessed. A contextual list (a G/L account per chart of accounts) answers each code with its Context.

Route: GET /logisticsCodeLists

Excel formula: =LF.sapbyd.logisticsCodeLists("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
codeListenumYesWhich list to read. Values: CustomerReturnCustomerReturn_ApprovalStatusCode, CustomerReturnCustomerReturn_LifeCycleStatusCode, GoodsAndActivityConfirmation_InventoryChangeItemGoodsAndActivityConfirmation_InventoryMovementDirectionCode, InboundDeliveryInboundDelivery_DeliveryProcessingStatusCode, InboundDeliveryInboundDelivery_ReleaseStatusCode
Data returned in Excel
Field
Type
Relations
Description
Description
default

string

—

-

Code
default

string

—

-

Materials

The materials (stocked products): ID, description, base unit of measure, product category. A service product is another object; the sales, logistics and valuation views of a material are each their own.

Read

Materials

The materials (stocked products): ID, description, base unit of measure, product category. A service product is another object; the sales, logistics and valuation views of a material are each their own.

Route: GET /materials

Excel formula: =LF.sapbyd.materials("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
Material_InternalIDstringNo-
Material_DescriptionstringNoText contained in the description (case-sensitive).
Material_ProductCategory_ProductCategoryInternalIDstringNo-
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

UUID

string

—

-

Material_DescriptionLanguageCode

string

—

-

Material_DescriptionLanguageCodeText

string

—

-

Material_SerialNumberProfileCode

string

—

-

Material_SerialNumberProfileCodeText

string

—

-

Material_IdentifiedStockTypeCode

string

—

-

Material_IdentifiedStockTypeCodeText

string

—

-

ObjectID

string

—

-

Material_LastChangeDateTime

date

—

-

Material_BaseMeasureUnitCode
default

string

—

-

Material_BaseMeasureUnitCodeText

string

—

-

Material_Description
default

string

—

-

Material_PlanningMeasureUnitCode

string

—

-

Material_PlanningMeasureUnitCodeText

string

—

-

Material_ValuationLevelTypeCode

string

—

-

Material_ValuationLevelTypeCodeText

string

—

-

Material_CreationDateTime

date

—

-

Material_InternalID
default

string

—

-

Material_ProductCategory_ProductCategoryInternalID
default

string

—

-

Outbound Deliveries

Outbound deliveries: what is shipped to a customer, with its processing, release and cancellation statuses kept apart. Stock leaves when the goods issue is posted (outboundDeliveryRequestItems), not when a delivery is created.

Read

Outbound Deliveries

Outbound deliveries: what is shipped to a customer, with its processing, release and cancellation statuses kept apart. Stock leaves when the goods issue is posted (outboundDeliveryRequestItems), not when a delivery is created.

Route: GET /outboundDeliveries

Excel formula: =LF.sapbyd.outboundDeliveries("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
OutboundDelivery_IDstringNo-
OutboundDelivery_ProductRecipientParty_PartyIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
OutboundDelivery_DeliveryProcessingStatusCodestringNo1 Not Started, 2 In Process, 3 Finished, 4 Not Relevant, 5 Interrupted
OutboundDelivery_ReleaseStatusCodestringNo1 Not Released, 2 Partially Released, 3 Released, 4 Release Discarded, 5 Release Canceled, 6 Not Relevant, 7 Release Cancellation Requested,...
OutboundDelivery_CancellationStatusCodestringNo1 Not Canceled, 2 Cancellation Requested, 3 Cancellation Discarded, 4 Canceled, 5 Partially Canceled, 6 Partial Cancellation Requested
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

OutboundDelivery_DeliveryProcessingStatusCodeText
default

string

—

-

OutboundDelivery_ReleaseStatusCodeText
default

string

—

-

OutboundDelivery_TypeCodeText
default

string

—

-

OutboundDelivery_CreationDateTime
default

date

—

-

OutboundDelivery_ID
default

string

—

-

OutboundDelivery_ProductRecipientParty_PartyID
default

string

—

-

Outbound Delivery Request Items

The lines of the outbound delivery requests: product, source line, fulfilment and cancellation status — and the goods issue that ships them without warehouse tasks.

Read

Outbound Delivery Request Items

The lines of the outbound delivery requests: product, source line, fulfilment and cancellation status — and the goods issue that ships them without warehouse tasks.

Route: GET /outboundDeliveryRequestItems

Excel formula: =LF.sapbyd.outboundDeliveryRequestItems("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ParentObjectIDstringNo-
OutboundDeliveryRequest_Item_ProductIDstringNo-
OutboundDeliveryRequest_OrderFulfilmentProcessingStatusCodestringNo1 Not Started, 2 In Process, 3 Finished, 4 Not Relevant, 5 Interrupted
salesOrderIdstringNoThe lines of the request of this sales order, by its ID.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

OutboundDeliveryRequest_OrderFulfilmentProcessingStatusCode

string

—

-

OutboundDeliveryRequest_OrderFulfilmentProcessingStatusCodeText
default

string

—

-

OutboundDeliveryRequest_Item_ProductID
default

string

—

-

OutboundDeliveryRequest_Item_SupplyPlanningAreaID

string

—

-

OutboundDeliveryRequest_Item_DeliveryBlockingStatusCode

string

—

-

OutboundDeliveryRequest_Item_DeliveryBlockingStatusCodeText

string

—

-

OutboundDeliveryRequest_Item_IdentifiedStockTypeCode

string

—

-

OutboundDeliveryRequest_Item_IdentifiedStockTypeCodeText

string

—

-

OutboundDeliveryRequest_Item_IncotermsClassificationCode

string

—

-

OutboundDeliveryRequest_Item_IncotermsClassificationCodeText

string

—

-

OutboundDeliveryRequest_Item_ConsistencyStatusCode

string

—

-

OutboundDeliveryRequest_Item_ConsistencyStatusCodeText

string

—

-

OutboundDeliveryRequest_Item_IncotermsLocationName

string

—

-

OutboundDeliveryRequest_BaseBusinessDocumentItemID
default

string

—

-

OutboundDeliveryRequest_Item_DeliveryItemGroupID

string

—

-

OutboundDeliveryRequest_Item_PickupIndicator

boolean

—

-

OutboundDeliveryRequest_Item_DeliveryPriorityCode

string

—

-

OutboundDeliveryRequest_Item_DeliveryPriorityCodeText

string

—

-

OutboundDeliveryRequest_Item_IdentifiedStockID

string

—

-

ObjectID

string

—

-

OutboundDeliveryRequest_Item_PartialDeliveryControlCode

string

—

-

OutboundDeliveryRequest_Item_PartialDeliveryControlCodeText

string

—

-

OutboundDeliveryRequest_CompleteDeliveryRequestedIndicator

boolean

—

-

OutboundDeliveryRequest_Item_CancellationStatusCode

string

—

-

OutboundDeliveryRequest_Item_CancellationStatusCodeText

string

—

-

ParentObjectID
default

string

→ outboundDeliveryRequests

-

can_post_issue

boolean

—

-

Outbound Delivery Requests

What is to be shipped, from a sales order: its source document. A request moves no stock; its lines are outboundDeliveryRequestItems.

Read

Outbound Delivery Requests

What is to be shipped, from a sales order: its source document. A request moves no stock; its lines are outboundDeliveryRequestItems.

Route: GET /outboundDeliveryRequests

Excel formula: =LF.sapbyd.outboundDeliveryRequests("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
OutboundDeliveryRequest_BaseBusinessTransactionDocumentIDstringNoThe sales order ID.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

OutboundDeliveryRequest_CreationDateTime
default

date

—

-

ObjectID

string

—

-

OutboundDeliveryRequest_BaseBusinessTransactionDocumentID
default

string

—

-

OutboundDeliveryRequest_BaseBusinessDocumentTypeCode

string

—

-

OutboundDeliveryRequest_BaseBusinessDocumentTypeCodeText
default

string

—

-

Post Goods Issue

Posts the goods issue of a request line without warehouse tasks: SAP creates the outbound delivery and the stock leaves. Release the delivery next (outboundDeliveryRelease).

Create

Post Goods Issue

Post Goods Issue

Route: POST /mutation/outboundDeliveryRequestItemPostIssue

Inputs you can set
NameTypeRequiredDescription
AllowSplitIndicatorbooleanNo-
AutoReleaseOutboundDeliverybooleanNo-
ididYes-
SplitByDeliveryPriorityCodeIndicatorbooleanNo-
SplitByOrderIndicatorbooleanNo-
SplitByShippingOrPickupDateTimeIndicatorbooleanNo-
TaskBasedIndicatorbooleanNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Post Goods Receipt

Posts the goods receipt of an inbound delivery: the stock is increased.

Create

Post Goods Receipt

Post Goods Receipt

Route: POST /mutation/inboundDeliveryPostReceipt

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Release Inbound Delivery

Releases an inbound delivery — with warehouse tasks when TaskBasedIndicator is true. Answers it read back.

Create

Release Inbound Delivery

Release Inbound Delivery

Route: POST /mutation/inboundDeliveryRelease

Inputs you can set
NameTypeRequiredDescription
ididYes-
TaskBasedIndicatorbooleanNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Release Outbound Delivery

Releases an outbound delivery once its goods issue is posted: the customer can be invoiced. Answers it read back.

Create

Release Outbound Delivery

Release Outbound Delivery

Route: POST /mutation/outboundDeliveryRelease

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Request Return Follow-Up

Requests the follow-up of every line — credit memo, replacement or repair, as each line says. Answers the return read back.

Create

Request Return Follow-Up

Request Return Follow-Up

Route: POST /mutation/customerReturnRequestFollowUp

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Revoke Delivery Cancellation

Revokes the cancellation of an outbound delivery.

Create

Revoke Delivery Cancellation

Revoke Delivery Cancellation

Route: POST /mutation/outboundDeliveryRevokeCancellation

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Set Delivery as Advised

Sets the delivery back to advised (1 Advised). Answers it read back.

Create

Set Delivery as Advised

Set Delivery as Advised

Route: POST /mutation/inboundDeliverySetAdvised

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Sites and Locations

The sites and locations of the tenant: ID, name, whether it is a site, a ship-from or ship-to location, whether it manages inventory, its status and time zone. A site is not a company.

Read

Sites and Locations

The sites and locations of the tenant: ID, name, whether it is a site, a ship-from or ship-to location, whether it manages inventory, its status and time zone. A site is not a company.

Route: GET /locations

Excel formula: =LF.sapbyd.locations("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
Location_IDstringNo-
Location_NamestringNo-
Location_SiteIndicatorbooleanNo-
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

Location_LifeCycleStatusCodeText
default

string

—

-

Location_ID
default

string

—

-

Location_SiteIndicator
default

boolean

—

-

Location_Name
default

string

—

-

Location_InventoryManagedLocationIndicator
default

boolean

—

-

Stock Movement Lines

The lines of the stock movements: direction (1 Inventory issue, 2 Inventory receipt), reason, stock type, location, transfer group. A transfer is an issue and a receipt sharing a transfer group — not two consumptions.

Read

Stock Movement Lines

The lines of the stock movements: direction (1 Inventory issue, 2 Inventory receipt), reason, stock type, location, transfer group. A transfer is an issue and a receipt sharing a transfer group — not two consumptions.

Route: GET /stockMovementLines

Excel formula: =LF.sapbyd.stockMovementLines("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ParentObjectIDstringNo-
GoodsAndActivityConfirmation_InventoryMovementDirectionCodestringNo1 Inventory issue, 2 Inventory receipt
GoodsAndActivityConfirmation_TransferGroupIDstringNo-
Location_Location_IDstringNo-
stockMovementIdstringNoThe lines of this confirmation, by its ID or its ObjectID.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

GoodsAndActivityConfirmation_InventoryChangeReasonCodeText
default

string

—

-

GoodsAndActivityConfirmation_TransferGroupID
default

string

—

-

GoodsAndActivityConfirmation_StockTypeCodeText
default

string

—

-

GoodsAndActivityConfirmation_InventoryMovementDirectionCodeText
default

string

—

-

GoodsAndActivityConfirmation_InventoryChangeItem_ID
default

string

—

-

ParentObjectID
default

string

→ stockMovements

-

Location_Location_ID
default

string

—

-

Stock Movements

Goods and activity confirmations: the documents that record a stock change — transaction date, the document it confirms, whether it reverses another. Their lines (stockMovementLines) say the direction; the service lists movements, not stock balances.

Read

Stock Movements

Goods and activity confirmations: the documents that record a stock change — transaction date, the document it confirms, whether it reverses another. Their lines (stockMovementLines) say the direction; the service lists movements, not stock balances.

Route: GET /stockMovements

Excel formula: =LF.sapbyd.stockMovements("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
GoodsAndActivityConfirmation_IDstringNo-
GoodsAndActivityConfirmation_DocumentReferenceIDstringNoThe delivery or order it confirms.
GoodsAndActivityConfirmation_CancellationDocumentIndicatorbooleanNotrue for a confirmation that reverses another: its lines keep the original direction — never invert them twice.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

GoodsAndActivityConfirmation_DocumentReferenceTypeCodeText
default

string

—

-

GoodsAndActivityConfirmation_ID
default

string

—

-

GoodsAndActivityConfirmation_CancellationDocumentIndicator
default

boolean

—

-

GoodsAndActivityConfirmation_TransactionDateTime
default

date

—

-

GoodsAndActivityConfirmation_DocumentReferenceID
default

string

—

-

Submit Return for Approval

Submits a customer return for approval. Answers it read back.

Create

Submit Return for Approval

Submit Return for Approval

Route: POST /mutation/customerReturnSubmit

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Production

Fix Planning Order

Fixes a proposal: planning no longer moves it. Not a release. Answers it read back.

Create

Fix Planning Order

Fix Planning Order

Route: POST /mutation/productionPlanningOrderFix

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Production Code Lists

The valid values of the codes production publishes — types, statuses, units, accounts — so a code is never guessed. A contextual list (a G/L account per chart of accounts) answers each code with its Context.

Read

Production Code Lists

The valid values of the codes production publishes — types, statuses, units, accounts — so a code is never guessed. A contextual list (a G/L account per chart of accounts) answers each code with its Context.

Route: GET /productionCodeLists

Excel formula: =LF.sapbyd.productionCodeLists("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
codeListenumYesWhich list to read. Values: ProductionOrderProductionOrder_LifeCycleStatusCode, ProductionPlanningOrderProductionPlanningOrder_LifeCycleStatusCode, ProductionRequisitionProductionRequisition_LifeCycleStatusCode
Data returned in Excel
Field
Type
Relations
Description
Code
default

string

—

-

Description
default

string

—

-

Production Orders

Production orders, newest first: site, main product with its planned, fulfilled and open quantities, lot, requested dates, priority and status. Planned, fulfilled and open quantities are three measures, each in its own unit: never add them.

Read

Production Orders

Production orders, newest first: site, main product with its planned, fulfilled and open quantities, lot, requested dates, priority and status. Planned, fulfilled and open quantities are three measures, each in its own unit: never add them.

Route: GET /productionOrders

Excel formula: =LF.sapbyd.productionOrders("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ProductionOrder_IDstringNo-
ProductionOrder_SiteIDstringNo-
ProductionOrder_MainProductOutput_ProductIDstringNo-
ProductionOrder_LifeCycleStatusCodestringNo1 In Preparation, 2 Released, 3 Started, 4 Finished, 5 Closed, 6 Canceled
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

ProductionOrder_RequestedStartDateTime
default

date

—

-

ProductionOrder_LifeCycleStatusCodeText
default

string

—

-

ProductionOrder_ID
default

string

—

-

ProductionOrder_SiteID
default

string

—

-

ProductionOrder_MainProductOutput_ProductID
default

string

—

-

ProductionOrder_MainProductOutput_PlannedQuantity
default

number

—

-

ProductionOrder_MainProductOutput_PlannedQuantityUnitCode
default

string

—

-

ProductionOrder_MainProductOutput_FulfilledQuantity
default

number

—

-

ProductionOrder_MainProductOutput_OpenQuantity
default

number

—

-

ProductionLot_ID
default

string

—

-

Production Planning Orders

Production proposals from planning: dates, whether planning may still move them (fixed or not), supply status and status. Releasing one requests production — a requisition, then an order.

Read

Production Planning Orders

Production proposals from planning: dates, whether planning may still move them (fixed or not), supply status and status. Releasing one requests production — a requisition, then an order.

Route: GET /productionPlanningOrders

Excel formula: =LF.sapbyd.productionPlanningOrders("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ProductionPlanningOrder_IDstringNo-
ProductionPlanningOrder_FixedIndicatorbooleanNotrue when planning may no longer move it.
ProductionPlanningOrder_LifeCycleStatusCodestringNo1 Planned, 2 Execution Requested
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

ProductionPlanningOrder_FixedIndicator
default

boolean

—

-

ProductionPlanningOrder_EndDateTime
default

date

—

-

ProductionPlanningOrder_LifeCycleStatusCodeText
default

string

—

-

ProductionPlanningOrder_StartDateTime
default

date

—

-

ProductionPlanningOrder_ID
default

string

—

-

ProductionRequisition_ID
default

string

—

-

Production Requisitions

Production requisitions — what a released proposal asks the shop floor to make — and how far it went: requested, order creation started, started, finished, closed.

Read

Production Requisitions

Production requisitions — what a released proposal asks the shop floor to make — and how far it went: requested, order creation started, started, finished, closed.

Route: GET /productionRequisitions

Excel formula: =LF.sapbyd.productionRequisitions("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ProductionRequisition_IDstringNo-
ProductionRequisition_LifeCycleStatusCodestringNo1 Production Requested, 2 Production Order Creation Started, 3 Production Finished, 4 Closed, 5 Production Started
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

ObjectID

string

—

-

ProductionRequisition_LifeCycleStatusCode

string

—

-

ProductionRequisition_LifeCycleStatusCodeText
default

string

—

-

ProductionRequisition_ID
default

string

—

-

Release Planning Order

Releases a proposal to production: SAP creates its production requisition (2 Execution Requested). Answers it read back.

Create

Release Planning Order

Release Planning Order

Route: POST /mutation/productionPlanningOrderRelease

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Release Production Order

Releases a production order In Preparation for execution (2 Released): its tasks can start. Check materials, resources and dates first. Answers the order read back.

Create

Release Production Order

Release Production Order

Route: POST /mutation/productionOrderRelease

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Unfix Planning Order

Lets planning move a fixed proposal again. Answers it read back.

Create

Unfix Planning Order

Unfix Planning Order

Route: POST /mutation/productionPlanningOrderUnfix

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Projects

Approve Time

Approves time In Approval. Answers the time sheet read back.

Create

Approve Time

Approve Time

Route: POST /mutation/employeeTimeApprove

Inputs you can set
NameTypeRequiredDescription
ApprovalDatestringNo-
ApproverEmployeeUUIDstringNo-
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Close Task

Closes a completed task (4 Closed): no more time or costs on it. Answers the task read back.

Create

Close Task

Close Task

Route: POST /mutation/taskClose

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Create Project Baseline

Saves the current plan of the project as its baseline, to compare progress against. Answers the project read back.

Create

Create Project Baseline

Create Project Baseline

Route: POST /mutation/projectCreateBaseline

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Discard Time Changes

Discards the pending changes of a time sheet. Answers it read back.

Create

Discard Time Changes

Discard Time Changes

Route: POST /mutation/employeeTimeDiscard

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Employee Time Items

The lines of the time sheets: date, start and end, duration (ISO 8601 duration as SAP spells it: P4D (four days), PT4H (four hours). Not a number of hours.) and billable duration when it differs, project and task, service product, type and approval status.

Read

Employee Time Items

The lines of the time sheets: date, start and end, duration (ISO 8601 duration as SAP spells it: P4D (four days), PT4H (four hours). Not a number of hours.) and billable duration when it differs, project and task, service product, type and approval status.

Route: GET /employeeTimeItems

Excel formula: =LF.sapbyd.employeeTimeItems("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ParentObjectIDstringNo-
EmployeeTime_Item_ProjectIDstringNoThe project business id, e.g. CP2.
EmployeeTime_Item_ProjectElementIDstringNoThe task business id, e.g. CP2-1.
EmployeeTime_Item_ApprovalStatusCodestringNo1 Not Started, 2 Approval not Necessary, 3 In Approval, 4 Approved, 5 Rejected, 6 In Revision, 7 Withdrawn
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

EmployeeTime_Item_ProjectElementID
default

string

—

-

EmployeeTime_Item_Duration
default

string

—

-

ParentObjectID
default

string

→ employeeTimes

-

EmployeeTime_Item_ApprovalStatusCodeText
default

string

—

-

EmployeeTime_Item_StartDate
default

date

—

-

EmployeeTime_Item_ProjectID
default

string

—

-

EmployeeTime_Item_ServiceProductID
default

string

—

-

Employee Times

Time sheets: the employee, the approval status and the life cycle of what they recorded. Dates, durations, projects and tasks are on their lines (employeeTimeItems).

Read

Employee Times

Time sheets: the employee, the approval status and the life cycle of what they recorded. Dates, durations, projects and tasks are on their lines (employeeTimeItems).

Route: GET /employeeTimes

Excel formula: =LF.sapbyd.employeeTimes("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
EmployeeTime_EmployeeIDstringNoEmployee ID, e.g. E0202 — employees lists them.
EmployeeTime_ApprovalStatusCodestringNo1 Not Started, 2 Approval not Necessary, 3 In Approval, 4 Approved, 5 Rejected, 6 In Revision, 7 Withdrawn
EmployeeTime_LifeCycleStatusCodestringNo1 Inactive, 2 Active, 3 Pending Changes, 4 Pending Cancellation, 5 Canceled
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

EmployeeTime_ApprovalStatusCode

string

—

-

EmployeeTime_ApprovalStatusCodeText
default

string

—

-

EmployeeTime_PlanningCategoryCode

string

—

-

EmployeeTime_PlanningCategoryCodeText

string

—

-

ObjectID

string

—

-

EmployeeTime_CreationDateTime

date

—

-

EmployeeTime_EmployeeFormattedName
default

string

—

-

EmployeeTime_EmployeeID
default

string

—

-

EmployeeTime_EmployeeTimeAgreementItemUUID

string

—

-

EmployeeTime_LifeCycleStatusCode

string

—

-

EmployeeTime_LifeCycleStatusCodeText
default

string

—

-

EmployeeTime_LastChangeDateTime

date

—

-

EmployeeTime_EmployeeUUID

string

—

-

can_submit

boolean

—

-

can_approve

boolean

—

-

can_reject

boolean

—

-

can_discard

boolean

—

-

Employees

The employees of the tenant: ID and name — the people a project, a task or a time sheet names.

Read

Employees

The employees of the tenant: ID and name — the people a project, a task or a time sheet names.

Route: GET /employees

Excel formula: =LF.sapbyd.employees("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
Employee_EmployeeIDstringNo-
Employee_FormattedNamestringNo-
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

Employee_NickName

string

—

-

Employee_GenderCode

string

—

-

Employee_GenderCodeText

string

—

-

Employee_AcademicTitleCode

string

—

-

Employee_AcademicTitleCodeText

string

—

-

Employee_FormOfAddressCode

string

—

-

Employee_FormOfAddressCodeText

string

—

-

Employee_MaritalStatusCode

string

—

-

Employee_MaritalStatusCodeText

string

—

-

Employee_FamilyName
default

string

—

-

Employee_BirthDate

date

—

-

Employee_MiddleName

string

—

-

Employee_BirthPlaceName

string

—

-

Employee_NationalityCountryCode

string

—

-

Employee_NationalityCountryCodeText

string

—

-

ObjectID

string

—

-

Employee_EmployeeID
default

string

—

-

Employee_GivenName
default

string

—

-

Employee_BirthName

string

—

-

Employee_InternalID

string

—

-

Employee_FormattedName
default

string

—

-

Employee_LastChangeDateTime

date

—

-

UUID

string

—

-

Employee_CreationDateTime

date

—

-

Finish Task

Marks a released or started task completed (6 Completed). Answers the task read back.

Create

Finish Task

Finish Task

Route: POST /mutation/taskFinish

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Project Tasks

The tasks of the projects — the summary task included — with their parent, responsible employee, planned duration, constraints and status. A tree by ParentTaskID; RightNeighbourTaskID orders siblings and is no dependency.

Read

Project Tasks

The tasks of the projects — the summary task included — with their parent, responsible employee, planned duration, constraints and status. A tree by ParentTaskID; RightNeighbourTaskID orders siblings and is no dependency.

Route: GET /projectTasks

Excel formula: =LF.sapbyd.projectTasks("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
Project_Task_TaskIDstringNoExactly this business id, e.g. CP2-1.
Project_Task_TaskNamestringNo-
Project_Task_LifeCycleStatusCodestringNo1 In Planning, 2 Released, 3 Stopped, 4 Closed, 5 Started, 6 Completed
Project_Task_ResponsibleEmployeeIDstringNoEmployee ID, e.g. E0202 — employees lists them.
Project_Task_ParentTaskIDstringNo-
Project_Task_MilestoneIndicatorbooleanNo-
projectIdstringNoThe project’s business id (CP2) or ObjectID: only its tasks.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

Project_Task_TaskID
default

string

—

-

Project_Task_TaskName
default

string

—

-

Project_Task_PlannedDuration
default

string

—

-

Project_Task_LifeCycleStatusCodeText
default

string

—

-

Project_Task_ParentTaskID
default

string

—

-

Project_Task_ResponsibleEmployeeID
default

string

—

-

Create

Create Project Task

Create Project Task

Route: POST /mutation/projectTasks

Inputs you can set
NameTypeRequiredDescription
Project_Task_ConstraintEndDateTimestringNo-
Project_Task_ConstraintStartDateTimestringNo-
Project_Task_MilestoneIndicatorbooleanNo-
Project_Task_ParentTaskIDstringNo-
Project_Task_PhaseIndicatorbooleanNo-
Project_Task_PlannedDurationstringNo-
Project_Task_ResponsibleEmployeeIDstringNo-
Project_Task_ScheduleActivityEndDateTimeConstraintTypeCodestringNo-
Project_Task_ScheduleActivityStartDateTimeConstraintTypeCodestringNo-
Project_Task_TaskIDstringNo-
Project_Task_TaskNamestringYes-
Project_Task_WorkingDayCalendarCodestringNo-
projectIdstringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Project Task

Update Project Task

Route: PATCH /mutation/projectTasks

Inputs you can set
NameTypeRequiredDescription
Project_Task_ConstraintEndDateTimestringNo-
Project_Task_ConstraintStartDateTimestringNo-
Project_Task_MilestoneIndicatorbooleanNo-
Project_Task_ParentTaskIDstringNo-
Project_Task_PhaseIndicatorbooleanNo-
Project_Task_PlannedDurationstringNo-
Project_Task_ResponsibleEmployeeIDstringNo-
Project_Task_ScheduleActivityEndDateTimeConstraintTypeCodestringNo-
Project_Task_ScheduleActivityStartDateTimeConstraintTypeCodestringNo-
Project_Task_TaskIDstringNo-
Project_Task_TaskNamestringYes-
Project_Task_WorkingDayCalendarCodestringNo-
projectIdstringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Projects

Projects, newest first: ID, name, manager, type, responsible cost centre, planned dates, completion and status. Started makes a project chargeable without releasing its tasks; Released releases them; Closed and Stopped block time and costs.

Read

Projects

Projects, newest first: ID, name, manager, type, responsible cost centre, planned dates, completion and status. Started makes a project chargeable without releasing its tasks; Released releases them; Closed and Stopped block time and costs.

Route: GET /projects

Excel formula: =LF.sapbyd.projects("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
Project_ProjectIDstringNoExactly this business id, e.g. CP2.
Project_SummaryTask_ProjectNamestringNoText contained in the project name (case-sensitive).
Project_ProjectLifeCycleStatusCodestringNo1 In Planning, 2 Started, 3 Released, 4 Stopped, 5 Closed, 6 Completed
Project_SummaryTask_ResponsibleEmployeeIDstringNoEmployee ID, e.g. E0202 — employees lists them.
Project_ProjectTypeCodestringNoA code of the ProjectProject_ProjectTypeCode code list.
Project_ResponsibleCostCentreIDstringNo-
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

Project_ProjectID
default

string

—

-

Project_EstimatedCompletionPercent
default

number

—

-

Project_ProjectLifeCycleStatusCodeText
default

string

—

-

Project_ProjectTypeCodeText
default

string

—

-

Project_PlannedStartDateTime
default

date

—

-

Project_ResponsibleCostCentreID
default

string

—

-

Project_PlannedEndDateTime
default

date

—

-

Project_SummaryTask_ProjectName
default

string

—

-

Project_SummaryTask_ResponsibleEmployeeFormattedName
default

string

—

-

Create

Create Project

Create Project

Route: POST /mutation/projects

Inputs you can set
NameTypeRequiredDescription
Project_EstimatedCompletionPercentnumberNo-
Project_PlannedEndDateTimestringNo-
Project_PlannedStartDateTimestringNo-
Project_ProjectIDstringNo-
Project_ProjectLanguageCodestringNo-
Project_ProjectTypeCodestringNo-
Project_RequestingCostCentreIDstringNo-
Project_ResponsibleCostCentreIDstringYes-
Project_SummaryTask_PriorityCodestringNo-
Project_SummaryTask_ProjectNamestringYes-
Project_SummaryTask_ResponsibleEmployeeIDstringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Update Project

Update Project

Route: PATCH /mutation/projects

Inputs you can set
NameTypeRequiredDescription
Project_EstimatedCompletionPercentnumberNo-
Project_PlannedEndDateTimestringNo-
Project_PlannedStartDateTimestringNo-
Project_ProjectIDstringNo-
Project_ProjectLanguageCodestringNo-
Project_ProjectTypeCodestringNo-
Project_RequestingCostCentreIDstringNo-
Project_ResponsibleCostCentreIDstringYes-
Project_SummaryTask_PriorityCodestringNo-
Project_SummaryTask_ProjectNamestringYes-
Project_SummaryTask_ResponsibleEmployeeIDstringYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Projects Code Lists

The valid values of the codes projects publishes — types, statuses, units, accounts — so a code is never guessed. A contextual list (a G/L account per chart of accounts) answers each code with its Context.

Read

Projects Code Lists

The valid values of the codes projects publishes — types, statuses, units, accounts — so a code is never guessed. A contextual list (a G/L account per chart of accounts) answers each code with its Context.

Route: GET /projectCodeLists

Excel formula: =LF.sapbyd.projectCodeLists("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
codeListenumYesWhich list to read. Values: EmployeeTimeEmployeeTime_ApprovalStatusCode, EmployeeTimeEmployeeTime_LifeCycleStatusCode, EmployeeTime_ItemEmployeeTime_Item_ApprovalStatusCode, ProjectProject_LifeCycleStatusCode, ProjectProject_ProjectLanguageCode
Data returned in Excel
Field
Type
Relations
Description
Description
default

string

—

-

Code
default

string

—

-

Reject Time

Rejects time In Approval. Answers the time sheet read back.

Create

Reject Time

Reject Time

Route: POST /mutation/employeeTimeReject

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Schedule Project

Has SAP compute the project’s dates from its tasks’ durations, constraints, dependencies and calendar. Answers the project read back.

Create

Schedule Project

Schedule Project

Route: POST /mutation/projectSchedule

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Start and Release Project

Starts a project and releases it with its tasks (3 Released). Answers the project read back.

Create

Start and Release Project

Start and Release Project

Route: POST /mutation/projectStartAndRelease

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Start Project

Starts a project In Planning (2 Started): time and costs can be recorded on it, its tasks are not released yet. Answers the project read back.

Create

Start Project

Start Project

Route: POST /mutation/projectStart

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Submit Time for Approval

Submits recorded time for approval. Answers the time sheet read back.

Create

Submit Time for Approval

Submit Time for Approval

Route: POST /mutation/employeeTimeSubmit

Inputs you can set
NameTypeRequiredDescription
ApproverExplicitlySpecifiedIndicatorbooleanNo-
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Purchasing

Accept Invoice Exception

Accepts a discrepancy SAP raised on a supplier invoice, so the invoice can proceed.

Create

Accept Invoice Exception

Accept Invoice Exception

Route: POST /mutation/supplierInvoiceExceptionAccept

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Activate Supplier

Activates a supplier In Preparation (2 Active). Answers the supplier read back.

Create

Activate Supplier

Activate Supplier

Route: POST /mutation/supplierActivate

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Approve Purchase Order

Approves a purchase order In Approval. Answers the order read back.

Create

Approve Purchase Order

Approve Purchase Order

Route: POST /mutation/purchaseOrderApprove

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Block Supplier

Blocks an active supplier (3 Blocked). Answers the supplier read back.

Create

Block Supplier

Block Supplier

Route: POST /mutation/supplierBlock

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Calculate Invoice Gross Amount

Has SAP calculate the gross amount of an invoice being entered. Answers the invoice read back.

Create

Calculate Invoice Gross Amount

Calculate Invoice Gross Amount

Route: POST /mutation/supplierInvoiceCalculateGross

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Calculate Invoice Tax

Has SAP calculate the tax amount of an invoice being entered, from its lines and tax codes. Answers the invoice read back.

Create

Calculate Invoice Tax

Calculate Invoice Tax

Route: POST /mutation/supplierInvoiceCalculateTax

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Cancel Purchase Order

Cancels a purchase order not yet finished. Cancelling its receipt later does not cancel an invoice of it.

Create

Cancel Purchase Order

Cancel Purchase Order

Route: POST /mutation/purchaseOrderCancel

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Confirm Purchase Order

Records the supplier’s confirmation of a sent purchase order (acknowledgement received). It is not a receipt: the goods or services are acknowledged in a goods receipt. Answers the order read back.

Create

Confirm Purchase Order

Confirm Purchase Order

Route: POST /mutation/purchaseOrderConfirm

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Finish Invoice Entry

Finishes the data entry of an invoice: SAP runs its checks — prices, quantities, assignments, taxes, duplicates — and the invoice goes to Ready for Posting, approval, or Exception. Answers the invoice read back.

Create

Finish Invoice Entry

Finish Invoice Entry

Route: POST /mutation/supplierInvoiceFinishEntry

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Finish Receipt Entry

Finishes the data entry of a receipt In Preparation or In Revision (Preparation Finished). Answers the receipt read back.

Create

Finish Receipt Entry

Finish Receipt Entry

Route: POST /mutation/goodsReceiptFinishEntry

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Flag Supplier as Obsolete

Flags a supplier obsolete (4 Obsolete): the record stays, and is no longer used. Answers the supplier read back.

Create

Flag Supplier as Obsolete

Flag Supplier as Obsolete

Route: POST /mutation/supplierFlagObsolete

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Goods and Service Receipts

Goods and service acknowledgements: the receipt of what a purchase order line ordered — not the supplier’s confirmation of the order. Date, posting date, statuses (life cycle, release, approval, cancellation) and whether it reverses another.

Read

Goods and Service Receipts

Goods and service acknowledgements: the receipt of what a purchase order line ordered — not the supplier’s confirmation of the order. Date, posting date, statuses (life cycle, release, approval, cancellation) and whether it reverses another.

Route: GET /goodsReceipts

Excel formula: =LF.sapbyd.goodsReceipts("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
GoodsAndServiceAcknowledgement_IDstringNo-
GoodsAndServiceAcknowledgement_SellerParty_PartyIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
GoodsAndServiceAcknowledgement_LifeCycleStatusCodestringNo1 In Preparation, 2 In Approval, 3 In Revision, 4 Rejected, 5 Released, 6 Canceled, 7 Partially Canceled, 8 Preparation Finished, 9 Approved...
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

GoodsAndServiceAcknowledgement_CancellationDocumentIndicator
default

boolean

—

-

GoodsAndServiceAcknowledgement_ID
default

string

—

-

GoodsAndServiceAcknowledgement_LifeCycleStatusCodeText
default

string

—

-

GoodsAndServiceAcknowledgement_PostingDate
default

date

—

-

GoodsAndServiceAcknowledgement_Date
default

date

—

-

GoodsAndServiceAcknowledgement_SellerParty_PartyID
default

string

—

-

Post Supplier Invoice

Posts an invoice Ready for Posting or Approved: the payable reaches the ledger. Posting is not paying.

Create

Post Supplier Invoice

Post Supplier Invoice

Route: POST /mutation/supplierInvoicePost

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Purchase Order Items

The lines of the purchase orders: product, quantity and unit, net amount, unit price and its base quantity, what each line requires — a receipt, an invoice, a confirmation — and its delivery and invoicing status. A unit price holds for its base quantity (a price may be per 100 units): never multiply it by a quantity yo...

Read

Purchase Order Items

The lines of the purchase orders: product, quantity and unit, net amount, unit price and its base quantity, what each line requires — a receipt, an invoice, a confirmation — and its delivery and invoicing status. A unit price holds for its base quantity (a price may be per 100 units): never multiply it by a quantity yo...

Route: GET /purchaseOrderItems

Excel formula: =LF.sapbyd.purchaseOrderItems("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ParentObjectIDstringNo-
PurchaseOrder_Item_ProductIDstringNoThe material or service product ID.
PurchaseOrder_Item_DeliveryStatusCodestringNoA code of the PurchaseOrder_ItemPurchaseOrder_Item_DeliveryStatusCode code list.
PurchaseOrder_Item_InvoicingStatusCodestringNoA code of the PurchaseOrder_ItemPurchaseOrder_Item_InvoicingStatusCode code list.
purchaseOrderIdstringNoThe lines of this purchase order, by its ID or its ObjectID.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

PurchaseOrder_Item_ID
default

string

—

-

PurchaseOrder_Item_Quantity
default

number

—

-

PurchaseOrder_Item_DeliveryStatusCodeText
default

string

—

-

PurchaseOrder_Item_NetAmount
default

number

—

-

PurchaseOrder_Item_ProductID
default

string

—

-

PurchaseOrder_Item_NetAmountCurrencyCode
default

string

—

-

PurchaseOrder_Item_InvoicingStatusCodeText
default

string

—

-

ParentObjectID
default

string

→ purchaseOrders

-

PurchaseOrder_Item_Description
default

string

—

-

PurchaseOrder_Item_QuantityUnitCode
default

string

—

-

Purchase Orders

Purchase orders, newest first: supplier, totals and currency, and their statuses kept apart — life cycle, delivery, invoicing, supplier acknowledgement. Their lines are purchaseOrderItems.

Read

Purchase Orders

Purchase orders, newest first: supplier, totals and currency, and their statuses kept apart — life cycle, delivery, invoicing, supplier acknowledgement. Their lines are purchaseOrderItems.

Route: GET /purchaseOrders

Excel formula: =LF.sapbyd.purchaseOrders("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
PurchaseOrder_IDstringNoExactly this purchase order ID.
PurchaseOrder_Supplier_PartyIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
PurchaseOrder_LifeCycleStatusCodestringNo1 In Preparation, 2 In Approval, 3 In Revision, 4 Rejected, 5 Not Yet Acknowledged, 6 Sent, 7 Acknowledgement Received, 8 Canceled, 9 Follow...
PurchaseOrder_DeliveryStatusCodestringNo1 Not Delivered, 2 Partially Delivered, 3 Delivered, 4 Not Relevant
PurchaseOrder_InvoicingStatusCodestringNo1 Not Started, 2 In Process, 3 Finished, 4 Not Relevant, 5 Interrupted
PurchaseOrder_CurrencyCodestringNoA code of the PurchaseOrderPurchaseOrder_CurrencyCode code list.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

PurchaseOrder_TotalNetAmount
default

number

—

-

PurchaseOrder_LifeCycleStatusCodeText
default

string

—

-

PurchaseOrder_InvoicingStatusCodeText
default

string

—

-

PurchaseOrder_CurrencyCode
default

string

—

-

PurchaseOrder_CreationDateTime
default

date

—

-

PurchaseOrder_ID
default

string

—

-

PurchaseOrder_DeliveryStatusCodeText
default

string

—

-

PurchaseOrder_Supplier_PartyID
default

string

—

-

Purchasing Code Lists

The valid values of the codes purchasing publishes — types, statuses, units, accounts — so a code is never guessed. A contextual list (a G/L account per chart of accounts) answers each code with its Context.

Read

Purchasing Code Lists

The valid values of the codes purchasing publishes — types, statuses, units, accounts — so a code is never guessed. A contextual list (a G/L account per chart of accounts) answers each code with its Context.

Route: GET /purchasingCodeLists

Excel formula: =LF.sapbyd.purchasingCodeLists("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
codeListenumYesWhich list to read. Values: GoodsAndServiceAcknowledgementGoodsAndServiceAcknowledgement_LifeCycleStatusCode, PurchaseOrderPurchaseOrder_CurrencyCode, PurchaseOrderPurchaseOrder_DeliveryStatusCode, PurchaseOrderPurchaseOrder_InvoicingStatusCode, PurchaseOrderPurchaseOrder_LifeCycleStatusCode
Data returned in Excel
Field
Type
Relations
Description
Code
default

string

—

-

Description
default

string

—

-

Reject Purchase Order

Rejects a purchase order In Approval. Answers the order read back.

Create

Reject Purchase Order

Reject Purchase Order

Route: POST /mutation/purchaseOrderReject

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Release Receipt

Submits a finished or approved receipt for release: once released, it confirms the receipt of the ordered goods or services. Answers the receipt read back.

Create

Release Receipt

Release Receipt

Route: POST /mutation/goodsReceiptRelease

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Revoke Supplier Obsolescence

Revokes the obsolescence of a supplier: it comes back Blocked (3), and needs unblocking to be active again. Answers the supplier read back.

Create

Revoke Supplier Obsolescence

Revoke Supplier Obsolescence

Route: POST /mutation/supplierRevokeObsolescence

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Send Back Purchase Order

Sends a purchase order In Approval back for revision. Answers the order read back.

Create

Send Back Purchase Order

Send Back Purchase Order

Route: POST /mutation/purchaseOrderSendBack

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Submit Purchase Order for Ordering

Submits a purchase order In Preparation or In Revision for ordering: it goes to approval when one is required, otherwise it is sent to the supplier. Answers the order read back.

Create

Submit Purchase Order for Ordering

Submit Purchase Order for Ordering

Route: POST /mutation/purchaseOrderOrder

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Supplier Invoice Exceptions

The discrepancies SAP found on supplier invoices — price, quantity, duplicate… — each to be processed before the invoice posts. Accepting one is a decision, never automatic.

Read

Supplier Invoice Exceptions

The discrepancies SAP found on supplier invoices — price, quantity, duplicate… — each to be processed before the invoice posts. Accepting one is a decision, never automatic.

Route: GET /supplierInvoiceExceptions

Excel formula: =LF.sapbyd.supplierInvoiceExceptions("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
SupplierInvoiceException_IDstringNo-
SupplierInvoiceException_LifeCycleStatusCodestringNo1 To Be Processed, 2 Forwarded, 3 Accepted, 4 Rejected, 5 Obsolete
SupplierInvoiceException_ProcessingTypeCodestringNoA code of the SupplierInvoiceExceptionSupplierInvoiceException_ProcessingTypeCode code list.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

SupplierInvoiceException_LifeCycleStatusCode

string

—

-

SupplierInvoiceException_LifeCycleStatusCodeText
default

string

—

-

SupplierInvoiceException_ProcessingTypeCode

string

—

-

SupplierInvoiceException_ProcessingTypeCodeText
default

string

—

-

ObjectID

string

—

-

SupplierInvoiceException_ID
default

string

—

-

can_accept

boolean

—

-

Supplier Invoice Items

The lines of the supplier invoices: product, quantity and unit, net and gross amounts, unit price and its base quantity, line type. A unit price holds for its base quantity (a price may be per 100 units): never multiply it by a quantity yourself — the line’s net amount is SAP’s.

Read

Supplier Invoice Items

The lines of the supplier invoices: product, quantity and unit, net and gross amounts, unit price and its base quantity, line type. A unit price holds for its base quantity (a price may be per 100 units): never multiply it by a quantity yourself — the line’s net amount is SAP’s.

Route: GET /supplierInvoiceItems

Excel formula: =LF.sapbyd.supplierInvoiceItems("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ParentObjectIDstringNo-
SupplierInvoice_Item_ProductIDstringNo-
supplierInvoiceIdstringNoThe lines of this invoice, by its ID or its ObjectID.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

SupplierInvoice_Item_Quantity
default

number

—

-

SupplierInvoice_Item_NetAmountCurrencyCode
default

string

—

-

SupplierInvoice_Item_ID
default

string

—

-

ParentObjectID
default

string

→ supplierInvoices

-

SupplierInvoice_Item_Description
default

string

—

-

SupplierInvoice_Item_NetAmount
default

number

—

-

SupplierInvoice_Item_QuantityUnitCode
default

string

—

-

SupplierInvoice_Item_ProductID
default

string

—

-

Supplier Invoices

Supplier invoices and credit memos, newest first: supplier, invoice and receipt dates, net, tax and gross totals, type, and their statuses kept apart — life cycle, posting, approval. Posted is not paid. Their lines are supplierInvoiceItems; their discrepancies, supplierInvoiceExceptions.

Read

Supplier Invoices

Supplier invoices and credit memos, newest first: supplier, invoice and receipt dates, net, tax and gross totals, type, and their statuses kept apart — life cycle, posting, approval. Posted is not paid. Their lines are supplierInvoiceItems; their discrepancies, supplierInvoiceExceptions.

Route: GET /supplierInvoices

Excel formula: =LF.sapbyd.supplierInvoices("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
SupplierInvoice_IDstringNoSAP’s invoice ID.
SupplierInvoice_SellerParty_PartyIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
SupplierInvoice_ExternalReference_IDstringNoThe supplier’s own invoice number. Not proof of uniqueness: duplicates are SAP’s check.
SupplierInvoice_LifeCycleStatusCodestringNo1 In Process, 2 Exception, 3 Ready for Posting, 4 In Approval, 5 In Revision, 6 Approved, 7 Voided, 8 Posted, 9 Canceled, 10 In Cancellation...
SupplierInvoice_PostingStatusCodestringNo1 Not Posted, 2 Voided, 3 Posted, 4 Canceled, 5 Not Relevant, 6 Posting not relevant
SupplierInvoice_TypeCodestringNoInvoice, credit memo… — see the code list.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

SupplierInvoice_TotalGrossAmount
default

number

—

-

SupplierInvoice_TypeCodeText
default

string

—

-

SupplierInvoice_TotalGrossAmountCurrencyCode
default

string

—

-

SupplierInvoice_LifeCycleStatusCodeText
default

string

—

-

SupplierInvoice_ID
default

string

—

-

SupplierInvoice_InvoiceDate
default

date

—

-

SupplierInvoice_SellerParty_PartyID
default

string

—

-

SupplierInvoice_ExternalReference_ID
default

string

—

-

Suppliers

The suppliers: ID, name, ABC classification and master-data status. A supplier is a business partner in the supplier role: the same partner may be a customer too.

Read

Suppliers

The suppliers: ID, name, ABC classification and master-data status. A supplier is a business partner in the supplier role: the same partner may be a customer too.

Route: GET /suppliers

Excel formula: =LF.sapbyd.suppliers("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
Supplier_InternalIDstringNo-
Supplier_BusinessPartnerFormattedNamestringNoText contained in the name (case-sensitive).
Supplier_LifeCycleStatusCodestringNo1 In Preparation, 2 Active, 3 Blocked, 4 Obsolete, 5 Deleted
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

Supplier_LifeCycleStatusCode

string

—

-

Supplier_LifeCycleStatusCodeText
default

string

—

-

Supplier_ABCClassificationCode

string

—

-

Supplier_ABCClassificationCodeText
default

string

—

-

Supplier_SortingFormattedName

string

—

-

Supplier_SecondLineName

string

—

-

Supplier_CreationDateTime

date

—

-

ObjectID

string

—

-

Supplier_IndustrialSectorCode

string

—

-

Supplier_IndustrialSectorCodeText

string

—

-

Supplier_LegalCompetenceIndicator

boolean

—

-

Supplier_InternalID
default

string

—

-

Supplier_BusinessPartnerFormattedName
default

string

—

-

Supplier_CompanyLegalFormCode

string

—

-

Supplier_CompanyLegalFormCodeText

string

—

-

UUID

string

—

-

Supplier_FirstLineName

string

—

-

Supplier_LastChangeDateTime

date

—

-

can_activate

boolean

—

-

can_block

boolean

—

-

can_unblock

boolean

—

-

can_flag_obsolete

boolean

—

-

can_revoke_obsolescence

boolean

—

-

Unblock Supplier

Unblocks a blocked supplier (2 Active). Answers the supplier read back.

Create

Unblock Supplier

Unblock Supplier

Route: POST /mutation/supplierUnblock

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Withdraw Purchase Order

Withdraws a purchase order from approval, back to its buyer. Answers the order read back.

Create

Withdraw Purchase Order

Withdraw Purchase Order

Route: POST /mutation/purchaseOrderWithdraw

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Sales

Accept Lead

Accepts a lead for sales. SAP may answer success and keep the lead Open: read the status back, and look for the linked opportunity before calling it converted.

Create

Accept Lead

Accept Lead

Route: POST /mutation/leadAccept

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Activate Customer

Activates a customer In Preparation (2 Active). Answers the customer read back.

Create

Activate Customer

Activate Customer

Route: POST /mutation/customerActivate

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Approve Quote

Approves a quote In Approval. Answers it read back.

Create

Approve Quote

Approve Quote

Route: POST /mutation/customerQuoteApprove

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Block Customer

Blocks an active customer (3 Blocked). Answers the customer read back.

Create

Block Customer

Block Customer

Route: POST /mutation/customerBlock

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Business Partners

Every business partner of the tenant — person or organisation — with its ID, name and status: the identity a customer, a supplier or a contact role is added to, never recreated per domain.

Read

Business Partners

Every business partner of the tenant — person or organisation — with its ID, name and status: the identity a customer, a supplier or a contact role is added to, never recreated per domain.

Route: GET /businessPartners

Excel formula: =LF.sapbyd.businessPartners("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
BusinessPartner_InternalIDstringNo-
BusinessPartner_BusinessPartnerFormattedNamestringNoText contained in the name (case-sensitive).
BusinessPartner_CategoryCodestringNoA code of the BusinessPartnerRelationshipBusinessPartnerRelationship_FirstBusinessPartnerCategoryCode code list.
BusinessPartner_LifeCycleStatusCodestringNo1 In Preparation, 2 Active, 3 Blocked, 4 Obsolete, 5 Deleted
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

BusinessPartner_InternalID
default

string

—

-

BusinessPartner_PersonMiddleName

string

—

-

BusinessPartner_LifeCycleStatusCode

string

—

-

BusinessPartner_LifeCycleStatusCodeText
default

string

—

-

BusinessPartner_PersonFamilyName

string

—

-

BusinessPartner_PersonMaritalStatusCode

string

—

-

BusinessPartner_PersonMaritalStatusCodeText

string

—

-

BusinessPartner_CategoryCode

string

—

-

BusinessPartner_CategoryCodeText
default

string

—

-

BusinessPartner_CompanyLegalFormCode

string

—

-

BusinessPartner_CompanyLegalFormCodeText

string

—

-

BusinessPartner_SortingFormattedName

string

—

-

BusinessPartner_OrganisationSecondLineName

string

—

-

BusinessPartner_PersonFormOfAddressCode

string

—

-

BusinessPartner_PersonFormOfAddressCodeText

string

—

-

ObjectID

string

—

-

BusinessPartner_PersonOccupationCode

string

—

-

BusinessPartner_PersonOccupationCodeText

string

—

-

BusinessPartner_PersonGenderCode

string

—

-

BusinessPartner_PersonGenderCodeText

string

—

-

BusinessPartner_PersonGivenName

string

—

-

UUID

string

—

-

BusinessPartner_LastChangeDateTime

date

—

-

BusinessPartner_IndustrialSectorCode

string

—

-

BusinessPartner_IndustrialSectorCodeText

string

—

-

BusinessPartner_PersonBirthDate

date

—

-

BusinessPartner_OrganisationFirstLineName

string

—

-

BusinessPartner_PersonAcademicTitleCode

string

—

-

BusinessPartner_PersonAcademicTitleCodeText

string

—

-

BusinessPartner_BusinessPartnerFormattedName
default

string

—

-

BusinessPartner_CreationDateTime

date

—

-

Create Invoices

Creates the customer invoices of a request, on the invoice date given — releasing them at once only when automatic release is allowed. The invoices it made are listed in customerInvoices; never create a second one by hand. Answers the request read back.

Create

Create Invoices

Create Invoices

Route: POST /mutation/invoiceRequestCreateInvoices

Inputs you can set
NameTypeRequiredDescription
AutomaticReleaseAllowedIndicatorbooleanNo-
BaseBusinessTransactionDocumentBasedCustomerInvoiceSeparationRequiredIndicatorbooleanNo-
CustomerInvoiceDatestringYes-
ididYes-
InvoicingClearingRequestedIndicatorbooleanNo-
ProvisionDateBasedCustomerInvoiceSeparationRequiredIndicatorbooleanNo-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Customer Invoice Items

The lines of the customer invoices: product, description, quantity and unit, net, tax and gross amounts.

Read

Customer Invoice Items

The lines of the customer invoices: product, description, quantity and unit, net, tax and gross amounts.

Route: GET /customerInvoiceItems

Excel formula: =LF.sapbyd.customerInvoiceItems("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ParentObjectIDstringNo-
CustomerInvoice_Item_ProductIDstringNo-
customerInvoiceIdstringNoThe lines of this invoice, by its ID or its ObjectID.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

CustomerInvoice_Item_Quantity
default

number

—

-

CustomerInvoice_Item_ProductID
default

string

—

-

CustomerInvoice_Item_NetAmount
default

number

—

-

ParentObjectID
default

string

→ customerInvoices

-

CustomerInvoice_Item_QuantityUnitCode
default

string

—

-

CustomerInvoice_Item_NetAmountCurrencyCode
default

string

—

-

CustomerInvoice_Item_ID
default

string

—

-

CustomerInvoice_Item_Description
default

string

—

-

Customer Invoice Requests

Invoice requests: what is due to be invoiced to a customer, from an order, a service or a project — not invoices. Buyer, bill-to, proposed invoice date, amounts and their statuses (life cycle, invoicing, processing). One request can make several invoices, and several requests one invoice.

Read

Customer Invoice Requests

Invoice requests: what is due to be invoiced to a customer, from an order, a service or a project — not invoices. Buyer, bill-to, proposed invoice date, amounts and their statuses (life cycle, invoicing, processing). One request can make several invoices, and several requests one invoice.

Route: GET /invoiceRequests

Excel formula: =LF.sapbyd.invoiceRequests("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
CustomerInvoiceRequest_NamestringNo-
CustomerInvoiceRequest_BuyerPartyIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
CustomerInvoiceRequest_BaseBusinessTransactionDocumentIDstringNoThe ID of the order, service or project it invoices.
CustomerInvoiceRequest_LifeCycleStatusCodestringNo1 In Preparation, 2 Released, 3 Blocked, 4 Finished, 5 Canceled, 6 Released With Pending Changes
CustomerInvoiceRequest_InvoicingStatusCodestringNo1 Not Invoiced, 2 Partially Invoiced, 3 Invoiced, 4 Not Relevant
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

CustomerInvoiceRequest_BuyerPartyID
default

string

—

-

CustomerInvoiceRequest_Name
default

string

—

-

CustomerInvoiceRequest_ProposedInvoiceDate
default

date

—

-

CustomerInvoiceRequest_TotalNetAmountCurrencyCode
default

string

—

-

CustomerInvoiceRequest_LifeCycleStatusCodeText
default

string

—

-

CustomerInvoiceRequest_InvoicingStatusCodeText
default

string

—

-

CustomerInvoiceRequest_TotalNetAmount
default

number

—

-

CustomerInvoiceRequest_BaseBusinessTransactionDocumentID
default

string

—

-

Customer Invoices

Customer invoices, credit memos and their kin (CI Invoice, CCM Credit Memo, CCI Correction Invoice, CDP Down Payment Request, DN Debit Note, RCM Rebate Credit Memo), newest first: customer, date, net, tax and gross amounts, and release and approval statuses. Released is not paid. Their lines are customerInvoiceItems.

Read

Customer Invoices

Customer invoices, credit memos and their kin (CI Invoice, CCM Credit Memo, CCI Correction Invoice, CDP Down Payment Request, DN Debit Note, RCM Rebate Credit Memo), newest first: customer, date, net, tax and gross amounts, and release and approval statuses. Released is not paid. Their lines are customerInvoiceItems.

Route: GET /customerInvoices

Excel formula: =LF.sapbyd.customerInvoices("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
CustomerInvoice_IDstringNo-
CustomerInvoice_BuyerParty_PartyIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
CustomerInvoice_ProcessingTypeCodestringNoCI Invoice, CCM Credit Memo, CCI Correction Invoice, CDP Down Payment Request, DN Debit Note, RCM Rebate Credit Memo
CustomerInvoice_ReleaseStatusCodestringNo1 Not Released, 3 Released, 4 Release Discarded, 5 Release Canceled
CustomerInvoice_ReferenceBusinessTransactionDocumentIDstringNoThe order or invoice request it was made from.
CustomerInvoice_CancellationDocumentIndicatorbooleanNo-
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

CustomerInvoice_TotalGrossAmount
default

number

—

-

CustomerInvoice_ID
default

string

—

-

CustomerInvoice_ReleaseStatusCodeText
default

string

—

-

CustomerInvoice_Date
default

date

—

-

CustomerInvoice_ProcessingTypeCodeText
default

string

—

-

CustomerInvoice_TotalGrossAmountCurrencyCode
default

string

—

-

CustomerInvoice_BuyerParty_PartyID
default

string

—

-

Customer Quotes

Sales quotes: customer, date, net and gross amounts, currency, status, approval and result (won, lost). A won quote is followed by a sales order of its own.

Read

Customer Quotes

Sales quotes: customer, date, net and gross amounts, currency, status, approval and result (won, lost). A won quote is followed by a sales order of its own.

Route: GET /customerQuotes

Excel formula: =LF.sapbyd.customerQuotes("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
CustomerQuote_IDstringNo-
CustomerQuote_DescriptionstringNo-
CustomerQuote_BuyerParty_PartyIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
CustomerQuote_LifeCycleStatusCodestringNo1 Open, 2 In Process, 3 Completed
CustomerQuote_ApprovalStatusCodestringNo1 Not Started, 2 Approval not Necessary, 3 In Approval, 4 Approved, 5 Rejected, 6 In Revision, 7 Withdrawn
CustomerQuote_CustomerQuoteResultStatusCodestringNo1 Not Relevant, 2 Pending, 3 Won, 4 Lost
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

CustomerQuote_NetAmount
default

number

—

-

CustomerQuote_CurrencyCode
default

string

—

-

CustomerQuote_Description
default

string

—

-

CustomerQuote_DateTime
default

date

—

-

CustomerQuote_LifeCycleStatusCodeText
default

string

—

-

CustomerQuote_ApprovalStatusCodeText
default

string

—

-

CustomerQuote_ID
default

string

—

-

CustomerQuote_BuyerParty_PartyID
default

string

—

-

Customers

The customers: ID, name, category (person or organisation), ABC classification, the order, delivery and invoicing blocks, and the master-data status. A customer is a business partner in the customer role: the same partner may be a supplier too.

Read

Customers

The customers: ID, name, category (person or organisation), ABC classification, the order, delivery and invoicing blocks, and the master-data status. A customer is a business partner in the customer role: the same partner may be a supplier too.

Route: GET /customers

Excel formula: =LF.sapbyd.customers("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
Customer_InternalIDstringNo-
Customer_BusinessPartnerFormattedNamestringNoText contained in the name (case-sensitive).
Customer_LifeCycleStatusCodestringNo1 In Preparation, 2 Active, 3 Blocked, 4 Obsolete, 5 Deleted
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

Customer_InternalID
default

string

—

-

Customer_CategoryCodeText
default

string

—

-

Customer_OrderBlockingReasonCodeText
default

string

—

-

Customer_LifeCycleStatusCodeText
default

string

—

-

Customer_BusinessPartnerFormattedName
default

string

—

-

Finish Sales Order Fulfilment

Finishes the fulfilment of every line: nothing more is delivered or performed for it. Answers the order read back.

Create

Finish Sales Order Fulfilment

Finish Sales Order Fulfilment

Route: POST /mutation/salesOrderFinishFulfilment

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Flag Customer as Obsolete

Flags a customer obsolete (4 Obsolete): the record stays, and is no longer used. Answers the customer read back.

Create

Flag Customer as Obsolete

Flag Customer as Obsolete

Route: POST /mutation/customerFlagObsolete

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Hand Over Lead

Hands a lead over from marketing to sales. SAP may answer success and keep it Open: read the status back.

Create

Hand Over Lead

Hand Over Lead

Route: POST /mutation/leadHandOver

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Leads

Sales leads: description, prospect, source, qualification and status. A lead converted is one with a linked opportunity — the status alone does not say it.

Read

Leads

Sales leads: description, prospect, source, qualification and status. A lead converted is one with a linked opportunity — the status alone does not say it.

Route: GET /leads

Excel formula: =LF.sapbyd.leads("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
Lead_IDstringNo-
Lead_DescriptionstringNo-
Lead_ProspectParty_PartyIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
Lead_LifeCycleStatusCodestringNo1 Open, 2 Qualified, 3 Handed Over, 4 Accepted, 5 Rejected, 6 In Revision, 7 Converted, 8 Obsolete
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

Lead_QualificationLevelCodeText
default

string

—

-

Lead_Description
default

string

—

-

Lead_ID
default

string

—

-

Lead_LifeCycleStatusCodeText
default

string

—

-

Lead_StartDate
default

date

—

-

Lead_ProspectParty_PartyID
default

string

—

-

Lose Opportunity

Marks an opportunity lost (5 Lost). Answers it read back.

Create

Lose Opportunity

Lose Opportunity

Route: POST /mutation/opportunityLose

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Opportunities

Sales opportunities: description, prospect, sales phase, chance of success, expected and weighted revenue, and status. Expected revenue, weighted revenue and probability are three measures: never added together.

Read

Opportunities

Sales opportunities: description, prospect, sales phase, chance of success, expected and weighted revenue, and status. Expected revenue, weighted revenue and probability are three measures: never added together.

Route: GET /opportunities

Excel formula: =LF.sapbyd.opportunities("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
Opportunity_IDstringNo-
Opportunity_DescriptionstringNo-
Opportunity_ProspectParty_PartyIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
Opportunity_LifeCycleStatusCodestringNo1 Open, 2 In Process, 3 Stopped, 4 Won, 5 Lost
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

Opportunity_ExpectedRevenueAmountCurrencyCode
default

string

—

-

Opportunity_Description
default

string

—

-

Opportunity_LifeCycleStatusCodeText
default

string

—

-

Opportunity_ExpectedRevenueAmount
default

number

—

-

Opportunity_SalesPhaseCodeText
default

string

—

-

Opportunity_ChanceOfSuccessPercent
default

number

—

-

Opportunity_ID
default

string

—

-

Opportunity_ProspectParty_PartyID
default

string

—

-

Process Opportunity

Starts working an open opportunity (2 In Process). Answers it read back.

Create

Process Opportunity

Process Opportunity

Route: POST /mutation/opportunityProcess

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Reject Lead

Rejects a lead (5 Rejected). Answers the lead read back.

Create

Reject Lead

Reject Lead

Route: POST /mutation/leadReject

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Release Customer Invoice

Releases a customer invoice: it is posted to accounting and can be sent. Answers it read back.

Create

Release Customer Invoice

Release Customer Invoice

Route: POST /mutation/customerInvoiceRelease

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Release Invoice Request

Releases an invoice request In Preparation, so it can be invoiced. Answers it read back.

Create

Release Invoice Request

Release Invoice Request

Route: POST /mutation/invoiceRequestRelease

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Release Sales Order

Releases a sales order: it is no longer a draft and its follow-up documents can be created. Not the release of its lines to execution. Answers it read back.

Create

Release Sales Order

Release Sales Order

Route: POST /mutation/salesOrderRelease

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Release Sales Order to Execution

Releases every line of the order to execution — delivery, service or project. Answers the order read back.

Create

Release Sales Order to Execution

Release Sales Order to Execution

Route: POST /mutation/salesOrderReleaseToExecution

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Reopen Opportunity

Reopens a stopped, won or lost opportunity. Answers it read back.

Create

Reopen Opportunity

Reopen Opportunity

Route: POST /mutation/opportunityReopen

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Revoke Customer Obsolescence

Revokes the obsolescence of a customer: it comes back Blocked (3), and needs unblocking to be active again. Answers the customer read back.

Create

Revoke Customer Obsolescence

Revoke Customer Obsolescence

Route: POST /mutation/customerRevokeObsolescence

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Sales Code Lists

The valid values of the codes sales publishes — types, statuses, units, accounts — so a code is never guessed. A contextual list (a G/L account per chart of accounts) answers each code with its Context.

Read

Sales Code Lists

The valid values of the codes sales publishes — types, statuses, units, accounts — so a code is never guessed. A contextual list (a G/L account per chart of accounts) answers each code with its Context.

Route: GET /salesCodeLists

Excel formula: =LF.sapbyd.salesCodeLists("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
codeListenumYesWhich list to read. Values: BusinessPartnerBusinessPartner_LifeCycleStatusCode, BusinessPartnerRelationshipBusinessPartnerRelationship_FirstBusinessPartnerCategoryCode, CustomerCustomer_LifeCycleStatusCode, CustomerInvoiceCustomerInvoice_ProcessingTypeCode, CustomerInvoiceCustomerInvoice_ReleaseStatusCode
Data returned in Excel
Field
Type
Relations
Description
Description
default

string

—

-

Code
default

string

—

-

Sales Order Items

The lines of the sales orders: product, description, net amount, processing type, and their release, fulfilment, invoicing and cancellation statuses.

Read

Sales Order Items

The lines of the sales orders: product, description, net amount, processing type, and their release, fulfilment, invoicing and cancellation statuses.

Route: GET /salesOrderItems

Excel formula: =LF.sapbyd.salesOrderItems("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ParentObjectIDstringNo-
SalesOrder_ItemProduct_ProductIDstringNo-
salesOrderIdstringNoThe lines of this sales order, by its ID or its ObjectID.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

ParentObjectID
default

string

→ salesOrders

-

SalesOrder_Item_NetAmount
default

number

—

-

SalesOrder_Item_ID
default

string

—

-

SalesOrder_Item_FulfilmentProcessingStatusCodeText
default

string

—

-

SalesOrder_Item_Description
default

string

—

-

SalesOrder_Item_NetAmountCurrencyCode
default

string

—

-

SalesOrder_Item_ProcessingTypeCodeText
default

string

—

-

SalesOrder_ItemProduct_ProductID
default

string

—

-

Sales Orders

Sales orders, newest first: customer, name, external reference, net and gross amounts, and their statuses kept apart — life cycle, release, execution release, delivery, invoicing, approval, blocks. Their lines are salesOrderItems.

Read

Sales Orders

Sales orders, newest first: customer, name, external reference, net and gross amounts, and their statuses kept apart — life cycle, release, execution release, delivery, invoicing, approval, blocks. Their lines are salesOrderItems.

Route: GET /salesOrders

Excel formula: =LF.sapbyd.salesOrders("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
SalesOrder_IDstringNo-
SalesOrder_NamestringNo-
SalesOrder_BuyerParty_PartyIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
SalesOrder_ExternalReferencestringNoThe customer’s purchase order number, exactly.
SalesOrder_LifeCycleStatusCodestringNo1 Open, 2 In Process, 3 Completed, 4 In Preparation
SalesOrder_ReleaseStatusCodestringNo1 Not Released, 2 Partially Released, 3 Released, 4 Release Discarded, 5 Release Canceled, 6 Not Relevant, 7 Release Cancellation Requested,...
SalesOrder_DeliveryStatusCodestringNo1 Not Started, 2 In Process, 3 Finished, 4 Not Relevant, 5 Interrupted
SalesOrder_InvoiceStatusCodestringNo1 Not Started, 2 In Process, 3 Finished, 4 Not Relevant, 5 Interrupted
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

SalesOrder_InvoiceStatusCodeText
default

string

—

-

SalesOrder_Name
default

string

—

-

SalesOrder_NetAmountCurrencyCode
default

string

—

-

SalesOrder_NetAmount
default

number

—

-

SalesOrder_DeliveryStatusCodeText
default

string

—

-

SalesOrder_ID
default

string

—

-

SalesOrder_LifeCycleStatusCodeText
default

string

—

-

SalesOrder_BuyerParty_PartyID
default

string

—

-

Send Back Quote

Sends a quote In Approval back for revision. Answers it read back.

Create

Send Back Quote

Send Back Quote

Route: POST /mutation/customerQuoteSendBack

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Send Order Confirmation

Sends the order confirmation to the customer — an output (email or print), not an internal validation.

Create

Send Order Confirmation

Send Order Confirmation

Route: POST /mutation/salesOrderSendConfirmation

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Stop Opportunity

Stops an opportunity (3 Stopped). Answers it read back.

Create

Stop Opportunity

Stop Opportunity

Route: POST /mutation/opportunityStop

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Submit Quote for Approval

Submits a quote for approval (3 In Approval). Answers it read back.

Create

Submit Quote for Approval

Submit Quote for Approval

Route: POST /mutation/customerQuoteSubmit

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Unblock Customer

Unblocks a blocked customer (2 Active). Answers the customer read back.

Create

Unblock Customer

Unblock Customer

Route: POST /mutation/customerUnblock

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Unblock Sales Order Fulfilment

Lifts the delivery block of a sales order. Answers it read back.

Create

Unblock Sales Order Fulfilment

Unblock Sales Order Fulfilment

Route: POST /mutation/salesOrderUnblockFulfilment

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Win Opportunity

Marks an opportunity won (4 Won). Answers it read back.

Create

Win Opportunity

Win Opportunity

Route: POST /mutation/opportunityWin

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Service

Complete Service Request

Completes a request (3 Completed). Closing it is SAP’s next step. Answers it read back.

Create

Complete Service Request

Complete Service Request

Route: POST /mutation/serviceRequestComplete

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Release Service Order

Releases a service order. Answers it read back.

Create

Release Service Order

Release Service Order

Route: POST /mutation/serviceOrderRelease

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Release Service Order to Execution

Releases every line of the service order to execution: its work can be confirmed. Answers the order read back.

Create

Release Service Order to Execution

Release Service Order to Execution

Route: POST /mutation/serviceOrderReleaseToExecution

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Service Confirmations

Service confirmations — the work actually done: name, customer, date, and the fulfilment and invoicing status of their lines. Several confirmations may feed one service order line; confirming is not completing.

Read

Service Confirmations

Service confirmations — the work actually done: name, customer, date, and the fulfilment and invoicing status of their lines. Several confirmations may feed one service order line; confirming is not completing.

Route: GET /serviceConfirmations

Excel formula: =LF.sapbyd.serviceConfirmations("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ServiceConfirmation_IDstringNo-
ServiceConfirmation_NamestringNo-
ServiceConfirmation_BuyerIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

ServiceConfirmation_BuyerID
default

string

—

-

ServiceConfirmation_ID
default

string

—

-

ServiceConfirmation_ItemListInvoiceProcessingStatusCodeText
default

string

—

-

ServiceConfirmation_Name
default

string

—

-

ServiceConfirmation_ItemListFulfilmentProcessingStatusCodeText
default

string

—

-

ServiceConfirmation_DateTime
default

date

—

-

Service Orders

Service orders — the service sold and planned: name, customer, date, priority, amounts and statuses (life cycle, release). Their work is recorded in service confirmations.

Read

Service Orders

Service orders — the service sold and planned: name, customer, date, priority, amounts and statuses (life cycle, release). Their work is recorded in service confirmations.

Route: GET /serviceOrders

Excel formula: =LF.sapbyd.serviceOrders("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ServiceOrder_IDstringNo-
ServiceOrder_NamestringNo-
ServiceOrder_BuyerIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
ServiceOrder_LifeCycleStatusCodestringNo1 Open, 2 In Process, 3 Completed, 4 In Preparation
ServiceOrder_ReleaseStatusCodestringNo1 Not Released, 2 Partially Released, 3 Released, 4 Release Discarded, 5 Release Canceled, 6 Not Relevant, 7 Release Cancellation Requested,...
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

ServiceOrder_NetAmount
default

number

—

-

ServiceOrder_LifeCycleStatusCodeText
default

string

—

-

ServiceOrder_BuyerID
default

string

—

-

ServiceOrder_CurrencyCode
default

string

—

-

ServiceOrder_Name
default

string

—

-

ServiceOrder_DateTime
default

date

—

-

ServiceOrder_ReleaseStatusCodeText
default

string

—

-

ServiceOrder_ID
default

string

—

-

Service Requests

Service requests — a customer’s need or incident: name, customer, status and who is to act. A request is not the service order that answers it, nor the confirmation of the work.

Read

Service Requests

Service requests — a customer’s need or incident: name, customer, status and who is to act. A request is not the service order that answers it, nor the confirmation of the work.

Route: GET /serviceRequests

Excel formula: =LF.sapbyd.serviceRequests("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
ididNoRead exactly this record by its ObjectID. Answers one row, or none.
ServiceRequest_IDstringNo-
ServiceRequest_NamestringNo-
ServiceRequest_Buyer_PartyIDstringNoThe business partner ID (customer or supplier number, e.g. 1001), as the partner reads list it.
ServiceRequest_ServiceRequestLifeCycleStatusCodestringNo1 Open, 2 In Process, 3 Completed, 4 Closed
per_pagenumberNoRows per page (max 200) Default: 50
pagenumberNoPage number, starting at 1
Data returned in Excel
Field
Type
Relations
Description
id
default

id

—

-

ServiceRequest_ServiceRequestLifeCycleStatusCodeText
default

string

—

-

ServiceRequest_CreationDateTime
default

date

—

-

ServiceRequest_Name
default

string

—

-

ServiceRequest_RequestAssignmentStatusCodeText
default

string

—

-

ServiceRequest_ID
default

string

—

-

ServiceRequest_Buyer_PartyID
default

string

—

-

Start Service Request

Starts processing an open request (2 In Process). Answers it read back.

Create

Start Service Request

Start Service Request

Route: POST /mutation/serviceRequestStart

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.

Take Over Service Request

Takes the request over for processing, as the signed-in user. Answers it read back.

Create

Take Over Service Request

Take Over Service Request

Route: POST /mutation/serviceRequestTakeOver

Inputs you can set
NameTypeRequiredDescription
ididYes-
Data returned in Excel

This action returns a confirmation rather than a selectable table.