C_SettlmtDocEDI

DDL: C_SETTLMTDOCEDI Type: view_entity CONSUMPTION
65 Fields 1 Data Sources

Settlement Document EDI

C_SettlmtDocEDI is a Consumption CDS View that provides data about "Settlement Document EDI" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDocTP) and exposes 65 fields with key field SettlmtDoc.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDocTP R_SettlmtDocTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Settlement Document EDI view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Search.searchable false view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.representativeKey SettlmtDoc view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc SettlmtDoc Settlement Doc.
SettlmtDocCat SettlmtDocCat Settlement Document Category
SettlmtCat SettlmtCat Settl. Category
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
DocumentDate DocumentDate Journal Entry Date
SettlmtDocCurrency SettlmtDocCurrency Doc. Currency
GrossAmount CustomerTotalGrossAmount Customer Total Gross Amount
NetAmount CustomerTotalNetAmount Extracted Net Value
TaxAmount CustomerTotalTaxAmount Customer Total Tax Amount
PaymentTerms CustomerPaymentTerms Pyt Terms
CashDiscount1Days CustomerCashDiscount1Days Customer 1st Payment in Days
CashDiscount2Days CustomerCashDiscount2Days Customer 2nd Payment in Days
NetPaymentDays CustomerNetPaymentDays Customer Cash Discount Days
CashDiscount1Percent CustomerCashDiscount1Percent Customer Discount for 1st Payment in %
CashDiscount2Percent CustomerCashDiscount2Percent Customer Discount for 2nd Payment in %
FixedValueDate CustomerFixedValueDate Customer Fixed Value Date
CanceledSettlmtDoc CanceledSettlmtDoc Reversed Document
SettlmtReltdCndnContr SettlmtReltdCndnContr Related Condition Contract
ExternalDocumentReferenceID _SettlmtReltdCndnContr ExternalDocumentReferenceID Ext. Identifier
CndnContrValidFrom _SettlmtReltdCndnContr CndnContrValidFrom Valid From
CndnContrValidTo _SettlmtReltdCndnContr CndnContrValidTo Valid To
CndnContrClassfctnType _SettlmtReltdCndnContr CndnContrClassfctnType Contract Category
SettlmtPartnerCat SettlmtPartnerCat Settlmt Part Cat
SettlmtDateCat SettlmtDateCat Settlement Date Type
ActualSettlmtDate ActualSettlmtDate Actual Settl. Date
SettlmtDate SettlmtDate Settlement Date
SettlmtPeriodStartDate SettlmtPeriodStartDate Start Date of Period
SettlmtPeriodEndDate SettlmtPeriodEndDate End Date of Period
SettlmtBusProcCat SettlmtBusProcCat Use Case Type
SettlmtDocType SettlmtDocType Settlement Document Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SuplrSettlmtCompanyCode SuplrSettlmtCompanyCode Suppl. Company Code
AlternativeInvoicingParty AlternativeInvoicingParty Alternative Supplier
CustSettlmtCompanyCode CustSettlmtCompanyCode Cust. Company Code
InvoicingParty InvoicingParty Supplier
PayeeParty PayeeParty Payee
SettlmtDocAuthznCat SettlmtDocAuthznCat Authorization Cat.
_BillToParty _BillToParty
_CanceledSettlmtDoc _CanceledSettlmtDoc
_CustomerPaymentTerms _CustomerPaymentTerms
_CustomerPricingElement _CustomerPricingElement
_Partner _Partner
_PayerParty _PayerParty
_SettlmtBusProcCat _SettlmtBusProcCat
_SettlmtCat _SettlmtCat
_SettlmtDateCat _SettlmtDateCat
_SettlmtDocCat _SettlmtDocCat
_SettlmtDocCurrency _SettlmtDocCurrency
_SettlmtPartnerCat _SettlmtPartnerCat
_SettlmtReltdCndnContr _SettlmtReltdCndnContr
_SupplierPricingElement _SupplierPricingElement
_AltvInvoicingPartyCompany _AltvInvoicingPartyCompany
_AlternativeInvoicingParty _AlternativeInvoicingParty
_PayeeParty _PayeeParty
_PayeePartyCompany _PayeePartyCompany
_SuplrSettlmtCompanyCode _SuplrSettlmtCompanyCode
_InvoicingParty _InvoicingParty
_InvoicingPartyCompany _InvoicingPartyCompany
_BillToPartyCompany _BillToPartyCompany
_PayerPartyCompany _PayerPartyCompany

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_SettlmtDocEDI.
-- 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_SettlmtDocEDI AS
SELECT
  SettlmtDoc,
  SettlmtDocCat,
  SettlmtCat,
  BillToParty,
  PayerParty,
  DocumentDate,
  SettlmtDocCurrency,
  CustomerTotalGrossAmount AS GrossAmount,
  CustomerTotalNetAmount AS NetAmount,
  CustomerTotalTaxAmount AS TaxAmount,
  CustomerPaymentTerms AS PaymentTerms,
  CustomerCashDiscount1Days AS CashDiscount1Days,
  CustomerCashDiscount2Days AS CashDiscount2Days,
  CustomerNetPaymentDays AS NetPaymentDays,
  CustomerCashDiscount1Percent AS CashDiscount1Percent,
  CustomerCashDiscount2Percent AS CashDiscount2Percent,
  CustomerFixedValueDate AS FixedValueDate,
  CanceledSettlmtDoc,
  SettlmtReltdCndnContr,
  _SettlmtReltdCndnContr.ExternalDocumentReferenceID AS ExternalDocumentReferenceID,
  _SettlmtReltdCndnContr.CndnContrValidFrom AS CndnContrValidFrom,
  _SettlmtReltdCndnContr.CndnContrValidTo AS CndnContrValidTo,
  _SettlmtReltdCndnContr.CndnContrClassfctnType AS CndnContrClassfctnType,
  SettlmtPartnerCat,
  SettlmtDateCat,
  ActualSettlmtDate,
  SettlmtDate,
  SettlmtPeriodStartDate,
  SettlmtPeriodEndDate,
  SettlmtBusProcCat,
  SettlmtDocType,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SuplrSettlmtCompanyCode,
  AlternativeInvoicingParty,
  CustSettlmtCompanyCode,
  InvoicingParty,
  PayeeParty,
  SettlmtDocAuthznCat
FROM R_SettlmtDocTP
;

Learn More