C_SchedgAgrmtItmMassUpdt

Mass Changes to Scheduling Agreements | view: CSCHAGRMTITMMAS | TRAN | Extraction: Not supported | Component: Scheduling Agreement
Tables used: EKKO, EKPO, CMD_PRDTYPE, CMD_PRDTYPE_T, T163K, T163I, ADCP, ADRC, T001, TKA02, T005, TINC, TINCT, TINCV, TINCVT, MARA, T023, T023T, MARC, MAKT, T134, T134T, T052, TVZBT, T001W, T161T, T024, T024E, T163, T163Y, T027A, T027B, T001L, LFA1, T163L, T163M, USR21
Column Name Description
SchedulingAgreement FK Scheduling Agreement
SchedulingAgreementItem Item Number of Purchasing Document
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
Column Name Description
CreationDate Created On
ValidityStartDate Valid From
ValidityEndDate Valid To
SchedAgrmtCumQtyReconcileDate Reconciliation date for agreed cumulative quantity
ItemLastTransmissionDate Last Transmission Date
Column Name Description
PurchaseContractValidityStatus Contract Status Show values
PurContrValidityStatusName Contract Status Show values
IsOrderAcknRqd Order Acknowledgment Requirement Show values
PurgDocEstimatedPrice Indicator: Estimated Price Show values
PriceIsToBePrinted Price Printout Show values
PurchasingInfoRecordUpdateCode Indicator: Update Info Record Show values
PurchasingDocumentDeletionCode Deletion Indicator Show values
UnlimitedOverdeliveryIsAllowed Indicator: Unlimited Overdelivery Allowed Show values
StockType Stock Type Show values
InvoiceIsExpected Invoice Receipt Show values
InvoiceIsGoodsReceiptBased Indicator: GR-Based Invoice Verification Show values
FirmTradeOffZoneBindMRP Firm/Trade-Off Zones Binding with Regard to Mat. Planning Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
DefaultPartner Default Partner Show values
Column Name Description Domain name
FormattedPurchasingDocItem Formatted Scheduling Agreement
SupplierName Name of Supplier TEXT80
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
MaterialGroupName Product Group Description TEXT20
PlantName Plant Name TEXT30
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
AcctAssignmentCategoryName Account Assignment Category Description TEXT20
MaterialName Material Description TEXT40
CompanyCodeName Name of Company Code or Company TEXT25
PurgDocItemCategoryName Text for Item Category TEXT20
PurchasingDocumentItemText Short Text TEXT40
SupplierMaterialNumber Material Number Used by Supplier IDNEX
ItemIncotermsClassfctnDesc Description TEXT30
IncotermsLocation1 Incoterms Location 1
IncotermsLocation2 Incoterms Location 2
NoDaysReminder1 Number of Days for First Reminder/Expediter MAHNT
NoDaysReminder2 Number of Days for Second Reminder/Expediter MAHNT
NoDaysReminder3 Number of Days for Third Reminder/Expediter MAHNT
SupplierConfControlKeyName Confirmation Category: Description TEXT20
PurgDocOrderAcknNumber Order Acknowledgment Number TEXT20
RequirementTracking Requirement Tracking Number CHAR10
ProductType Product Type Group CHAR2
ProductTypeName Product Type Group Description TEXT40
MaterialTypeName Description of Material Type TEXT25
StorageLocationName Storage Location Name TEXT16
PurgInfoRecordUpdateCodeText null
PurDocDeletionCodeName Short Text for Fixed Values DDTEXT
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
StockTypeName Short Text for Fixed Values DDTEXT
ShippingInstructionName Shipping Instructions: Description TEXT30
MinRemainingShelfLife Minimum Remaining Shelf Life DEC4
ScheduleLineFirmOrderInDays Firm Zone (Go-Ahead for Production) PACK2
SchedLineSemiFirmOrderInDays Trade-Off Zone (Go-Ahead for Materials Procurement) PACK2
FirmTradeOffZoneBindMRPText null
NetPriceQuantity Price Unit DEC5
PaymentTerms Terms of Payment Key ZTERM
PaymentTermsName Description of terms of payment TEXT30
ExchangeRate Exchange Rate
IncotermsClassificationName Description TEXT30
HeaderIncotermsLoc1 Incoterms Location 1
HeaderIncotermsLoc2 Incoterms Location 2
IncotermsVersionName Description TEXT30
CreatedByUser User of person who created a purchasing document USNAM
SchedgAgrmtPartnerName null
EmploymentInternalID Personnel Number PERNR
PartnerCounter Partner counter PARZA
PartnerFunction Partner Function PARVW
SupplierContact Number of Contact Person
ReferenceSupplier Supplier Reference
SupplierSubrange Supplier Subrange LTSNR
PreferredSupplierName Supplier Name TEXT80
NumberOfBusinessPartners null
ReleaseDateTime null
InternalComment null
PurchasingDocInclusionList null
PurchasingDocExclusionList null
PurOrdItemsAreSelected null
PurOrdHeadersAreSelected null
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T163K.MANDT
Company Code
  • Company Code
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.COMPANYCODE == T001.BUKRS
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == TCURC.MANDT
  • C_SCHEDGAGRMTITMMASSUPDT.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == TINC.MANDT
  • C_SCHEDGAGRMTITMMASSUPDT.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_SCHEDGAGRMTITMMASSUPDT.ITEMINCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Incoterms Version
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.INCOTERMSVERSION == TINCV.INCOV
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == TINCV.MANDT
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == TINC.MANDT
  • C_SCHEDGAGRMTITMMASSUPDT.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_SCHEDGAGRMTITMMASSUPDT.ITEMINCOTERMSCLASSIFICATION == TINC.INCO1
Material Number
  • Material Number
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.MATERIAL == MARA.MATNR
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.MATERIALGROUP == T023.MATKL
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T023.MANDT
Material type
  • Client
  • Material type
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T134.MANDT
  • C_SCHEDGAGRMTITMMASSUPDT.MATERIALTYPE == T134.MTART
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.ORDERPRICEUNIT == T006.MSEHI
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T006.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T006.MANDT
  • C_SCHEDGAGRMTITMMASSUPDT.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T001W.MANDT
  • C_SCHEDGAGRMTITMMASSUPDT.PLANT == T001W.WERKS
Item Category
  • Item Category
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T163.MANDT
Agreement Type
  • ?
  • Client
  • Agreement Type
  • C_SCHEDGAGRMTITMMASSUPDT.[column in domain "BSTYP"] == T161.BSTYP
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T161.MANDT
  • C_SCHEDGAGRMTITMMASSUPDT.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.PURCHASINGGROUP == T024.EKGRP
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T024.MANDT
Number of purchasing info record
  • Number of purchasing info record
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.PURCHASINGINFORECORD == EINA.INFNR
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == EINA.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.PURCHASINGORGANIZATION == T024E.EKORG
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T024E.MANDT
Certificate Type
  • Client
  • Certificate Type
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == TQ05.MANDT
  • C_SCHEDGAGRMTITMMASSUPDT.QUALITYCERTIFICATETYPE == TQ05.ZGTYP
Delivery Address
  • ?
  • ?
  • Delivery Address
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.[column in domain "AD_NATION"] == ADRC.NATION
  • C_SCHEDGAGRMTITMMASSUPDT.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_SCHEDGAGRMTITMMASSUPDT.REFERENCEDELIVERYADDRESSID == ADRC.ADDRNUMBER
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == ADRC.CLIENT
Shipping Instructions
  • Shipping Instructions
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.SHIPPINGINSTRUCTION == T027A.EVERS
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T027A.MANDT
Storage Location
  • Storage Location
  • Client
  • Plant
  • C_SCHEDGAGRMTITMMASSUPDT.STORAGELOCATION == T001L.LGORT
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T001L.MANDT
  • C_SCHEDGAGRMTITMMASSUPDT.PLANT == T001L.WERKS
Supplier
  • Supplier
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.SUPPLIER == LFA1.LIFNR
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == LFA1.MANDT
Confirmation Control Key
  • Confirmation Control Key
  • Client
  • C_SCHEDGAGRMTITMMASSUPDT.SUPPLIERCONFIRMATIONCONTROLKEY == T163L.BSTAE
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T163L.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • C_SCHEDGAGRMTITMMASSUPDT.[column in domain "KVEWE"] == T683.KVEWE
  • C_SCHEDGAGRMTITMMASSUPDT.[column in domain "KAPPL"] == T683.KAPPL
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T683.MANDT
  • C_SCHEDGAGRMTITMMASSUPDT.TAXCALCULATIONPROCEDURE == T683.KALSM
Tax on sales/purchases code
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Tax on sales/purchases code
  • C_SCHEDGAGRMTITMMASSUPDT.MANDT == T007A.MANDT
  • C_SCHEDGAGRMTITMMASSUPDT.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • C_SCHEDGAGRMTITMMASSUPDT.TAXCODE == T007A.MWSKZ