C_OpnSlsOrdAboveThreshold

Open Sales Orders Above Threshold | view: CGRCNPSOR | Extraction: Not supported | Component: Information System
Tables used: VBAKVBAKVBAPVBKDVEDAVBEPKNA1
Column Name Description
SalesDocument Sales Document
SalesDocumentItem Sales Document Item
ScheduleLine Schedule Line Number
Column Name Description
Column Name Description
Column Name Description
DeliveryDate Schedule line date
CurrentDate null
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
Column Name Description
SDDocumentCategory SD Document Category Show values
SalesDocumentItemType Item Type Show values
IsReturnsItem Returns Item Show values
CompletionRule Completion Rule for Quotation / Contract Show values
Column Name Description Domain name
SalesDocumentItemUUID GUID in 'CHAR' Format in Uppercase SYSUUID_C
SalesDocumentItemText Short text for sales order item TEXT40
CustomerName Name of Customer TEXT80
DeliveryDateOffsetInDays null
SalesDocumentType Sales Document Type AUART
OrganizationDivision Division SPART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
CreatedByUser Name of Person Responsible for Creating the Object USNAM
Master Data Relations Join Conditions
Division
  • Division
  • Client
  • C_OPNSLSORDABOVETHRESHOLD.DIVISION == TSPA.SPART
  • C_OPNSLSORDABOVETHRESHOLD.MANDT == TSPA.MANDT
Material: order item
  • Product Number
  • Client
  • C_OPNSLSORDABOVETHRESHOLD.PRODUCT == MARA.MATNR
  • C_OPNSLSORDABOVETHRESHOLD.MANDT == MARA.MANDT
Sales document item category
  • Sales document item category
  • Client
  • C_OPNSLSORDABOVETHRESHOLD.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • C_OPNSLSORDABOVETHRESHOLD.MANDT == TVPT.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_OPNSLSORDABOVETHRESHOLD.SOLDTOPARTY == KNA1.KUNNR
  • C_OPNSLSORDABOVETHRESHOLD.MANDT == KNA1.MANDT