I_SupplierQuotation_Api01

Supplier Quotation | view: IMMQTNAPI01 | TRAN | Extraction: Not supported | Component: RFQ/Quotation
Tables used: EKKO
Column Name Description
SupplierQuotation Supplier Quotation Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
PurchasingDocumentOrderDate Purchasing Document Date
QuotationSubmissionDate Quotation Submission Date
QuotationLatestSubmissionDate Deadline for Submission of Bid/Quotation
BindingPeriodValidityEndDate Binding Period for Quotation
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
QTNLifecycleStatus Supplier Quotation Lifecycle Status Show values
FollowOnDocumentCategory Follow-On Purchasing Document Category Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
Column Name Description Domain name
CreatedByUser User of person who created a purchasing document USNAM
LastChangeDateTime Change Time Stamp TZNTSTMPL
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
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
PurchasingDocumentCondition Number of the Document Condition KNUMV
SupplierQuotationExternalID Quotation Number ANGNR
ExchangeRate Exchange Rate KURSP
FollowOnDocumentType Follow-On Purchasing Document Type BSART
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_SUPPLIERQUOTATION_API01.COMPANYCODE == T001.BUKRS
  • I_SUPPLIERQUOTATION_API01.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • I_SUPPLIERQUOTATION_API01.MANDT == TCURC.MANDT
  • I_SUPPLIERQUOTATION_API01.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • I_SUPPLIERQUOTATION_API01.MANDT == TINC.MANDT
  • I_SUPPLIERQUOTATION_API01.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • I_SUPPLIERQUOTATION_API01.MANDT == TINCV.MANDT
  • I_SUPPLIERQUOTATION_API01.INCOTERMSVERSION == TINCV.INCOV
Language Key I_SUPPLIERQUOTATION_API01.LANGUAGE == T002.SPRAS
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • Client
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • I_SUPPLIERQUOTATION_API01.[column in domain "KAPPL"] == T683.KAPPL
  • I_SUPPLIERQUOTATION_API01.MANDT == T683.MANDT
  • I_SUPPLIERQUOTATION_API01.[column in domain "KVEWE"] == T683.KVEWE
  • I_SUPPLIERQUOTATION_API01.PRICINGPROCEDURE == T683.KALSM
Supplier Quotation Document Type
  • Purchasing Document Category
  • Client
  • Supplier Quotation Document Type
  • I_SUPPLIERQUOTATION_API01.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • I_SUPPLIERQUOTATION_API01.MANDT == T161.MANDT
  • I_SUPPLIERQUOTATION_API01.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • I_SUPPLIERQUOTATION_API01.PURCHASINGGROUP == T024.EKGRP
  • I_SUPPLIERQUOTATION_API01.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • I_SUPPLIERQUOTATION_API01.PURCHASINGORGANIZATION == T024E.EKORG
  • I_SUPPLIERQUOTATION_API01.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • I_SUPPLIERQUOTATION_API01.SUPPLIER == LFA1.LIFNR
  • I_SUPPLIERQUOTATION_API01.MANDT == LFA1.MANDT