P_PrcgCndnRecordItem

DDL: P_PRCGCNDNRECORDITEM Type: view BASIC
33 Fields 1 Data Sources

P_PrcgCndnRecordItem is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (konp) and exposes 33 fields with key fields ConditionRecord, ConditionSequentialNumber.

Data Sources (1)

SourceAliasJoin Type
konp konp from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPRCGCNDNRECDITM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord knumh NoCondRec.Batch
KEY ConditionSequentialNumber kopos SequNo of Cond.
ConditionType kschl Tax Item Type
ConditionTextID knumt Text number
PricingScaleType stfkz Scale Type
PricingScaleBasis kzbzg Scale Basis
ConditionScaleQuantity kstbm Scale Quantity
ConditionScaleQuantityUnit konms Scale UoM
ConditionScaleAmount kstbw Scale Value
ConditionScaleAmountCurrency konws Scale Currency
ConditionCalculationType krech Calculat.Type
ConditionRateValueUnit konwa Cond. Currency
ConditionQuantity kpein Pricing Unit
ConditionQuantityUnit kmein Unit of Measure
ConditionToBaseQtyNmrtr kumza Numerator
ConditionToBaseQtyDnmntr kumne Denominator
BaseUnit meins Valuation Unit
ConditionAlternativeCurrency kwaeh Cndn Currency
ConditionExclusion kznep Exclusion
ConditionIsDeleted loevm_ko Deletion Indic.
AdditionalValueDays valtg Add.Value Days
PaymentTerms zterm Terms of Payment
CndnMaxNumberOfSalesOrders anzauf NumberOfOrders
MinimumConditionBasisValue mikbas MinCondBaseVal.
MaximumConditionBasisValue mxkbas MaxCondBaseVal.
MaximumConditionAmount komxwrt MaxConditValue
IncrementalScale klf_stg Increment scale
PricingScaleLine klf_kal Pricing scale
ConditionReleaseStatus kfrst Release Status
ConditionChangeReason cndn_chgreason Cndn Change Reason
ConditionTaxCode mwsk1 Tax Code
ConditionWithholdingTaxCode mwsk2 W/Tax Code
CmmdtyPrcgConditionFormulaUUID cmmdtyprcgcndnfmlauuid Doc. Cond. Item GUID

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_PrcgCndnRecordItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_PrcgCndnRecordItem AS
SELECT
  knumh AS ConditionRecord,
  kopos AS ConditionSequentialNumber,
  kschl AS ConditionType,
  knumt AS ConditionTextID,
  stfkz AS PricingScaleType,
  kzbzg AS PricingScaleBasis,
  kstbm AS ConditionScaleQuantity,
  konms AS ConditionScaleQuantityUnit,
  kstbw AS ConditionScaleAmount,
  konws AS ConditionScaleAmountCurrency,
  krech AS ConditionCalculationType,
  konwa AS ConditionRateValueUnit,
  kpein AS ConditionQuantity,
  kmein AS ConditionQuantityUnit,
  kumza AS ConditionToBaseQtyNmrtr,
  kumne AS ConditionToBaseQtyDnmntr,
  meins AS BaseUnit,
  kwaeh AS ConditionAlternativeCurrency,
  kznep AS ConditionExclusion,
  loevm_ko AS ConditionIsDeleted,
  valtg AS AdditionalValueDays,
  zterm AS PaymentTerms,
  anzauf AS CndnMaxNumberOfSalesOrders,
  mikbas AS MinimumConditionBasisValue,
  mxkbas AS MaximumConditionBasisValue,
  komxwrt AS MaximumConditionAmount,
  klf_stg AS IncrementalScale,
  klf_kal AS PricingScaleLine,
  kfrst AS ConditionReleaseStatus,
  cndn_chgreason AS ConditionChangeReason,
  mwsk1 AS ConditionTaxCode,
  mwsk2 AS ConditionWithholdingTaxCode,
  cmmdtyprcgcndnfmlauuid AS CmmdtyPrcgConditionFormulaUUID
FROM konp
;

Learn More