CRMS4_IU_C_UID

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 CRMS4_IU_C_UID.
-- 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 CRMS4_IU_C_UID AS
SELECT
  UtilitiesInvoicingDocument AS OPBEL,
  UtilitiesInvoicingDocPrintDate AS DRUCKDAT,
  NetDueDate AS FAEDN,
  CashDiscountDueDate AS FAEDS,
  CashDiscountPercent AS SKTPZ,
  PostingDate AS BUDAT,
  DocumentDate AS BLDAT,
  TotalAmountInTransactionCrcy AS TOTAL_AMNT,
  TransactionCurrency AS TOTAL_WAER,
  PaymentMethod AS PYMET,
  UtilitiesInvoicingReason AS ERGRD,
  UtilsInvcgDocIsReversed AS STOKZ,
  UtilsInvcgDocReversalRsn AS ICREASON,
  ReversalUtilsInvcgDocument AS INTOPBEL,
  UtilsInvcgDocIsNotReleased AS TOBRELEASD,
  UtilsInvcgDocIsSimulated AS SIMULATED,
  UtilsInvcgDocumentIsPosted AS INVOICED,
  BusinessPartner AS PARTNER,
  ContractAccount AS VKONT,
  UtilitiesPortion AS PORTION,
  UtilitiesBillingReason AS ABRVORG,
  CAReconciliationKey AS FIKEY,
  UtilitiesInvoicingParty AS INVOICING_PARTY,
  UtilsInvcgDocCreationDate AS ERDAT,
  UtilsInvcgDocCreatedByUser AS ERNAM,
  UtilsInvcgDocLastChangeDate AS AEDAT,
  UtilsInvcgDocLastChangedByUser AS AENAM,
  OriginalUtilsInvcgDocRvslDate AS STO_BUDAT,
  OriginalUtilsInvcgDocument AS STO_OPBEL,
  REVLOCK,
  UtilsInvcgDocPrintBlockRsn AS PRINTLOCK,
  AuthorizationGroup AS BEGRU,
  LOEVM,
  FORMKEY,
  BILLING_PERIOD,
  ABWVK,
  ABWBL,
  OSB_GROUP
FROM CRMS4_IU_I_UID
;