C_CustExpdPriceCondition

DDL: C_CUSTEXPDPRICECONDITION SQL: CCUSTEXPDPRCCOND Type: view CONSUMPTION Package: ODATA_SD_SDOC_CUSTPRICE

Sales Doc w. Cust-Expd Price Prcg Elmnt

C_CustExpdPriceCondition is a Consumption CDS View that provides data about "Sales Doc w. Cust-Expd Price Prcg Elmnt" in SAP S/4HANA. It reads from 2 data sources (C_PricingElement, I_SalesDocumentItem) and exposes 36 fields with key fields PricingDocument, PricingDocumentItem, PricingProcedureStep, PricingProcedureCounter, SalesDocument. It has 2 associations to related views. Part of development package ODATA_SD_SDOC_CUSTPRICE.

2 data source(s) 36 fields

Data Sources (2)

SourceAliasJoin Type
C_PricingElement PricingElement from
I_SalesDocumentItem SalesDocument inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SalesDocument _SalesDocument $projection.SalesDocument = _SalesDocument.SalesDocument
[0..*] C_PricingConditionType_VH _PricingConditionTypeVH $projection.ConditionType = _PricingConditionTypeVH.ConditionType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCUSTEXPDPRCCOND view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
EndUserText.label Sales Doc w. Cust-Expd Price Prcg Elmnt view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY PricingDocument PricingDocument
KEY PricingDocumentItem PricingDocumentItem
KEY PricingProcedureStep PricingProcedureStep
KEY PricingProcedureCounter PricingProcedureCounter
KEY SalesDocument I_SalesDocumentItem SalesDocument
KEY SalesDocumentItem I_SalesDocumentItem SalesDocumentItem
ConditionInactiveReason C_PricingElement ConditionInactiveReason
ConditionApplication C_PricingElement ConditionApplication
ConditionType C_PricingElement ConditionType
ConditionTypeName C_PricingElement ConditionTypeName
ConditionRateValue C_PricingElement ConditionRateValue
ConditionRateValueIntlUnit C_PricingElement ConditionRateValueIntlUnit
ConditionRateValueUnit C_PricingElement ConditionRateValueUnit
ConditionQuantity C_PricingElement ConditionQuantity
ConditionQuantityUnit C_PricingElement ConditionQuantityUnit
ConditionBaseValue C_PricingElement ConditionBaseValue
ConditionBaseValueIntlUnit C_PricingElement ConditionBaseValueIntlUnit
ConditionBaseValueUnit C_PricingElement ConditionBaseValueUnit
ConditionIsForStatistics C_PricingElement ConditionIsForStatistics
IsGroupCondition C_PricingElement IsGroupCondition
TaxCode C_PricingElement TaxCode
TaxCodeName C_PricingElement TaxCodeName
ConditionAmount C_PricingElement ConditionAmount
TransactionCurrency C_PricingElement TransactionCurrency
ConditionInactiveReasonName C_PricingElement ConditionInactiveReasonName
ConditionIsManuallyChanged C_PricingElement ConditionIsManuallyChanged
ConditionIsDeletable C_PricingElement ConditionIsDeletable
PricingProcedure C_PricingElement PricingProcedure
SuperordinateDocument C_PricingElement SuperordinateDocument
SuperordinateDocumentItem C_PricingElement SuperordinateDocumentItem
Associations_SalesDocument
_ConditionApplication _ConditionApplication
_ConditionQuantityUnit _ConditionQuantityUnit
_PricingConditionTypeVH _PricingConditionTypeVH
_ConditionQuantityUnitVH _ConditionQuantityUnitVH
_ConditionRateValueUnitVH _ConditionRateValueUnitVH 
@AbapCatalog.sqlViewName: 'CCUSTEXPDPRCCOND'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED


@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@EndUserText.label: 'Sales Doc w. Cust-Expd Price Prcg Elmnt'

define view
C_CustExpdPriceCondition

as select from
C_PricingElement as PricingElement

inner join I_SalesDocumentItem as SalesDocument on PricingDocumentItem = SalesDocument.SalesDocumentItem
and SalesDocumentCondition = SalesDocument.SalesDocumentCondition

association [1..1] to I_SalesDocument           as _SalesDocument          on $projection.SalesDocument = _SalesDocument.SalesDocument

association [0..*] to C_PricingConditionType_VH as _PricingConditionTypeVH on $projection.ConditionType = _PricingConditionTypeVH.ConditionType


{

  key PricingDocument,
  key PricingDocumentItem,
  key PricingProcedureStep,
  key PricingProcedureCounter,

      @ObjectModel.foreignKey.association: null
  key SalesDocument.SalesDocument,

  key SalesDocument.SalesDocumentItem,

      @ObjectModel.readOnly: true
      PricingElement.ConditionInactiveReason,

      @ObjectModel.readOnly: true
      @ObjectModel.foreignKey.association: '_ConditionApplication'
      PricingElement.ConditionApplication,

      @Consumption: { valueHelp: '_PricingConditionTypeVH' }
      PricingElement.ConditionType,


      @ObjectModel.readOnly: true
      PricingElement.ConditionTypeName,

      @Semantics.amount.currencyCode: 'ConditionRateValueIntlUnit'
      PricingElement.ConditionRateValue,


      @Semantics.currencyCode: true
      @ObjectModel.readOnly: true
      PricingElement.ConditionRateValueIntlUnit,


      PricingElement.ConditionRateValueUnit,


      PricingElement.ConditionQuantity,


      PricingElement.ConditionQuantityUnit,


      @ObjectModel.readOnly: true
      @Semantics.amount.currencyCode: 'ConditionBaseValueIntlUnit'
      PricingElement.ConditionBaseValue,
      @ObjectModel.readOnly: true
      @Semantics.currencyCode: true
      PricingElement.ConditionBaseValueIntlUnit,
      @ObjectModel.readOnly: true
      PricingElement.ConditionBaseValueUnit,


      @ObjectModel.readOnly: true
      PricingElement.ConditionIsForStatistics,

      @ObjectModel.readOnly: true
      PricingElement.IsGroupCondition,

      @ObjectModel.readOnly: true
      PricingElement.TaxCode,
      @ObjectModel.readOnly: true
      PricingElement.TaxCodeName,

      @UI: { identification.position: 100}
      PricingElement.ConditionAmount,

      @ObjectModel.readOnly: true
      @Semantics.currencyCode: true
      PricingElement.TransactionCurrency,

      @ObjectModel.readOnly: true
      PricingElement.ConditionInactiveReasonName,

      @ObjectModel.readOnly: true
      PricingElement.ConditionIsManuallyChanged,

      PricingElement.ConditionIsDeletable,
      @ObjectModel.readOnly: true
      PricingElement.PricingProcedure,
      @ObjectModel.readOnly: true
      PricingElement.SuperordinateDocument,
      @ObjectModel.readOnly: true
      PricingElement.SuperordinateDocumentItem,




      ---------------------------------------
      -- Associations                      --
      ---------------------------------------
      _SalesDocument,
      _ConditionApplication,
      _ConditionQuantityUnit,
      _PricingConditionTypeVH,
      _ConditionQuantityUnitVH,
      _ConditionRateValueUnitVH

}

Learn More