A_SubscriptionOrderItem

DDL: A_SUBSCRIPTIONORDERITEM Type: view_entity CONSUMPTION
70 Fields 1 Data Sources 1 OData Services

Subscription Order Item

A_SubscriptionOrderItem is a Consumption CDS View that provides data about "Subscription Order Item" in SAP S/4HANA. It reads from 1 data source (R_SubscriptionOrderItemTP) and exposes 70 fields with key fields SubscriptionOrder, SubscriptionOrderItem. It is exposed through 1 OData service (API_SUBSCRIPTIONORDER).

Data Sources (1)

SourceAliasJoin Type
R_SubscriptionOrderItemTP R_SubscriptionOrderItemTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Subscription Order Item view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name SubscriptionOrderItem_Type view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

OData Services (1)

ServiceBindingVersionContractRelease
API_SUBSCRIPTIONORDER API_SUBSCRIPTIONORDER V4 C2 Deprecated

Fields (70)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionOrder SubscriptionOrder
KEY SubscriptionOrderItem SubscriptionOrderItem
ServiceObjectType ServiceObjectType Object Type
ServiceDocumentItemObjectType ServiceDocumentItemObjectType
SubscrpnOrdItemCategory SubscrpnOrdItemCategory
SubscriptionOrderItemUUID SubscriptionOrderItemUUID
ParentSubscriptionOrderItem ParentSubscriptionOrderItem
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
Product Product Product Sold
SubscrpnOrdItmDescription SubscrpnOrdItmDescription
Quantity Quantity Value
QuantityUnit QuantityUnit Unit of measure
SubscrpnOrdRjcnReason SubscrpnOrdRjcnReason
PurchaseOrderByShipToParty PurchaseOrderByShipToParty
SubscrpnOrdItemIsNew SubscrpnOrdItemIsNew
SubscrpnOrdItemIsInProcess SubscrpnOrdItemIsInProcess
SubscrpnOrdItemIsReleased SubscrpnOrdItemIsReleased
SubscrpnOrdItemIsCompleted SubscrpnOrdItemIsCompleted
SubscrpnOrdItemIsRejected SubscrpnOrdItemIsRejected
SubscrpnOrdItmHasError SubscrpnOrdItmHasError
SubscrpnOrdItemCreditStatus SubscrpnOrdItemCreditStatus
SoldToParty SoldToParty Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
ShipToPartyAddressID ShipToPartyAddressID Ship-to Party Address
BillToPartyAddressIdentifier BillToPartyAddressIdentifier
PayerToPartyAddressIdentifier PayerToPartyAddressIdentifier
ContactPerson ContactPerson Contact Person Key
PersonResponsible PersonResponsible Person Responsible
PaymentTerms PaymentTerms Pyt Terms
CABillgCycle CABillgCycle Billing Cycle
ContractAccount ContractAccount Contract Acct
SubscrpnContrItmStartDateTime SubscrpnContrItmStartDateTime
SubscrpnContrItemExtnDuration SubscrpnContrItemExtnDuration
SubscrpnContrItemExtnDurnUnit SubscrpnContrItemExtnDurnUnit
SubscrpnContrItmEndDateTime SubscrpnContrItmEndDateTime
SbscrContrTimeSliceStrtDteTme SbscrContrTimeSliceStrtDteTme
SbscrContrTimeSliceEndDteTme SbscrContrTimeSliceEndDteTme
SubscrpnContrAutoRnwlIsActv SubscrpnContrAutoRnwlIsActv
SubscrpnContrArnwlStrtDurn SubscrpnContrArnwlStrtDurn
SubscrpnContrArnwlStrtDurnUnit SubscrpnContrArnwlStrtDurnUnit
SubscrpnContrAutoRnwlDurn SubscrpnContrAutoRnwlDurn
SubscrpnContrAutoRnwlDurnUnit SubscrpnContrAutoRnwlDurnUnit
RevenueAccountingReference RevenueAccountingReference
RevenueAccountingRefType RevenueAccountingRefType
CrsCatalogMappingVersionNumber CrsCatalogMappingVersionNumber Version
ConfigurationNumber ConfigurationNumber Int. object no.
SubscrpnOrdItemIsPhased SubscrpnOrdItemIsPhased
SubscrpnOrdItmPhasedPrdcssrItm SubscrpnOrdItmPhasedPrdcssrItm
SbscrContrItemCanclnParty SbscrContrItemCanclnParty
SbscrContrItemCanclnReason SbscrContrItemCanclnReason
SbscrContrItmCanclnProcedure SbscrContrItmCanclnProcedure
SbscrContrItmCanclnRecDateTime SbscrContrItmCanclnRecDateTime
SbscrContrItmCanclnReqDateTime SbscrContrItmCanclnReqDateTime
TransactionCurrency TransactionCurrency Transaction Currency
SrvcDocItmRecrrgChrgNetAmount SrvcDocItmRecrrgChrgNetAmount
SrvcDocItmRecrrgChrgTaxAmount SrvcDocItmRecrrgChrgTaxAmount
SrvcDocItmRecrrgChrgGrossAmt SrvcDocItmRecrrgChrgGrossAmt
SrvcDocItmRecrrgChrgDuration SrvcDocItmRecrrgChrgDuration
SrvcDocItmRecrrgChrgDurnUnit SrvcDocItmRecrrgChrgDurnUnit
SubscriptionContractExternalID SubscriptionContractExternalID Contract Number
CustMgmtMasterAgreement CustMgmtMasterAgreement
CustMgmtMstrAgrmtItem CustMgmtMstrAgrmtItem
CustMgmtMstrAgrmtParentItem CustMgmtMstrAgrmtParentItem
SharingContractID SharingContractID Sharing Contract
SubscrpnContractSharingGroupID SubscrpnContractSharingGroupID Sharing Group ID

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 A_SubscriptionOrderItem.
-- 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 A_SubscriptionOrderItem AS
SELECT
  SubscriptionOrder,
  SubscriptionOrderItem,
  ServiceObjectType,
  ServiceDocumentItemObjectType,
  SubscrpnOrdItemCategory,
  SubscriptionOrderItemUUID,
  ParentSubscriptionOrderItem,
  CreationDateTime,
  LastChangeDateTime,
  CreatedByUser,
  LastChangedByUser,
  Product,
  SubscrpnOrdItmDescription,
  Quantity,
  QuantityUnit,
  SubscrpnOrdRjcnReason,
  PurchaseOrderByShipToParty,
  SubscrpnOrdItemIsNew,
  SubscrpnOrdItemIsInProcess,
  SubscrpnOrdItemIsReleased,
  SubscrpnOrdItemIsCompleted,
  SubscrpnOrdItemIsRejected,
  SubscrpnOrdItmHasError,
  SubscrpnOrdItemCreditStatus,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ShipToPartyAddressID,
  BillToPartyAddressIdentifier,
  PayerToPartyAddressIdentifier,
  ContactPerson,
  PersonResponsible,
  PaymentTerms,
  CABillgCycle,
  ContractAccount,
  SubscrpnContrItmStartDateTime,
  SubscrpnContrItemExtnDuration,
  SubscrpnContrItemExtnDurnUnit,
  SubscrpnContrItmEndDateTime,
  SbscrContrTimeSliceStrtDteTme,
  SbscrContrTimeSliceEndDteTme,
  SubscrpnContrAutoRnwlIsActv,
  SubscrpnContrArnwlStrtDurn,
  SubscrpnContrArnwlStrtDurnUnit,
  SubscrpnContrAutoRnwlDurn,
  SubscrpnContrAutoRnwlDurnUnit,
  RevenueAccountingReference,
  RevenueAccountingRefType,
  CrsCatalogMappingVersionNumber,
  ConfigurationNumber,
  SubscrpnOrdItemIsPhased,
  SubscrpnOrdItmPhasedPrdcssrItm,
  SbscrContrItemCanclnParty,
  SbscrContrItemCanclnReason,
  SbscrContrItmCanclnProcedure,
  SbscrContrItmCanclnRecDateTime,
  SbscrContrItmCanclnReqDateTime,
  TransactionCurrency,
  SrvcDocItmRecrrgChrgNetAmount,
  SrvcDocItmRecrrgChrgTaxAmount,
  SrvcDocItmRecrrgChrgGrossAmt,
  SrvcDocItmRecrrgChrgDuration,
  SrvcDocItmRecrrgChrgDurnUnit,
  SubscriptionContractExternalID,
  CustMgmtMasterAgreement,
  CustMgmtMstrAgrmtItem,
  CustMgmtMstrAgrmtParentItem,
  SharingContractID,
  SubscrpnContractSharingGroupID
FROM R_SubscriptionOrderItemTP
;

Learn More