R_CH_ElectronicDocIncgInvoice

DDL: R_CH_ELECTRONICDOCINCGINVOICE Type: view_entity BASIC
18 Fields 1 Data Sources

Switzerland Incoming Invoice

R_CH_ElectronicDocIncgInvoice is a Basic CDS View that provides data about "Switzerland Incoming Invoice" in SAP S/4HANA. It reads from 1 data source (edochinvinc) and exposes 18 fields with key field ElectronicDocUUID.

Data Sources (1)

SourceAliasJoin Type
edochinvinc edochinvinc from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Switzerland Incoming Invoice view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID edoc_guid eDocument GUID
CH_ElectronicDocInvcIssuerID biller_id Biller ID
CH_ElectronicDocRecipientID ebill_accnt_id Recipient ID
CH_ElectronicDocTransactionID transaction_id Update key
CH_ElectronicDocumentID document_id Snapshot ID
CH_EDocRcpntBusinessPartnerID customer_id Recipient Cust. ID
CH_EDocInvcIssuerCompanyName company_name Company
CH_EDocRcpntBusPartnerName receiver_company_name Recipient Cust. Name
CH_ElectronicDocInvcIssuerTxID tax_id Biller Tax ID
CH_ElectronicDocAcctgDocNmbr reference_value Doc. Reference
CH_ElectronicDocIBAN iban IBAN House Bank
CH_ElectronicDocQRCodeRefNmbr creditor_reference QR/SCOR Reference
CH_ElectronicDocTotalAmount total_amount Total Amount
CH_ElectronicDocTotalTaxAmount total_tax Total Tax
CH_ElectronicDocCurrency currency Valuation Crcy
CH_ElectronicDocType document_type Unit
CH_ElectronicDocPaymentType payment_type Payment Type
CH_ElectronicDocRecnclnCmnt reconciliation_comment Reconciliation Comm.

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 R_CH_ElectronicDocIncgInvoice.
-- 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 R_CH_ElectronicDocIncgInvoice AS
SELECT
  edoc_guid AS ElectronicDocUUID,
  biller_id AS CH_ElectronicDocInvcIssuerID,
  ebill_accnt_id AS CH_ElectronicDocRecipientID,
  transaction_id AS CH_ElectronicDocTransactionID,
  document_id AS CH_ElectronicDocumentID,
  customer_id AS CH_EDocRcpntBusinessPartnerID,
  company_name AS CH_EDocInvcIssuerCompanyName,
  receiver_company_name AS CH_EDocRcpntBusPartnerName,
  tax_id AS CH_ElectronicDocInvcIssuerTxID,
  reference_value AS CH_ElectronicDocAcctgDocNmbr,
  iban AS CH_ElectronicDocIBAN,
  creditor_reference AS CH_ElectronicDocQRCodeRefNmbr,
  total_amount AS CH_ElectronicDocTotalAmount,
  total_tax AS CH_ElectronicDocTotalTaxAmount,
  currency AS CH_ElectronicDocCurrency,
  document_type AS CH_ElectronicDocType,
  payment_type AS CH_ElectronicDocPaymentType,
  reconciliation_comment AS CH_ElectronicDocRecnclnCmnt
FROM edochinvinc
;

Learn More