CRMS4_IU_I_UID
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)
| Source | Alias | Join Type |
|---|---|---|
| erdk | erdk | inner |
| I_UtilitiesInvoicingDocument | I_UtilitiesInvoicingDocument | from |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA