A_CndnContrCndnRecord

DDL: A_CNDNCONTRCNDNRECORD Type: view_entity CONSUMPTION Package: WCB_API_A2A_CC_SRV
51 Fields 1 Data Sources 1 OData Services

Condition Record

A_CndnContrCndnRecord is a Consumption CDS View that provides data about "Condition Record" in SAP S/4HANA. It reads from 1 data source (R_CndnContrCndnRecordTP) and exposes 51 fields with key fields ConditionContract, ConditionRecord. It is exposed through 1 OData service (API_CONDITION_CONTRACT). Part of development package WCB_API_A2A_CC_SRV.

Data Sources (1)

SourceAliasJoin Type
R_CndnContrCndnRecordTP R_CndnContrCndnRecordTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Condition Record view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.query.implementedBy ABAP:CL_WCB_CC_TP_QRY_COND_REC view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

OData Services (1)

ServiceBindingVersionContractRelease
API_CONDITION_CONTRACT API_CONDITION_CONTRACT V4 C2 C1

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract ConditionContract Condition Contract
KEY ConditionRecord ConditionRecord Cond.Record No.
ConditionTable ConditionTable Condition Table
ConditionApplication ConditionApplication Application
ConditionType ConditionType Condition type
ConditionValidityStartDate ConditionValidityStartDate Valid From
ConditionValidityEndDate ConditionValidityEndDate Valid To
ConditionCalculationType ConditionCalculationType Calculat.Type
PricingScaleBasis PricingScaleBasis Scale Basis
ConditionRateAmount ConditionRateAmount Condition Amount
ConditionAccrualsAmount ConditionAccrualsAmount
ConditionCurrency ConditionCurrency Currency
ConditionQuantity ConditionQuantity Pricing Unit
ConditionQuantityUnit ConditionQuantityUnit Unit of Measure
ConditionQuantityUnitISOCode
ConditionQuantityUnitSAPCode
ConditionRateRatio ConditionRateRatio Ratio
ConditionAccrualsRatio ConditionAccrualsRatio
ConditionRateRatioUnit ConditionRateRatioUnit Unit of Measure
ConditionRateRatioUnitISOCode
ConditionRateRatioUnitSAPCode
PricingScaleType PricingScaleType Scale Type
ConditionScaleQuantityUnit ConditionScaleQuantityUnit Scale UoM
CndnScaleQuantityUnitISOCode
CndnScaleQuantityUnitSAPCode
ConditionScaleAmountCurrency ConditionScaleAmountCurrency Scale Currency
ConditionIsDeleted ConditionIsDeleted Deletion Indic.
Product Product Product Sold
Customer Customer Sold-to Party
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
ShipToParty ShipToParty Ship-To Party (obsolete)
Supplier Supplier Supplier
InvoicingParty InvoicingParty Supplier
PriorSupplier PriorSupplier Prior Supplier
SupplyingSupplier SupplyingSupplier Goods Supplier
CompanyCode CompanyCode Receiver Company Code
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
PurchasingOrganization PurchasingOrganization Purchasing Organization
Plant Plant Valuation Area
ProductGroup ProductGroup Product Sold Group
SalesSpcfcProductGroup1 SalesSpcfcProductGroup1 Sales-Specific Product Group 1
SalesSpcfcProductGroup2 SalesSpcfcProductGroup2 Sales-Specific Product Group 2
SalesSpcfcProductGroup3 SalesSpcfcProductGroup3 Sales-Specific Product Group 3
SalesSpcfcProductGroup4 SalesSpcfcProductGroup4 Sales-Specific Product Group 4
SalesSpcfcProductGroup5 SalesSpcfcProductGroup5 Sales-Specific Product Group 5
ProdUnivHierarchyNode ProdUnivHierarchyNode

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 A_CndnContrCndnRecord.
-- 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 A_CndnContrCndnRecord AS
SELECT
  ConditionContract,
  ConditionRecord,
  ConditionTable,
  ConditionApplication,
  ConditionType,
  ConditionValidityStartDate,
  ConditionValidityEndDate,
  ConditionCalculationType,
  PricingScaleBasis,
  ConditionRateAmount,
  ConditionAccrualsAmount,
  ConditionCurrency,
  ConditionQuantity,
  ConditionQuantityUnit,
  cast( _ConditionQuantityUnit.UnitOfMeasureISOCode as wlf_kvmei_iso preserving type ) AS ConditionQuantityUnitISOCode,
  cast( _ConditionQuantityUnit.UnitOfMeasureSAPCode as wlf_kvmei_sapcode preserving type ) AS ConditionQuantityUnitSAPCode,
  ConditionRateRatio,
  ConditionAccrualsRatio,
  ConditionRateRatioUnit,
  cast( _ConditionRateRatioUnit.UnitOfMeasureISOCode as wcb_cond_percent_sign_iso preserving type ) AS ConditionRateRatioUnitISOCode,
  cast( _ConditionRateRatioUnit.UnitOfMeasureSAPCode as wcb_cond_percent_sign_sap preserving type ) AS ConditionRateRatioUnitSAPCode,
  PricingScaleType,
  ConditionScaleQuantityUnit,
  cast( _ConditionScaleQuantityUnit.UnitOfMeasureISOCode as wcb_konms_iso preserving type ) AS CndnScaleQuantityUnitISOCode,
  cast( _ConditionScaleQuantityUnit.UnitOfMeasureSAPCode as wcb_konms_sapcode preserving type ) AS CndnScaleQuantityUnitSAPCode,
  ConditionScaleAmountCurrency,
  ConditionIsDeleted,
  Product,
  Customer,
  BillToParty,
  PayerParty,
  ShipToParty,
  Supplier,
  InvoicingParty,
  PriorSupplier,
  SupplyingSupplier,
  CompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  PurchasingOrganization,
  Plant,
  ProductGroup,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  ProdUnivHierarchyNode
FROM R_CndnContrCndnRecordTP
;

Learn More