I_PresalesDocumentItem

Presales Document Item | view: IPRESALESDOCITEM | TRAN | Extraction: Not supported | Component: S4CRM: Opportunities
Tables used: CRMS4D_OPPT_I
Column Name Description
PresalesDocument Transaction ID
PresalesDocumentObjectType FK Business Trans. Cat.
PresalesDocumentItem Shortened Item Number in Document
Column Name Description
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
PresalesDocumentUUID GUID of a CRM Order Object SYSUUID
PresalesDocumentItemUUID GUID of a CRM Order Object SYSUUID
PresalesDocItemDescription Product Description CRM_PRSHTEXT40_DB
Product Product Name Entered CRM_ORDERED_PROD
ProductHierarchy Product Category COM_CATEGORY_ID
TextObjectKey 32 Character CRM Object GUID (Converted)
Master Data Relations Join Conditions
Competitor
  • Client
  • Competitor
  • I_PRESALESDOCUMENTITEM.MANDT == BUT000.CLIENT
  • I_PRESALESDOCUMENTITEM.COMPETITOR == BUT000.PARTNER
Customer Contact Person
  • Client
  • Customer Contact Person
  • I_PRESALESDOCUMENTITEM.MANDT == BUT000.CLIENT
  • I_PRESALESDOCUMENTITEM.CONTACTPERSON == BUT000.PARTNER
Payer
  • Client
  • Payer
  • I_PRESALESDOCUMENTITEM.MANDT == BUT000.CLIENT
  • I_PRESALESDOCUMENTITEM.PAYERPARTY == BUT000.PARTNER
Item Category
  • Client
  • Item Category
CRM Item Object Type I_PRESALESDOCUMENTITEM.PRESALESDOCUMENTITEMOBJECTTYPE == CRMC_SUBOB_CAT_I.SUBOBJ_CATEGORY
Business Trans. Cat. I_PRESALESDOCUMENTITEM.PRESALESDOCUMENTOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Business Transaction Type
  • Client
  • Business Transaction Type
Sales Prospect
  • Client
  • Sales Prospect
  • I_PRESALESDOCUMENTITEM.MANDT == BUT000.CLIENT
  • I_PRESALESDOCUMENTITEM.PROSPECT == BUT000.PARTNER
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • I_PRESALESDOCUMENTITEM.MANDT == T006.MANDT
  • I_PRESALESDOCUMENTITEM.SALESQUANTITYUNIT == T006.MSEHI
Sales Rep
  • Client
  • Sales Rep
  • I_PRESALESDOCUMENTITEM.MANDT == BUT000.CLIENT
  • I_PRESALESDOCUMENTITEM.SALESREPRESENTATIVE == BUT000.PARTNER
Currency
  • Client
  • Currency
  • I_PRESALESDOCUMENTITEM.MANDT == TCURC.MANDT
  • I_PRESALESDOCUMENTITEM.TRANSACTIONCURRENCY == TCURC.WAERS