C_SbscrContrItmDelivPlanTP

DDL: C_SBSCRCONTRITMDELIVPLANTP Type: view_entity CONSUMPTION
14 Fields 1 Data Sources

Subscription Item Delivery Plan - TP

C_SbscrContrItmDelivPlanTP is a Consumption CDS View that provides data about "Subscription Item Delivery Plan - TP" in SAP S/4HANA. It reads from 1 data source (R_SbscrContrItmDeliveryPlanTP) and exposes 14 fields with key fields ServiceObjectType, SubscriptionContract, SubscriptionContractItem, SbscrContrItmDelivPlnRecdNmbr.

Data Sources (1)

SourceAliasJoin Type
R_SbscrContrItmDeliveryPlanTP R_SbscrContrItmDeliveryPlanTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Subscription Item Delivery Plan - TP view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY SubscriptionContract SubscriptionContract Transaction ID
KEY SubscriptionContractItem SubscriptionContractItem Item Number in Doc.
KEY SbscrContrItmDelivPlnRecdNmbr SbscrContrItmDelivPlnRecdNmbr
DeliveryDateTime DeliveryDateTime
DeliveryQuantity DeliveryQuantity Delivery unit
DeliveryQuantityUnit DeliveryQuantityUnit Unit of measure
SbscrContrItmDelivPlnDelivSts SbscrContrItmDelivPlnDelivSts
SrvcDocItmDelivPlnDelivStsTextlocalized
SDDocumentCategory SDDocumentCategory Document Cat.
SDDocumentCategoryNamelocalized
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
int1

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_SbscrContrItmDelivPlanTP.
-- 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_SbscrContrItmDelivPlanTP AS
SELECT
  ServiceObjectType,
  SubscriptionContract,
  SubscriptionContractItem,
  SbscrContrItmDelivPlnRecdNmbr,
  DeliveryDateTime,
  DeliveryQuantity,
  DeliveryQuantityUnit,
  SbscrContrItmDelivPlnDelivSts,
  _SrvcDocItmDelivPlnDelivSts._Text.SrvcDocItmDelivPlnDelivStsText : localized AS SrvcDocItmDelivPlnDelivStsTextlocalized,
  SDDocumentCategory,
  _SDDocumentCategory._Text.SDDocumentCategoryName : localized AS SDDocumentCategoryNamelocalized,
  SalesDocument,
  SalesDocumentItem,
  virtual SbsConItmDelivPlnDelivStsCrty : abap.int1 AS int1
FROM R_SbscrContrItmDeliveryPlanTP
;

Learn More