Connexion SAP Business ByDesign pour LinkyFlow
LinkyFlow connecte Excel a SAP Business ByDesign pour consulter, modifier et publier les donnees e-commerce utiles depuis un tableur.
Ressources
135
Requetes de lecture
57
Actions ecriture
83
Champs documentes
1491
Workflows a ramener dans Excel
Chaque ressource ci-dessous correspond a un workflow tableur concret. Les lectures ramenent des colonnes utiles dans Excel; les creations et modifications indiquent ce qui peut etre relu en lignes avant envoi.
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.
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
Formule Excel: =LF.sapbyd.reportFields("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | string | — | - |
roledefault | string | — | - |
filterabledefault | boolean | — | - |
mandatorydefault | boolean | — | - |
selectiondefault | string | — | - |
formatdefault | 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.
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
Formule Excel: =LF.sapbyd.reportRows("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.reports("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
namedefault | 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.
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
Formule Excel: =LF.sapbyd.accountingDocumentLines("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
ParentObjectIDdefault | string | → accountingDocuments | - |
CancelledIndicatordefault | boolean | — | - |
ChartOfAccountsItemCodedefault | string | — | - |
ChartOfAccountsItemCodeTextdefault | string | — | - |
DebitCreditCodeTextdefault | string | — | - |
IDdefault | string | — | - |
LineItemCurrencyAmountdefault | number | — | - |
currencyCodedefault | string | — | - |
LocalCurrencyAmountdefault | number | — | - |
currencyCode2default | 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.
Utilise comme filtre par
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
Formule Excel: =LF.sapbyd.accountingDocuments("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
AccountingDocument_PostingDatedefault | date | — | - |
AccountingDocument_TypeCodeTextdefault | string | — | - |
AccountingDocument_FiscalYearIDdefault | string | — | - |
AccountingDocument_IDdefault | string | — | - |
AccountingDocument_CancellationDocumentIndicatordefault | boolean | — | - |
AccountingDocument_SetOfBooksIDdefault | string | — | - |
AccountingDocument_AccountingPeriodIDdefault | string | — | - |
Notedefault | 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.
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
Formule Excel: =LF.sapbyd.bankStatements("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
HouseBankStatement_Datedefault | date | — | - |
HouseBankStatement_IDdefault | string | — | - |
HouseBankStatement_ClosingBalanceAmountdefault | number | — | - |
HouseBankStatement_LifeCycleStatusCodeTextdefault | string | — | - |
HouseBankStatement_OpeningBalanceAmountdefault | number | — | - |
HouseBankStatement_CurrencyCodedefault | string | — | - |
HouseBankStatement_BankAccountInternalIDdefault | 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.
Cancel Journal Entry
Cancel Journal Entry
Route: POST /mutation/journalEntryCancel
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.companies("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
UUIDdefault | string | — | - |
IDdefault | string | — | - |
ObjectID | string | — | - |
Cost Centres
The cost centres, by ID and UUID: what an expense line is assigned to.
Cost Centres
The cost centres, by ID and UUID: what an expense line is assigned to.
Route: GET /costCentres
Formule Excel: =LF.sapbyd.costCentres("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
UUIDdefault | string | — | - |
ObjectID | string | — | - |
IDdefault | 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.
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
Formule Excel: =LF.sapbyd.financeCodeLists("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
Codedefault | string | — | - |
Descriptiondefault | string | — | - |
Contextdefault | 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.
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
Formule Excel: =LF.sapbyd.houseBankAccounts("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
HouseBankAccount_CompanyHouseBankIDdefault | string | — | - |
HouseBankAccount_BankAccountIDdefault | string | — | - |
HouseBankAccount_BlockedIndicatordefault | boolean | — | - |
HouseBankAccount_CurrencyCodedefault | string | — | - |
HouseBankAccount_InternalIDdefault | string | — | - |
HouseBankAccount_BankAccountStandardIDdefault | 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...
Utilise comme filtre par
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
Formule Excel: =LF.sapbyd.journalEntries("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
CompanyUUIDdefault | string | — | - |
AccountingDocumentTypeCodeTextdefault | string | — | - |
ExternalIDdefault | string | — | - |
IDdefault | string | — | - |
PostingDatedefault | date | — | - |
TransactionCurrencyCodedefault | string | — | - |
ApprovalStatusCodeTextdefault | string | — | - |
LifeCycleStatusCodeTextdefault | string | — | - |
PostingStatusCodedefault | string | — | - |
PostingStatusCodeTextdefault | string | — | - |
Create Journal Entry
Create Journal Entry
Route: POST /mutation/journalEntries
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.journalEntryLines("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
ParentObjectIDdefault | string | → journalEntries | - |
ChartOfAccountsItemCodedefault | string | — | - |
ChartOfAccountsItemCodeTextdefault | string | — | - |
DebitCreditCodeTextdefault | string | — | - |
IDdefault | string | — | - |
LocalCurrencyAmountdefault | number | — | - |
currencyCodedefault | string | — | - |
TransactionCurrencyAmountdefault | number | — | - |
currencyCode3default | 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.
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
Formule Excel: =LF.sapbyd.payments("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
Payment_TransactionCurrencyCodedefault | string | — | - |
Payment_BusinessPartnerNamedefault | string | — | - |
Payment_ValueDatedefault | date | — | - |
Payment_CompanyIDdefault | string | — | - |
Payment_DocumentIDdefault | string | — | - |
Payment_BusinessPartnerIDdefault | string | — | - |
Payment_TransactionCurrencyAmountdefault | number | — | - |
Payment_PaymentTransactionStatusCodeTextdefault | 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.
Post Journal Entry
Post Journal Entry
Route: POST /mutation/journalEntryPost
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Profit Centres
The profit centres, by ID and UUID: what a line of the ledger is reported on.
Profit Centres
The profit centres, by ID and UUID: what a line of the ledger is reported on.
Route: GET /profitCentres
Formule Excel: =LF.sapbyd.profitCentres("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
UUIDdefault | string | — | - |
ObjectID | string | — | - |
IDdefault | 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.
Simulate Journal Entry
Simulate Journal Entry
Route: POST /mutation/journalEntrySimulate
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Submit Journal Entry
Submit Journal Entry
Route: POST /mutation/journalEntrySubmit
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Void Journal Entry
Discards a Not Posted voucher (life cycle 2 Void): nothing was posted, so nothing is reversed. Answers the voucher read back.
Void Journal Entry
Void Journal Entry
Route: POST /mutation/journalEntryVoid
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Logistics
Acknowledge Delivery Note
Records the receipt of the supplier’s delivery note (2 Received). Moves no stock. Answers the delivery read back.
Acknowledge Delivery Note
Acknowledge Delivery Note
Route: POST /mutation/inboundDeliveryAcknowledgeNote
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Approve Return
Approves a customer return In Approval. Answers it read back.
Approve Return
Approve Return
Route: POST /mutation/customerReturnApprove
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Cancel Outbound Delivery
Cancels an outbound delivery. Its goods issue is reversed by SAP.
Cancel Outbound Delivery
Cancel Outbound Delivery
Route: POST /mutation/outboundDeliveryCancel
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.customerReturns("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
CustomerReturn_IDdefault | string | — | - |
CustomerReturn_CurrencyCodedefault | string | — | - |
CustomerReturn_LifeCycleStatusCodeTextdefault | string | — | - |
CustomerReturn_GrossAmountdefault | number | — | - |
CustomerReturn_Namedefault | string | — | - |
CustomerReturn_DateTimedefault | date | — | - |
CustomerReturn_BuyerParty_PartyIDdefault | 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.
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
Formule Excel: =LF.sapbyd.inboundDeliveries("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
InboundDelivery_DeliveryProcessingStatusCodeTextdefault | string | — | - |
InboundDelivery_CreationDateTimedefault | date | — | - |
InboundDelivery_IDdefault | string | — | - |
InboundDelivery_ReleaseStatusCodeTextdefault | string | — | - |
InboundDelivery_ProcessingTypeCodeTextdefault | string | — | - |
InboundDelivery_SenderParty_PartyIDdefault | 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.
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
Formule Excel: =LF.sapbyd.inboundDeliveryRequests("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
InboundDeliveryRequest_BaseBusinessTransactionDocumentIDdefault | string | — | - |
UUID | string | — | - |
InboundDeliveryRequest_BaseBusinessDocumentTypeCode | string | — | - |
InboundDeliveryRequest_BaseBusinessDocumentTypeCodeTextdefault | 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.
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
Formule Excel: =LF.sapbyd.logisticsCodeLists("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
Descriptiondefault | string | — | - |
Codedefault | 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.
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
Formule Excel: =LF.sapbyd.materials("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | 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_BaseMeasureUnitCodedefault | string | — | - |
Material_BaseMeasureUnitCodeText | string | — | - |
Material_Descriptiondefault | string | — | - |
Material_PlanningMeasureUnitCode | string | — | - |
Material_PlanningMeasureUnitCodeText | string | — | - |
Material_ValuationLevelTypeCode | string | — | - |
Material_ValuationLevelTypeCodeText | string | — | - |
Material_CreationDateTime | date | — | - |
Material_InternalIDdefault | string | — | - |
Material_ProductCategory_ProductCategoryInternalIDdefault | 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.
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
Formule Excel: =LF.sapbyd.outboundDeliveries("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
OutboundDelivery_DeliveryProcessingStatusCodeTextdefault | string | — | - |
OutboundDelivery_ReleaseStatusCodeTextdefault | string | — | - |
OutboundDelivery_TypeCodeTextdefault | string | — | - |
OutboundDelivery_CreationDateTimedefault | date | — | - |
OutboundDelivery_IDdefault | string | — | - |
OutboundDelivery_ProductRecipientParty_PartyIDdefault | 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.
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
Formule Excel: =LF.sapbyd.outboundDeliveryRequestItems("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
OutboundDeliveryRequest_OrderFulfilmentProcessingStatusCode | string | — | - |
OutboundDeliveryRequest_OrderFulfilmentProcessingStatusCodeTextdefault | string | — | - |
OutboundDeliveryRequest_Item_ProductIDdefault | 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_BaseBusinessDocumentItemIDdefault | 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 | — | - |
ParentObjectIDdefault | 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.
Utilise comme filtre par
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
Formule Excel: =LF.sapbyd.outboundDeliveryRequests("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
OutboundDeliveryRequest_CreationDateTimedefault | date | — | - |
ObjectID | string | — | - |
OutboundDeliveryRequest_BaseBusinessTransactionDocumentIDdefault | string | — | - |
OutboundDeliveryRequest_BaseBusinessDocumentTypeCode | string | — | - |
OutboundDeliveryRequest_BaseBusinessDocumentTypeCodeTextdefault | 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).
Post Goods Issue
Post Goods Issue
Route: POST /mutation/outboundDeliveryRequestItemPostIssue
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Post Goods Receipt
Posts the goods receipt of an inbound delivery: the stock is increased.
Post Goods Receipt
Post Goods Receipt
Route: POST /mutation/inboundDeliveryPostReceipt
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Release Inbound Delivery
Releases an inbound delivery — with warehouse tasks when TaskBasedIndicator is true. Answers it read back.
Release Inbound Delivery
Release Inbound Delivery
Route: POST /mutation/inboundDeliveryRelease
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Release Outbound Delivery
Releases an outbound delivery once its goods issue is posted: the customer can be invoiced. Answers it read back.
Release Outbound Delivery
Release Outbound Delivery
Route: POST /mutation/outboundDeliveryRelease
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Request Return Follow-Up
Request Return Follow-Up
Route: POST /mutation/customerReturnRequestFollowUp
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Revoke Delivery Cancellation
Revokes the cancellation of an outbound delivery.
Revoke Delivery Cancellation
Revoke Delivery Cancellation
Route: POST /mutation/outboundDeliveryRevokeCancellation
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Set Delivery as Advised
Sets the delivery back to advised (1 Advised). Answers it read back.
Set Delivery as Advised
Set Delivery as Advised
Route: POST /mutation/inboundDeliverySetAdvised
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.locations("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
Location_LifeCycleStatusCodeTextdefault | string | — | - |
Location_IDdefault | string | — | - |
Location_SiteIndicatordefault | boolean | — | - |
Location_Namedefault | string | — | - |
Location_InventoryManagedLocationIndicatordefault | 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.
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
Formule Excel: =LF.sapbyd.stockMovementLines("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
GoodsAndActivityConfirmation_InventoryChangeReasonCodeTextdefault | string | — | - |
GoodsAndActivityConfirmation_TransferGroupIDdefault | string | — | - |
GoodsAndActivityConfirmation_StockTypeCodeTextdefault | string | — | - |
GoodsAndActivityConfirmation_InventoryMovementDirectionCodeTextdefault | string | — | - |
GoodsAndActivityConfirmation_InventoryChangeItem_IDdefault | string | — | - |
ParentObjectIDdefault | string | → stockMovements | - |
Location_Location_IDdefault | 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.
Utilise comme filtre par
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
Formule Excel: =LF.sapbyd.stockMovements("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
GoodsAndActivityConfirmation_DocumentReferenceTypeCodeTextdefault | string | — | - |
GoodsAndActivityConfirmation_IDdefault | string | — | - |
GoodsAndActivityConfirmation_CancellationDocumentIndicatordefault | boolean | — | - |
GoodsAndActivityConfirmation_TransactionDateTimedefault | date | — | - |
GoodsAndActivityConfirmation_DocumentReferenceIDdefault | string | — | - |
Submit Return for Approval
Submits a customer return for approval. Answers it read back.
Submit Return for Approval
Submit Return for Approval
Route: POST /mutation/customerReturnSubmit
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Production
Fix Planning Order
Fixes a proposal: planning no longer moves it. Not a release. Answers it read back.
Fix Planning Order
Fix Planning Order
Route: POST /mutation/productionPlanningOrderFix
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.productionCodeLists("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
Codedefault | string | — | - |
Descriptiondefault | 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.
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
Formule Excel: =LF.sapbyd.productionOrders("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
ProductionOrder_RequestedStartDateTimedefault | date | — | - |
ProductionOrder_LifeCycleStatusCodeTextdefault | string | — | - |
ProductionOrder_IDdefault | string | — | - |
ProductionOrder_SiteIDdefault | string | — | - |
ProductionOrder_MainProductOutput_ProductIDdefault | string | — | - |
ProductionOrder_MainProductOutput_PlannedQuantitydefault | number | — | - |
ProductionOrder_MainProductOutput_PlannedQuantityUnitCodedefault | string | — | - |
ProductionOrder_MainProductOutput_FulfilledQuantitydefault | number | — | - |
ProductionOrder_MainProductOutput_OpenQuantitydefault | number | — | - |
ProductionLot_IDdefault | 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.
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
Formule Excel: =LF.sapbyd.productionPlanningOrders("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
ProductionPlanningOrder_FixedIndicatordefault | boolean | — | - |
ProductionPlanningOrder_EndDateTimedefault | date | — | - |
ProductionPlanningOrder_LifeCycleStatusCodeTextdefault | string | — | - |
ProductionPlanningOrder_StartDateTimedefault | date | — | - |
ProductionPlanningOrder_IDdefault | string | — | - |
ProductionRequisition_IDdefault | 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.
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
Formule Excel: =LF.sapbyd.productionRequisitions("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
ObjectID | string | — | - |
ProductionRequisition_LifeCycleStatusCode | string | — | - |
ProductionRequisition_LifeCycleStatusCodeTextdefault | string | — | - |
ProductionRequisition_IDdefault | string | — | - |
Release Planning Order
Releases a proposal to production: SAP creates its production requisition (2 Execution Requested). Answers it read back.
Release Planning Order
Release Planning Order
Route: POST /mutation/productionPlanningOrderRelease
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Release Production Order
Release Production Order
Route: POST /mutation/productionOrderRelease
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Unfix Planning Order
Lets planning move a fixed proposal again. Answers it read back.
Unfix Planning Order
Unfix Planning Order
Route: POST /mutation/productionPlanningOrderUnfix
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Projects
Approve Time
Approves time In Approval. Answers the time sheet read back.
Approve Time
Approve Time
Route: POST /mutation/employeeTimeApprove
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Close Task
Closes a completed task (4 Closed): no more time or costs on it. Answers the task read back.
Close Task
Close Task
Route: POST /mutation/taskClose
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Create Project Baseline
Saves the current plan of the project as its baseline, to compare progress against. Answers the project read back.
Create Project Baseline
Create Project Baseline
Route: POST /mutation/projectCreateBaseline
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Discard Time Changes
Discards the pending changes of a time sheet. Answers it read back.
Discard Time Changes
Discard Time Changes
Route: POST /mutation/employeeTimeDiscard
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.employeeTimeItems("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
EmployeeTime_Item_ProjectElementIDdefault | string | — | - |
EmployeeTime_Item_Durationdefault | string | — | - |
ParentObjectIDdefault | string | → employeeTimes | - |
EmployeeTime_Item_ApprovalStatusCodeTextdefault | string | — | - |
EmployeeTime_Item_StartDatedefault | date | — | - |
EmployeeTime_Item_ProjectIDdefault | string | — | - |
EmployeeTime_Item_ServiceProductIDdefault | 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).
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
Formule Excel: =LF.sapbyd.employeeTimes("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
EmployeeTime_ApprovalStatusCode | string | — | - |
EmployeeTime_ApprovalStatusCodeTextdefault | string | — | - |
EmployeeTime_PlanningCategoryCode | string | — | - |
EmployeeTime_PlanningCategoryCodeText | string | — | - |
ObjectID | string | — | - |
EmployeeTime_CreationDateTime | date | — | - |
EmployeeTime_EmployeeFormattedNamedefault | string | — | - |
EmployeeTime_EmployeeIDdefault | string | — | - |
EmployeeTime_EmployeeTimeAgreementItemUUID | string | — | - |
EmployeeTime_LifeCycleStatusCode | string | — | - |
EmployeeTime_LifeCycleStatusCodeTextdefault | 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.
Employees
The employees of the tenant: ID and name — the people a project, a task or a time sheet names.
Route: GET /employees
Formule Excel: =LF.sapbyd.employees("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | 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_FamilyNamedefault | string | — | - |
Employee_BirthDate | date | — | - |
Employee_MiddleName | string | — | - |
Employee_BirthPlaceName | string | — | - |
Employee_NationalityCountryCode | string | — | - |
Employee_NationalityCountryCodeText | string | — | - |
ObjectID | string | — | - |
Employee_EmployeeIDdefault | string | — | - |
Employee_GivenNamedefault | string | — | - |
Employee_BirthName | string | — | - |
Employee_InternalID | string | — | - |
Employee_FormattedNamedefault | 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.
Finish Task
Finish Task
Route: POST /mutation/taskFinish
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.projectTasks("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
Project_Task_TaskIDdefault | string | — | - |
Project_Task_TaskNamedefault | string | — | - |
Project_Task_PlannedDurationdefault | string | — | - |
Project_Task_LifeCycleStatusCodeTextdefault | string | — | - |
Project_Task_ParentTaskIDdefault | string | — | - |
Project_Task_ResponsibleEmployeeIDdefault | string | — | - |
Create Project Task
Create Project Task
Route: POST /mutation/projectTasks
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Update Project Task
Update Project Task
Route: PATCH /mutation/projectTasks
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Utilise comme filtre par
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
Formule Excel: =LF.sapbyd.projects("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
Project_ProjectIDdefault | string | — | - |
Project_EstimatedCompletionPercentdefault | number | — | - |
Project_ProjectLifeCycleStatusCodeTextdefault | string | — | - |
Project_ProjectTypeCodeTextdefault | string | — | - |
Project_PlannedStartDateTimedefault | date | — | - |
Project_ResponsibleCostCentreIDdefault | string | — | - |
Project_PlannedEndDateTimedefault | date | — | - |
Project_SummaryTask_ProjectNamedefault | string | — | - |
Project_SummaryTask_ResponsibleEmployeeFormattedNamedefault | string | — | - |
Create Project
Create Project
Route: POST /mutation/projects
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Update Project
Update Project
Route: PATCH /mutation/projects
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.projectCodeLists("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
Descriptiondefault | string | — | - |
Codedefault | string | — | - |
Reject Time
Rejects time In Approval. Answers the time sheet read back.
Reject Time
Reject Time
Route: POST /mutation/employeeTimeReject
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Schedule Project
Has SAP compute the project’s dates from its tasks’ durations, constraints, dependencies and calendar. Answers the project read back.
Schedule Project
Schedule Project
Route: POST /mutation/projectSchedule
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Start and Release Project
Starts a project and releases it with its tasks (3 Released). Answers the project read back.
Start and Release Project
Start and Release Project
Route: POST /mutation/projectStartAndRelease
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Start Project
Start Project
Route: POST /mutation/projectStart
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Submit Time for Approval
Submits recorded time for approval. Answers the time sheet read back.
Submit Time for Approval
Submit Time for Approval
Route: POST /mutation/employeeTimeSubmit
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Purchasing
Accept Invoice Exception
Accepts a discrepancy SAP raised on a supplier invoice, so the invoice can proceed.
Accept Invoice Exception
Accept Invoice Exception
Route: POST /mutation/supplierInvoiceExceptionAccept
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Activate Supplier
Activates a supplier In Preparation (2 Active). Answers the supplier read back.
Activate Supplier
Activate Supplier
Route: POST /mutation/supplierActivate
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Approve Purchase Order
Approves a purchase order In Approval. Answers the order read back.
Approve Purchase Order
Approve Purchase Order
Route: POST /mutation/purchaseOrderApprove
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Block Supplier
Blocks an active supplier (3 Blocked). Answers the supplier read back.
Block Supplier
Block Supplier
Route: POST /mutation/supplierBlock
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Calculate Invoice Gross Amount
Has SAP calculate the gross amount of an invoice being entered. Answers the invoice read back.
Calculate Invoice Gross Amount
Calculate Invoice Gross Amount
Route: POST /mutation/supplierInvoiceCalculateGross
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Calculate Invoice Tax
Calculate Invoice Tax
Route: POST /mutation/supplierInvoiceCalculateTax
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Cancel Purchase Order
Cancels a purchase order not yet finished. Cancelling its receipt later does not cancel an invoice of it.
Cancel Purchase Order
Cancel Purchase Order
Route: POST /mutation/purchaseOrderCancel
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Confirm Purchase Order
Confirm Purchase Order
Route: POST /mutation/purchaseOrderConfirm
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Finish Invoice Entry
Finish Invoice Entry
Route: POST /mutation/supplierInvoiceFinishEntry
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Finish Receipt Entry
Finishes the data entry of a receipt In Preparation or In Revision (Preparation Finished). Answers the receipt read back.
Finish Receipt Entry
Finish Receipt Entry
Route: POST /mutation/goodsReceiptFinishEntry
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Flag Supplier as Obsolete
Flags a supplier obsolete (4 Obsolete): the record stays, and is no longer used. Answers the supplier read back.
Flag Supplier as Obsolete
Flag Supplier as Obsolete
Route: POST /mutation/supplierFlagObsolete
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.goodsReceipts("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
GoodsAndServiceAcknowledgement_CancellationDocumentIndicatordefault | boolean | — | - |
GoodsAndServiceAcknowledgement_IDdefault | string | — | - |
GoodsAndServiceAcknowledgement_LifeCycleStatusCodeTextdefault | string | — | - |
GoodsAndServiceAcknowledgement_PostingDatedefault | date | — | - |
GoodsAndServiceAcknowledgement_Datedefault | date | — | - |
GoodsAndServiceAcknowledgement_SellerParty_PartyIDdefault | string | — | - |
Post Supplier Invoice
Posts an invoice Ready for Posting or Approved: the payable reaches the ledger. Posting is not paying.
Post Supplier Invoice
Post Supplier Invoice
Route: POST /mutation/supplierInvoicePost
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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...
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
Formule Excel: =LF.sapbyd.purchaseOrderItems("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
PurchaseOrder_Item_IDdefault | string | — | - |
PurchaseOrder_Item_Quantitydefault | number | — | - |
PurchaseOrder_Item_DeliveryStatusCodeTextdefault | string | — | - |
PurchaseOrder_Item_NetAmountdefault | number | — | - |
PurchaseOrder_Item_ProductIDdefault | string | — | - |
PurchaseOrder_Item_NetAmountCurrencyCodedefault | string | — | - |
PurchaseOrder_Item_InvoicingStatusCodeTextdefault | string | — | - |
ParentObjectIDdefault | string | → purchaseOrders | - |
PurchaseOrder_Item_Descriptiondefault | string | — | - |
PurchaseOrder_Item_QuantityUnitCodedefault | 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.
Utilise comme filtre par
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
Formule Excel: =LF.sapbyd.purchaseOrders("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
PurchaseOrder_TotalNetAmountdefault | number | — | - |
PurchaseOrder_LifeCycleStatusCodeTextdefault | string | — | - |
PurchaseOrder_InvoicingStatusCodeTextdefault | string | — | - |
PurchaseOrder_CurrencyCodedefault | string | — | - |
PurchaseOrder_CreationDateTimedefault | date | — | - |
PurchaseOrder_IDdefault | string | — | - |
PurchaseOrder_DeliveryStatusCodeTextdefault | string | — | - |
PurchaseOrder_Supplier_PartyIDdefault | 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.
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
Formule Excel: =LF.sapbyd.purchasingCodeLists("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
Codedefault | string | — | - |
Descriptiondefault | string | — | - |
Reject Purchase Order
Rejects a purchase order In Approval. Answers the order read back.
Reject Purchase Order
Reject Purchase Order
Route: POST /mutation/purchaseOrderReject
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Release Receipt
Release Receipt
Route: POST /mutation/goodsReceiptRelease
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Revoke Supplier Obsolescence
Revoke Supplier Obsolescence
Route: POST /mutation/supplierRevokeObsolescence
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Send Back Purchase Order
Sends a purchase order In Approval back for revision. Answers the order read back.
Send Back Purchase Order
Send Back Purchase Order
Route: POST /mutation/purchaseOrderSendBack
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Submit Purchase Order for Ordering
Submit Purchase Order for Ordering
Route: POST /mutation/purchaseOrderOrder
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.supplierInvoiceExceptions("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
SupplierInvoiceException_LifeCycleStatusCode | string | — | - |
SupplierInvoiceException_LifeCycleStatusCodeTextdefault | string | — | - |
SupplierInvoiceException_ProcessingTypeCode | string | — | - |
SupplierInvoiceException_ProcessingTypeCodeTextdefault | string | — | - |
ObjectID | string | — | - |
SupplierInvoiceException_IDdefault | 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.
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
Formule Excel: =LF.sapbyd.supplierInvoiceItems("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
SupplierInvoice_Item_Quantitydefault | number | — | - |
SupplierInvoice_Item_NetAmountCurrencyCodedefault | string | — | - |
SupplierInvoice_Item_IDdefault | string | — | - |
ParentObjectIDdefault | string | → supplierInvoices | - |
SupplierInvoice_Item_Descriptiondefault | string | — | - |
SupplierInvoice_Item_NetAmountdefault | number | — | - |
SupplierInvoice_Item_QuantityUnitCodedefault | string | — | - |
SupplierInvoice_Item_ProductIDdefault | 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.
Utilise comme filtre par
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
Formule Excel: =LF.sapbyd.supplierInvoices("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
SupplierInvoice_TotalGrossAmountdefault | number | — | - |
SupplierInvoice_TypeCodeTextdefault | string | — | - |
SupplierInvoice_TotalGrossAmountCurrencyCodedefault | string | — | - |
SupplierInvoice_LifeCycleStatusCodeTextdefault | string | — | - |
SupplierInvoice_IDdefault | string | — | - |
SupplierInvoice_InvoiceDatedefault | date | — | - |
SupplierInvoice_SellerParty_PartyIDdefault | string | — | - |
SupplierInvoice_ExternalReference_IDdefault | 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.
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
Formule Excel: =LF.sapbyd.suppliers("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
Supplier_LifeCycleStatusCode | string | — | - |
Supplier_LifeCycleStatusCodeTextdefault | string | — | - |
Supplier_ABCClassificationCode | string | — | - |
Supplier_ABCClassificationCodeTextdefault | string | — | - |
Supplier_SortingFormattedName | string | — | - |
Supplier_SecondLineName | string | — | - |
Supplier_CreationDateTime | date | — | - |
ObjectID | string | — | - |
Supplier_IndustrialSectorCode | string | — | - |
Supplier_IndustrialSectorCodeText | string | — | - |
Supplier_LegalCompetenceIndicator | boolean | — | - |
Supplier_InternalIDdefault | string | — | - |
Supplier_BusinessPartnerFormattedNamedefault | 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.
Unblock Supplier
Unblock Supplier
Route: POST /mutation/supplierUnblock
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Withdraw Purchase Order
Withdraws a purchase order from approval, back to its buyer. Answers the order read back.
Withdraw Purchase Order
Withdraw Purchase Order
Route: POST /mutation/purchaseOrderWithdraw
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Accept Lead
Accept Lead
Route: POST /mutation/leadAccept
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Activate Customer
Activates a customer In Preparation (2 Active). Answers the customer read back.
Activate Customer
Activate Customer
Route: POST /mutation/customerActivate
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Approve Quote
Approves a quote In Approval. Answers it read back.
Approve Quote
Approve Quote
Route: POST /mutation/customerQuoteApprove
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Block Customer
Blocks an active customer (3 Blocked). Answers the customer read back.
Block Customer
Block Customer
Route: POST /mutation/customerBlock
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.businessPartners("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
BusinessPartner_InternalIDdefault | string | — | - |
BusinessPartner_PersonMiddleName | string | — | - |
BusinessPartner_LifeCycleStatusCode | string | — | - |
BusinessPartner_LifeCycleStatusCodeTextdefault | string | — | - |
BusinessPartner_PersonFamilyName | string | — | - |
BusinessPartner_PersonMaritalStatusCode | string | — | - |
BusinessPartner_PersonMaritalStatusCodeText | string | — | - |
BusinessPartner_CategoryCode | string | — | - |
BusinessPartner_CategoryCodeTextdefault | 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_BusinessPartnerFormattedNamedefault | 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 Invoices
Create Invoices
Route: POST /mutation/invoiceRequestCreateInvoices
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Customer Invoice Items
The lines of the customer invoices: product, description, quantity and unit, net, tax and gross amounts.
Customer Invoice Items
The lines of the customer invoices: product, description, quantity and unit, net, tax and gross amounts.
Route: GET /customerInvoiceItems
Formule Excel: =LF.sapbyd.customerInvoiceItems("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
CustomerInvoice_Item_Quantitydefault | number | — | - |
CustomerInvoice_Item_ProductIDdefault | string | — | - |
CustomerInvoice_Item_NetAmountdefault | number | — | - |
ParentObjectIDdefault | string | → customerInvoices | - |
CustomerInvoice_Item_QuantityUnitCodedefault | string | — | - |
CustomerInvoice_Item_NetAmountCurrencyCodedefault | string | — | - |
CustomerInvoice_Item_IDdefault | string | — | - |
CustomerInvoice_Item_Descriptiondefault | 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.
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
Formule Excel: =LF.sapbyd.invoiceRequests("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
CustomerInvoiceRequest_BuyerPartyIDdefault | string | — | - |
CustomerInvoiceRequest_Namedefault | string | — | - |
CustomerInvoiceRequest_ProposedInvoiceDatedefault | date | — | - |
CustomerInvoiceRequest_TotalNetAmountCurrencyCodedefault | string | — | - |
CustomerInvoiceRequest_LifeCycleStatusCodeTextdefault | string | — | - |
CustomerInvoiceRequest_InvoicingStatusCodeTextdefault | string | — | - |
CustomerInvoiceRequest_TotalNetAmountdefault | number | — | - |
CustomerInvoiceRequest_BaseBusinessTransactionDocumentIDdefault | 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.
Utilise comme filtre par
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
Formule Excel: =LF.sapbyd.customerInvoices("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
CustomerInvoice_TotalGrossAmountdefault | number | — | - |
CustomerInvoice_IDdefault | string | — | - |
CustomerInvoice_ReleaseStatusCodeTextdefault | string | — | - |
CustomerInvoice_Datedefault | date | — | - |
CustomerInvoice_ProcessingTypeCodeTextdefault | string | — | - |
CustomerInvoice_TotalGrossAmountCurrencyCodedefault | string | — | - |
CustomerInvoice_BuyerParty_PartyIDdefault | 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.
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
Formule Excel: =LF.sapbyd.customerQuotes("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
CustomerQuote_NetAmountdefault | number | — | - |
CustomerQuote_CurrencyCodedefault | string | — | - |
CustomerQuote_Descriptiondefault | string | — | - |
CustomerQuote_DateTimedefault | date | — | - |
CustomerQuote_LifeCycleStatusCodeTextdefault | string | — | - |
CustomerQuote_ApprovalStatusCodeTextdefault | string | — | - |
CustomerQuote_IDdefault | string | — | - |
CustomerQuote_BuyerParty_PartyIDdefault | 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.
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
Formule Excel: =LF.sapbyd.customers("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
Customer_InternalIDdefault | string | — | - |
Customer_CategoryCodeTextdefault | string | — | - |
Customer_OrderBlockingReasonCodeTextdefault | string | — | - |
Customer_LifeCycleStatusCodeTextdefault | string | — | - |
Customer_BusinessPartnerFormattedNamedefault | string | — | - |
Finish Sales Order Fulfilment
Finishes the fulfilment of every line: nothing more is delivered or performed for it. Answers the order read back.
Finish Sales Order Fulfilment
Finish Sales Order Fulfilment
Route: POST /mutation/salesOrderFinishFulfilment
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Flag Customer as Obsolete
Flags a customer obsolete (4 Obsolete): the record stays, and is no longer used. Answers the customer read back.
Flag Customer as Obsolete
Flag Customer as Obsolete
Route: POST /mutation/customerFlagObsolete
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Hand Over Lead
Hands a lead over from marketing to sales. SAP may answer success and keep it Open: read the status back.
Hand Over Lead
Hand Over Lead
Route: POST /mutation/leadHandOver
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.leads("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
Lead_QualificationLevelCodeTextdefault | string | — | - |
Lead_Descriptiondefault | string | — | - |
Lead_IDdefault | string | — | - |
Lead_LifeCycleStatusCodeTextdefault | string | — | - |
Lead_StartDatedefault | date | — | - |
Lead_ProspectParty_PartyIDdefault | string | — | - |
Lose Opportunity
Marks an opportunity lost (5 Lost). Answers it read back.
Lose Opportunity
Lose Opportunity
Route: POST /mutation/opportunityLose
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.opportunities("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
Opportunity_ExpectedRevenueAmountCurrencyCodedefault | string | — | - |
Opportunity_Descriptiondefault | string | — | - |
Opportunity_LifeCycleStatusCodeTextdefault | string | — | - |
Opportunity_ExpectedRevenueAmountdefault | number | — | - |
Opportunity_SalesPhaseCodeTextdefault | string | — | - |
Opportunity_ChanceOfSuccessPercentdefault | number | — | - |
Opportunity_IDdefault | string | — | - |
Opportunity_ProspectParty_PartyIDdefault | string | — | - |
Process Opportunity
Starts working an open opportunity (2 In Process). Answers it read back.
Process Opportunity
Process Opportunity
Route: POST /mutation/opportunityProcess
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Reject Lead
Rejects a lead (5 Rejected). Answers the lead read back.
Reject Lead
Reject Lead
Route: POST /mutation/leadReject
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Release Customer Invoice
Releases a customer invoice: it is posted to accounting and can be sent. Answers it read back.
Release Customer Invoice
Release Customer Invoice
Route: POST /mutation/customerInvoiceRelease
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Release Invoice Request
Releases an invoice request In Preparation, so it can be invoiced. Answers it read back.
Release Invoice Request
Release Invoice Request
Route: POST /mutation/invoiceRequestRelease
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Release Sales Order
Release Sales Order
Route: POST /mutation/salesOrderRelease
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Release Sales Order to Execution
Releases every line of the order to execution — delivery, service or project. Answers the order read back.
Release Sales Order to Execution
Release Sales Order to Execution
Route: POST /mutation/salesOrderReleaseToExecution
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Reopen Opportunity
Reopens a stopped, won or lost opportunity. Answers it read back.
Reopen Opportunity
Reopen Opportunity
Route: POST /mutation/opportunityReopen
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
Revoke Customer Obsolescence
Revoke Customer Obsolescence
Route: POST /mutation/customerRevokeObsolescence
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.salesCodeLists("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
Descriptiondefault | string | — | - |
Codedefault | string | — | - |
Sales Order Items
The lines of the sales orders: product, description, net amount, processing type, and their release, fulfilment, invoicing and cancellation statuses.
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
Formule Excel: =LF.sapbyd.salesOrderItems("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
ParentObjectIDdefault | string | → salesOrders | - |
SalesOrder_Item_NetAmountdefault | number | — | - |
SalesOrder_Item_IDdefault | string | — | - |
SalesOrder_Item_FulfilmentProcessingStatusCodeTextdefault | string | — | - |
SalesOrder_Item_Descriptiondefault | string | — | - |
SalesOrder_Item_NetAmountCurrencyCodedefault | string | — | - |
SalesOrder_Item_ProcessingTypeCodeTextdefault | string | — | - |
SalesOrder_ItemProduct_ProductIDdefault | 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.
Utilise comme filtre par
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
Formule Excel: =LF.sapbyd.salesOrders("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
SalesOrder_InvoiceStatusCodeTextdefault | string | — | - |
SalesOrder_Namedefault | string | — | - |
SalesOrder_NetAmountCurrencyCodedefault | string | — | - |
SalesOrder_NetAmountdefault | number | — | - |
SalesOrder_DeliveryStatusCodeTextdefault | string | — | - |
SalesOrder_IDdefault | string | — | - |
SalesOrder_LifeCycleStatusCodeTextdefault | string | — | - |
SalesOrder_BuyerParty_PartyIDdefault | string | — | - |
Send Back Quote
Sends a quote In Approval back for revision. Answers it read back.
Send Back Quote
Send Back Quote
Route: POST /mutation/customerQuoteSendBack
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Send Order Confirmation
Sends the order confirmation to the customer — an output (email or print), not an internal validation.
Send Order Confirmation
Send Order Confirmation
Route: POST /mutation/salesOrderSendConfirmation
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Stop Opportunity
Stops an opportunity (3 Stopped). Answers it read back.
Stop Opportunity
Stop Opportunity
Route: POST /mutation/opportunityStop
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Submit Quote for Approval
Submits a quote for approval (3 In Approval). Answers it read back.
Submit Quote for Approval
Submit Quote for Approval
Route: POST /mutation/customerQuoteSubmit
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Unblock Customer
Unblocks a blocked customer (2 Active). Answers the customer read back.
Unblock Customer
Unblock Customer
Route: POST /mutation/customerUnblock
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Unblock Sales Order Fulfilment
Lifts the delivery block of a sales order. Answers it read back.
Unblock Sales Order Fulfilment
Unblock Sales Order Fulfilment
Route: POST /mutation/salesOrderUnblockFulfilment
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Win Opportunity
Marks an opportunity won (4 Won). Answers it read back.
Win Opportunity
Win Opportunity
Route: POST /mutation/opportunityWin
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Service
Complete Service Request
Completes a request (3 Completed). Closing it is SAP’s next step. Answers it read back.
Complete Service Request
Complete Service Request
Route: POST /mutation/serviceRequestComplete
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Release Service Order
Releases a service order. Answers it read back.
Release Service Order
Release Service Order
Route: POST /mutation/serviceOrderRelease
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Release Service Order to Execution
Releases every line of the service order to execution: its work can be confirmed. Answers the order read back.
Release Service Order to Execution
Release Service Order to Execution
Route: POST /mutation/serviceOrderReleaseToExecution
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
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.
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
Formule Excel: =LF.sapbyd.serviceConfirmations("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
ServiceConfirmation_BuyerIDdefault | string | — | - |
ServiceConfirmation_IDdefault | string | — | - |
ServiceConfirmation_ItemListInvoiceProcessingStatusCodeTextdefault | string | — | - |
ServiceConfirmation_Namedefault | string | — | - |
ServiceConfirmation_ItemListFulfilmentProcessingStatusCodeTextdefault | string | — | - |
ServiceConfirmation_DateTimedefault | 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.
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
Formule Excel: =LF.sapbyd.serviceOrders("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
ServiceOrder_NetAmountdefault | number | — | - |
ServiceOrder_LifeCycleStatusCodeTextdefault | string | — | - |
ServiceOrder_BuyerIDdefault | string | — | - |
ServiceOrder_CurrencyCodedefault | string | — | - |
ServiceOrder_Namedefault | string | — | - |
ServiceOrder_DateTimedefault | date | — | - |
ServiceOrder_ReleaseStatusCodeTextdefault | string | — | - |
ServiceOrder_IDdefault | 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.
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
Formule Excel: =LF.sapbyd.serviceRequests("selection", "fields")
Entrees configurables
Donnees retournees dans Excel
Field | Type | Relations | Description |
|---|---|---|---|
iddefault | id | — | - |
ServiceRequest_ServiceRequestLifeCycleStatusCodeTextdefault | string | — | - |
ServiceRequest_CreationDateTimedefault | date | — | - |
ServiceRequest_Namedefault | string | — | - |
ServiceRequest_RequestAssignmentStatusCodeTextdefault | string | — | - |
ServiceRequest_IDdefault | string | — | - |
ServiceRequest_Buyer_PartyIDdefault | string | — | - |
Start Service Request
Starts processing an open request (2 In Process). Answers it read back.
Start Service Request
Start Service Request
Route: POST /mutation/serviceRequestStart
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.
Take Over Service Request
Takes the request over for processing, as the signed-in user. Answers it read back.
Take Over Service Request
Take Over Service Request
Route: POST /mutation/serviceRequestTakeOver
Entrees configurables
Donnees retournees dans Excel
Cette action retourne une confirmation plutot qu une table selectionnable.