I_USFedAPInvoiceTradingPartner

DDL: I_USFEDAPINVOICETRADINGPARTNER Type: view_entity BASIC
9 Fields 2 Data Sources 1 Associations

AP Invoice Trading Partner details

I_USFedAPInvoiceTradingPartner is a Basic CDS View that provides data about "AP Invoice Trading Partner details" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountLineItemRawData, bseg) and exposes 9 fields with key fields SourceLedger, CompanyCode, FiscalYear, LedgerGLLineItem. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_GLAccountLineItemRawData _Acdoca from
bseg _Bseg inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] fmfguskontkey _Fmfguskontkey $projection.USFedGovernmentUUID = _Fmfguskontkey.uskontkey

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label AP Invoice Trading Partner details view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_GLAccountLineItemRawData SourceLedger Source Ledger
KEY CompanyCode I_GLAccountLineItemRawData CompanyCode Receiver Company Code
KEY FiscalYear I_GLAccountLineItemRawData FiscalYear G/L Fiscal Year
AccountingDocumentasAccountingDocument
KEY LedgerGLLineItem I_GLAccountLineItemRawData LedgerGLLineItem Journal Entry Item
fmfgus_keyasUSFedGovernmentUUID
USFedTradingPartnerAgency _Fmfguskontkey tp_agencid Agency ID (TP)
USFedTrdgPartBusEventTypeCode _Fmfguskontkey tp_betc BsEvntTypCd(TP)
USFedTrdgPartMainAccount _Fmfguskontkey tp_main_acct Main Acct (TP)

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 I_USFedAPInvoiceTradingPartner.
-- 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 I_USFedAPInvoiceTradingPartner AS
SELECT
  _Acdoca.SourceLedger AS SourceLedger,
  _Acdoca.CompanyCode AS CompanyCode,
  _Acdoca.FiscalYear AS FiscalYear,
  _Acdoca.LedgerGLLineItem AS LedgerGLLineItem,
  _Fmfguskontkey.tp_agencid AS USFedTradingPartnerAgency,
  _Fmfguskontkey.tp_betc AS USFedTrdgPartBusEventTypeCode,
  _Fmfguskontkey.tp_main_acct AS USFedTrdgPartMainAccount
FROM I_GLAccountLineItemRawData AS _Acdoca
INNER JOIN bseg AS _Bseg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fmfguskontkey AS _Fmfguskontkey ON USFedGovernmentUUID = _Fmfguskontkey.uskontkey  -- association [0..1]
;

Learn More