I_SalesSchedgAgrmt

Sales Scheduling Agreement | view: ISDSCHEDGAGRMT | ATTR | Extraction: Not supported | Component: Customer Scheduling Agreement
Tables used: VBKD, VEDA, VBAK
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
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
SalesSchedgAgrmtDate Document Date (Date Received/Sent)
CustomerPurchaseOrderDate Customer Reference Date
PricingDate Date for Pricing and Exchange Rate
RequestedDeliveryDate Requested Delivery Date
AgrmtValdtyStartDate Valid-from Date
AgrmtValdtyEndDate Valid-to Date
BillingDocumentDate Billing Date
ExchangeRateDate Translation date
Column Name Description
SDDocumentCategory SD Document Category Show values
SalesSchedgAgrmtProcessingType SD document indicator Show values
DelivSchedTypeMRPRlvnceCode MRP for delivery schedule types Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallDelivConfStatus Delivery Confirmation Status (All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
OverallDeliveryBlockStatus Overall Delivery Block Status (All Items) Show values
OverallBillingBlockStatus Billing Block Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
CentralCreditCheckStatus Status of Credit Check SAP Credit Management Show values
CentralCreditChkTechErrSts Status of Technical Error SAP Credit Management Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
OverallTrdCmplncEmbargoSts Embargo Status (All Items) Show values
OvrlTrdCmplncSnctndListChkSts Screening Status (All Items) Show values
OvrlTrdCmplncLegalCtrlChkSts Legal Control Status 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
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser User Who Last Changed the Business Document USNAM
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
PurchaseOrderByCustomer Customer Reference BSTKD
CustomerPurchaseOrderSuplmnt Purchase order number supplement BSTZD
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
SalesSchedgAgrmtCondition Number of the Document Condition KNUMV
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • I_SALESSCHEDGAGRMT.MANDT == TVV1.MANDT
  • I_SALESSCHEDGAGRMT.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • I_SALESSCHEDGAGRMT.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_SALESSCHEDGAGRMT.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • I_SALESSCHEDGAGRMT.MANDT == TVV3.MANDT
  • I_SALESSCHEDGAGRMT.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • I_SALESSCHEDGAGRMT.MANDT == TVV4.MANDT
  • I_SALESSCHEDGAGRMT.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • I_SALESSCHEDGAGRMT.MANDT == TVV5.MANDT
  • I_SALESSCHEDGAGRMT.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • I_SALESSCHEDGAGRMT.MANDT == T001.MANDT
  • I_SALESSCHEDGAGRMT.BILLINGCOMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • I_SALESSCHEDGAGRMT.CONTROLLINGAREA == TKA01.KOKRS
  • I_SALESSCHEDGAGRMT.MANDT == TKA01.MANDT
Customer Group
  • Client
  • Customer Group
  • I_SALESSCHEDGAGRMT.MANDT == T151.MANDT
  • I_SALESSCHEDGAGRMT.CUSTOMERGROUP == T151.KDGRP
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • I_SALESSCHEDGAGRMT.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • I_SALESSCHEDGAGRMT.MANDT == T176.MANDT
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • I_SALESSCHEDGAGRMT.MANDT == TVLS.MANDT
  • I_SALESSCHEDGAGRMT.DELIVERYBLOCKREASON == TVLS.LIFSP
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • I_SALESSCHEDGAGRMT.MANDT == TVKOV.MANDT
  • I_SALESSCHEDGAGRMT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_SALESSCHEDGAGRMT.SALESORGANIZATION == TVKOV.VKORG
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • I_SALESSCHEDGAGRMT.MANDT == TCURV.MANDT
  • I_SALESSCHEDGAGRMT.EXCHANGERATETYPE == TCURV.KURST
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • I_SALESSCHEDGAGRMT.MANDT == TVFS.MANDT
  • I_SALESSCHEDGAGRMT.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • I_SALESSCHEDGAGRMT.MANDT == TINC.MANDT
  • I_SALESSCHEDGAGRMT.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • I_SALESSCHEDGAGRMT.MANDT == TINCV.MANDT
  • I_SALESSCHEDGAGRMT.INCOTERMSVERSION == TINCV.INCOV
Usage Indicator
  • Client
  • Usage Indicator
  • I_SALESSCHEDGAGRMT.MANDT == TVLV.MANDT
  • I_SALESSCHEDGAGRMT.MATLUSAGEINDICATOR == TVLV.ABRVW
Division in order header
  • Client
  • Division
  • Distribution Channel
  • Sales Organization
  • I_SALESSCHEDGAGRMT.MANDT == TVTA.MANDT
  • I_SALESSCHEDGAGRMT.ORGANIZATIONDIVISION == TVTA.SPART
  • I_SALESSCHEDGAGRMT.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_SALESSCHEDGAGRMT.SALESORGANIZATION == TVTA.VKORG
Payment Method
  • Client
  • ?
  • Payment Method
  • I_SALESSCHEDGAGRMT.MANDT == T042Z.MANDT
  • I_SALESSCHEDGAGRMT.[column in domain "LAND1"] == T042Z.LAND1
  • I_SALESSCHEDGAGRMT.PAYMENTMETHOD == T042Z.ZLSCH
Sales District
  • Client
  • Sales District
  • I_SALESSCHEDGAGRMT.MANDT == T171.MANDT
  • I_SALESSCHEDGAGRMT.SALESDISTRICT == T171.BZIRK
Sales group
  • Client
  • Sales group
  • Sales office
  • I_SALESSCHEDGAGRMT.MANDT == TVBVK.MANDT
  • I_SALESSCHEDGAGRMT.SALESGROUP == TVBVK.VKGRP
  • I_SALESSCHEDGAGRMT.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • I_SALESSCHEDGAGRMT.MANDT == TVKO.MANDT
  • I_SALESSCHEDGAGRMT.SALESORGANIZATION == TVKO.VKORG
Order type in order header
  • Sales Scheduling Agreement Type
  • Client
  • I_SALESSCHEDGAGRMT.SALESSCHEDGAGRMTTYPE == TVAK.AUART
  • I_SALESSCHEDGAGRMT.MANDT == TVAK.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • I_SALESSCHEDGAGRMT.SDDOCUMENTREASON == TVAU.AUGRU
  • I_SALESSCHEDGAGRMT.MANDT == TVAU.MANDT
Pricing Procedure in Pricing
  • Client
  • Pricing Procedure in Pricing
  • ?
  • ?
  • I_SALESSCHEDGAGRMT.MANDT == T683.MANDT
  • I_SALESSCHEDGAGRMT.SDPRICINGPROCEDURE == T683.KALSM
  • I_SALESSCHEDGAGRMT.[column in domain "KAPPL"] == T683.KAPPL
  • I_SALESSCHEDGAGRMT.[column in domain "KVEWE"] == T683.KVEWE
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_SALESSCHEDGAGRMT.MANDT == TVSB.MANDT
  • I_SALESSCHEDGAGRMT.SHIPPINGCONDITION == TVSB.VSBED
Shipping Type
  • Client
  • Shipping Type
  • I_SALESSCHEDGAGRMT.MANDT == T173.MANDT
  • I_SALESSCHEDGAGRMT.SHIPPINGTYPE == T173.VSART
Sold-to Party
  • Sold-to Party
  • Client
  • I_SALESSCHEDGAGRMT.SOLDTOPARTY == KNA1.KUNNR
  • I_SALESSCHEDGAGRMT.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • I_SALESSCHEDGAGRMT.MANDT == TCURC.MANDT
  • I_SALESSCHEDGAGRMT.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales office
  • Division
  • Distribution Channel
  • Sales Organization
  • I_SALESSCHEDGAGRMT.MANDT == TVKBZ.MANDT
  • I_SALESSCHEDGAGRMT.SALESOFFICE == TVKBZ.VKBUR
  • I_SALESSCHEDGAGRMT.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_SALESSCHEDGAGRMT.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_SALESSCHEDGAGRMT.SALESORGANIZATION == TVKBZ.VKORG