R_PrcgDocumentHeaderElementTP
Pricing Document Header Element - TP
R_PrcgDocumentHeaderElementTP is a Transactional CDS View that provides data about "Pricing Document Header Element - TP" in SAP S/4HANA. It reads from 1 data source (P_PricingDocumentHeaderElement) and exposes 58 fields with key fields PricingDocument, PrcgDocumentHostObjectNodeID, PrcgDocHostObjSONTInUppercase, PricingProcedureStep, PricingDocumentElementCounter. Part of development package VF_PRC_RAP_ROOT.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_PricingDocumentHeaderElement | PricingDocumentElement | from |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| ObjectModel.sapObjectNodeType.name | PricingDocumentHeaderElement | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| EndUserText.label | Pricing Document Header Element - TP | view |
Fields (58)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PricingDocument | P_PricingDocumentHeaderElement | PricingDocument | Document Condition |
| KEY | PrcgDocumentHostObjectNodeID | P_PricingDocumentHeaderElement | PrcgDocumentHostObjectNodeID | |
| KEY | PrcgDocHostObjSONTInUppercase | P_PricingDocumentHeaderElement | PrcgDocHostObjSONTInUppercase | |
| KEY | PricingProcedureStep | P_PricingDocumentHeaderElement | PricingProcedureStep | Step Number |
| KEY | PricingDocumentElementCounter | P_PricingDocumentHeaderElement | PricingDocumentElementCounter | Pricing Procedure Counter |
| ConditionApplication | P_PricingDocumentHeaderElement | ConditionApplication | Application | |
| ConditionType | P_PricingDocumentHeaderElement | ConditionType | Condition type | |
| ConditionTypeName | ||||
| ConditionCalculationType | P_PricingDocumentHeaderElement | ConditionCalculationType | Calculat.Type | |
| ConditionCategory | P_PricingDocumentHeaderElement | ConditionCategory | Condit.Category | |
| PriceConditionDeterminationDte | P_PricingDocumentHeaderElement | PriceConditionDeterminationDte | Condition Pricing Date | |
| ConditionRateAmount | P_PricingDocumentHeaderElement | ConditionRateAmount | Condition Amount | |
| ConditionRateRatio | P_PricingDocumentHeaderElement | ConditionRateRatio | Ratio | |
| ConditionBaseAmount | P_PricingDocumentHeaderElement | ConditionBaseAmount | Condition Basis Amount | |
| ConditionBaseQuantity | P_PricingDocumentHeaderElement | ConditionBaseQuantity | Quantity | |
| ConditionQuantity | P_PricingDocumentHeaderElement | ConditionQuantity | Pricing Unit | |
| ConditionAmount | P_PricingDocumentHeaderElement | ConditionAmount | Condition Value | |
| ConditionCurrency | P_PricingDocumentHeaderElement | ConditionCurrency | Currency | |
| TransactionCurrency | P_PricingDocumentHeaderElement | TransactionCurrency | Transaction Currency | |
| ConditionQuantityUnit | P_PricingDocumentHeaderElement | ConditionQuantityUnit | Unit of Measure | |
| ConditionRateRatioUnit | P_PricingDocumentHeaderElement | ConditionRateRatioUnit | Unit of Measure | |
| ConditionInactiveReason | P_PricingDocumentHeaderElement | ConditionInactiveReason | Inactive | |
| ConditionClass | P_PricingDocumentHeaderElement | ConditionClass | Condition Class | |
| ConditionOrigin | P_PricingDocumentHeaderElement | ConditionOrigin | Condit.Origin | |
| VariantCondition | P_PricingDocumentHeaderElement | VariantCondition | Variant Key | |
| CndnRoundingOffDiffAmount | P_PricingDocumentHeaderElement | CndnRoundingOffDiffAmount | CondRoundDiff. | |
| TaxCode | P_PricingDocumentHeaderElement | TaxCode | Tax Code | |
| StructureCondition | P_PricingDocumentHeaderElement | StructureCondition | Structure Cond. | |
| IsGroupCondition | P_PricingDocumentHeaderElement | IsGroupCondition | Group Condition | |
| ConditionIsForConfiguration | P_PricingDocumentHeaderElement | ConditionIsForConfiguration | UsedfVarConfig | |
| IsRelevantForAccrual | P_PricingDocumentHeaderElement | IsRelevantForAccrual | Accruals | |
| CndnIsRelevantForIntcoBilling | P_PricingDocumentHeaderElement | CndnIsRelevantForIntcoBilling | IntcoBillCond | |
| ConditionRecord | P_PricingDocumentHeaderElement | ConditionRecord | Cond.Record No. | |
| ConditionControl | P_PricingDocumentHeaderElement | ConditionControl | Cond.Control | |
| ConditionIsForStatistics | P_PricingDocumentHeaderElement | ConditionIsForStatistics | Statistical | |
| ConditionIsManuallyChanged | P_PricingDocumentHeaderElement | ConditionIsManuallyChanged | Changed Manual. | |
| ConditionExchRateIsIndrctQtan | P_PricingDocumentHeaderElement | ConditionExchRateIsIndrctQtan | ||
| ConditionAbsoluteExchangeRate | P_PricingDocumentHeaderElement | ConditionAbsoluteExchangeRate | ||
| AccountKeyForGLAccount | P_PricingDocumentHeaderElement | AccountKeyForGLAccount | Account Key | |
| GLAccount | P_PricingDocumentHeaderElement | GLAccount | General Ledger | |
| ConditionRateValueIsAmount | ||||
| ConditionRateValueIsRatio | ||||
| ConditionBaseValueIsAmount | ||||
| ConditionBaseValueIsQuantity | ||||
| _ConditionApplication | P_PricingDocumentHeaderElement | _ConditionApplication | ||
| _PricingConditionType | P_PricingDocumentHeaderElement | _PricingConditionType | ||
| _ConditionCalculationType | P_PricingDocumentHeaderElement | _ConditionCalculationType | ||
| _ConditionCategory | P_PricingDocumentHeaderElement | _ConditionCategory | ||
| _ConditionCurrency | P_PricingDocumentHeaderElement | _ConditionCurrency | ||
| _TransactionCurrency | P_PricingDocumentHeaderElement | _Currency | ||
| _ConditionQuantityUnit | P_PricingDocumentHeaderElement | _ConditionQuantityUnit | ||
| _ConditionInactiveReason | P_PricingDocumentHeaderElement | _ConditionInactiveReason | ||
| _ConditionClass | P_PricingDocumentHeaderElement | _ConditionClass | ||
| _ConditionOrigin | P_PricingDocumentHeaderElement | _ConditionOrigin | ||
| _ConditionRateRatioUnit | P_PricingDocumentHeaderElement | _ConditionRateRatioUnit | ||
| _StructureCondition | P_PricingDocumentHeaderElement | _StructureCondition | ||
| _ConditionControl | P_PricingDocumentHeaderElement | _ConditionControl | ||
| _PricingDocument | _PricingDocument |
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 R_PrcgDocumentHeaderElementTP.
-- 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 R_PrcgDocumentHeaderElementTP AS
SELECT
PricingDocumentElement.PricingDocument AS PricingDocument,
PricingDocumentElement.PrcgDocumentHostObjectNodeID AS PrcgDocumentHostObjectNodeID,
PricingDocumentElement.PrcgDocHostObjSONTInUppercase AS PrcgDocHostObjSONTInUppercase,
PricingDocumentElement.PricingProcedureStep AS PricingProcedureStep,
PricingDocumentElement.PricingDocumentElementCounter AS PricingDocumentElementCounter,
PricingDocumentElement.ConditionApplication AS ConditionApplication,
PricingDocumentElement.ConditionType AS ConditionType,
PricingDocumentElement._PricingConditionType._Text_2[1: Language=$session.system_language].ConditionTypeName AS ConditionTypeName,
PricingDocumentElement.ConditionCalculationType AS ConditionCalculationType,
PricingDocumentElement.ConditionCategory AS ConditionCategory,
PricingDocumentElement.PriceConditionDeterminationDte AS PriceConditionDeterminationDte,
PricingDocumentElement.ConditionRateAmount AS ConditionRateAmount,
PricingDocumentElement.ConditionRateRatio AS ConditionRateRatio,
PricingDocumentElement.ConditionBaseAmount AS ConditionBaseAmount,
PricingDocumentElement.ConditionBaseQuantity AS ConditionBaseQuantity,
PricingDocumentElement.ConditionQuantity AS ConditionQuantity,
PricingDocumentElement.ConditionAmount AS ConditionAmount,
PricingDocumentElement.ConditionCurrency AS ConditionCurrency,
PricingDocumentElement.TransactionCurrency AS TransactionCurrency,
PricingDocumentElement.ConditionQuantityUnit AS ConditionQuantityUnit,
PricingDocumentElement.ConditionRateRatioUnit AS ConditionRateRatioUnit,
PricingDocumentElement.ConditionInactiveReason AS ConditionInactiveReason,
PricingDocumentElement.ConditionClass AS ConditionClass,
PricingDocumentElement.ConditionOrigin AS ConditionOrigin,
PricingDocumentElement.VariantCondition AS VariantCondition,
PricingDocumentElement.CndnRoundingOffDiffAmount AS CndnRoundingOffDiffAmount,
PricingDocumentElement.TaxCode AS TaxCode,
PricingDocumentElement.StructureCondition AS StructureCondition,
PricingDocumentElement.IsGroupCondition AS IsGroupCondition,
PricingDocumentElement.ConditionIsForConfiguration AS ConditionIsForConfiguration,
PricingDocumentElement.IsRelevantForAccrual AS IsRelevantForAccrual,
PricingDocumentElement.CndnIsRelevantForIntcoBilling AS CndnIsRelevantForIntcoBilling,
PricingDocumentElement.ConditionRecord AS ConditionRecord,
PricingDocumentElement.ConditionControl AS ConditionControl,
PricingDocumentElement.ConditionIsForStatistics AS ConditionIsForStatistics,
PricingDocumentElement.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
PricingDocumentElement.ConditionExchRateIsIndrctQtan AS ConditionExchRateIsIndrctQtan,
PricingDocumentElement.ConditionAbsoluteExchangeRate AS ConditionAbsoluteExchangeRate,
PricingDocumentElement.AccountKeyForGLAccount AS AccountKeyForGLAccount,
PricingDocumentElement.GLAccount AS GLAccount,
cast( '' as boole_d ) AS ConditionRateValueIsAmount,
cast( '' as boole_d ) AS ConditionRateValueIsRatio,
cast( '' as boole_d ) AS ConditionBaseValueIsAmount,
cast( '' as boole_d ) AS ConditionBaseValueIsQuantity,
PricingDocumentElement._ConditionApplication AS _ConditionApplication,
PricingDocumentElement._PricingConditionType AS _PricingConditionType,
PricingDocumentElement._ConditionCalculationType AS _ConditionCalculationType,
PricingDocumentElement._ConditionCategory AS _ConditionCategory,
PricingDocumentElement._ConditionCurrency AS _ConditionCurrency,
PricingDocumentElement._Currency AS _TransactionCurrency,
PricingDocumentElement._ConditionQuantityUnit AS _ConditionQuantityUnit,
PricingDocumentElement._ConditionInactiveReason AS _ConditionInactiveReason,
PricingDocumentElement._ConditionClass AS _ConditionClass,
PricingDocumentElement._ConditionOrigin AS _ConditionOrigin,
PricingDocumentElement._ConditionRateRatioUnit AS _ConditionRateRatioUnit,
PricingDocumentElement._StructureCondition AS _StructureCondition,
PricingDocumentElement._ConditionControl AS _ConditionControl
FROM P_PricingDocumentHeaderElement AS PricingDocumentElement
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA