I_SlsPrcgCndnRecdValidityTP_2

DDL: I_SLSPRCGCNDNRECDVALIDITYTP_2 Type: view_entity TRANSACTIONAL Package: RAP_SD_MD_CM_API
119 Fields 1 Data Sources

Validity of Condition Record for Pricing in Sales - TP

I_SlsPrcgCndnRecdValidityTP_2 is a Transactional CDS View that provides data about "Validity of Condition Record for Pricing in Sales - TP" in SAP S/4HANA. It reads from 1 data source (R_SlsPrcgCndnRecdValidityTP) and exposes 119 fields with key fields ConditionRecord, ConditionValidityEndDate. Part of development package RAP_SD_MD_CM_API.

Data Sources (1)

SourceAliasJoin Type
R_SlsPrcgCndnRecdValidityTP R_SlsPrcgCndnRecdValidityTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Validity of Condition Record for Pricing in Sales - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
Metadata.ignorePropagatedAnnotations true view

Fields (119)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord ConditionRecord Cond.Record No.
KEY ConditionValidityEndDate ConditionValidityEndDate Valid To
ConditionValidityStartDate ConditionValidityStartDate Valid From
ConditionApplication ConditionApplication Application
ConditionType ConditionType Condition type
ConditionReleaseStatus ConditionReleaseStatus Release Status
DepartureCountry DepartureCountry Departure Country / Region
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
BillableControl BillableControl Billable Control
Industry Industry Industry Sector
CityCode CityCode IATA: City
ConditionContract ConditionContract Condition Contract
County County Wyoming County
EngagementProject EngagementProject Engmnt Project ID
ConfigurationNumber ConfigurationNumber Int. object no.
InternationalArticleNumber InternationalArticleNumber EAN/UPC
TechnicalObjectType TechnicalObjectType Text object
Equipment Equipment Equipment check
CustomerHierarchy CustomerHierarchy
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
CustomerGroup CustomerGroup Customer Group
CustomerPriceGroup CustomerPriceGroup CustPrice Group
MaterialPricingGroup MaterialPricingGroup
SoldToParty SoldToParty Sold-to Party
BPForSoldToParty BPForSoldToParty
Customer Customer Sold-to Party
BPForCustomer BPForCustomer
PayerParty PayerParty Payer
BPForPayerParty BPForPayerParty
ShipToParty ShipToParty Ship-To Party (obsolete)
BPForShipToParty BPForShipToParty
Supplier Supplier Supplier
BPForSupplier BPForSupplier
DestinationCountry DestinationCountry Dest. Ctry/Reg
MaterialGroup MaterialGroup Product Group
Material Material Vehicle Model
ReturnsRefundExtent ReturnsRefundExtent
AdditionalMaterialGroup1 AdditionalMaterialGroup1 MaterialGroup 1
AdditionalMaterialGroup2 AdditionalMaterialGroup2 MaterialGroup 2
AdditionalMaterialGroup3 AdditionalMaterialGroup3 MaterialGroup 3
AdditionalMaterialGroup4 AdditionalMaterialGroup4 MaterialGroup 4
AdditionalMaterialGroup5 AdditionalMaterialGroup5 MaterialGroup 5
PersonWorkAgreement PersonWorkAgreement Personnel No.
PriceListType PriceListType Price List Tp.
PostalCode PostalCode Postal Code
Region Region Venue Region
EngagementProjectServiceOrg EngagementProjectServiceOrg Service Org.
RequirementSegment RequirementSegment Req. Segment
StockSegment StockSegment Stock Segment
Division Division Internal Division ID
TradingContract TradingContract
TradingContractItem TradingContractItem Item Number
MainItemMaterialPricingGroup MainItemMaterialPricingGroup
MainItemPricingRefMaterial MainItemPricingRefMaterial
VariantCondition VariantCondition Variant Key
ValueAddedServiceChargeCode ValueAddedServiceChargeCode
SDDocument SDDocument SD Document
ReferenceSDDocument ReferenceSDDocument Reference Doc.
ReferenceSDDocumentItem ReferenceSDDocumentItem Reference Item
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganization SalesOrganization Sales Organization
SalesOrderSalesOrganization SalesOrderSalesOrganization
OrderQuantityUnit OrderQuantityUnit Sales Unit
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
TransactionCurrency TransactionCurrency Transaction Currency
WBSElementInternalID WBSElementInternalID WBS Internal ID
WorkPackageInternalID WorkPackageInternalID
Plant Plant Valuation Area
PlantRegion PlantRegion Region-Dlv.Plnt
WorkItem WorkItem Work Item ID
ConditionProcessingStatus ConditionProcessingStatus
PricingDate PricingDate Pricing Date
ConditionIsExclusive ConditionIsExclusive
ConditionScaleBasisValue ConditionScaleBasisValue Scale Base Val.
ServiceDocument ServiceDocument Transaction ID
ServiceDocumentItem ServiceDocumentItem Service Document
TimeSheetOvertimeCategory TimeSheetOvertimeCategory
SalesSDDocumentCategory SalesSDDocumentCategory Document Cat.
ReturnReason ReturnReason Return Reason
ProdUnivHierarchyNode ProdUnivHierarchyNode
CustomerConditionGroup CustomerConditionGroup
ShippingType ShippingType Shipping Type
SubscriptionContractDuration SubscriptionContractDuration Duration Value
SubscriptionContractLockReason SubscriptionContractLockReason
CrsCtlgMappgPriceVersionNumber CrsCtlgMappgPriceVersionNumber Price Version
OrderType OrderType Order Type
SalesDocumentType SalesDocumentType Sales Doc. Type
SDDocumentReason SDDocumentReason Order Reason
VolumeRebateGroup VolumeRebateGroup Vol. Rebate Grp
ValuationType ValuationType Valuation Type
SalesDistrict SalesDistrict Sales District
Batch Batch Lot No.
PurgDocSupplyingPlant PurgDocSupplyingPlant
MatUsageIndicator MatUsageIndicator
ShippingCondition ShippingCondition Shipping Conditions
PlantCounty PlantCounty County-Dlv.Plnt
PlantCity PlantCity City-Dlv.Plant
MaterialExternalGroup MaterialExternalGroup Ext. Matl Group
CustomerHierarchyRootNode CustomerHierarchyRootNode
CustomerHierarchyNodeID CustomerHierarchyNodeID
CustomerHierarchyNodeType CustomerHierarchyNodeType
AdditionalCustomerGroup1 AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 AdditionalCustomerGroup5 Customer Grp 5
SDDocumentItem SDDocumentItem
Country Country Venue: Ctry/Reg
CustomerPurchaseOrderType CustomerPurchaseOrderType
CountryOfOrigin CountryOfOrigin Country/Region of Origin
SalesDocumentItemCategory SalesDocumentItemCategory Item Category
BillToParty BillToParty Inv. Recipient
BusinessPartnerIndustryCode BusinessPartnerIndustryCode
BillingDocumentType BillingDocumentType Billing Type
MatlAccountAssignmentGroup MatlAccountAssignmentGroup
Route Route Vehicle route

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 I_SlsPrcgCndnRecdValidityTP_2.
-- 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 I_SlsPrcgCndnRecdValidityTP_2 AS
SELECT
  ConditionRecord,
  ConditionValidityEndDate,
  ConditionValidityStartDate,
  ConditionApplication,
  ConditionType,
  ConditionReleaseStatus,
  DepartureCountry,
  SalesDocument,
  SalesDocumentItem,
  BillableControl,
  Industry,
  CityCode,
  ConditionContract,
  County,
  EngagementProject,
  ConfigurationNumber,
  InternationalArticleNumber,
  TechnicalObjectType,
  Equipment,
  CustomerHierarchy,
  IncotermsClassification,
  IncotermsTransferLocation,
  CustomerGroup,
  CustomerPriceGroup,
  MaterialPricingGroup,
  SoldToParty,
  BPForSoldToParty,
  Customer,
  BPForCustomer,
  PayerParty,
  BPForPayerParty,
  ShipToParty,
  BPForShipToParty,
  Supplier,
  BPForSupplier,
  DestinationCountry,
  MaterialGroup,
  Material,
  ReturnsRefundExtent,
  AdditionalMaterialGroup1,
  AdditionalMaterialGroup2,
  AdditionalMaterialGroup3,
  AdditionalMaterialGroup4,
  AdditionalMaterialGroup5,
  PersonWorkAgreement,
  PriceListType,
  PostalCode,
  Region,
  EngagementProjectServiceOrg,
  RequirementSegment,
  StockSegment,
  Division,
  TradingContract,
  TradingContractItem,
  MainItemMaterialPricingGroup,
  MainItemPricingRefMaterial,
  VariantCondition,
  ValueAddedServiceChargeCode,
  SDDocument,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  SalesOffice,
  SalesGroup,
  SalesOrganization,
  SalesOrderSalesOrganization,
  OrderQuantityUnit,
  DistributionChannel,
  TransactionCurrency,
  WBSElementInternalID,
  WorkPackageInternalID,
  Plant,
  PlantRegion,
  WorkItem,
  ConditionProcessingStatus,
  PricingDate,
  ConditionIsExclusive,
  ConditionScaleBasisValue,
  ServiceDocument,
  ServiceDocumentItem,
  TimeSheetOvertimeCategory,
  SalesSDDocumentCategory,
  ReturnReason,
  ProdUnivHierarchyNode,
  CustomerConditionGroup,
  ShippingType,
  SubscriptionContractDuration,
  SubscriptionContractLockReason,
  CrsCtlgMappgPriceVersionNumber,
  OrderType,
  SalesDocumentType,
  SDDocumentReason,
  VolumeRebateGroup,
  ValuationType,
  SalesDistrict,
  Batch,
  PurgDocSupplyingPlant,
  MatUsageIndicator,
  ShippingCondition,
  PlantCounty,
  PlantCity,
  MaterialExternalGroup,
  CustomerHierarchyRootNode,
  CustomerHierarchyNodeID,
  CustomerHierarchyNodeType,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  SDDocumentItem,
  Country,
  CustomerPurchaseOrderType,
  CountryOfOrigin,
  SalesDocumentItemCategory,
  BillToParty,
  BusinessPartnerIndustryCode,
  BillingDocumentType,
  MatlAccountAssignmentGroup,
  Route
FROM R_SlsPrcgCndnRecdValidityTP
;

Learn More