I_SchedgAgrmtPartnWD

Scheduling Agreement Partners with Draft | view: ISAPARTNER000WD | Extraction: Not supported | Component: Scheduling Agreement

Tables used: EKKO, BUT000, TB913, TPAR, EKPA, T161T, ADR2, ADR6, LFA1, USR21, ADCP, ADRC, ADRP, TSAD3, KNVK

🔑 Keys (7)
💰 Amounts
∑ Quantities
📅 Dates (1)
☰ Categorical (2)
Other (7)
🔗 Relations (14)

Column Name	Description
PartnerCounter	Partner counter
PartnerFunction FK	Partner Function
Plant FK	Plant
SupplierSubrange FK	Supplier Subrange
PurchasingOrganization FK	Purchasing organization
SchedulingAgreementItem FK	Item Number of Purchasing Document
SchedulingAgreement FK	Purchasing Document Number

Column Name	Description

Column Name	Description

Column Name	Description
CreationDate	Date on which the record was created

Column Name	Description
SchedgAgrmtCategory	Purchasing Document Category	Show values
DefaultPartner	Default Partner	Show values

Column Name	Description	Domain name
PartnerCounterForEdit	Partner counter	PARZA
SchedgAgrmtPartner	Partner	KTONR
SchedgAgrmtPartnerName	Partner Name	NAME
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
SupplierContact	Number of Contact Person	PARNR
EmploymentInternalID	Personnel Number	PERNR
PersonWorkAgreement	Personnel Number	PERNR

Master Data Relations	Join Conditions
Partner Function Client Partner Function Partner Function	`I_SCHEDGAGRMTPARTNWD.MANDT == TPAR.MANDT` `I_SCHEDGAGRMTPARTNWD.PARTNERFUNCTIONFOREDIT == TPAR.PARVW` `I_SCHEDGAGRMTPARTNWD.PARTNERFUNCTION == TPAR.PARVW`
Partner Function Client Partner Function Partner Function	`I_SCHEDGAGRMTPARTNWD.MANDT == TPAR.MANDT` `I_SCHEDGAGRMTPARTNWD.PARTNERFUNCTIONFOREDIT == TPAR.PARVW` `I_SCHEDGAGRMTPARTNWD.PARTNERFUNCTION == TPAR.PARVW`
Plant Plant Plant Client	`I_SCHEDGAGRMTPARTNWD.PLANTFOREDIT == T001W.WERKS` `I_SCHEDGAGRMTPARTNWD.PLANT == T001W.WERKS` `I_SCHEDGAGRMTPARTNWD.MANDT == T001W.MANDT`
Plant Plant Plant Client	`I_SCHEDGAGRMTPARTNWD.PLANTFOREDIT == T001W.WERKS` `I_SCHEDGAGRMTPARTNWD.PLANT == T001W.WERKS` `I_SCHEDGAGRMTPARTNWD.MANDT == T001W.MANDT`
Purchasing Document Type Client Purchasing Document Type Purchasing Document Type Purchasing Document Category	`I_SCHEDGAGRMTPARTNWD.MANDT == T161.MANDT` `I_SCHEDGAGRMTPARTNWD.PURCHASINGDOCUMENTTYPE == T161.BSART` `I_SCHEDGAGRMTPARTNWD.SCHEDGAGRMTTYPE == T161.BSART` `I_SCHEDGAGRMTPARTNWD.SCHEDGAGRMTCATEGORY == T161.BSTYP`
Purchasing Group Client Purchasing Group	`I_SCHEDGAGRMTPARTNWD.MANDT == T024.MANDT` `I_SCHEDGAGRMTPARTNWD.PURCHASINGGROUP == T024.EKGRP`
Purchasing organization Client Purchasing organization Purchasing organization	`I_SCHEDGAGRMTPARTNWD.MANDT == T024E.MANDT` `I_SCHEDGAGRMTPARTNWD.PURCHASINGORGANIZATION == T024E.EKORG` `I_SCHEDGAGRMTPARTNWD.PURCHASINGORGFOREDIT == T024E.EKORG`
Purchasing organization Client Purchasing organization Purchasing organization	`I_SCHEDGAGRMTPARTNWD.MANDT == T024E.MANDT` `I_SCHEDGAGRMTPARTNWD.PURCHASINGORGANIZATION == T024E.EKORG` `I_SCHEDGAGRMTPARTNWD.PURCHASINGORGFOREDIT == T024E.EKORG`
Purchasing Document Type Client Purchasing Document Type Purchasing Document Type Purchasing Document Category	`I_SCHEDGAGRMTPARTNWD.MANDT == T161.MANDT` `I_SCHEDGAGRMTPARTNWD.PURCHASINGDOCUMENTTYPE == T161.BSART` `I_SCHEDGAGRMTPARTNWD.SCHEDGAGRMTTYPE == T161.BSART` `I_SCHEDGAGRMTPARTNWD.SCHEDGAGRMTCATEGORY == T161.BSTYP`
Account Number of Supplier Account Number of Supplier Client	`I_SCHEDGAGRMTPARTNWD.SUPPLIER == LFA1.LIFNR` `I_SCHEDGAGRMTPARTNWD.MANDT == LFA1.MANDT`
Supplier Subrange Account Number of Supplier Client Supplier Subrange Supplier Subrange	`I_SCHEDGAGRMTPARTNWD.SUPPLIER == WYT1.LIFNR` `I_SCHEDGAGRMTPARTNWD.MANDT == WYT1.MANDT` `I_SCHEDGAGRMTPARTNWD.SUPPLIERSUBRANGE == WYT1.LTSNR` `I_SCHEDGAGRMTPARTNWD.SUPPLIERSUBRANGEFOREDIT == WYT1.LTSNR`
Supplier Subrange Account Number of Supplier Client Supplier Subrange Supplier Subrange	`I_SCHEDGAGRMTPARTNWD.SUPPLIER == WYT1.LIFNR` `I_SCHEDGAGRMTPARTNWD.MANDT == WYT1.MANDT` `I_SCHEDGAGRMTPARTNWD.SUPPLIERSUBRANGE == WYT1.LTSNR` `I_SCHEDGAGRMTPARTNWD.SUPPLIERSUBRANGEFOREDIT == WYT1.LTSNR`