C_SalesSchedgAgrmt

Sales Scheduling Agreements | view: CSLSSCHEDGAGRMT | TRAN | Extraction: Not supported | Component: Customer Scheduling Agreement
Column Name Description
SalesSchedulingAgreement Sales Scheduling Agreement
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
SalesSchedgAgrmtDate Document Date (Date Received/Sent)
PricingDate Date for Pricing and Exchange Rate
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallBillingBlockStatus Billing Block Status (All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
OverallTrdCmplncEmbargoSts Embargo Status (All Items) Show values
OvrlTrdCmplncSnctndListChkSts Screening Status (All Items) Show values
OvrlTrdCmplncLegalCtrlChkSts Legal Control Status (All Items) Show values
OverallChmlCmplncStatus Product Marketability Status (All Items) Show values
OverallDangerousGoodsStatus Dangerous Goods Status (All Items) Show values
OverallSafetyDataSheetStatus Safety Data Sheet Status (All Items) Show values
Column Name Description Domain name
PurchaseOrderByCustomer Customer Reference BSTKD
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser User Who Last Changed the Business Document USNAM
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
OverallSDProcessStatusDesc Status Description TEXT20
OverallBillingBlockStatusDesc Status Description TEXT20
OverallDeliveryStatusDesc Status Description TEXT20
OvrlSDDocumentRejectionStsDesc Status Description TEXT20
SalesDocumentTypeName Sales Document Type Description TEXT20
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • C_SALESSCHEDGAGRMT.MANDT == TVKOV.MANDT
  • C_SALESSCHEDGAGRMT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_SALESSCHEDGAGRMT.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Division
  • Client
  • Distribution Channel
  • Sales Organization
  • C_SALESSCHEDGAGRMT.ORGANIZATIONDIVISION == TVTA.SPART
  • C_SALESSCHEDGAGRMT.MANDT == TVTA.MANDT
  • C_SALESSCHEDGAGRMT.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_SALESSCHEDGAGRMT.SALESORGANIZATION == TVTA.VKORG
Sales group
  • Client
  • Sales office
  • Sales group
  • C_SALESSCHEDGAGRMT.MANDT == TVBVK.MANDT
  • C_SALESSCHEDGAGRMT.SALESOFFICE == TVBVK.VKBUR
  • C_SALESSCHEDGAGRMT.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • C_SALESSCHEDGAGRMT.MANDT == TVKO.MANDT
  • C_SALESSCHEDGAGRMT.SALESORGANIZATION == TVKO.VKORG
Order type in order header
  • Sales Scheduling Agreement Type
  • Client
  • C_SALESSCHEDGAGRMT.SALESSCHEDGAGRMTTYPE == TVAK.AUART
  • C_SALESSCHEDGAGRMT.MANDT == TVAK.MANDT
Customer - Document Customer
  • Client
  • Sold-to Party
  • Customer Number
  • C_SALESSCHEDGAGRMT.MANDT == KNA1.MANDT
  • C_SALESSCHEDGAGRMT.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESSCHEDGAGRMT.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • Customer Number
  • C_SALESSCHEDGAGRMT.MANDT == KNA1.MANDT
  • C_SALESSCHEDGAGRMT.SOLDTOPARTY == KNA1.KUNNR
  • C_SALESSCHEDGAGRMT.SHIPTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_SALESSCHEDGAGRMT.MANDT == TCURC.MANDT
  • C_SALESSCHEDGAGRMT.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Client
  • Distribution Channel
  • Sales office
  • Sales Organization
  • C_SALESSCHEDGAGRMT.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_SALESSCHEDGAGRMT.MANDT == TVKBZ.MANDT
  • C_SALESSCHEDGAGRMT.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_SALESSCHEDGAGRMT.SALESOFFICE == TVKBZ.VKBUR
  • C_SALESSCHEDGAGRMT.SALESORGANIZATION == TVKBZ.VKORG