I_SchedgagrmthdrApi01

Purchase Scheduling Agreement | view: ISCHAGMTHDAPI01 | 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
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
ScheduleAgreementHasReleaseDoc Indicator for scheduling agreement release documentation Show values
PurchasingDocumentOrigin Status of Purchasing Document 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
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
ExchangeRate Exchange Rate KURSP
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
SupplierAddressID Address Number AD_ADDRNUM
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
SupplierQuotationExternalID Quotation Number ANGNR
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
CompanyVATRegistration VAT Registration Number STCEG
VATRegistrationCountry Country/Region of Sales Tax ID Number LAND1
LastChangeDateTime Change Time Stamp TZNTSTMPL
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_SCHEDGAGRMTHDRAPI01.MANDT == T001.MANDT
  • I_SCHEDGAGRMTHDRAPI01.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • I_SCHEDGAGRMTHDRAPI01.MANDT == TCURC.MANDT
  • I_SCHEDGAGRMTHDRAPI01.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • I_SCHEDGAGRMTHDRAPI01.MANDT == TINC.MANDT
  • I_SCHEDGAGRMTHDRAPI01.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • I_SCHEDGAGRMTHDRAPI01.MANDT == TINCV.MANDT
  • I_SCHEDGAGRMTHDRAPI01.INCOTERMSVERSION == TINCV.INCOV
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • I_SCHEDGAGRMTHDRAPI01.MANDT == LFA1.MANDT
  • I_SCHEDGAGRMTHDRAPI01.INVOICINGPARTY == LFA1.LIFNR
Language Key I_SCHEDGAGRMTHDRAPI01.LANGUAGE == T002.SPRAS
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • Purchasing Document Category
  • I_SCHEDGAGRMTHDRAPI01.PURCHASINGDOCUMENTTYPE == T161.BSART
  • I_SCHEDGAGRMTHDRAPI01.MANDT == T161.MANDT
  • I_SCHEDGAGRMTHDRAPI01.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • I_SCHEDGAGRMTHDRAPI01.MANDT == T024.MANDT
  • I_SCHEDGAGRMTHDRAPI01.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • I_SCHEDGAGRMTHDRAPI01.MANDT == T024E.MANDT
  • I_SCHEDGAGRMTHDRAPI01.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • I_SCHEDGAGRMTHDRAPI01.MANDT == LFA1.MANDT
  • I_SCHEDGAGRMTHDRAPI01.SUPPLIER == LFA1.LIFNR
Goods Supplier
  • Client
  • Goods Supplier
  • I_SCHEDGAGRMTHDRAPI01.MANDT == LFA1.MANDT
  • I_SCHEDGAGRMTHDRAPI01.SUPPLYINGSUPPLIER == LFA1.LIFNR