P_ScheduleAgmtMassUpdate

Private View for Scheduling Agreement | view: PSAGREEMENT | TRAN | Extraction: Not supported | Component: Scheduling Agreement
Tables used: EKKOEKPOADCPADRCT001TKA02T005MARAT023T023TT134T134TTPART001WEKPAT161T161TT024LFA1USR21
Column Name Description
FormattedPurchasingDocItem null
Column Name Description
Column Name Description
Column Name Description
ItemLastTransmissionDate Last Transmission
SchedAgrmtCumQtyReconcileDate Reconciliation date for agreed cumulative quantity
PurchasingDocumentOrderDate Purchasing Document Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
FirmTradeOffZoneBindMRP Firm/Trade-Off Zones Binding with Regard to Mat. Planning Show values
PurchasingDocumentCategory Purchasing Document Category Show values
IsOrderAcknRqd Order Acknowledgment Requirement Show values
InvoiceIsGoodsReceiptBased Indicator: GR-Based Invoice Verification Show values
InvoiceIsExpected Invoice receipt indicator Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
PurgDocEstimatedPrice Indicator: Estimated Price Show values
PriceIsToBePrinted Price Printout Show values
IsInfoRecordUpdated Indicator: Update Info Record Show values
StockType Stock Type Show values
PurchaseContractValidityStatus Validity Status Show values
PurContrValidityStatusName Contract Status Show values
DefaultPartner Default Partner Show values
IsStrategicPartner Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
SchedulingAgreement Purchasing Document Number EBELN
SchedulingAgreementItem Item Number of Purchasing Document EBELP
HierarchyNodeLevel null
ParentNode null
DrillDownState null
PaymentTerms Terms of Payment Key ZTERM
ExchangeRate Exchange Rate KURSP
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
ProductType Product Type MTART
ShippingInstruction Shipping Instructions EVERS
QualityCertificateType Certificate Type QZGTYP
ConfirmationControl Confirmation Control Key BSTAE
ReferenceDeliveryAddressID Number of delivery address AD_ADDRNUM
MinRemainingShelfLife Minimum Remaining Shelf Life DEC4
MaterialType Material type MTART
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
PurchasingDocumentItemText Short Text TEXT40
Material Material Number MATNR
Plant Plant WERKS
StorageLocation Storage Location LGORT
RequirementTracking Requirement Tracking Number CHAR10
SchedLineSemiFirmOrderInDays Trade-Off Zone (Go-Ahead for Materials Procurement) PACK2
ScheduleLineFirmOrderInDays Firm Zone (Go-Ahead for Production) PACK2
PurgDocOrderAcknNumber Order Acknowledgment Number TEXT20
AccountAssignmentCategory Account Assignment Category KNTTP
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
NoDaysReminder3 Number of Days for Third Reminder/Expediter MAHNT
NoDaysReminder2 Number of Days for Second Reminder/Expediter MAHNT
NoDaysReminder1 Number of Days for First Reminder/Expediter MAHNT
TaxCode Tax on sales/purchases code MWSKZ
SupplierMaterialNumber Material Number Used by Supplier IDNEX
PurchasingInfoRecord Number of purchasing info record INFNR
MaterialGroup Material Group MATKL
ItemIncotermsClassification Incoterms (Part 1) INCO1
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
CompanyCodeName Name of Company Code or Company TEXT25
TaxCalculationProcedure Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM
MaterialTypeName Description of Material Type TEXT25
PurchasingDocumentCategoryName Purchasing Document Category Name DDTEXT
PurchasingDocumentItemCategory Item category in purchasing document PSTYP
PurchasingGroupName Purchasing Group Name TEXT18
MaterialGroupName Product Group Description TEXT20
EmploymentInternalID Personnel Number PERNR
PartnerCounter Partner counter PARZA
PartnerFunction Partner Function PARVW
SupplierContact Number of Contact Person PARNR
ReferenceSupplier Reference to other supplier LIFNR
SupplierSubrange Supplier Subrange LTSNR
NumberOfContractItems Number of Contracts
PreferredSupplierName Supplier Name TEXT80
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_SCHEDULEAGMTMASSUPDATE.COMPANYCODE == T001.BUKRS
  • P_SCHEDULEAGMTMASSUPDATE.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_SCHEDULEAGMTMASSUPDATE.MANDT == TCURC.MANDT
  • P_SCHEDULEAGMTMASSUPDATE.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • P_SCHEDULEAGMTMASSUPDATE.MANDT == TINC.MANDT
  • P_SCHEDULEAGMTMASSUPDATE.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Incoterms Version
  • Client
  • P_SCHEDULEAGMTMASSUPDATE.INCOTERMSVERSION == TINCV.INCOV
  • P_SCHEDULEAGMTMASSUPDATE.MANDT == TINCV.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • ?
  • Client
  • P_SCHEDULEAGMTMASSUPDATE.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_SCHEDULEAGMTMASSUPDATE.[column in domain "BSTYP"] == T161.BSTYP
  • P_SCHEDULEAGMTMASSUPDATE.MANDT == T161.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • P_SCHEDULEAGMTMASSUPDATE.MANDT == T024.MANDT
  • P_SCHEDULEAGMTMASSUPDATE.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_SCHEDULEAGMTMASSUPDATE.MANDT == T024E.MANDT
  • P_SCHEDULEAGMTMASSUPDATE.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • P_SCHEDULEAGMTMASSUPDATE.SUPPLIER == LFA1.LIFNR
  • P_SCHEDULEAGMTMASSUPDATE.MANDT == LFA1.MANDT