A_SettlmtDoc

DDL: A_SETTLMTDOC Type: view_entity CONSUMPTION
77 Fields 1 Data Sources 1 OData Services

Settlement Document

A_SettlmtDoc is a Consumption CDS View that provides data about "Settlement Document" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDocTP) and exposes 77 fields with key field SettlmtDoc. It is exposed through 1 OData service (API_SETTLMT_DOC).

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDocTP R_SettlmtDocTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Settlement Document view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true 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 #PUBLIC_REMOTE_API view

OData Services (1)

ServiceBindingVersionContractRelease
API_SETTLMT_DOC API_SETTLMT_DOC V4 C2 C1

Fields (77)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc SettlmtDoc Settlement Doc.
SettlmtDocType SettlmtDocType Settlement Document Type
SettlmtProcessType SettlmtProcessType Settlement Process Type
PostingDate PostingDate Posting Date for GR
SettlmtDocAcctgTransfSts SettlmtMgmtAcctgTransfSts Posting Status
InvoicingParty InvoicingParty Supplier
PayeeParty PayeeParty Payee
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
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
CustSettlmtCompanyCode CustSettlmtCompanyCode Cust. Company Code
DocumentDate DocumentDate Journal Entry Date
DocumentReferenceID DocumentReferenceID Reference
AssignmentReference AssignmentReference Assignment Reference
SettlmtDocCurrency SettlmtDocCurrency Doc. Currency
SettlmtDocCurrencyISOCode
ExchangeRateType ExchangeRateType Exch. Rate Type
ExchangeRate ExchangeRate Exchange rate
ExchangeRateIsFixed ExchangeRateIsFixed Fixed Exch.Rate
ExchangeRateDate ExchangeRateDate Translatn Date
SupplierTotalGrossAmount SupplierTotalGrossAmount Supplier Total Gross Amount
SupplierTotalNetAmount SupplierTotalNetAmount Supplier Total Net Amount
SupplierTotalTaxAmount SupplierTotalTaxAmount Supplier Total Tax Amount
CustomerTotalGrossAmount CustomerTotalGrossAmount Customer Total Gross Amount
CustomerTotalNetAmount CustomerTotalNetAmount Extracted Net Value
CustomerTotalTaxAmount CustomerTotalTaxAmount Customer Total Tax Amount
SupplierPaymentTerms SupplierPaymentTerms Supplier Payment Terms
SupplierCashDiscount1Days SupplierCashDiscount1Days Supplier First Payment in Days
SupplierCashDiscount2Days SupplierCashDiscount2Days Supplier Second Payment in Days
SupplierNetPaymentDays SupplierNetPaymentDays Supplier Cash Discount Days
SupplierCashDiscount1Percent SupplierCashDiscount1Percent Supplier Discount for 1st Payment in %
SupplierCashDiscount2Percent SupplierCashDiscount2Percent Supplier Discount for 2nd Payment in %
SupplierPaymentMethod SupplierPaymentMethod Supplier Payment Method
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
CustomerCashDiscount1Days CustomerCashDiscount1Days Customer 1st Payment in Days
CustomerCashDiscount2Days CustomerCashDiscount2Days Customer 2nd Payment in Days
CustomerNetPaymentDays CustomerNetPaymentDays Customer Cash Discount Days
CustomerCashDiscount1Percent CustomerCashDiscount1Percent Customer Discount for 1st Payment in %
CustomerCashDiscount2Percent CustomerCashDiscount2Percent Customer Discount for 2nd Payment in %
CustomerPaymentMethod CustomerPaymentMethod Cust Pmt Method
SuplrTotEligibleAmtForCshDisc SuplrTotEligibleAmtForCshDisc Suplr Cash Disc Bas
CustTotEligibleAmtForCshDisc CustTotEligibleAmtForCshDisc Cust Cash Disc Bas
SettlmtDocIsCanceled SettlmtDocIsCanceled Doc. Reversed
CanceledSettlmtDoc CanceledSettlmtDoc Reversed Document
SettlmtDocActivityReason SettlmtDocActivityReason Header Document Creation Activity Reason
PaymentReference PaymentReference Payment Reference
SettlmtApplSts SettlmtApplSts Appl. Status
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SettlmtReltdRefDocCat SettlmtReltdRefDocCat Contract Cat.
SettlmtReltdRefDoc SettlmtReltdRefDoc Contract
SettlmtPartnerCat SettlmtPartnerCat Settlmt Part Cat
SupplierSettlmtBlkgReason SupplierSettlmtBlkgReason Supplier Settlement Blocking Reason
CustomerSettlmtBlkgReason CustomerSettlmtBlkgReason Customer Settlement Blocking Reason
AlternativeInvoicingParty AlternativeInvoicingParty Alternative Supplier
TaxDepartureCountry TaxDepartureCountry Tx Dep Ctry/Reg
TaxDestinationCountry TaxDestinationCountry Tx Des Ctry/Reg
IsEUTriangularDeal IsEUTriangularDeal Is EU Triangular Deal
SupplierVATRegistration SupplierVATRegistration VAT Registration No.
CustomerVATRegistration CustomerVATRegistration VAT Registration No.
virtualTotalGrossAmountwbrtw
SettlmtDocAuthznCat SettlmtDocAuthznCat Authorization Cat.
_InvoicingParty _InvoicingParty
_PayeeParty _PayeeParty
_BillToParty _BillToParty
_PayerParty _PayerParty
_AlternativeInvoicingParty _AlternativeInvoicingParty
_InvoicingPartyCompany _InvoicingPartyCompany
_PayeePartyCompany _PayeePartyCompany
_AltvInvoicingPartyCompany _AltvInvoicingPartyCompany
_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 A_SettlmtDoc.
-- 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 A_SettlmtDoc AS
SELECT
  SettlmtDoc,
  SettlmtDocType,
  SettlmtProcessType,
  PostingDate,
  SettlmtMgmtAcctgTransfSts AS SettlmtDocAcctgTransfSts,
  InvoicingParty,
  PayeeParty,
  BillToParty,
  PayerParty,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SuplrSettlmtCompanyCode,
  CustSettlmtCompanyCode,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtDocCurrency,
  cast(_SettlmtDocCurrency.CurrencyISOCode as waers_iso preserving type ) AS SettlmtDocCurrencyISOCode,
  ExchangeRateType,
  ExchangeRate,
  ExchangeRateIsFixed,
  ExchangeRateDate,
  SupplierTotalGrossAmount,
  SupplierTotalNetAmount,
  SupplierTotalTaxAmount,
  CustomerTotalGrossAmount,
  CustomerTotalNetAmount,
  CustomerTotalTaxAmount,
  SupplierPaymentTerms,
  SupplierCashDiscount1Days,
  SupplierCashDiscount2Days,
  SupplierNetPaymentDays,
  SupplierCashDiscount1Percent,
  SupplierCashDiscount2Percent,
  SupplierPaymentMethod,
  CustomerPaymentTerms,
  CustomerCashDiscount1Days,
  CustomerCashDiscount2Days,
  CustomerNetPaymentDays,
  CustomerCashDiscount1Percent,
  CustomerCashDiscount2Percent,
  CustomerPaymentMethod,
  SuplrTotEligibleAmtForCshDisc,
  CustTotEligibleAmtForCshDisc,
  SettlmtDocIsCanceled,
  CanceledSettlmtDoc,
  SettlmtDocActivityReason,
  PaymentReference,
  SettlmtApplSts,
  SalesOffice,
  SalesGroup,
  SettlmtReltdRefDocCat,
  SettlmtReltdRefDoc,
  SettlmtPartnerCat,
  SupplierSettlmtBlkgReason,
  CustomerSettlmtBlkgReason,
  AlternativeInvoicingParty,
  TaxDepartureCountry,
  TaxDestinationCountry,
  IsEUTriangularDeal,
  SupplierVATRegistration,
  CustomerVATRegistration,
  virtual TotalGrossAmount : wbrtw AS virtualTotalGrossAmountwbrtw,
  SettlmtDocAuthznCat
FROM R_SettlmtDocTP
;

Learn More