C_SubscrpnContrAllwncTP_2

DDL: C_SUBSCRPNCONTRALLWNCTP_2 Type: view_entity CONSUMPTION
29 Fields 1 Data Sources

Subscription Contract Allowance - TP

C_SubscrpnContrAllwncTP_2 is a Consumption CDS View that provides data about "Subscription Contract Allowance - TP" in SAP S/4HANA. It reads from 1 data source (R_SubscriptionContractTP) and exposes 29 fields with key field SubscriptionContract.

Data Sources (1)

SourceAliasJoin Type
R_SubscriptionContractTP R_SubscriptionContractTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Subscription Contract Allowance - TP view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionContract SubscriptionContract Transaction ID
SubscriptionContractType SubscriptionContractType
SubscrpnContractDescription SubscrpnContractDescription
SubscriptionContractUUID SubscriptionContractUUID Object GUID
ServiceObjectType ServiceObjectType Object Type
Language Language Report Text Language
SubscrpnContractIsCompleted SubscrpnContractIsCompleted
ServiceDocumentType ServiceDocumentType Transaction Type
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
ServiceOrganization ServiceOrganization
SoldToParty SoldToParty Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId
ResponsibleEmployeeName _RespEmployee BusinessPartnerName Extracted Customer Name
ContactPersonBusinessPartnerId ContactPersonBusinessPartnerId
ContactPersonName _ContactPerson BusinessPartnerName Extracted Customer Name
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp

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_SubscrpnContrAllwncTP_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 C_SubscrpnContrAllwncTP_2 AS
SELECT
  SubscriptionContract,
  SubscriptionContractType,
  SubscrpnContractDescription,
  SubscriptionContractUUID,
  ServiceObjectType,
  Language,
  SubscrpnContractIsCompleted,
  ServiceDocumentType,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  DistributionChannel,
  Division,
  ServiceOrganization,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  RespEmployeeBusinessPartnerId,
  _RespEmployee.BusinessPartnerName AS ResponsibleEmployeeName,
  ContactPersonBusinessPartnerId,
  _ContactPerson.BusinessPartnerName AS ContactPersonName,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM R_SubscriptionContractTP
;

Learn More