C_PurchaseContractMassUpdt

Mass Changes to Purchase Contracts | view: CCTRMASSCHANGE | TRAN | Extraction: Not supported | Component: Contract

Tables used: EKKO, EKKO, BUT000, T001, TKA02, TB913, TINC, TINCT, TINCV, TINCVT, TPAR, T052, TVZBT, EKPA, T024, T024E, ADR2, ADR6, LFA1, LFA1, ADCP, ADR2, ADR6, ADRC, ADRP, TSAD3, KNVK

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities
📅 Dates (3)
☰ Categorical (3)
Other (24)
🔗 Relations (11)

Column Name	Description
PurchaseContract	Purchasing Contract Header
PartnerFunction FK	Partner Function
PartnerCounter	Partner counter

Column Name	Description
💲 Currency Key (DocumentCurrency):
PurchaseContractTargetAmount	Target Value for Header Area per Distribution

Column Name	Description

Column Name	Description
CreationDate	Purchase Contract Date
ValidityStartDate	Valid From
ValidityEndDate	Valid To

Column Name	Description
ExchangeRateIsFixed	Indicator for Fixed Exchange Rate	Show values
PurchaseContractValidityStatus	Validity Status	Show values
PurContrValidityStatusName	Contract Status	Show values

Column Name	Description	Domain name
ExchangeRate	Exchange Rate
SupplierName	Name of Supplier	TEXT80
CompanyCodeName	Name of Company Code or Company	TEXT25
PurchasingOrganizationName	Purchasing Organization Name	TEXT20
PurchasingGroupName	Purchasing Group Name	TEXT18
IncotermsClassificationName	Description	TEXT30
PaymentTerms	Terms of Payment Key	ZTERM
PaymentTermsName	Description of terms of payment	TEXT30
NumberOfBusinessPartners	null
CorrespncExternalReference	Your Reference	TEXT12
CorrespncInternalReference	Our Reference	TEXT12
SupplierRespSalesPersonName	Responsible Salesperson at Supplier's Office	TEXT30
SupplierPhoneNumber	Supplier's Telephone Number	TEXT16
PurchasingDocumentName	Name of Purchasing Document	TEXT40
IncotermsVersionName	Description	TEXT30
IncotermsLocation1	Incoterms Location 1	INCO_L
IncotermsLocation2	Incoterms Location 2	INCO_L
MaterialGroup	Material Group	MATKL
Plant	Plant	WERKS
Material	Material Number	MATNR
PurchasingDocumentItemCategory	Item category in purchasing document	PSTYP
AccountAssignmentCategory	Account Assignment Category	KNTTP
PurchasingContractDeletionCode	null
PreferredSupplierName	Name of Supplier	TEXT80

Master Data Relations	Join Conditions
Company Code Company Code Client	`C_PURCHASECONTRACTMASSUPDT.COMPANYCODE == T001.BUKRS` `C_PURCHASECONTRACTMASSUPDT.MANDT == T001.MANDT`
Currency Key Currency Key Client	`C_PURCHASECONTRACTMASSUPDT.DOCUMENTCURRENCY == TCURC.WAERS` `C_PURCHASECONTRACTMASSUPDT.MANDT == TCURC.MANDT`
Incoterms (Part 1) Client Incoterms (Part 1)	`C_PURCHASECONTRACTMASSUPDT.MANDT == TINC.MANDT` `C_PURCHASECONTRACTMASSUPDT.INCOTERMSCLASSIFICATION == TINC.INCO1`
Incoterms Version Client Incoterms Version	`C_PURCHASECONTRACTMASSUPDT.MANDT == TINCV.MANDT` `C_PURCHASECONTRACTMASSUPDT.INCOTERMSVERSION == TINCV.INCOV`
Partner Function Partner Function Client	`C_PURCHASECONTRACTMASSUPDT.PARTNERFUNCTION == TPAR.PARVW` `C_PURCHASECONTRACTMASSUPDT.MANDT == TPAR.MANDT`
Purchasing Document Type Purchasing Document Type Client ?	`C_PURCHASECONTRACTMASSUPDT.PURCHASECONTRACTTYPE == T161.BSART` `C_PURCHASECONTRACTMASSUPDT.MANDT == T161.MANDT` `C_PURCHASECONTRACTMASSUPDT.[column in domain "BSTYP"] == T161.BSTYP`
Purchasing Group Client Purchasing Group	`C_PURCHASECONTRACTMASSUPDT.MANDT == T024.MANDT` `C_PURCHASECONTRACTMASSUPDT.PURCHASINGGROUP == T024.EKGRP`
Purchasing Organization Purchasing Organization Client	`C_PURCHASECONTRACTMASSUPDT.PURCHASINGORGANIZATION == T024E.EKORG` `C_PURCHASECONTRACTMASSUPDT.MANDT == T024E.MANDT`
Account Number of Supplier Client Account Number of Supplier	`C_PURCHASECONTRACTMASSUPDT.MANDT == LFA1.MANDT` `C_PURCHASECONTRACTMASSUPDT.REFERENCESUPPLIER == LFA1.LIFNR`
Supplier Supplier Client	`C_PURCHASECONTRACTMASSUPDT.SUPPLIER == LFA1.LIFNR` `C_PURCHASECONTRACTMASSUPDT.MANDT == LFA1.MANDT`
Supplier Subrange Supplier Subrange Client Account Number of Supplier	`C_PURCHASECONTRACTMASSUPDT.SUPPLIERSUBRANGE == WYT1.LTSNR` `C_PURCHASECONTRACTMASSUPDT.MANDT == WYT1.MANDT` `C_PURCHASECONTRACTMASSUPDT.REFERENCESUPPLIER == WYT1.LIFNR`