C_SlsDocItemTradeCmplncIssue

Sales Doc Item Trade Compliance Issue | view: CSLSDOCITEMSO07 | Extraction: Not supported | Component: Sales Analytics
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
RequestedQuantity Requested Quantity
📏 Sales unit (OrderQuantityUnit):
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
Column Name Description
RequestedDeliveryDate Requested Delivery Date
Column Name Description
DeliveryStatus Delivery Status (Item) Show values
SDProcessStatus Overall Processing Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
TrdCmplncEmbargoSts Embargo Status (Item) Show values
TrdCmplncSnctndListChkSts Screening Status (Item) Show values
OvrlTrdCmplncLegalCtrlChkSts Legal Control Status (All Schedule Lines) Show values
Column Name Description Domain name
DueDays Next Action in Days DUE_DAYS
MaterialName Material Description TEXT40
Plant Plant (Own or External) WERKS
MaterialByCustomer Material Number Used by Customer IDNEX
SalesDocumentItemText Short text for sales order item TEXT40
ShippingPointName Description TEXT30
ShippingPointCountry Shipping Point Country or Region LAND1
ShippingPointCountryName Shipping Point Country or Region TEXT50
ShipFromPartyCountryName Ship-to Party Country or Region TEXT50
ShipToParty Ship-to Party KUNNR
ShipToPartyName Name of Ship-to Party TEXT80
ShipToPartyCountry Ship-to Party Country or Region LAND1
ShipToPartyCountryName Ship-to Party Country or Region TEXT50
SalesDocumentType Sales Document Type AUART
TrdCmplncEmbargoStsCritlty null
TrdCmplncSnctndListCritlty null
OvrlTrdCmplncLglCtrlStsCritlty null
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Product Number
  • Client
  • Plant (Own or External)
  • C_SLSDOCITEMTRADECMPLNCISSUE.BATCH == MCHA.CHARG
  • C_SLSDOCITEMTRADECMPLNCISSUE.MATERIAL == MCHA.MATNR
  • C_SLSDOCITEMTRADECMPLNCISSUE.MANDT == MCHA.MANDT
  • C_SLSDOCITEMTRADECMPLNCISSUE.PLANT == MCHA.WERKS
Material: order item
  • Product Number
  • Client
  • C_SLSDOCITEMTRADECMPLNCISSUE.MATERIAL == MARA.MATNR
  • C_SLSDOCITEMTRADECMPLNCISSUE.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • C_SLSDOCITEMTRADECMPLNCISSUE.MATERIALGROUP == T023.MATKL
  • C_SLSDOCITEMTRADECMPLNCISSUE.MANDT == T023.MANDT
Sales unit
  • Client
  • Sales unit
  • C_SLSDOCITEMTRADECMPLNCISSUE.MANDT == T006.MANDT
  • C_SLSDOCITEMTRADECMPLNCISSUE.ORDERQUANTITYUNIT == T006.MSEHI
Sales document item category
  • Client
  • Sales document item category
  • C_SLSDOCITEMTRADECMPLNCISSUE.MANDT == TVPT.MANDT
  • C_SLSDOCITEMTRADECMPLNCISSUE.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Country key
  • Client
  • Ship-from Party Country or Region
  • C_SLSDOCITEMTRADECMPLNCISSUE.MANDT == T005.MANDT
  • C_SLSDOCITEMTRADECMPLNCISSUE.SHIPFROMPARTYCOUNTRY == T005.LAND1
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_SLSDOCITEMTRADECMPLNCISSUE.MANDT == TVST.MANDT
  • C_SLSDOCITEMTRADECMPLNCISSUE.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Client
  • Shipping Type
  • C_SLSDOCITEMTRADECMPLNCISSUE.MANDT == T173.MANDT
  • C_SLSDOCITEMTRADECMPLNCISSUE.SHIPPINGTYPE == T173.VSART
Storage location
  • Client
  • Storage location
  • Plant (Own or External)
  • C_SLSDOCITEMTRADECMPLNCISSUE.MANDT == T001L.MANDT
  • C_SLSDOCITEMTRADECMPLNCISSUE.STORAGELOCATION == T001L.LGORT
  • C_SLSDOCITEMTRADECMPLNCISSUE.PLANT == T001L.WERKS
SD Document Currency
  • SD Document Currency
  • Client
  • C_SLSDOCITEMTRADECMPLNCISSUE.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_SLSDOCITEMTRADECMPLNCISSUE.MANDT == TCURC.MANDT