C_SettlmtDocListEDP

DDL: C_SETTLMTDOCLISTEDP Type: view_entity CONSUMPTION
80 Fields 1 Data Sources 5 Associations

Settlement Document List EDP

C_SettlmtDocListEDP is a Consumption CDS View that provides data about "Settlement Document List EDP" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDocList) and exposes 80 fields with key field SettlmtDocList. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDocList R_SettlmtDocList from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_SettlmtMgmtAcctgTransfSts _SettlmtMgmtAcctgTransfSts $projection.SettlmtDocListAcctgTransfSts = _SettlmtMgmtAcctgTransfSts.SettlmtMgmtAcctgTransfSts
[0..*] I_SettlmtDocListPartner _SettlmtDocListPartner $projection.SettlmtDocList = _SettlmtDocListPartner.SettlmtDocList
[0..*] I_SettlmtDocListBankData _SettlmtDocListBankData $projection.SettlmtDocList = _SettlmtDocListBankData.SettlmtDocList
[0..1] C_SettlmtDocListEDP _RvsdSettlmtDocList $projection.RvsdSettlmtDocList = _RvsdSettlmtDocList.SettlmtDocList
[1..1] E_SettlmtMgmtDoc _Extension $projection.SettlmtDocList = _Extension.SettlmtMgmtDoc

Annotations (11)

NameValueLevelField
EndUserText.label Settlement Document List EDP view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SettlmtDocList 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 (80)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDocList SettlmtDocList
SettlmtDocType SettlmtDocType Settlement Document Type
SettlmtDocListType SettlmtDocListType
SettlmtDocCat SettlmtDocCat Settlement Document Category
SettlmtProcessType SettlmtProcessType Settlement Process Type
SettlmtDocListCat SettlmtDocListCat
LogisticsDataEntryCat LogisticsDataEntryCat Entry Category
PostingDate PostingDate Posting Date for GR
SettlmtDocListAcctgTransfSts SettlmtDocListAcctgTransfSts Posting Status
DocumentDate DocumentDate Journal Entry Date
DocumentReferenceID DocumentReferenceID Reference
AssignmentReference AssignmentReference Assignment Reference
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
InvoicingParty InvoicingParty Supplier
PayeeParty PayeeParty Payee
AlternativeInvoicingParty AlternativeInvoicingParty Alternative Supplier
CompanyCode CompanyCode Receiver Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
SettlmtDocListCurrency SettlmtDocListCurrency Doc. Currency
ExchangeRate ExchangeRate Exchange rate
ExchangeRateType ExchangeRateType Exch. Rate Type
ExchangeRateIsFixed ExchangeRateIsFixed Fixed Exch.Rate
ExchangeRateDate ExchangeRateDate Translatn Date
SettlmtDocListTotalGrossAmount SettlmtDocListTotalGrossAmount
SettlmtDocListTotalNetAmount SettlmtDocListTotalNetAmount
SettlmtDocListTotalTaxAmount SettlmtDocListTotalTaxAmount
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.
EligibleAmountForCashDiscount EligibleAmountForCashDiscount
SettlmtDocListIsReversed SettlmtDocListIsReversed
RvsdSettlmtDocList RvsdSettlmtDocList
VATRegistration VATRegistration VAT Registration No.
FiscalPeriod FiscalPeriod Tax period
SettlmtBusProcCat SettlmtBusProcCat Use Case Type
_SettlmtDocListPlainLongText _SettlmtDocListPlainLongText
_SettlmtDocListPartner _SettlmtDocListPartner
_SettlmtDocListBankData _SettlmtDocListBankData
_SettlmtDocType _SettlmtDocType
_SettlmtDocCat _SettlmtDocCat
_SettlmtProcessType _SettlmtProcessType
_SettlmtDocListCat _SettlmtDocListCat
_LogisticsDataEntryCat _LogisticsDataEntryCat
_SettlmtMgmtAcctgTransfSts _SettlmtMgmtAcctgTransfSts
_BillToParty _BillToParty
_PayerParty _PayerParty
_InvoicingParty _InvoicingParty
_PayeeParty _PayeeParty
_AlternativeInvoicingParty _AlternativeInvoicingParty
_BillToPartyCompany _BillToPartyCompany
_PayerPartyCompany _PayerPartyCompany
_InvoicingPartyCompany _InvoicingPartyCompany
_PayeePartyCompany _PayeePartyCompany
_AltvInvoicingPartyCompany _AltvInvoicingPartyCompany
_CompanyCode _CompanyCode
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesArea _SalesArea
_CreatedByUser _CreatedByUser
_SettlmtDocListCurrency _SettlmtDocListCurrency
_ExchangeRateType _ExchangeRateType
_PaymentTerms _PaymentTerms
_RvsdSettlmtDocList _RvsdSettlmtDocList
_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_SettlmtDocListEDP.
-- 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_SettlmtDocListEDP AS
SELECT
  SettlmtDocList,
  SettlmtDocType,
  SettlmtDocListType,
  SettlmtDocCat,
  SettlmtProcessType,
  SettlmtDocListCat,
  LogisticsDataEntryCat,
  PostingDate,
  SettlmtDocListAcctgTransfSts,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  BillToParty,
  PayerParty,
  InvoicingParty,
  PayeeParty,
  AlternativeInvoicingParty,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  SettlmtDocListCurrency,
  ExchangeRate,
  ExchangeRateType,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  SettlmtDocListTotalGrossAmount,
  SettlmtDocListTotalNetAmount,
  SettlmtDocListTotalTaxAmount,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PaymentMethod,
  EligibleAmountForCashDiscount,
  SettlmtDocListIsReversed,
  RvsdSettlmtDocList,
  VATRegistration,
  FiscalPeriod,
  SettlmtBusProcCat
FROM R_SettlmtDocList
LEFT OUTER JOIN I_SettlmtMgmtAcctgTransfSts AS _SettlmtMgmtAcctgTransfSts ON SettlmtDocListAcctgTransfSts = _SettlmtMgmtAcctgTransfSts.SettlmtMgmtAcctgTransfSts  -- association [0..1]
LEFT OUTER JOIN I_SettlmtDocListPartner AS _SettlmtDocListPartner ON SettlmtDocList = _SettlmtDocListPartner.SettlmtDocList  -- association [0..*]
LEFT OUTER JOIN I_SettlmtDocListBankData AS _SettlmtDocListBankData ON SettlmtDocList = _SettlmtDocListBankData.SettlmtDocList  -- association [0..*]
LEFT OUTER JOIN C_SettlmtDocListEDP AS _RvsdSettlmtDocList ON RvsdSettlmtDocList = _RvsdSettlmtDocList.SettlmtDocList  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDoc AS _Extension ON SettlmtDocList = _Extension.SettlmtMgmtDoc  -- association [1..1]
;

Learn More