C_SchedgAgrmtMassUpdt

Mass Changes to Scheduling Agreements | view: CSCHAGRMNT | TRAN | Extraction: Not supported | Component: Scheduling Agreement
Tables used: EKKOBUT000T001TKA02TB913TINCTINCTTINCVTINCVTTPARTPARTT052TVZBTEKPAT161T161TT024T024EADR2ADR6LFA1LFA1USR21ADCPADR2ADR6ADRCADRPTSAD3KNVK
Column Name Description
SchedulingAgreement Scheduling Agreement
PartnerFunction FK Partner Function
PartnerCounter Partner counter
Column Name Description
Column Name Description
Column Name Description
CreationDate Created On
ValidityStartDate Valid From
ValidityEndDate Valid To
ItemLastTransmissionDate Last Transmission
Column Name Description
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
PurchaseContractValidityStatus Contract Status Show values
PurContrValidityStatusName Contract Status Show values
Column Name Description Domain name
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
ExchangeRate Exchange Rate
IncotermsClassificationName Description TEXT30
HeaderIncotermsLoc1 Incoterms Location 1
HeaderIncotermsLoc2 Incoterms Location 2
IncotermsVersionName Description TEXT30
PaymentTerms Terms of Payment Key ZTERM
PaymentTermsName Description of terms of payment TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
SupplierName Name of Supplier TEXT80
CreatedByUser User of person who created a purchasing document USNAM
CreatedByUserFullName User Description
MaterialGroup Material Group MATKL
Plant Plant WERKS
Material Material Number MATNR
PurchasingDocumentItemCategory Item category in purchasing document PSTYP
AccountAssignmentCategory Account Assignment Category KNTTP
QualityCertificateType Certificate Type QZGTYP
PreferredSupplierName Name of Supplier TEXT80
PartnerFunctionName Name TEXT20
NumberOfBusinessPartners null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_SCHEDGAGRMTMASSUPDT.COMPANYCODE == T001.BUKRS
  • C_SCHEDGAGRMTMASSUPDT.MANDT == T001.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_SCHEDGAGRMTMASSUPDT.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_SCHEDGAGRMTMASSUPDT.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_SCHEDGAGRMTMASSUPDT.INCOTERMSVERSION == TINCV.INCOV
  • C_SCHEDGAGRMTMASSUPDT.MANDT == TINCV.MANDT
Partner Function
  • Partner Function
  • Client
  • C_SCHEDGAGRMTMASSUPDT.PARTNERFUNCTION == TPAR.PARVW
  • C_SCHEDGAGRMTMASSUPDT.MANDT == TPAR.MANDT
Agreement Type
  • Agreement Type
  • ?
  • Client
  • C_SCHEDGAGRMTMASSUPDT.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_SCHEDGAGRMTMASSUPDT.[column in domain "BSTYP"] == T161.BSTYP
  • C_SCHEDGAGRMTMASSUPDT.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_SCHEDGAGRMTMASSUPDT.PURCHASINGGROUP == T024.EKGRP
  • C_SCHEDGAGRMTMASSUPDT.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_SCHEDGAGRMTMASSUPDT.PURCHASINGORGANIZATION == T024E.EKORG
  • C_SCHEDGAGRMTMASSUPDT.MANDT == T024E.MANDT
Supplier Reference
  • Supplier Reference
  • Client
  • C_SCHEDGAGRMTMASSUPDT.REFERENCESUPPLIER == LFA1.LIFNR
  • C_SCHEDGAGRMTMASSUPDT.MANDT == LFA1.MANDT
Supplier
  • Supplier
  • Client
  • C_SCHEDGAGRMTMASSUPDT.SUPPLIER == LFA1.LIFNR
  • C_SCHEDGAGRMTMASSUPDT.MANDT == LFA1.MANDT
Supplier Subrange
  • Supplier Subrange
  • Supplier Reference
  • Client
  • C_SCHEDGAGRMTMASSUPDT.SUPPLIERSUBRANGE == WYT1.LTSNR
  • C_SCHEDGAGRMTMASSUPDT.REFERENCESUPPLIER == WYT1.LIFNR
  • C_SCHEDGAGRMTMASSUPDT.MANDT == WYT1.MANDT