C_SubscrpnContrItemDistrSitn

DDL: C_SUBSCRPNCONTRITEMDISTRSITN Type: view_entity CONSUMPTION
28 Fields 1 Data Sources

Subcription Contract Distribution Situation

C_SubscrpnContrItemDistrSitn is a Consumption CDS View that provides data about "Subcription Contract Distribution Situation" in SAP S/4HANA. It reads from 1 data source (I_SubscrpnContrItemDistrSitn) and exposes 28 fields with key fields ServiceObjectType, SubscriptionContract, SubscriptionContractItem.

Data Sources (1)

SourceAliasJoin Type
I_SubscrpnContrItemDistrSitn SubscriptionContractItem from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.uniqueIdField SubscriptionContractItemUUID view
EndUserText.label Subcription Contract Distribution Situation view
Metadata.ignorePropagatedAnnotations true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType I_SubscrpnContrItemDistrSitn ServiceObjectType Object Type
KEY SubscriptionContract SubscriptionContract Transaction ID
KEY SubscriptionContractItem SubscriptionContractItem Item Number in Doc.
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocItemCategory ServiceDocItemCategory
Product Product Product Sold
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Resp.
ResponsibleEmployeeUserID ResponsibleEmployeeUserID User Name
SubscrpnDocItemStateSecsValue SubscrpnDocItemStateSecsValue Seconds in waiting state
SubscriptionContractItemUUID SubscriptionContractItemUUID
SubscrpnContrItmCharUUID SubscrpnContrItmCharUUID
SubscrpnDocItemDistrStepType SubscrpnDocItemDistrStepType
SubscrpnDocItemDistrStepCat SubscrpnDocItemDistrStepCat
SubscrpnDocItemDistrStepSchema SubscrpnDocItemDistrStepSchema
SubscrpnDocItemDistrStepState SubscrpnDocItemDistrStepState
SubscrpnDocItemDistrStep SubscrpnDocItemDistrStep
SbscrDocItemDistrStpExecDteTme SbscrDocItemDistrStpExecDteTme
SalesOrganizationOrgUnitID I_SubscrpnContrItemDistrSitn SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID I_SubscrpnContrItemDistrSitn SalesOfficeOrgUnitID
ServiceOrganization ServiceOrganization
SalesGroupOrgUnitID SalesGroupOrgUnitID
SalesOrganization I_SubscrpnContrItemDistrSitn SalesOrganization Sales Organization
DistributionChannel I_SubscrpnContrItemDistrSitn DistributionChannel RefDistCh-Cust/Mat.
Division I_SubscrpnContrItemDistrSitn Division Internal Division ID
SalesOffice I_SubscrpnContrItemDistrSitn SalesOffice Sales Office
SalesGroup I_SubscrpnContrItemDistrSitn SalesGroup Sales Group
_RespEmployee _RespEmployee
_ServiceDocument _ServiceDocument

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_SubscrpnContrItemDistrSitn.
-- 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_SubscrpnContrItemDistrSitn AS
SELECT
  SubscriptionContractItem.ServiceObjectType AS ServiceObjectType,
  SubscriptionContract,
  SubscriptionContractItem,
  ServiceDocumentType,
  ServiceDocItemCategory,
  Product,
  RespEmployeeBusinessPartnerId,
  ResponsibleEmployeeUserID,
  SubscrpnDocItemStateSecsValue,
  SubscriptionContractItemUUID,
  SubscrpnContrItmCharUUID,
  SubscrpnDocItemDistrStepType,
  SubscrpnDocItemDistrStepCat,
  SubscrpnDocItemDistrStepSchema,
  SubscrpnDocItemDistrStepState,
  SubscrpnDocItemDistrStep,
  SbscrDocItemDistrStpExecDteTme,
  SubscriptionContractItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  SubscriptionContractItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceOrganization,
  SalesGroupOrgUnitID,
  SubscriptionContractItem.SalesOrganization AS SalesOrganization,
  SubscriptionContractItem.DistributionChannel AS DistributionChannel,
  SubscriptionContractItem.Division AS Division,
  SubscriptionContractItem.SalesOffice AS SalesOffice,
  SubscriptionContractItem.SalesGroup AS SalesGroup
FROM I_SubscrpnContrItemDistrSitn AS SubscriptionContractItem
;

Learn More