A_BusSolnOrderSalesItem

Sales Order Item | view: ABSOSALESITEM | TRAN | Extraction: Not supported | Component: S4CRM: Solution Order
Tables used: CRMS4D_EXT_REF, CRMS4D_SERV_I, TVAGT
Column Name Description
BusinessSolutionOrder Transaction ID
BusinessSolutionOrderItem Shortened Item Number in Document
Column Name Description
💲 Currency (TransactionCurrency):
ServiceDocumentItemNetAmount Net Value
Column Name Description
📏 Unit of Measure in Which the Product Is Sold (QuantityUnit):
Quantity CRM: Order Quantity
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross Weight
ItemNetWeight Net Weight
📏 Unit for the Volume of a Product (ItemVolumeUnit):
ItemVolume Volume Occupied by the Product per Volume Unit
Column Name Description
Column Name Description
ItemOrderProbabilityInPercent Order Probability Show values
BusSolnOrdItmIsReleased Release Status Show values
BusSolnOrdItmIsRejected Cancellation Status Show values
SrvcDocItmDeliveryStatus Delivery Status Show values
ServiceDocItemBillingStatus Billing Status Show values
PartialDeliveryIsAllowed Delivery Control (Item) Show values
OrderCombinationIsAllowed Indicator: Order Combination Show values
Column Name Description Domain name
BusinessSolutionOrderItemUUID GUID of a CRM Order Object SYSUUID
Product Product Name Entered CRM_ORDERED_PROD
BusSolnOrdItmDescription Product Description CRM_PRSHTEXT40_DB
Language Short Text Language for an Item SYLANGU
BusSolnOrdItmExtReference External Reference Number CRMS4_EXT_REF_NUM
IncotermsPart2 Incoterms (Part 2) CRM_INCOTERMS2
BusSolnOrdItmIsCompleted null
BusSolnOrdItmDistrStatus null
BusSolnOrdItmDistrStatusName null
BusSolnOrdItmRjcnReasonText Description TEXT40
SrvcDocDeliveryStatusText Short Text for Fixed Values DDTEXT
RequestedDeliveryUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ProfitCenter Profit Center PRCTR
PurchaseOrderByCustomer Sold-To Party's External Reference Number TEXT35
DeliveryGroup Delivery Group (Items are Delivered Together) CRMT_DLV_GROUP
Master Data Relations Join Conditions
Business Partner: Billing Block Reason
  • Business Partner: Billing Block Reason
  • Client
  • A_BUSSOLNORDERSALESITEM.BILLINGBLOCKREASON == TVFS.FAKSP
  • A_BUSSOLNORDERSALESITEM.MANDT == TVFS.MANDT
Bill-To Party
  • Client
  • Bill-To Party
  • A_BUSSOLNORDERSALESITEM.MANDT == BUT000.CLIENT
  • A_BUSSOLNORDERSALESITEM.BILLTOPARTY == BUT000.PARTNER
Item Category
  • Client
  • Item Category
Cancellation Reason Code
  • Client
  • Cancellation Reason Code
  • A_BUSSOLNORDERSALESITEM.MANDT == TVAG.MANDT
  • A_BUSSOLNORDERSALESITEM.BUSSOLNORDITMRJCNREASON == TVAG.ABGRU
Customer Contact Person
  • Customer Contact Person
  • Client
  • A_BUSSOLNORDERSALESITEM.CONTACTPERSON == BUT000.PARTNER
  • A_BUSSOLNORDERSALESITEM.MANDT == BUT000.CLIENT
Business Partner: Delivery Block Reason
  • Client
  • Business Partner: Delivery Block Reason
  • A_BUSSOLNORDERSALESITEM.MANDT == TVLS.MANDT
  • A_BUSSOLNORDERSALESITEM.DELIVERYBLOCKREASON == TVLS.LIFSP
Delivery Priority
  • Client
  • Delivery Priority
  • A_BUSSOLNORDERSALESITEM.MANDT == TPRIO.MANDT
  • A_BUSSOLNORDERSALESITEM.DELIVERYPRIORITY == TPRIO.LPRIO
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • A_BUSSOLNORDERSALESITEM.MANDT == TINC.MANDT
  • A_BUSSOLNORDERSALESITEM.INCOTERMSPART1 == TINC.INCO1
Unit for the Volume of a Product
  • Client
  • Unit for the Volume of a Product
  • A_BUSSOLNORDERSALESITEM.MANDT == T006.MANDT
  • A_BUSSOLNORDERSALESITEM.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Client
  • Weight Unit
  • A_BUSSOLNORDERSALESITEM.MANDT == T006.MANDT
  • A_BUSSOLNORDERSALESITEM.ITEMWEIGHTUNIT == T006.MSEHI
Customer Price Group
  • Client
  • Customer Price Group
  • A_BUSSOLNORDERSALESITEM.MANDT == T188.MANDT
  • A_BUSSOLNORDERSALESITEM.MATERIALPRICINGGROUP == T188.KONDA
Payer
  • Client
  • Payer
  • A_BUSSOLNORDERSALESITEM.MANDT == BUT000.CLIENT
  • A_BUSSOLNORDERSALESITEM.PAYERPARTY == BUT000.PARTNER
Terms of Payment
  • Terms of Payment
  • Client
  • ?
  • A_BUSSOLNORDERSALESITEM.PAYMENTTERMS == T052.ZTERM
  • A_BUSSOLNORDERSALESITEM.MANDT == T052.MANDT
  • A_BUSSOLNORDERSALESITEM.[column in domain "DZTAGG_052"] == T052.ZTAGG
Employee Responsible
  • Client
  • Employee Responsible
  • A_BUSSOLNORDERSALESITEM.MANDT == BUT000.CLIENT
  • A_BUSSOLNORDERSALESITEM.PERSONRESPONSIBLE == BUT000.PARTNER
Unit of Measure in Which the Product Is Sold
  • Client
  • Unit of Measure in Which the Product Is Sold
  • A_BUSSOLNORDERSALESITEM.MANDT == T006.MANDT
  • A_BUSSOLNORDERSALESITEM.QUANTITYUNIT == T006.MSEHI
Ship-To Party
  • Client
  • Ship-To Party
  • A_BUSSOLNORDERSALESITEM.MANDT == BUT000.CLIENT
  • A_BUSSOLNORDERSALESITEM.SHIPTOPARTY == BUT000.PARTNER
Sold-To Party
  • Client
  • Sold-To Party
  • A_BUSSOLNORDERSALESITEM.MANDT == BUT000.CLIENT
  • A_BUSSOLNORDERSALESITEM.SOLDTOPARTY == BUT000.PARTNER
Currency
  • Currency
  • Client
  • A_BUSSOLNORDERSALESITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • A_BUSSOLNORDERSALESITEM.MANDT == TCURC.MANDT