C_PurInfoRecdSupplPrcgCndn

Supplementary PIR Pricing Condition | view: CPIRSUPRGCN | Extraction: Not supported | Component: Info Record

Tables used: T685, T685A, EINA, EINE, A017, A018, A025, A028, A066, A067, KONH, KONP

🔑 Keys (3)
💰 Amounts (3)
∑ Quantities
📅 Dates (3)
☰ Categorical (5)
Other (3)
🔗 Relations (13)

Column Name	Description
ConditionRecord	Number of the Condition Record
ConditionSequentialNumber	Sequential number of the condition
ConditionValidityEndDate	Validity end date of the condition record

Column Name	Description
💲 Condition Unit (Currency or Percentage) (ConditionRateValueUnit):
ConditionRateValue	Condition amount or percentage where no scale exists
ConditionLowerLimit	Lower limit of the condition rate/amount
ConditionUpperLimit	Upper limit for the condition rate

Column Name	Description

Column Name	Description
ConditionValidityEndDate	Validity end date of the condition record
ConditionValidityStartDate	Validity start date of the condition record
CreationDate	Date on which the record was created

Column Name	Description
PurchasingInfoRecordCategory	Purchasing info record category	Show values
ConditionCalculationType	Calculation Type for Condition	Show values
ConditionIsDeleted	Deletion Indicator for Condition Record	Show values
ConditionCategory	Condition Category (Examples: Tax, Freight, Price, Cost)	Show values
ConditionReleaseStatus	Release Status	Show values

Column Name	Description	Domain name
MaterialGroup	Material Group	MATKL
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
ConditionQuantity	Condition Pricing Unit	KPEIN

Master Data Relations	Join Conditions
Base Unit of Measure Base Unit of Measure Client	`C_PURINFORECDSUPPLPRCGCNDN.BASEUNIT == T006.MSEHI` `C_PURINFORECDSUPPLPRCGCNDN.MANDT == T006.MANDT`
Condition Currency (for Cumulation Fields) Condition Currency (for Cumulation Fields) Client	`C_PURINFORECDSUPPLPRCGCNDN.CONDITIONALTERNATIVECURRENCY == TCURC.WAERS` `C_PURINFORECDSUPPLPRCGCNDN.MANDT == TCURC.MANDT`
Application	`C_PURINFORECDSUPPLPRCGCNDN.CONDITIONAPPLICATION == T681A.KAPPL`
Condition exclusion indicator Condition exclusion indicator Application Client	`C_PURINFORECDSUPPLPRCGCNDN.CONDITIONEXCLUSION == T686A.KZNEP` `C_PURINFORECDSUPPLPRCGCNDN.CONDITIONAPPLICATION == T686A.KAPPL` `C_PURINFORECDSUPPLPRCGCNDN.MANDT == T686A.MANDT`
Condition Unit Condition Unit Client	`C_PURINFORECDSUPPLPRCGCNDN.CONDITIONQUANTITYUNIT == T006.MSEHI` `C_PURINFORECDSUPPLPRCGCNDN.MANDT == T006.MANDT`
Condition Unit (Currency or Percentage) Condition Unit (Currency or Percentage) Client	`C_PURINFORECDSUPPLPRCGCNDN.CONDITIONRATEVALUEUNIT == TCURC.WAERS` `C_PURINFORECDSUPPLPRCGCNDN.MANDT == TCURC.MANDT`
Condition Type ? Application Condition Type Condition Type Client	`C_PURINFORECDSUPPLPRCGCNDN.[column in domain "KVEWE"] == T685.KVEWE` `C_PURINFORECDSUPPLPRCGCNDN.CONDITIONAPPLICATION == T685.KAPPL` `C_PURINFORECDSUPPLPRCGCNDN.CONDITIONTYPE == T685.KSCHL` `C_PURINFORECDSUPPLPRCGCNDN.PURGPRICINGCONDITIONTYPE == T685.KSCHL` `C_PURINFORECDSUPPLPRCGCNDN.MANDT == T685.MANDT`
Material Number Material Number Client	`C_PURINFORECDSUPPLPRCGCNDN.MATERIAL == MARA.MATNR` `C_PURINFORECDSUPPLPRCGCNDN.MANDT == MARA.MANDT`
Plant Client Plant	`C_PURINFORECDSUPPLPRCGCNDN.MANDT == T001W.MANDT` `C_PURINFORECDSUPPLPRCGCNDN.PLANT == T001W.WERKS`
Number of purchasing info record Number of purchasing info record Client	`C_PURINFORECDSUPPLPRCGCNDN.PURCHASINGINFORECORD == EINA.INFNR` `C_PURINFORECDSUPPLPRCGCNDN.MANDT == EINA.MANDT`
Purchasing organization Purchasing organization Client	`C_PURINFORECDSUPPLPRCGCNDN.PURCHASINGORGANIZATION == T024E.EKORG` `C_PURINFORECDSUPPLPRCGCNDN.MANDT == T024E.MANDT`
Condition Type ? Application Condition Type Condition Type Client	`C_PURINFORECDSUPPLPRCGCNDN.[column in domain "KVEWE"] == T685.KVEWE` `C_PURINFORECDSUPPLPRCGCNDN.CONDITIONAPPLICATION == T685.KAPPL` `C_PURINFORECDSUPPLPRCGCNDN.CONDITIONTYPE == T685.KSCHL` `C_PURINFORECDSUPPLPRCGCNDN.PURGPRICINGCONDITIONTYPE == T685.KSCHL` `C_PURINFORECDSUPPLPRCGCNDN.MANDT == T685.MANDT`
Vendor's account number Vendor's account number Client	`C_PURINFORECDSUPPLPRCGCNDN.SUPPLIER == LFA1.LIFNR` `C_PURINFORECDSUPPLPRCGCNDN.MANDT == LFA1.MANDT`