A_OpportunityItem

Opportunity Item | view: AOPPTYITEM | TRAN | Extraction: Not supported | Component: S4CRM: Opportunities
Column Name Description
Opportunity Transaction ID
OpportunityItem Shortened Item Number in Document
Column Name Description
💲 Currency (TransactionCurrency):
NetValueAmount Net Value
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (SalesQuantityUnit):
ProductQuantity CRM: Order Quantity
Column Name Description
Column Name Description
OpportunityItemStatus Opportunity Lifecycle Status Show values
Column Name Description Domain name
OpportunityUUID GUID of a CRM Order Object SYSUUID
OpportunityItemUUID GUID of a CRM Order Object SYSUUID
OpportunityItemDescription Product Description CRM_PRSHTEXT40_DB
Product Product Name Entered CRM_ORDERED_PROD
ProductHierarchy Product Category COM_CATEGORY_ID
ReferenceLead Transaction ID CRM_OBJECT_ID
ReferenceLeadItem Shortened Item Number in Document CRMS4_NUMBER_INT
Master Data Relations Join Conditions
Competitor
  • Client
  • Competitor
  • A_OPPORTUNITYITEM.MANDT == BUT000.CLIENT
  • A_OPPORTUNITYITEM.COMPETITOR == BUT000.PARTNER
Customer Contact Person
  • Client
  • Customer Contact Person
  • A_OPPORTUNITYITEM.MANDT == BUT000.CLIENT
  • A_OPPORTUNITYITEM.CONTACTPERSON == BUT000.PARTNER
Item Category
  • Client
  • Item Category
Payer
  • Client
  • Payer
  • A_OPPORTUNITYITEM.MANDT == BUT000.CLIENT
  • A_OPPORTUNITYITEM.PAYERPARTY == BUT000.PARTNER
Sales Prospect
  • Client
  • Sales Prospect
  • A_OPPORTUNITYITEM.MANDT == BUT000.CLIENT
  • A_OPPORTUNITYITEM.PROSPECT == BUT000.PARTNER
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • A_OPPORTUNITYITEM.MANDT == T006.MANDT
  • A_OPPORTUNITYITEM.SALESQUANTITYUNIT == T006.MSEHI
Currency
  • Client
  • Currency
  • A_OPPORTUNITYITEM.MANDT == TCURC.MANDT
  • A_OPPORTUNITYITEM.TRANSACTIONCURRENCY == TCURC.WAERS