C_PurgOrgLvlInfoRecdMassUpdt

Mass Changes to Purchasing Info Records | view: CPIRPOLMASS | Extraction: Not supported | Component: Info Record

Tables used: T069T, T005T, TINCT, TINCVT, MARA, T023T, MAKT, T001W, T024, EINA, T024E, EINE, T005U, TWRVT, T027B, LFA1, T163M, WYT1T, ADCP, ADR2, ADR3, ADR6, ADRP, USR21

🔑 Keys (4)
💰 Amounts
∑ Quantities (4)
📅 Dates (5)
☰ Categorical
Other (64)
🔗 Relations (24)

Column Name	Description
PurchasingInfoRecord FK	Number of purchasing info record
PurchasingInfoRecordCategory	Purchasing info record category
PurchasingOrganization FK	Purchasing organization
Plant FK	Plant

Column Name	Description

Column Name	Description
📏 Points Unit (ProductPurchasePointsQtyUnit):
ProductPurchasePointsQty	Number of Points
📏 Order Price Unit (Purchasing) (PurchaseOrderPriceUnit):
MinimumPurchaseOrderQuantity	Minimum Purchase Order Quantity
StandardPurchaseOrderQuantity	Standard Purchase Order Quantity
MaximumOrderQuantity	Maximum Purchase Order Quantity

Column Name	Description
CreationDate	Date on which the record was created
AvailabilityStartDate	Available (Deliverable) From
AvailabilityEndDate	Available (Deliverable) Until
SupplierCertValidityEndDate	Certificate of Origin Valid Until
TimeDependentTaxValidFromDate	Valid-From Date of the Tax Rate

Column Name	Description

Column Name	Description	Domain name
PlantName	Plant Name	TEXT30
PurchasingOrganizationName	Purchasing Organization Name
FormattedInfoRec	null
PurchasingGroupName	Purchasing Group Name
MaterialConditionGroup	Condition Group with Supplier
IsMarkedForDeletion	Purch. info: Purch. organization data flagged for deletion
MaterialName	Material Description	TEXT40
SupplierName	Name of Supplier	TEXT80
SupplierSubrangeName	Description of Supplier Subrange	TEXT20
MaterialGroup	Material Group
MaterialGroupName	Product Group Description	TEXT20
IsDeleted	Purchasing info: General data flagged for deletion
PurchasingInfoRecordDesc	Short Text for Purchasing Info Record
SupplierMaterialNumber	Material Number Used by Supplier
SupplierRespSalesPersonName	Salesperson Responsible in the Event of Queries
SupplierPhoneNumber	Supplier's Telephone Number
SupplierMaterialGroup	Supplier Material Group
PriorSupplierName	Name of Supplier	TEXT80
VarblPurOrdUnitIsActive	Variable Purchase Order Unit Active
Manufacturer	Manufacturer
ManufacturerName	Name of Supplier	TEXT80
IsRegularSupplier	Regular Supplier
NoDaysReminder1	Number of Days for First Reminder/Expediter
NoDaysReminder2	Number of Days for Second Reminder/Expediter
NoDaysReminder3	Number of Days for Third Reminder/Expediter
ReturnAgreementName	Description	TEXT40
SupplierCertOriginCatName	Certificate text	CHAR10
SupplierCertOriginNumber	Certificate Number
CountryName	Country/Region Name	TEXT50
RegionName	Description	TEXT20
SuplrCertOriginClassfctnNumber	Number
SupplierSubrangeSortNumber	Sort Sequence Number
OrderItemQtyToBaseQtyNmrtr	Numerator for Conversion of Order Unit to Base Unit
OrderItemQtyToBaseQtyDnmntr	Denominator for Conversion of Order Unit to Base Unit
MaterialPlannedDeliveryDurn	Planned Delivery Time in Days
OverdelivTolrtdLmtRatioInPct	Overdelivery Tolerance
UnderdelivTolrtdLmtRatioInPct	Underdelivery Tolerance
UnlimitedOverdeliveryIsAllowed	Unlimited Overdelivery Allowed
InvoiceIsGoodsReceiptBased	Indicator: GR-Based Invoice Verification
TaxCountryName	Country/Region Name	TEXT50
IncotermsClassificationName	Description	TEXT30
IncotermsLocation1	Incoterms Location 1
IncotermsLocation2	Incoterms Location 2
IsRelevantForAutomSrcg	Checkbox
IncotermsVersionName	Description	TEXT30
MinRemainingShelfLife	Minimum Remaining Shelf Life
ShippingInstructionName	Shipping Instructions: Description	TEXT30
IsEvaluatedRcptSettlmtAllowed	No Evaluated Receipt Settlement (ERS)
IsOrderAcknRqd	Order Acknowledgment Requirement
SupplierConfControlKeyName	Confirmation Category: Description	TEXT20
MaterialStagingTime	Staging Time in Days
IsRetMatlAuthznRqdBySupplier	Supplier RMA Number Required
IsCashDiscountGranted	Item Does Not Qualify for Cash Discount
PricingDateControl	Price Determination (Pricing) Date Control
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
CreatedByUserName	Full Name of Person
ShelfLifeExpirationDatePeriod	Period indicator
ShelfLifeExpirationDateText	Short Text for Fixed Values	DDTEXT
IncotermsTransferLocation	Incoterms (Part 2)
InternalComment	null
PurchasingDocInclusionList	null
PurchasingDocExclusionList	null
PurOrdItemsAreSelected	null
PurOrdHeadersAreSelected	null

Master Data Relations	Join Conditions
Base Unit of Measure Base Unit of Measure Client	`C_PURGORGLVLINFORECDMASSUPDT.BASEUNIT == T006.MSEHI` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T006.MANDT`
Incoterms (Part 1) Incoterms (Part 1) Client	`C_PURGORGLVLINFORECDMASSUPDT.INCOTERMSCLASSIFICATION == TINC.INCO1` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == TINC.MANDT`
Incoterms Version Incoterms Version Client	`C_PURGORGLVLINFORECDMASSUPDT.INCOTERMSVERSION == TINCV.INCOV` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == TINCV.MANDT`
Material Number Client Material Number	`C_PURGORGLVLINFORECDMASSUPDT.MANDT == MARA.MANDT` `C_PURGORGLVLINFORECDMASSUPDT.MATERIAL == MARA.MATNR`
Rounding Profile Plant Rounding Profile ? Client	`C_PURGORGLVLINFORECDMASSUPDT.PLANT == RDPR.WERKS` `C_PURGORGLVLINFORECDMASSUPDT.MATERIALROUNDINGPROFILE == RDPR.RDPRF` `C_PURGORGLVLINFORECDMASSUPDT.[column in domain "RDZAE"] == RDPR.RDZAE` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == RDPR.MANDT`
Plant Plant Client	`C_PURGORGLVLINFORECDMASSUPDT.PLANT == T001W.WERKS` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T001W.MANDT`
Prior Supplier Prior Supplier Client	`C_PURGORGLVLINFORECDMASSUPDT.PRIORSUPPLIER == LFA1.LIFNR` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == LFA1.MANDT`
Points Unit Points Unit Client	`C_PURGORGLVLINFORECDMASSUPDT.PRODUCTPURCHASEPOINTSQTYUNIT == T006.MSEHI` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T006.MANDT`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_PURGORGLVLINFORECDMASSUPDT.PURCHASEORDERPRICEUNIT == T006.MSEHI` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T006.MANDT`
Purchasing Group Purchasing Group Client	`C_PURGORGLVLINFORECDMASSUPDT.PURCHASINGGROUP == T024.EKGRP` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T024.MANDT`
Number of purchasing info record Number of purchasing info record Client	`C_PURGORGLVLINFORECDMASSUPDT.PURCHASINGINFORECORD == EINA.INFNR` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == EINA.MANDT`
Purchasing organization Purchasing organization Client	`C_PURGORGLVLINFORECDMASSUPDT.PURCHASINGORGANIZATION == T024E.EKORG` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T024E.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`C_PURGORGLVLINFORECDMASSUPDT.PURGDOCORDERQUANTITYUNIT == T006.MSEHI` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T006.MANDT`
Return Agreement Return Agreement Client	`C_PURGORGLVLINFORECDMASSUPDT.RETURNAGREEMENT == TWRV.RUECV` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == TWRV.MANDT`
Shipping Instructions Shipping Instructions Client	`C_PURGORGLVLINFORECDMASSUPDT.SHIPPINGINSTRUCTION == T027A.EVERS` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T027A.MANDT`
Vendor's account number Vendor's account number Client	`C_PURGORGLVLINFORECDMASSUPDT.SUPPLIER == LFA1.LIFNR` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == LFA1.MANDT`
Certificate Category Certificate Category Client	`C_PURGORGLVLINFORECDMASSUPDT.SUPPLIERCERTORIGINCAT == T069.URZTP` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T069.MANDT`
Country/Region of Issue of Certificate of Origin Country/Region of Issue of Certificate of Origin Client	`C_PURGORGLVLINFORECDMASSUPDT.SUPPLIERCERTORIGINCOUNTRY == T005.LAND1` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T005.MANDT`
Region (State, Province, County) Region (State, Province, County) Country/Region of Issue of Certificate of Origin Client	`C_PURGORGLVLINFORECDMASSUPDT.SUPPLIERCERTORIGINREGION == T005S.BLAND` `C_PURGORGLVLINFORECDMASSUPDT.SUPPLIERCERTORIGINCOUNTRY == T005S.LAND1` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T005S.MANDT`
Confirmation Control Key Confirmation Control Key Client	`C_PURGORGLVLINFORECDMASSUPDT.SUPPLIERCONFIRMATIONCONTROLKEY == T163L.BSTAE` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T163L.MANDT`
Supplier Subrange Vendor's account number Supplier Subrange Client	`C_PURGORGLVLINFORECDMASSUPDT.SUPPLIER == WYT1.LIFNR` `C_PURGORGLVLINFORECDMASSUPDT.SUPPLIERSUBRANGE == WYT1.LTSNR` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == WYT1.MANDT`
Tax on sales/purchases code ? Tax on sales/purchases code Client	`C_PURGORGLVLINFORECDMASSUPDT.[column in domain "KALSM_D"] == T007A.KALSM` `C_PURGORGLVLINFORECDMASSUPDT.TAXCODE == T007A.MWSKZ` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T007A.MANDT`
Input help for tax country Tax Reporting Country/Region Client	`C_PURGORGLVLINFORECDMASSUPDT.TAXCOUNTRY == T005.LAND1` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == T005.MANDT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Unit of Measure Group Unit of Measure Group ? Client	`C_PURGORGLVLINFORECDMASSUPDT.PRODUCTUNITGROUP == TWMEG.MEGRU` `C_PURGORGLVLINFORECDMASSUPDT.[column in domain "LRMEI"] == TWMEG.MEINS` `C_PURGORGLVLINFORECDMASSUPDT.MANDT == TWMEG.MANDT`