P_TR_ElectronicDocOutgInvoice

DDL: P_TR_ELECTRONICDOCOUTGINVOICE SQL: PEDOTRINV Type: view BASIC
12 Fields 1 Data Sources

P_TR_ElectronicDocOutgInvoice is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (edotrinv) and exposes 12 fields with key field ElectronicDocUUID.

Data Sources (1)

SourceAliasJoin Type
edotrinv edotrinv from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PEDOTRINV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ElectronicDocUUID edoc_guid eDocument GUID
TR_ElectronicDocEnvelopeID fit_envelope_id Envelope ID
TR_ElectronicDocInvoiceID fit_tra_id Invoice ID
TR_ElectronicDocUniqueID uuid Waste Partner UUID
TR_EDocBusinessPartnerAlias identifier Snd. Alias
TR_ElectronicDocTaxID vkn_tckn VKN/TCKN
TR_ElectronicDocBusPartner business_partner Busn. Partner
TR_EDocTaxExclusiveAmount net_amount Tax-Exclusive Amount
TR_ElectronicDocTaxAmount tax_amount VAT Amount Type
TR_EDocTaxInclusiveAmount gross_amount Tax-Inclusive Amount
SalesCurrency currency Valuation Crcy
TR_EDocBusPartnerName business_partner_name Bus. Partner Name

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 P_TR_ElectronicDocOutgInvoice.
-- 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.
-- SQL view name: PEDOTRINV

CREATE VIEW P_TR_ElectronicDocOutgInvoice AS
SELECT
  edoc_guid AS ElectronicDocUUID,
  fit_envelope_id AS TR_ElectronicDocEnvelopeID,
  fit_tra_id AS TR_ElectronicDocInvoiceID,
  uuid AS TR_ElectronicDocUniqueID,
  identifier AS TR_EDocBusinessPartnerAlias,
  vkn_tckn AS TR_ElectronicDocTaxID,
  business_partner AS TR_ElectronicDocBusPartner,
  net_amount AS TR_EDocTaxExclusiveAmount,
  tax_amount AS TR_ElectronicDocTaxAmount,
  gross_amount AS TR_EDocTaxInclusiveAmount,
  currency AS SalesCurrency,
  business_partner_name AS TR_EDocBusPartnerName
FROM edotrinv
;

Learn More