CRMS4_IU_I_UID

DDL: CRMS4_IU_I_UID Type: view_entity

Utilities Invoice Document

CRMS4_IU_I_UID is a CDS View that provides data about "Utilities Invoice Document" in SAP S/4HANA. It reads from 2 data sources (erdk, I_UtilitiesInvoicingDocument) and exposes 46 fields with key field UtilitiesInvoicingDocument.

Data Sources (2)

SourceAliasJoin Type
erdk erdk inner
I_UtilitiesInvoicingDocument I_UtilitiesInvoicingDocument from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Utilities Invoice Document view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesInvoicingDocument I_UtilitiesInvoicingDocument UtilitiesInvoicingDocument
UtilitiesInvoicingDocPrintDate I_UtilitiesInvoicingDocument UtilitiesInvoicingDocPrintDate
NetDueDate I_UtilitiesInvoicingDocument NetDueDate
CashDiscountDueDate I_UtilitiesInvoicingDocument CashDiscountDueDate
CashDiscountPercent I_UtilitiesInvoicingDocument CashDiscountPercent
PostingDate I_UtilitiesInvoicingDocument PostingDate
DocumentDate I_UtilitiesInvoicingDocument DocumentDate
TotalAmountInTransactionCrcy I_UtilitiesInvoicingDocument TotalAmountInTransactionCrcy
TransactionCurrency I_UtilitiesInvoicingDocument TransactionCurrency
PaymentMethod I_UtilitiesInvoicingDocument PaymentMethod
UtilitiesInvoicingReason I_UtilitiesInvoicingDocument UtilitiesInvoicingReason
UtilsInvcgDocIsReversed I_UtilitiesInvoicingDocument UtilsInvcgDocIsReversed
UtilsInvcgDocReversalRsn I_UtilitiesInvoicingDocument UtilsInvcgDocReversalRsn
ReversalUtilsInvcgDocument I_UtilitiesInvoicingDocument ReversalUtilsInvcgDocument
UtilsInvcgDocIsNotReleased I_UtilitiesInvoicingDocument UtilsInvcgDocIsNotReleased
UtilsInvcgDocIsSimulated I_UtilitiesInvoicingDocument UtilsInvcgDocIsSimulated
UtilsInvcgDocumentIsPosted I_UtilitiesInvoicingDocument UtilsInvcgDocumentIsPosted
BusinessPartner I_UtilitiesInvoicingDocument BusinessPartner
ContractAccount I_UtilitiesInvoicingDocument ContractAccount
UtilitiesPortion I_UtilitiesInvoicingDocument UtilitiesPortion
UtilitiesBillingReason I_UtilitiesInvoicingDocument UtilitiesBillingReason
CAReconciliationKey I_UtilitiesInvoicingDocument CAReconciliationKey
UtilitiesInvoicingParty I_UtilitiesInvoicingDocument UtilitiesInvoicingParty
UtilsInvcgDocCreationDate I_UtilitiesInvoicingDocument UtilsInvcgDocCreationDate
UtilsInvcgDocCreatedByUser I_UtilitiesInvoicingDocument UtilsInvcgDocCreatedByUser
UtilsInvcgDocLastChangeDate I_UtilitiesInvoicingDocument UtilsInvcgDocLastChangeDate
UtilsInvcgDocLastChangedByUser I_UtilitiesInvoicingDocument UtilsInvcgDocLastChangedByUser
OriginalUtilsInvcgDocRvslDate I_UtilitiesInvoicingDocument OriginalUtilsInvcgDocRvslDate
OriginalUtilsInvcgDocument I_UtilitiesInvoicingDocument OriginalUtilsInvcgDocument
revlock erdk revlock
UtilsInvcgDocPrintBlockRsn I_UtilitiesInvoicingDocument UtilsInvcgDocPrintBlockRsn
AuthorizationGroup I_UtilitiesInvoicingDocument AuthorizationGroup
loevm erdk loevm
formkey erdk formkey
abwvk erdk abwvk
abwbl erdk abwbl
osb_group erdk osb_group
_BusinessPartner I_UtilitiesInvoicingDocument _BusinessPartner
_CreatedByUser I_UtilitiesInvoicingDocument _CreatedByUser
_Currency I_UtilitiesInvoicingDocument _Currency
_LastChangedByUser I_UtilitiesInvoicingDocument _LastChangedByUser
_UtilitiesBillingReason I_UtilitiesInvoicingDocument _UtilitiesBillingReason
_UtilitiesInvoicingReason I_UtilitiesInvoicingDocument _UtilitiesInvoicingReason
_UtilitiesPortion I_UtilitiesInvoicingDocument _UtilitiesPortion
_UtilsInvcgDocReversalRsn I_UtilitiesInvoicingDocument _UtilsInvcgDocReversalRsn
_UtilsInvcgPrntBlockRsn I_UtilitiesInvoicingDocument _UtilsInvcgPrntBlockRsn
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Utilities Invoice Document'
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory:   #XL,
  dataClass:      #TRANSACTIONAL
}

define view entity CRMS4_IU_I_UID
  as select from I_UtilitiesInvoicingDocument
  inner join erdk on erdk.opbel = I_UtilitiesInvoicingDocument.UtilitiesInvoicingDocument 
{
  key I_UtilitiesInvoicingDocument.UtilitiesInvoicingDocument,
      I_UtilitiesInvoicingDocument.UtilitiesInvoicingDocPrintDate,
      I_UtilitiesInvoicingDocument.NetDueDate,
      I_UtilitiesInvoicingDocument.CashDiscountDueDate,
      I_UtilitiesInvoicingDocument.CashDiscountPercent,
      I_UtilitiesInvoicingDocument.PostingDate,
      I_UtilitiesInvoicingDocument.DocumentDate,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      I_UtilitiesInvoicingDocument.TotalAmountInTransactionCrcy,
      I_UtilitiesInvoicingDocument.TransactionCurrency,
      I_UtilitiesInvoicingDocument.PaymentMethod,
      I_UtilitiesInvoicingDocument.UtilitiesInvoicingReason,
      I_UtilitiesInvoicingDocument.UtilsInvcgDocIsReversed,
      I_UtilitiesInvoicingDocument.UtilsInvcgDocReversalRsn,
      I_UtilitiesInvoicingDocument.ReversalUtilsInvcgDocument,
      I_UtilitiesInvoicingDocument.UtilsInvcgDocIsNotReleased,
      I_UtilitiesInvoicingDocument.UtilsInvcgDocIsSimulated,
      I_UtilitiesInvoicingDocument.UtilsInvcgDocumentIsPosted,
      I_UtilitiesInvoicingDocument.BusinessPartner,
      I_UtilitiesInvoicingDocument.ContractAccount,
      I_UtilitiesInvoicingDocument.UtilitiesPortion,
      I_UtilitiesInvoicingDocument.UtilitiesBillingReason,
      I_UtilitiesInvoicingDocument.CAReconciliationKey,
      I_UtilitiesInvoicingDocument.UtilitiesInvoicingParty,
      I_UtilitiesInvoicingDocument.UtilsInvcgDocCreationDate,
      I_UtilitiesInvoicingDocument.UtilsInvcgDocCreatedByUser,
      I_UtilitiesInvoicingDocument.UtilsInvcgDocLastChangeDate,
      I_UtilitiesInvoicingDocument.UtilsInvcgDocLastChangedByUser,
      I_UtilitiesInvoicingDocument.OriginalUtilsInvcgDocRvslDate,
      I_UtilitiesInvoicingDocument.OriginalUtilsInvcgDocument,
      erdk.revlock,
      I_UtilitiesInvoicingDocument.UtilsInvcgDocPrintBlockRsn,
      I_UtilitiesInvoicingDocument.AuthorizationGroup,
      erdk.loevm,
      erdk.formkey,
      erdk.billing_period,
      erdk.abwvk,
      erdk.abwbl,
      erdk.osb_group,
      /* Associations */
      I_UtilitiesInvoicingDocument._BusinessPartner,
      I_UtilitiesInvoicingDocument._CreatedByUser,
      I_UtilitiesInvoicingDocument._Currency,
      I_UtilitiesInvoicingDocument._LastChangedByUser,
      I_UtilitiesInvoicingDocument._UtilitiesBillingReason,
      I_UtilitiesInvoicingDocument._UtilitiesInvoicingReason,
      I_UtilitiesInvoicingDocument._UtilitiesPortion,
      I_UtilitiesInvoicingDocument._UtilsInvcgDocReversalRsn,
      I_UtilitiesInvoicingDocument._UtilsInvcgPrntBlockRsn
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UTILITIESINVOICINGDOCUMENT",
"ERDK"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CURRENCY",
"I_USER",
"I_UTILITIESBILLINGREASON",
"I_UTILITIESINVOICINGREASON",
"I_UTILITIESPORTION",
"I_UTILSINVCGDOCREVERSALRSN",
"I_UTILSINVCGPRNTBLOCKRSN"
],
"BASE":
[
"I_UTILITIESINVOICINGDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/