C_RFM_PrvsnlSlsContrVarItems

DDL: C_RFM_PRVSNLSLSCONTRVARITEMS Type: view_entity CONSUMPTION Package: RFM_PROV_SALES_CONTRACTS
25 Fields 1 Data Sources 1 Associations 1 OData Services

Provisional Sales Contract Variant Items

C_RFM_PrvsnlSlsContrVarItems is a Consumption CDS View that provides data about "Provisional Sales Contract Variant Items" in SAP S/4HANA. It reads from 1 data source (I_RFM_PrvsnlSlsContrVarItems) and exposes 25 fields with key fields SalesContract, SalesContractItem, Material. It has 1 association to related views. It is exposed through 1 OData service (UI_RFM_PRVSNLSLSCONTR). Part of development package RFM_PROV_SALES_CONTRACTS.

Data Sources (1)

SourceAliasJoin Type
I_RFM_PrvsnlSlsContrVarItems I_RFM_PrvsnlSlsContrVarItems from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_RFM_PrvsnlVarExstcTxt _VarExstcTxt $projection.RFMVariantExstc = _VarExstcTxt.RFMVariantExstc

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Provisional Sales Contract Variant Items view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RFM_PRVSNLSLSCONTR UI_RFM_PRVSNLSLSCONTR V2 C1 NOT_RELEASED

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY SalesContract SalesContract Sales Document
KEY SalesContractItem SalesContractItem Item
KEY Material Material Vehicle Model
MaterialName MaterialName Material Description
RFMVariantExstc RFMVariantExstc
RFMVariantExstcTxt
SalesDocumentItem SalesDocumentItem Sales Document Item
ProductCharacteristic1 ProductCharacteristic1 Characteristic 1
ProductCharacteristic2 ProductCharacteristic2 Characteristic 2
ProductCharacteristic3 ProductCharacteristic3 Characteristic 3
ProductCharacteristic1Desc ProductCharacteristic1Desc
ProductCharacteristic2Desc ProductCharacteristic2Desc
ProductCharacteristic3Desc ProductCharacteristic3Desc
OrderQuantity OrderQuantity Quantity
ProposedQuantity ProposedQuantity
ContractItemConsumedQuantity
OrderQuantityUnit OrderQuantityUnit Sales Unit
SalesDocumentType SalesDocumentType Sales Doc. Type
OrganizationDivision OrganizationDivision Org. Division
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
_MaterialText _MaterialText
_VarExstcTxt _VarExstcTxt
_Header _Header
_OrderQuantityUnit _OrderQuantityUnit

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_RFM_PrvsnlSlsContrVarItems.
-- 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_RFM_PrvsnlSlsContrVarItems AS
SELECT
  SalesContract,
  SalesContractItem,
  Material,
  MaterialName,
  RFMVariantExstc,
  _VarExstcTxt[Language = $session.system_language].RFMVariantExstcTxt AS RFMVariantExstcTxt,
  SalesDocumentItem,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  ProductCharacteristic1Desc,
  ProductCharacteristic2Desc,
  ProductCharacteristic3Desc,
  OrderQuantity,
  ProposedQuantity,
  cast (0 as abap.quan(15,3)) AS ContractItemConsumedQuantity,
  OrderQuantityUnit,
  SalesDocumentType,
  OrganizationDivision,
  SalesOrganization,
  DistributionChannel
FROM I_RFM_PrvsnlSlsContrVarItems
LEFT OUTER JOIN I_RFM_PrvsnlVarExstcTxt AS _VarExstcTxt ON RFMVariantExstc = _VarExstcTxt.RFMVariantExstc  -- association [0..*]
;

Learn More