Power BI Connector for SAP Ariba Procurement

Build 25.0.9454

ContractRequestLineItems

Retrieves contract request line item information.

Table-Specific Information

Select

The connector uses the SAP Ariba API to process WHERE clause conditions that are built with the following column and operators:

  • ContractRequestUniqueName supports the '=,IN' comparison operators.

For example, the following queries are processed server-side: 

SELECT * FROM [ContractRequestLineItems]
SELECT * FROM [ContractRequestLineItems] WHERE [ContractRequestUniqueName] = 'CR10'

The connector processes other filters client-side within the connector.

Insert

You can use the following columns to create (insert) a new record:

  • ContractRequestUniqueName
  • NumberInCollection
  • StartDate
  • EndDate
  • AccountType
  • AccountCategory
  • ShipTo
  • IsHardReleaseMaximum
  • IsHardReleaseMinimum
  • IsRecurring
  • CompoundPricingTerms
  • RollUpAccumulatorsToParent
  • ShouldDefaultAccounting
  • LimitType
  • MaxAmount
  • MaxAmountCurrencyUniqueName
  • MaxAmountTolerancePercent
  • MinAmount
  • MinAmountCurrencyUniqueName
  • MaxReleaseAmount
  • MaxReleaseAmountCurrencyUniqueName
  • MinReleaseAmount
  • MinReleaseAmountCurrencyUniqueName
  • MaxQuantity
  • MaxQuantityTolerancePercent
  • MinQuantity
  • MaxReleaseQuantity
  • MinReleaseQuantity
  • MaxReleaseTolerancePercent
  • CatalogSubscription
  • CommodityCodeUniqueName
  • CommodityCodeDomain
  • LineTypeUniqueName
  • Description
  • DescriptionCommonCommodityCodeUniqueName
  • DescriptionCommonCommodityCodeDomain
  • DescriptionPriceAmount
  • DescriptionPriceCurrencyUniqueName
  • DescriptionSupplierPartAuxiliaryId
  • DescriptionSupplierPartNumber
  • DescriptionUnitOfMeasureUniqueName
  • AccountingsSplitAccountings

INSERT INTO [ContractRequestLineItems] ([ContractRequestUniqueName], [NumberInCollection], [LineTypeUniqueName], [Description], [LimitType]) VALUES ('CR19', '19', '_CatalogItem', 'Custom description.', 'Amount')

Update

You can use the following columns to update a record:

  • StartDate
  • EndDate
  • AccountType
  • AccountCategory
  • ShipTo
  • IsHardReleaseMaximum
  • IsHardReleaseMinimum
  • IsRecurring
  • CompoundPricingTerms
  • RollUpAccumulatorsToParent
  • ShouldDefaultAccounting
  • LimitType
  • MaxAmount
  • MaxAmountCurrencyUniqueName
  • MaxAmountTolerancePercent
  • MinAmount
  • MinAmountCurrencyUniqueName
  • MaxReleaseAmount
  • MaxReleaseAmountCurrencyUniqueName
  • MinReleaseAmount
  • MinReleaseAmountCurrencyUniqueName
  • MaxQuantity
  • MaxQuantityTolerancePercent
  • MinQuantity
  • MaxReleaseQuantity
  • MinReleaseQuantity
  • MaxReleaseTolerancePercent
  • CatalogSubscription
  • CommodityCodeUniqueName
  • CommodityCodeDomain
  • LineTypeUniqueName
  • Description
  • DescriptionCommonCommodityCodeUniqueName
  • DescriptionCommonCommodityCodeDomain
  • DescriptionPriceAmount
  • DescriptionPriceCurrencyUniqueName
  • DescriptionSupplierPartAuxiliaryId
  • DescriptionSupplierPartNumber
  • DescriptionUnitOfMeasureUniqueName
  • AccountingsSplitAccountings

UPDATE [ContractRequestLineItems] SET [Description] = 'test' WHERE ([ContractRequestUniqueName] = 'CR12') AND ([NumberInCollection] = 1)

Delete

You can specify the following columns to delete a record:

  • ContractRequestUniqueName
  • NumberInCollection

DELETE FROM [ContractRequestLineItems] WHERE [ContractRequestUniqueName] = 'CR12' AND [NumberInCollection] = '1'

Columns

Name Type ReadOnly References Description
ContractRequestUniqueName [KEY] String False

ContractRequests.UniqueName

The unique identifier of the contract request that contains these line items.

NumberInCollection [KEY] Int False

Line number within the contract request.

ParentLineNumber Int True

Line number of the parent line item for this line item.

ERPLineItemNumber String True

The line item number from the ERP system.

StartDate Datetime False

Start date for this line item.

EndDate Datetime False

End date for this line item.

AccountType String False

This account type of the line item.

AccountCategory String False

Account category name for SAP ERPs.

ItemCategory String True

Item category name for SAP ERPs.

BillingAddress String True

The corporate billing address.

ShipTo String False

Address where ordered items should be shipped.

HideAmount Boolean True

This field value determines whether the Amount value in BPOs is hidden from suppliers in the Ariba Network.

HideUnitPrice Boolean True

This field value determines whether the Unit Price value in BPOs is hidden from suppliers in the Ariba Network.

IsHardReleaseMaximum Boolean False

Specifies whether MaxReleaseAmount/MaxReleaseQuantity is a hard constraint or not.

IsHardReleaseMinimum Boolean False

The minimum quantity for each releases for this line item.

IsObsolete Boolean True

Specifies whether the item is obsolete or not. If item is obsolete, it doesn't get shown on the UI, but is retained. It is also impossible to create new releases on an obsolete item.

IsRecurring Boolean False

Indicates whether the review period recurs at a specified frequency within the date range specified by contract StartDate and EndDate.

CompoundPricingTerms Boolean False

Boolean to indicate if the subagreement wants its pricing to be compounded with the parent, this will be visible in the UI based on the parent's pricing term.

RollUpAccumulatorsToParent Boolean False

Indicates if subagreement spend should be rolled up to the parent.

ShouldDefaultAccounting Boolean False

Indicates if accounting fields should be defaulted from user profile and CEME.

LimitType String False

How the limit is determined (Amount or Quantity).

The allowed values are Amount, Quantity.

Amount Decimal True

Forecasted amount for this line item. For catalog items, this value is automatically populated from the catalog.

AmountCurrencyName String True

Currency name for the line item amount.

AmountCurrencyUniqueName String True

Unique identifier of the currency for the line item amount.

MaxAmount Decimal False

Maximum amount for releases against this line item.

MaxAmountCurrencyName String True

Currency name for the maximum amount.

MaxAmountCurrencyUniqueName String False

Unique identifier of the currency for the maximum amount.

MaxAmountTolerancePercent Decimal False

Tolerance percentage above maximum amount before moving to closed state.

MinAmount Decimal False

Minimum amount committed for this line item.

MinAmountCurrencyName String True

Currency name for the minimum amount.

MinAmountCurrencyUniqueName String False

Unique identifier of the currency for the minimum amount.

MaxReleaseAmount Decimal False

Maximum amount per release for this line item.

MaxReleaseAmountCurrencyName String True

Currency name for the maximum release amount.

MaxReleaseAmountCurrencyUniqueName String False

Unique identifier of the currency for the maximum release amount.

MinReleaseAmount Decimal False

Minimum amount per release for this line item.

MinReleaseAmountCurrencyName String True

Currency name for the minimum release amount.

MinReleaseAmountCurrencyUniqueName String False

Unique identifier of the currency for the minimum release amount.

ExpectedValueAmount Decimal True

Expected cost for SAP service line items.

ExpectedValueCurrencyName String True

Currency name for the expected value.

ExpectedValueCurrencyUniqueName String True

Unique identifier of the currency for the expected value.

OverallLimitAmount Decimal True

Maximum amount for SAP service line items.

OverallLimitCurrencyName String True

Currency name for the overall limit.

OverallLimitCurrencyUniqueName String True

Unique identifier of the currency for the overall limit.

MaxQuantity Decimal False

Maximum cumulative quantity for all releases of this line item.

MaxQuantityTolerancePercent Decimal False

Tolerance percentage above maximum quantity.

MinQuantity Decimal False

Minimum cumulative quantity for all releases of this line item.

MaxReleaseQuantity Decimal False

Maximum quantity per release for this line item.

MinReleaseQuantity Decimal False

Minimum quantity per release for this line item.

MaxReleaseTolerancePercent Decimal False

Maximum tolerance percentage per release.

CatalogSubscription String False

Catalog subscription name for retrieving catalog subscription.

CommodityCodeName String True

Name of the commodity code for this line item.

CommodityCodeUniqueName String False

Unique identifier of the commodity code for this line item.

CommodityCodeDomain String False

Domain value for the commodity code.

LineTypeName String True

Name of the line type.

LineTypeUniqueName String False

Unique identifier of the line type.

LineTypeCategory Int True

Category of the line type.

Description String False

Description text of the product.

DescriptionClassificationCodeAux String True

Classification code auxiliary for the product description.

DescriptionCommonCommodityCodeName String True

Name of the common commodity code.

DescriptionCommonCommodityCodeUniqueName String False

Unique identifier of the common commodity code.

DescriptionCommonCommodityCodeDomain String False

Domain of the common commodity code.

DescriptionContractPriceAmount Decimal True

Contract price amount for the product.

DescriptionContractPriceCurrencyName String True

Currency name for the contract price.

DescriptionContractPriceCurrencyUniqueName String True

Unique identifier of the currency for the contract price.

DescriptionCustomPriceAmount Decimal True

Custom catalog price amount for the product.

DescriptionCustomPriceCurrencyName String True

Currency name for the custom price.

DescriptionCustomPriceCurrencyUniqueName String True

Unique identifier of the currency for the custom price.

DescriptionIndexContractPriceAmount Decimal True

Index contract price amount for the product.

DescriptionIndexContractPriceCurrencyName String True

Currency name for the index contract price.

DescriptionIndexContractPriceCurrencyUniqueName String True

Unique identifier of the currency for the index contract price.

DescriptionLanguage String True

Language for the product description.

DescriptionLeadTime Int True

Lead time for the product.

DescriptionManName String True

Manufacturer name for the product.

DescriptionManPartNumber String True

Manufacturer part number for the product.

DescriptionManURL String True

Manufacturer URL for the product.

DescriptionNonContractPriceAmount Decimal True

Non-contract price amount for the product.

DescriptionNonContractPriceCurrencyName String True

Currency name for the non-contract price.

DescriptionNonContractPriceCurrencyUniqueName String True

Unique identifier of the currency for the non-contract price.

DescriptionPriceAmount Decimal False

Catalog price amount for the product.

DescriptionPriceCurrencyName String True

Currency name for the catalog price.

DescriptionPriceCurrencyUniqueName String False

Unique identifier of the currency for the catalog price.

DescriptionShortName String True

Short description of the product.

DescriptionSupplierPartAuxiliaryId String False

Supplier part auxiliary ID for the product.

DescriptionSupplierPartNumber String False

Supplier part number for the product.

DescriptionSupplierURL String True

Supplier URL for the product.

DescriptionUnitOfMeasureName String True

Name of the unit of measure.

DescriptionUnitOfMeasureUniqueName String False

Unique identifier of the unit of measure.

DescriptionCommonSupplierName String True

Name of the common supplier.

DescriptionCommonSupplierSystemId String True

System ID of the common supplier.

MilestoneNotificationDays Int True

Days to notify before completion.

MilestoneSupplierContact String True

Supplier contact that the user should contact to verify the milestone completion.

MilestoneTitle String True

The title of this milestone.

MilestoneVerifierGroup String True

Group type verifier field.

MilestoneVerifierUserName String True

Name of the verifier user.

MilestoneVerifierUserUniqueName String True

Unique identifier of the verifier user.

MilestoneVerifierUserPasswordAdapter String True

Password adapter of the verifier user.

AccountingsSplitAccountings String False

Split accounting information for this line item.

PricingInfoPricingTermsType String True

Pricing structure type (DiscountedPrice, DiscountedPercent, etc.).

PricingInfoDiscountedPriceAmount Decimal True

Amount for this term.

PricingInfoDiscountedPriceCurrencyName String True

Currency name for the term amount.

PricingInfoDiscountedPriceCurrencyUniqueName String True

Unique identifier of the currency for the term amount.

PricingInfoDiscountPercent Decimal True

Discount percentage applied to the base price.

TierPricingInfoPricingTermsType String True

Tier-based pricing structure type (TierBasedPricingTerms).

TierPricingInfoTierType String True

Tier basis for pricing calculation (Amount, Quantity).

TierPricingInfoTierValueType String True

Type of tier value calculation (Price, Percent).

TierPricingInfoIsTierPricingCumulative String True

Whether tier pricing applies cumulatively across tiers (Yes/No).

TierPricingInfoAmountCurrencyName String True

Currency name for the term amounts.

TierPricingInfoAmountCurrencyUniqueName String True

Unique identifier of the currency for the term amount.

TierPricingInfoTieredPricingSteps String True

Pricing steps with TierValue and MinTierValue thresholds.

TermPricingInfoPricingTermsType String True

Term-based pricing structure type (TermBasedPricingTerms).

TermPricingInfoPricingTiers String True

Time-period pricing with StartDate and discount/price values.

FormulaPricingInfoPricingTermsType String True

Formula-based pricing structure type.

FormulaPricingInfoFormula String True

Mathematical formula string for calculating prices.

FormulaPricingInfoGridInfos String True

Grid factor objects containing variables and values for formula calculation.

AdvancedPricingInfoPricingTermsType String True

Pricing terms type for advanced pricing structures.

AdvancedPricingInfoPricingTiers String True

Time-based pricing tiers with tier steps, dates, and ship-to information.

RangePricingInfoPricingTermsType String True

Pricing terms type for range-based pricing structures.

RangePricingInfoRangePricingTiers String True

Pricing tiers with minimum and maximum price ranges per period.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454