C_MassUpdtSchedgAgrmtPartner

Scheduling Agreement Partner | view: CSCHDGAGRMTPRTNR | Extraction: Not supported | Component: Scheduling Agreement

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

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

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

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
SchedgAgrmtPartner	Partner	KTONR
SchedgAgrmtPartnerName	Partner Name	NAME
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
PreferredSupplierName	Name of Supplier	TEXT80
SupplierContact	Number of Contact Person	PARNR
EmploymentInternalID	Personnel Number	PERNR
PartnerFunctionName	Name	TEXT20

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