I_Schedgagrmthdr

Scheduling Agreement Header | view: ISCHEDGAGRMTHDR | TRAN | Extraction: Not supported | Component: Contract
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
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
ScheduleAgreementHasReleaseDoc Indicator for scheduling agreement release documentation Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingCompletenessStatus Purchase order not yet complete Show values
PurchasingProcessingStatus Purchasing document processing state Show values
Column Name Description Domain name
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
CreatedByUser User of person who created a purchasing document USNAM
CreatedByUserFullName User Description SUIDTECHDESC
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount1Percent Cash discount percentage 1 PRZ23
CashDiscount2Days Cash discount days 2 ZBDXT
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
NetPaymentDays Net Payment Terms Period ZBDXT
ExchangeRate Exchange Rate KURSP
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
SupplierAddressID Address Number AD_ADDRNUM
SupplierQuotationExternalID Quotation Number ANGNR
VATRegistrationCountry Country/Region of Sales Tax ID Number LAND1
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
CorrespncExternalReference Your Reference TEXT12
CorrespncInternalReference Our Reference TEXT12
CompanyVATRegistration VAT Registration Number STCEG
LastChangeDateTime Change Time Stamp TZNTSTMPL
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_SCHEDGAGRMTHDR.COMPANYCODE == T001.BUKRS
  • I_SCHEDGAGRMTHDR.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • I_SCHEDGAGRMTHDR.DOCUMENTCURRENCY == TCURC.WAERS
  • I_SCHEDGAGRMTHDR.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_SCHEDGAGRMTHDR.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_SCHEDGAGRMTHDR.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_SCHEDGAGRMTHDR.INCOTERMSVERSION == TINCV.INCOV
  • I_SCHEDGAGRMTHDR.MANDT == TINCV.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • I_SCHEDGAGRMTHDR.INVOICINGPARTY == LFA1.LIFNR
  • I_SCHEDGAGRMTHDR.MANDT == LFA1.MANDT
Language Key I_SCHEDGAGRMTHDR.LANGUAGE == T002.SPRAS
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • I_SCHEDGAGRMTHDR.PURCHASINGDOCUMENTTYPE == T161.BSART
  • I_SCHEDGAGRMTHDR.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • I_SCHEDGAGRMTHDR.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_SCHEDGAGRMTHDR.PURCHASINGGROUP == T024.EKGRP
  • I_SCHEDGAGRMTHDR.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_SCHEDGAGRMTHDR.PURCHASINGORGANIZATION == T024E.EKORG
  • I_SCHEDGAGRMTHDR.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • I_SCHEDGAGRMTHDR.SUPPLIER == LFA1.LIFNR
  • I_SCHEDGAGRMTHDR.MANDT == LFA1.MANDT
Goods Supplier
  • Goods Supplier
  • Client
  • I_SCHEDGAGRMTHDR.SUPPLYINGSUPPLIER == LFA1.LIFNR
  • I_SCHEDGAGRMTHDR.MANDT == LFA1.MANDT