SAP Ariba connector specifications

Integrate with SAP Ariba to review and approve requestions requests without requiring any additional logins.

Version details

Citrix microapps supports the latest SAP Ariba APIs.

Endpoints

Note:

Custom endpoints are not supported.

GET

/api/approval/v1/prod/changes
/api/approval/v1/prod/requisitions/
/api/approval/v1/prod/requisitions/attachments
/api/approval/v1/prod/invoices/

POST

/api.ariba.com/v2/oauth/token
/api/approval/v1/

Service Actions

  • Approve Requisition - sets state of requisition to approved
  • Deny Requisition - sets state of requisition to denied

Key Entities

The following are the main business entities that this connector addresses:

  • requisitiondetails
  • approvers

Entities with Attributes

The following is a full list of entities and their attributes (SAP Ariba v.0.1.0):

approval_record (List of Approval records)

  • id: STRING(40), PK
  • user_id: STRING(40), FK(user.unique_name)
  • date: LONG
  • action: STRING(100)
  • summary: STRING(256)
  • requisition_id: STRING(40), FK(requisition_detail.unique_name)
  • type: STRING(100)
  • comment: STRING(100)

approval_request (List of Approval requests)

  • id: STRING(40), PK
  • state: STRING(40)
  • approval_state: STRING(40)
  • approval_required: BOOLEAN
  • approver: STRING(256)
  • requisition_id: STRING(40), FK(requisition_detail.unique_name)
  • reason: STRING(256)

approver (List of Approvers)

  • id: STRING(40)
  • approver_id: STRING(40), PK
  • requisition_id: STRING(40), FK(requisition_detail.unique_name)
  • approval_request_id: STRING(40), FK(approval_request.id)
  • type: STRING(40)
  • user_id: STRING(40), FK(user.unique_name)
  • user_email: STRING(40)
  • password_adapter: STRING(100)
  • approval_required: BOOLEAN
  • approval_state: STRING(40)
  • reason: STRING(256)
  • state: STRING(40)

change (List of Changes)

  • id: STRING(40), PK
  • approvable_unique_name: STRING(40), FK(requisition_detail.unique_name)
  • realm: STRING(100)
  • change_sequence_id: INTEGER(x32)
  • change_parameters: STRING(256)
  • change_type: STRING(40)
  • rest_resource_name: STRING(40)

comment (List of comments)

  • id: STRING(40), PK
  • date: DATE
  • attached_to_line: LONG
  • text: STRING(1000)
  • requisition_id: STRING(40), FK(requisition_detail.unique_name)
  • user_id: STRING(40), FK(user.unique_name)

dependency_approval_request (List of Dependency Approval requests)

  • parent_approval_request_id: STRING(40), PK, FK(approval_request.id)
  • approval_request_id: STRING(40), PK, FK(approval_request.id)

group (List of groups)

  • id: STRING(40), PK
  • unique_name: STRING(100)
  • approval_required: BOOLEAN
  • approval_state: STRING(40)
  • reason: STRING(256)
  • state: STRING(40)

invoice_approval_request (List of Invoice Approval Requests)

  • id: STRING(100), PK
  • creator: STRING(40)
  • approver_comment: STRING(256)
  • last_modified: DATE
  • state: STRING(40)
  • approval_required: BOOLEAN
  • approver: STRING(40)
  • approved_by: STRING(40)
  • invoice_id: STRING(40), FK(invoice_detail.unique_name)

invoice_detail (List of Invoice Details)

  • unique_name: STRING(40), PK
  • category: INTEGER(x32)
  • requester: STRING(40)
  • invoice_submission_method: STRING(40)
  • submit_date: DATETIME
  • invoice_purpose: STRING(40)
  • last_modified: DATETIME
  • invoice_number: INTEGER(x32)
  • invoice_date: DATETIME
  • status: STRING(40)
  • invoice_state: STRING(40)
  • total_invoiced_amount: FLOAT(prec=2, scale=0)
  • total_invoiced_currency: STRING(40)

invoice_line_item (List of Invoice Line items)

  • id: STRING(100), PK
  • commodity_code: STRING(40)
  • commodity_name: STRING(100)
  • original_price: FLOAT(prec=2, scale=0)
  • invoice_line_number: INTEGER(x32)
  • category: INTEGER(x32)
  • quantity: INTEGER(x32)
  • amount: FLOAT(prec=2, scale=0)
  • amount_currency: STRING(40)
  • invoice_id: STRING(40), FK(invoice_detail.unique_name)

line_item (List of Line items)

  • id: STRING(40), PK
  • cost_amount: FLOAT(prec=24, scale=4)
  • currency: STRING(40)
  • common_commodity_code: STRING(256)
  • deliver_to: STRING(100)
  • need_by: STRING(100)
  • number_in_collection: INTEGER(x32)
  • quantity: INTEGER(x32)
  • requisition_id: STRING(40), FK(requisition_detail.unique_name)
  • split_accounting_type: STRING(100)
  • supplier_name: STRING(100)
  • short_name: STRING(256)
  • description: STRING(1000)
  • unit_of_measure: STRING(40)
  • price_amount: FLOAT(prec=24, scale=4)
  • price_currency: STRING(40)
  • account_category_desc: STRING(256)
  • account_category_name: STRING(100)

line_item_accounting (List of Line item Accountings)

  • id: STRING(40), PK
  • line_item_id: STRING(40), FK(line_item.id)
  • requisition_id: STRING(40), FK(requisition_detail.unique_name)
  • number_in_collection: INTEGER(x32)
  • percentage: FLOAT(prec=24, scale=4)
  • cost_center_name: STRING(100)
  • cost_center_description: STRING(256)
  • general_ledger_name: STRING(100)
  • general_ledger_description: STRING(256)

requisition_detail (List of Requisition Details)

  • unique_name: STRING(40), PK
  • requester_id: STRING(40), FK(user.unique_name)
  • active_approval_request_ids: STRING(256)
  • is_pinned: BOOLEAN
  • active_approver_count: INTEGER(x32)
  • submit_date: LONG
  • title: STRING(100)
  • first_active_approver_name: STRING(100)
  • version: INTEGER(x32)
  • line_item_count: INTEGER(x32)
  • site: STRING(100)
  • requester_name: STRING(100)
  • status_string: STRING(100)
  • time_updated: LONG
  • realm: STRING(100)
  • last_modified: LONG
  • total_cost_amount: FLOAT(prec=24, scale=4)
  • total_cost_currency: STRING(40)

user (List of Users)

  • unique_name: STRING(40), PK
  • name: STRING(100)
  • email_address: STRING(100)
  • password_adapter: STRING(100)
  • realm: STRING(100)
  • phone: STRING(100)

user_group (Relations between users and groups)

  • user_id: STRING(40), PK, FK(user.unique_name)
  • group_id: STRING(40), PK, FK(group.id)

SAP Ariba connector specifications