I_SupplierPurchasingOrg

Supplier Purchasing Organization | view: ISUPPLPURCH | ATTR | Extraction: Full or Incremental | Component: Business Partners
Tables used: LFA1, LFM1
Column Name Description
Supplier FK Vendor's account number
PurchasingOrganization FK Purchasing organization
Column Name Description
💲 Purchase order currency (PurchaseOrderCurrency):
MinimumOrderAmount Minimum order value
AbsoluteHandlingSurchargeAmt Absolute handling surcharge
MinimumHandlingSurchargeAmt Minimum handling surcharge
MaximumHandlingSurchargeAmt Maximum handling surcharge
Column Name Description
Column Name Description
Column Name Description
PurchasingIsBlockedForSupplier Purchasing block at purchasing organization level Show values
PricingDateControl Price Determination (Pricing) Date Control Show values
PurOrdAutoGenerationIsAllowed Automatic Generation of Purchase Order Allowed Show values
InvoiceIsGoodsReceiptBased Indicator: GR-Based Invoice Verification Show values
DeletionIndicator Deletion Indicator for Supplier at Purchasing Level Show values
IsOrderAcknRqd Order Acknowledgment Requirement Show values
EvaldReceiptSettlementIsActive Evaluated Receipt Settlement (ERS) Show values
AutomaticEvaluatedRcptSettlmt Automatic evaluated receipt settlement for return items Show values
SuplrIsSubjToSubsqntSettlement Indicator: supplier subject to subseq. settlement accounting Show values
SuplrPurgOrgAgrmtOfBusVolIsRqd Comparison/agreement of business volumes necessary Show values
SuplrInvcRevalIsAllowed Revaluation allowed Show values
SuplrPurgOrgIsRlvtForPriceDetn Indicator: "relev. to price determination (vend. hierarchy) Show values
SuplrDiscountInKindIsGranted Checkbox Show values
SuplrIsRlvtForSettlmtMgmt Indicator: Relevant for Settlement Management Show values
InvoiceIsMMServiceEntryBased Indicator for Service-Based Invoice Verification Show values
AutomDebitCrtnIsEnbldOnGI Automatic debit creation on goods issue Show values
IsActiveEntity Draft - Indicator - Is active document Show values
Column Name Description Domain name
MaterialPlannedDeliveryDurn Planned Delivery Time in Days DEC3
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
PaymentTerms Terms of payment key ZTERM
SupplierABCClassificationCode ABC indicator LFABC
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
PlannedDeliveryDurationInDays Planned Delivery Time in Days DEC3
ContactPersonPhoneNumber Supplier's Telephone Number TEXT16
SupplierAccountNumber Our account number with the supplier CHAR12
PercentageHandlingSurchargeAmt Percentage handling surcharge PRZ32
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Group for Calculation Schema (Supplier)
  • Group for Calculation Schema (Supplier)
  • Client
  • I_SUPPLIERPURCHASINGORG.CALCULATIONSCHEMAGROUPCODE == TMKK.KALSK
  • I_SUPPLIERPURCHASINGORG.MANDT == TMKK.MANDT
Settlement profile for automatic evaluated receipt settlemnt
  • Purchasing organization
  • Client
  • Settlement profile for automatic evaluated receipt settlemnt
  • I_SUPPLIERPURCHASINGORG.PURCHASINGORGANIZATION == CVALID.EKORG
  • I_SUPPLIERPURCHASINGORG.MANDT == CVALID.MANDT
  • I_SUPPLIERPURCHASINGORG.EVALDRCPTSETTLEMENTPROFILE == CVALID.VALID_PRO
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • I_SUPPLIERPURCHASINGORG.MANDT == TINC.MANDT
  • I_SUPPLIERPURCHASINGORG.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • I_SUPPLIERPURCHASINGORG.MANDT == TINCV.MANDT
  • I_SUPPLIERPURCHASINGORG.INCOTERMSVERSION == TINCV.INCOV
Mode of Transport at the Border (Intrastat)
  • Mode of Transport at the Border (Intrastat)
  • ?
  • Client
  • I_SUPPLIERPURCHASINGORG.INTRASTATCRSBORDERTRMODE == T618.EXPVZ
  • I_SUPPLIERPURCHASINGORG.[column in domain "/ECRS/RPCTY"] == T618.LAND1
  • I_SUPPLIERPURCHASINGORG.MANDT == T618.MANDT
Planning Cycle
  • Client
  • Planning Cycle
  • ?
  • I_SUPPLIERPURCHASINGORG.MANDT == T439G.MANDT
  • I_SUPPLIERPURCHASINGORG.PLANNINGCYCLE == T439G.MRPPP
  • I_SUPPLIERPURCHASINGORG.[column in domain "WERKS_D"] == T439G.WERKS
Foreign key profile for transfer
  • Client
  • Profile for transferring material data via IDoc PROACT
  • I_SUPPLIERPURCHASINGORG.MANDT == TWVMO.MANDT
  • I_SUPPLIERPURCHASINGORG.PRODSTOCKANDSLSDATATRANSFPRFL == TWVMO.PAPRF
Purchase order currency
  • Client
  • Purchase order currency
  • I_SUPPLIERPURCHASINGORG.MANDT == TCURC.MANDT
  • I_SUPPLIERPURCHASINGORG.PURCHASEORDERCURRENCY == TCURC.WAERS
Purchasing Group
  • Purchasing Group
  • Client
  • I_SUPPLIERPURCHASINGORG.PURCHASINGGROUP == T024.EKGRP
  • I_SUPPLIERPURCHASINGORG.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_SUPPLIERPURCHASINGORG.PURCHASINGORGANIZATION == T024E.EKORG
  • I_SUPPLIERPURCHASINGORG.MANDT == T024E.MANDT
Rounding profile
  • ?
  • ?
  • Client
  • Rounding Profile
  • I_SUPPLIERPURCHASINGORG.[column in domain "RDZAE"] == RDPR.RDZAE
  • I_SUPPLIERPURCHASINGORG.[column in domain "WERKS_D"] == RDPR.WERKS
  • I_SUPPLIERPURCHASINGORG.MANDT == RDPR.MANDT
  • I_SUPPLIERPURCHASINGORG.ROUNDINGPROFILE == RDPR.RDPRF
Shipping conditions
  • Client
  • Shipping Conditions
  • I_SUPPLIERPURCHASINGORG.MANDT == TVSB.MANDT
  • I_SUPPLIERPURCHASINGORG.SHIPPINGCONDITION == TVSB.VSBED
Vendor's account number
  • Client
  • Vendor's account number
  • I_SUPPLIERPURCHASINGORG.MANDT == LFA1.MANDT
  • I_SUPPLIERPURCHASINGORG.SUPPLIER == LFA1.LIFNR
Confirmation Control Key
  • Confirmation Control Key
  • Client
  • I_SUPPLIERPURCHASINGORG.SUPPLIERCONFIRMATIONCONTROLKEY == T163L.BSTAE
  • I_SUPPLIERPURCHASINGORG.MANDT == T163L.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Units of measure group
  • Unit of Measure Group
  • ?
  • Client
  • I_SUPPLIERPURCHASINGORG.PRODUCTUNITGROUP == TWMEG.MEGRU
  • I_SUPPLIERPURCHASINGORG.[column in domain "LRMEI"] == TWMEG.MEINS
  • I_SUPPLIERPURCHASINGORG.MANDT == TWMEG.MANDT