C_SlsPriceAgreementTP

DDL: C_SLSPRICEAGREEMENTTP Type: view_entity CONSUMPTION Package: RAP_SD_MD_CM
59 Fields 1 Data Sources 1 Associations 1 OData Services

Price Agreement in Sales

C_SlsPriceAgreementTP is a Consumption CDS View that provides data about "Price Agreement in Sales" in SAP S/4HANA. It reads from 1 data source (R_SlsPrcgCndnRecordTP_3) and exposes 59 fields with key field ConditionRecord. It has 1 association to related views. It is exposed through 1 OData service (UI_SALESCONTRACTMANAGE). Part of development package RAP_SD_MD_CM.

Data Sources (1)

SourceAliasJoin Type
R_SlsPrcgCndnRecordTP_3 R_SlsPrcgCndnRecordTP_3 projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_SalesContractItemManageTP _ContractItem $projection.SDDocument = _ContractItem.SalesContract and $projection.SDDocumentItem = _ContractItem.SalesContractItem

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.query.implementedBy ABAP:CL_S4RAP_SLSPRCGCND_STICKY_QRY view
VDM.viewType #CONSUMPTION view
EndUserText.label Price Agreement in Sales view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SALESCONTRACTMANAGE UI_SALESCONTRACTMANAGE V4 C1 NOT_RELEASED

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord ConditionRecord Cond.Record No.
ConditionTable ConditionTable Condition Table
ConditionApplication ConditionApplication Application
ConditionType ConditionType Condition type
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
PricingScaleType PricingScaleType Scale Type
PricingScaleBasis PricingScaleBasis Scale Basis
PricingScaleCheckingRule PricingScaleCheckingRule Check Scale
ConditionCalculationType ConditionCalculationType Calculat.Type
ConditionRateRatio ConditionRateRatio Ratio
ConditionRateRatioUnit ConditionRateRatioUnit Unit of Measure
ConditionRateAmount ConditionRateAmount Condition Amount
ConditionCurrency ConditionCurrency Currency
ConditionQuantity ConditionQuantity Pricing Unit
ConditionQuantityUnit ConditionQuantityUnit Unit of Measure
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr Numerator
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr Denominator
BaseUnit BaseUnit Unit of Measure
ConditionLowerLimitAmount ConditionLowerLimitAmount Amount
ConditionLowerLimitRatio ConditionLowerLimitRatio Ratio
ConditionUpperLimitAmount ConditionUpperLimitAmount Amount
ConditionUpperLimitRatio ConditionUpperLimitRatio Ratio
ConditionAlternativeCurrency ConditionAlternativeCurrency Cndn Currency
ConditionIsDeleted ConditionIsDeleted Deletion Indic.
NewValueOfCndnValidityEndDate NewValueOfCndnValidityEndDate
ConditionValidityEndDate ConditionValidityEndDate Valid To
ConditionValidityStartDate ConditionValidityStartDate Valid From
Division Division Internal Division ID
SDDocument SDDocument SD Document
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
SDDocumentItem SDDocumentItem
ConditionHasScales ConditionHasScales Scales
ConditionScaleIsValueScale ConditionScaleIsValueScale
ConditionScaleIsQuantityScale ConditionScaleIsQuantityScale
ResultsHaveDeletedCondition ResultsHaveDeletedCondition
LastChangeDateTime LastChangeDateTime Timestamp
SAPObjectNodeType SAPObjectNodeType SONT Name
ConditionText ConditionText Node Condition Text
ConditionUnitConversionText ConditionUnitConversionText
Material Material Vehicle Model
MaterialPricingGroup MaterialPricingGroup
CustomerHierarchyRootNode CustomerHierarchyRootNode
CustomerHierarchyNodeID CustomerHierarchyNodeID
CustomerHierarchyNodeType CustomerHierarchyNodeType
ProdUnivHierarchyNode ProdUnivHierarchyNode
virtualConditionHasScalekostkz
virtualSalesPriceAgreementTitlechar40
virtualMaterialIsHidnabap_boolean
virtualSDDocumentIsHidnabap_boolean
virtualSDDocumentItemIsHidnabap_boolean
virtualConditionTableDescriptionddtext
virtualConditionTypeNamevtxtm
virtualMaterialPricingGroupNamebezei20
virtualSalesOrganizationNamevtext
virtualDistributionChannelNamevtext
virtualMaterialNamemaktx
_ContractItem _ContractItem

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 C_SlsPriceAgreementTP.
-- 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 C_SlsPriceAgreementTP AS
SELECT
  ConditionRecord,
  ConditionTable,
  ConditionApplication,
  ConditionType,
  CreatedByUser,
  CreationDate,
  PricingScaleType,
  PricingScaleBasis,
  PricingScaleCheckingRule,
  ConditionCalculationType,
  ConditionRateRatio,
  ConditionRateRatioUnit,
  ConditionRateAmount,
  ConditionCurrency,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionToBaseQtyNmrtr,
  ConditionToBaseQtyDnmntr,
  BaseUnit,
  ConditionLowerLimitAmount,
  ConditionLowerLimitRatio,
  ConditionUpperLimitAmount,
  ConditionUpperLimitRatio,
  ConditionAlternativeCurrency,
  ConditionIsDeleted,
  NewValueOfCndnValidityEndDate,
  ConditionValidityEndDate,
  ConditionValidityStartDate,
  Division,
  SDDocument,
  SalesOrganization,
  DistributionChannel,
  SDDocumentItem,
  ConditionHasScales,
  ConditionScaleIsValueScale,
  ConditionScaleIsQuantityScale,
  ResultsHaveDeletedCondition,
  LastChangeDateTime,
  SAPObjectNodeType,
  ConditionText,
  ConditionUnitConversionText,
  Material,
  MaterialPricingGroup,
  CustomerHierarchyRootNode,
  CustomerHierarchyNodeID,
  CustomerHierarchyNodeType,
  ProdUnivHierarchyNode,
  virtual ConditionHasScale : kostkz AS virtualConditionHasScalekostkz,
  virtual SalesPriceAgreementTitle : char40 AS virtualSalesPriceAgreementTitlechar40,
  virtual MaterialIsHidn : abap_boolean AS virtualMaterialIsHidnabap_boolean,
  virtual SDDocumentIsHidn : abap_boolean AS virtualSDDocumentIsHidnabap_boolean,
  virtual SDDocumentItemIsHidn : abap_boolean AS virtualSDDocumentItemIsHidnabap_boolean,
  virtual ConditionTableDescription : ddtext AS virtualConditionTableDescriptionddtext,
  virtual ConditionTypeName : vtxtm AS virtualConditionTypeNamevtxtm,
  virtual MaterialPricingGroupName : bezei20 AS virtualMaterialPricingGroupNamebezei20,
  virtual SalesOrganizationName : vtext AS virtualSalesOrganizationNamevtext,
  virtual DistributionChannelName : vtext AS virtualDistributionChannelNamevtext,
  virtual MaterialName : maktx AS virtualMaterialNamemaktx
FROM R_SlsPrcgCndnRecordTP_3
LEFT OUTER JOIN C_SalesContractItemManageTP AS _ContractItem ON SDDocument = _ContractItem.SalesContract AND SDDocumentItem = _ContractItem.SalesContractItem  -- association [0..1]
;

Learn More