C_SuplrBillgDocEDP

DDL: C_SUPLRBILLGDOCEDP Type: view_entity CONSUMPTION
67 Fields 1 Data Sources 5 Associations

Supplier Billing Document EDP

C_SuplrBillgDocEDP is a Consumption CDS View that provides data about "Supplier Billing Document EDP" in SAP S/4HANA. It reads from 1 data source (R_SuplrBillgDoc) and exposes 67 fields with key field SuplrBillgDoc. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SuplrBillgDoc R_SuplrBillgDoc from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_PaymentTerms _SupplierPaymentTerms $projection.PaymentTerms = _SupplierPaymentTerms.PaymentTerms
[0..*] I_SuplrBillgDocPartner _SuplrBillgDocPartner $projection.SuplrBillgDoc = _SuplrBillgDocPartner.SuplrBillgDoc
[0..*] I_SuplrBillgDocBankData _SuplrBillgDocBankData $projection.SuplrBillgDoc = _SuplrBillgDocBankData.SuplrBillgDoc
[0..*] I_SuplrBillgDocPrcgElmnt _SuplrBillgDocPrcgElmnt $projection.SuplrBillgDoc = _SuplrBillgDocPrcgElmnt.SuplrBillgDoc
[1..1] E_SettlmtMgmtDoc _Extension $projection.SuplrBillgDoc = _Extension.SettlmtMgmtDoc

Annotations (11)

NameValueLevelField
EndUserText.label Supplier Billing Document EDP view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SuplrBillgDoc view
ObjectModel.compositionRoot true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.modelingPattern #OUTPUT_EMAIL_DATA_PROVIDER view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY SuplrBillgDoc SuplrBillgDoc
SettlmtDocType SettlmtDocType Settlement Document Type
SettlmtDocCat SettlmtDocCat Settlement Document Category
SettlmtProcessType SettlmtProcessType Settlement Process Type
LogisticsDataEntryCat LogisticsDataEntryCat Entry Category
SettlmtCat SettlmtCat Settl. Category
PostingDate PostingDate Posting Date for GR
SuplrBillgDocAcctgTransfSts SuplrBillgDocAcctgTransfSts Posting Status
DocumentDate DocumentDate Journal Entry Date
DocumentReferenceID DocumentReferenceID Reference
AssignmentReference AssignmentReference Assignment Reference
InvoicingParty InvoicingParty Supplier
PayeeParty PayeeParty Payee
AlternativeInvoicingParty AlternativeInvoicingParty Alternative Supplier
CompanyCode CompanyCode Receiver Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
SuplrBillgDocCurrency SuplrBillgDocCurrency Doc. Currency
ExchangeRate ExchangeRate Exchange rate
ExchangeRateType ExchangeRateType Exch. Rate Type
ExchangeRateIsFixed ExchangeRateIsFixed Fixed Exch.Rate
ExchangeRateDate ExchangeRateDate Translatn Date
SuplrBillgDocTotalGrossAmount SuplrBillgDocTotalGrossAmount
SuplrBillgDocTotalNetAmount SuplrBillgDocTotalNetAmount
SuplrBillgDocTotalTaxAmount SuplrBillgDocTotalTaxAmount
PaymentTerms PaymentTerms Pyt Terms
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
PaymentMethod PaymentMethod Pymt Meth.
SuplrTotEligibleAmtForCshDisc SuplrTotEligibleAmtForCshDisc Suplr Cash Disc Bas
SuplrBillgDocIsReversed SuplrBillgDocIsReversed
RvsdSuplrBillgDoc RvsdSuplrBillgDoc
VATRegistration VATRegistration VAT Registration No.
FiscalPeriod FiscalPeriod Tax period
SettlmtBusProcCat SettlmtBusProcCat Use Case Type
_SuplrBillgDocPlainLongText _SuplrBillgDocPlainLongText
_SuplrBillgDocPartner _SuplrBillgDocPartner
_SuplrBillgDocBankData _SuplrBillgDocBankData
_SuplrBillgDocPrcgElmnt _SuplrBillgDocPrcgElmnt
_SettlmtDocType _SettlmtDocType
_SettlmtDocCat _SettlmtDocCat
_SettlmtProcessType _SettlmtProcessType
_LogisticsDataEntryCat _LogisticsDataEntryCat
_SettlmtCat _SettlmtCat
_SuplrBillgDocAcctgTransfSts _SuplrBillgDocAcctgTransfSts
_InvoicingParty _InvoicingParty
_PayeeParty _PayeeParty
_AlternativeInvoicingParty _AlternativeInvoicingParty
_InvoicingPartyCompany _InvoicingPartyCompany
_PayeePartyCompany _PayeePartyCompany
_AltvInvoicingPartyCompany _AltvInvoicingPartyCompany
_CompanyCode _CompanyCode
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_CreatedByUser _CreatedByUser
_SuplrBillgDocCurrency _SuplrBillgDocCurrency
_ExchangeRateType _ExchangeRateType
_SupplierPaymentTerms _SupplierPaymentTerms
_RvsdSuplrBillgDoc _RvsdSuplrBillgDoc
_SettlmtBusProcCat _SettlmtBusProcCat

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 C_SuplrBillgDocEDP.
-- 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 C_SuplrBillgDocEDP AS
SELECT
  SuplrBillgDoc,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  LogisticsDataEntryCat,
  SettlmtCat,
  PostingDate,
  SuplrBillgDocAcctgTransfSts,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  InvoicingParty,
  PayeeParty,
  AlternativeInvoicingParty,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  SuplrBillgDocCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  SuplrBillgDocTotalGrossAmount,
  SuplrBillgDocTotalNetAmount,
  SuplrBillgDocTotalTaxAmount,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PaymentMethod,
  SuplrTotEligibleAmtForCshDisc,
  SuplrBillgDocIsReversed,
  RvsdSuplrBillgDoc,
  VATRegistration,
  FiscalPeriod,
  SettlmtBusProcCat
FROM R_SuplrBillgDoc
LEFT OUTER JOIN I_PaymentTerms AS _SupplierPaymentTerms ON PaymentTerms = _SupplierPaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_SuplrBillgDocPartner AS _SuplrBillgDocPartner ON SuplrBillgDoc = _SuplrBillgDocPartner.SuplrBillgDoc  -- association [0..*]
LEFT OUTER JOIN I_SuplrBillgDocBankData AS _SuplrBillgDocBankData ON SuplrBillgDoc = _SuplrBillgDocBankData.SuplrBillgDoc  -- association [0..*]
LEFT OUTER JOIN I_SuplrBillgDocPrcgElmnt AS _SuplrBillgDocPrcgElmnt ON SuplrBillgDoc = _SuplrBillgDocPrcgElmnt.SuplrBillgDoc  -- association [0..*]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON SuplrBillgDoc = _Extension.SettlmtMgmtDoc  -- association [1..1]
;

Learn More