P_IncomingSalesOrder

Incoming Sales Order | view: PSDSLSORD | Extraction: Not supported | Component: Sales Planning
Tables used: SCAL_TT_DATE, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, SALESPLAN
Column Name Description
SDDocument FK Sales Document
SDDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Sales Plan Actual Amount
Column Name Description
📏 Base Unit of Measure (BaseUnit):
IncomingSalesOrdersQuantity Incoming Sales Orders Quantity
Column Name Description
DocumentDate Date on which the record was created
Column Name Description
SalesPlanPurpose Purposes of Sales Planning Show values
Column Name Description Domain name
SalesDocumentType Sales Document Type AUART
SalesPlan Sales Plan TEXT40
SalesPlanVersion Sales Plan Version TEXT40
CreatedByUser Name of Person Responsible for Creating the Object USNAM
SalesPlanPeriodName Sales Plan Period Name CHAR20
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Division SPART
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
Customer Sold-to Party KUNNR
ShipToParty Ship-to Party KUNNR
BillToParty Bill-to Party KUNNR
PayerParty Payer KUNNR
AdditionalCustomerGroup1 Customer Group 1 KVGR1
AdditionalCustomerGroup2 Customer Group 2 KVGR2
AdditionalCustomerGroup3 Customer Group 3 KVGR3
AdditionalCustomerGroup4 Customer Group 4 KVGR4
AdditionalCustomerGroup5 Customer Group 5 KVGR5
SalesEmployee Sales Employee PERNR
Plant Plant (Own or External) WERKS
ProfitCenter Profit Center PRCTR
CostCenter Cost Center KOSTL
Country Country/Region Key LAND1
BillToPartyCountry Destination Country/Region of Sales Order LAND1
Region Region (State, Province, County) REGIO
BillToPartyRegion Region of Sales Order REGIO
Master Data Relations Join Conditions
Material Group 1
  • Client
  • Material Group 1
  • P_INCOMINGSALESORDER.MANDT == TVM1.MANDT
  • P_INCOMINGSALESORDER.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Material Group 2
  • Client
  • P_INCOMINGSALESORDER.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
  • P_INCOMINGSALESORDER.MANDT == TVM2.MANDT
Material Group 3
  • Material Group 3
  • Client
  • P_INCOMINGSALESORDER.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • P_INCOMINGSALESORDER.MANDT == TVM3.MANDT
Material Group 4
  • Client
  • Material Group 4
  • P_INCOMINGSALESORDER.MANDT == TVM4.MANDT
  • P_INCOMINGSALESORDER.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Material Group 5
  • Client
  • P_INCOMINGSALESORDER.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • P_INCOMINGSALESORDER.MANDT == TVM5.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • P_INCOMINGSALESORDER.BASEUNIT == T006.MSEHI
  • P_INCOMINGSALESORDER.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • P_INCOMINGSALESORDER.BUSINESSAREA == TGSB.GSBER
  • P_INCOMINGSALESORDER.MANDT == TGSB.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • P_INCOMINGSALESORDER.COMPANYCODE == T001.BUKRS
  • P_INCOMINGSALESORDER.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_INCOMINGSALESORDER.CONTROLLINGAREA == TKA01.KOKRS
  • P_INCOMINGSALESORDER.MANDT == TKA01.MANDT
Customer Group
  • Customer Group
  • Client
  • P_INCOMINGSALESORDER.CUSTOMERGROUP == T151.KDGRP
  • P_INCOMINGSALESORDER.MANDT == T151.MANDT
Division
  • Division
  • Client
  • P_INCOMINGSALESORDER.DIVISION == TSPA.SPART
  • P_INCOMINGSALESORDER.MANDT == TSPA.MANDT
Material: order item
  • Material Number
  • Client
  • P_INCOMINGSALESORDER.MATERIAL == MARA.MATNR
  • P_INCOMINGSALESORDER.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_INCOMINGSALESORDER.MATERIALGROUP == T023.MATKL
  • P_INCOMINGSALESORDER.MANDT == T023.MANDT
Sales District
  • Sales District
  • Client
  • P_INCOMINGSALESORDER.SALESDISTRICT == T171.BZIRK
  • P_INCOMINGSALESORDER.MANDT == T171.MANDT
Shipping Type
  • Shipping Type
  • Client
  • P_INCOMINGSALESORDER.SHIPPINGTYPE == T173.VSART
  • P_INCOMINGSALESORDER.MANDT == T173.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • P_INCOMINGSALESORDER.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_INCOMINGSALESORDER.MANDT == TCURC.MANDT