I_SchedgagrmthdrWithDraft

Scheduling Agreement Header with Draft | view: ISCHEDGAGRM000WD | Extraction: Not supported | Component: Scheduling Agreement
Tables used: EKKOT161TUSR21
Column Name Description
SchedulingAgreement Purchasing Document Number
Column Name Description
💲 Currency Key (DocumentCurrency):
TargetAmount Target Value for Header Area per Distribution
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
PurchasingDocumentOrderDate Purchasing Document Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
QuotationSubmissionDate Quotation Submission Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
ScheduleAgreementHasReleaseDoc Indicator for scheduling agreement release documentation Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
PurchasingProcessingStatus Purchasing document processing state Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
SchedgAgrmtIsInPreparation Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
SchedulingAgreementForEdit Purchasing Document Number EBELN
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
CreatedByUser User of person who created a purchasing document USNAM
IncotermsTransferLocation Incoterms (Part 2) INCO2
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount2Days Cash discount days 2 ZBDXT
CashDiscount1Percent Cash discount percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
NetPaymentDays Net Payment Terms Period ZBDXT
SupplierAddressID Address Number AD_ADDRNUM
ExchangeRate Exchange Rate KURSP
ExchangeRateForEdit null
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
SchedgAgrmtOutpCtrlType Purchase Contract Output Control Type CHAR1
SchedgAgrmtOutpCtrlStatus Purchase Contract Output Control Status CHAR1
SchedgAgrmtOutpCtrlStatusText Purchase Contract Output Control Status Text
SchedgAgrmtOutpCtrlTime Purchase Contract Output Control Timestamp TZNTSTMPS
SupplierQuotationExternalID Quotation Number ANGNR
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
CorrespncExternalReference Your Reference TEXT12
CorrespncInternalReference Our Reference TEXT12
VATRegistrationCountry Country/Region of Sales Tax ID Number LAND1
CompanyVATRegistration VAT Registration Number STCEG
LastChangeDateTime Change Time Stamp TZNTSTMPL
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_SCHEDGAGRMTHDRWITHDRAFT.MANDT == T001.MANDT
  • I_SCHEDGAGRMTHDRWITHDRAFT.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • I_SCHEDGAGRMTHDRWITHDRAFT.MANDT == TCURC.MANDT
  • I_SCHEDGAGRMTHDRWITHDRAFT.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_SCHEDGAGRMTHDRWITHDRAFT.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_SCHEDGAGRMTHDRWITHDRAFT.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_SCHEDGAGRMTHDRWITHDRAFT.INCOTERMSVERSION == TINCV.INCOV
  • I_SCHEDGAGRMTHDRWITHDRAFT.MANDT == TINCV.MANDT
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • I_SCHEDGAGRMTHDRWITHDRAFT.MANDT == LFA1.MANDT
  • I_SCHEDGAGRMTHDRWITHDRAFT.INVOICINGPARTY == LFA1.LIFNR
Language Key I_SCHEDGAGRMTHDRWITHDRAFT.LANGUAGE == T002.SPRAS
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • I_SCHEDGAGRMTHDRWITHDRAFT.PURCHASINGDOCUMENTTYPE == T161.BSART
  • I_SCHEDGAGRMTHDRWITHDRAFT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • I_SCHEDGAGRMTHDRWITHDRAFT.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_SCHEDGAGRMTHDRWITHDRAFT.PURCHASINGGROUP == T024.EKGRP
  • I_SCHEDGAGRMTHDRWITHDRAFT.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • I_SCHEDGAGRMTHDRWITHDRAFT.MANDT == T024E.MANDT
  • I_SCHEDGAGRMTHDRWITHDRAFT.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • I_SCHEDGAGRMTHDRWITHDRAFT.SUPPLIER == LFA1.LIFNR
  • I_SCHEDGAGRMTHDRWITHDRAFT.MANDT == LFA1.MANDT
Goods Supplier
  • Client
  • Goods Supplier
  • I_SCHEDGAGRMTHDRWITHDRAFT.MANDT == LFA1.MANDT
  • I_SCHEDGAGRMTHDRWITHDRAFT.SUPPLYINGSUPPLIER == LFA1.LIFNR