C_DspAutomSettlmtDocs

DDL: C_DSPAUTOMSETTLMTDOCS Type: view_entity CONSUMPTION Package: WCB_PC
136 Fields 1 Data Sources

Display Automatic Settlement Documents (Obsolete)

C_DspAutomSettlmtDocs is a Consumption CDS View that provides data about "Display Automatic Settlement Documents (Obsolete)" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDocTP) and exposes 136 fields with key field SettlmtDoc. Part of development package WCB_PC.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDocTP R_SettlmtDocTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Display Automatic Settlement Documents (Obsolete) 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
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view

Fields (136)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc SettlmtDoc Settlement Doc.
SettlmtDocType SettlmtDocType Settlement Document Type
SettlmtDocTypeDesclocalized
SettlmtDocCat SettlmtDocCat Settlement Document Category
SettlmtDocCatNamelocalized
SettlmtProcessType SettlmtProcessType Settlement Process Type
SettlmtProcessTypeDesclocalized
SettlmtProcessCat SettlmtProcessCat Settlement Process Category
SettlmtProcessCatNamelocalized
PostingDate PostingDate Posting Date for GR
SettlmtMgmtAcctgTransfSts SettlmtMgmtAcctgTransfSts Posting Status
SettlmtMgmtAcctgTransfStsNamelocalized
InvoicingParty InvoicingParty Supplier
InvoicingPartyName
PayeeParty PayeeParty Payee
PayeePartyName
BillToParty BillToParty Inv. Recipient
BillToPartyName
PayerParty PayerParty Payer
PayerPartyName
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingOrganizationName
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingGroupName _PurchasingGroup PurchasingGroupName Purchasing Grp. Name
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
DivisionNameasDivisionNamelocalized
SuplrSettlmtCompanyCode SuplrSettlmtCompanyCode Suppl. Company Code
SuplrSettlmtCompanyCodeName _SuplrSettlmtCompanyCode CompanyCodeName Company Name
CustSettlmtCompanyCode CustSettlmtCompanyCode Cust. Company Code
CustSettlmtCompanyCodeName _CustSettlmtCompanyCode CompanyCodeName Company Name
CreatedByUser CreatedByUser User Name
CreatedByUserFullName
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
DocumentDate DocumentDate Journal Entry Date
DocumentReferenceID DocumentReferenceID Reference
AssignmentReference AssignmentReference Assignment Reference
SettlmtDocCurrency SettlmtDocCurrency Doc. Currency
CurrencyNameasCurrencyNamelocalized
ExchangeRateDate ExchangeRateDate Translatn Date
SupplierTotalNetAmount SupplierTotalNetAmount Supplier Total Net Amount
CustomerTotalNetAmount CustomerTotalNetAmount Extracted Net Value
SettlmtDocIsCanceled SettlmtDocIsCanceled Doc. Reversed
CanceledSettlmtDoc CanceledSettlmtDoc Reversed Document
SettlmtApplSts SettlmtApplSts Appl. Status
SettlmtApplStsDesclocalized
ExchangeRateType ExchangeRateType Exch. Rate Type
ExchangeRateTypeNamelocalized
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SettlmtReltdCndnContr SettlmtReltdCndnContr Related Condition Contract
SettlmtDocSmmrznCat SettlmtDocSmmrznCat Summarization
CreditControlAreaCurrency CreditControlAreaCurrency Credit Control Area Currency
ReleasedCreditAmount ReleasedCreditAmount Credit Value
SettlmtPartnerCat SettlmtPartnerCat Settlmt Part Cat
SupplierSettlmtStatus SupplierSettlmtStatus Settl. Status Supp.
SupplierSettlmtStatusNamelocalized
CustomerSettlmtStatus CustomerSettlmtStatus Settl. Status Cust.
CustomerSettlmtStatusNamelocalized
SupplierSettlmtDocCat SupplierSettlmtDocCat Doc. Type - Suppl.
CustomerSettlmtDocCat CustomerSettlmtDocCat Settlmt Doc Type
SupplierSettlmtBlkgReason SupplierSettlmtBlkgReason Supplier Settlement Blocking Reason
CustomerSettlmtBlkgReason CustomerSettlmtBlkgReason Customer Settlement Blocking Reason
FiscalPeriod FiscalPeriod Tax period
CndnContrType CndnContrType Contract Type
CndnContrTypeDesclocalized
CndnContrProcessCategory CndnContrProcessCategory Process Category
CndnContrProcessCategoryDesclocalized
SettlmtDate SettlmtDate Settlement Date
SettlmtDateCat SettlmtDateCat Settlement Date Type
SettlmtDateCatNamelocalized
ActualSettlmtDate ActualSettlmtDate Actual Settl. Date
SettlmtDateSequentialID SettlmtDateSequentialID Settlement Date ID
AlternativeInvoicingParty AlternativeInvoicingParty Alternative Supplier
SettlmtBusProcCat SettlmtBusProcCat Use Case Type
SettlmtBusProcCatNamelocalized
PostingPartnerCat PostingPartnerCat Posting Partner
SettlmtPeriodStartDate SettlmtPeriodStartDate Start Date of Period
SettlmtPeriodEndDate SettlmtPeriodEndDate End Date of Period
SettlmtApplStsGrp SettlmtApplStsGrp Status Group
SettlmtDocAuthznCat SettlmtDocAuthznCat Authorization Cat.
virtualTotalGrossAmountwbrtw
CompanyCodeasCompanyCode
TbDSettlmtDocChangeState
_AlternativeInvoicingParty _AlternativeInvoicingParty
_AltvInvoicingPartyCompany _AltvInvoicingPartyCompany
_BankData _BankData
_BillToParty _BillToParty
_BillToPartyCompany _BillToPartyCompany
_CanceledSettlmtDoc _CanceledSettlmtDoc
_CndnContrProcessCategory _CndnContrProcessCategory
_CndnContrType _CndnContrType
_CreatedByUser _CreatedByUser
_CreditControlAreaCurrency _CreditControlAreaCurrency
_CustomerPricingElement _CustomerPricingElement
_CustomerSettlmtBlkgReason _CustomerSettlmtBlkgReason
_CustomerSettlmtDocCat _CustomerSettlmtDocCat
_CustomerSettlmtStatus _CustomerSettlmtStatus
_DistributionChannel _DistributionChannel
_Division _Division
_ExchangeRateType _ExchangeRateType
_InvoicingParty _InvoicingParty
_InvoicingPartyCompany _InvoicingPartyCompany
_Partner _Partner
_PayeeParty _PayeeParty
_PayeePartyCompany _PayeePartyCompany
_PayerParty _PayerParty
_PayerPartyCompany _PayerPartyCompany
_PostingPartnerCat _PostingPartnerCat
_PurchasingGroup _PurchasingGroup
_PurchasingOrganization _PurchasingOrganization
_SalesArea _SalesArea
_SalesGroup _SalesGroup
_SalesOffice _SalesOffice
_SalesOrganization _SalesOrganization
_SettlmtApplSts _SettlmtApplSts
_SettlmtApplStsGrp _SettlmtApplStsGrp
_SettlmtApplStsGrpStsAssgmt _SettlmtApplStsGrpStsAssgmt
_SettlmtBusProcCat _SettlmtBusProcCat
_SettlmtDateCat _SettlmtDateCat
_SettlmtDocCat _SettlmtDocCat
_SettlmtDocCurrency _SettlmtDocCurrency
_SettlmtDocItem _SettlmtDocItem
_SettlmtDocSmmrznCat _SettlmtDocSmmrznCat
_SettlmtDocType _SettlmtDocType
_SettlmtMgmtAcctgTransfSts _SettlmtMgmtAcctgTransfSts
_SettlmtPartnerCat _SettlmtPartnerCat
_SettlmtProcessCat _SettlmtProcessCat
_SettlmtProcessType _SettlmtProcessType
_SettlmtReltdCndnContr _SettlmtReltdCndnContr
_SupplierPricingElement _SupplierPricingElement
_SupplierSettlmtBlkgReason _SupplierSettlmtBlkgReason
_SupplierSettlmtDocCat _SupplierSettlmtDocCat
_SupplierSettlmtStatus _SupplierSettlmtStatus

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_DspAutomSettlmtDocs.
-- 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_DspAutomSettlmtDocs AS
SELECT
  SettlmtDoc,
  SettlmtDocType,
  _SettlmtDocType._Text.SettlmtDocTypeDesc : localized AS SettlmtDocTypeDesclocalized,
  SettlmtDocCat,
  _SettlmtDocCat._Text.SettlmtDocCatName : localized AS SettlmtDocCatNamelocalized,
  SettlmtProcessType,
  _SettlmtProcessType._Text.SettlmtProcessTypeDesc : localized AS SettlmtProcessTypeDesclocalized,
  SettlmtProcessCat,
  _SettlmtProcessCat._Text.SettlmtProcessCatName : localized AS SettlmtProcessCatNamelocalized,
  PostingDate,
  SettlmtMgmtAcctgTransfSts,
  _SettlmtMgmtAcctgTransfSts._Text.SettlmtMgmtAcctgTransfStsName : localized AS SettlmtMgmtAcctgTransfStsNamelocalized,
  InvoicingParty,
  cast(_InvoicingParty.SupplierName as wlf_lifre_name preserving type ) AS InvoicingPartyName,
  PayeeParty,
  cast(_PayeeParty.SupplierName as wlf_lnrzb_name preserving type ) AS PayeePartyName,
  BillToParty,
  cast(_BillToParty.CustomerName as wlf_kunre_name preserving type ) AS BillToPartyName,
  PayerParty,
  cast(_PayerParty.CustomerName as wlf_kunrg_name preserving type ) AS PayerPartyName,
  PurchasingOrganization,
  R_SettlmtDocTP._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  SalesOrganization,
  DistributionChannel,
  Division,
  _Division._Text.DivisionName as DivisionName : localized AS DivisionNameasDivisionNamelocalized,
  SuplrSettlmtCompanyCode,
  _SuplrSettlmtCompanyCode.CompanyCodeName AS SuplrSettlmtCompanyCodeName,
  CustSettlmtCompanyCode,
  _CustSettlmtCompanyCode.CompanyCodeName AS CustSettlmtCompanyCodeName,
  CreatedByUser,
  cast( _CreatedByUser.UserDescription as wlf_created_by_fullname preserving type ) AS CreatedByUserFullName,
  CreationDate,
  LastChangeDate,
  DocumentDate,
  DocumentReferenceID,
  AssignmentReference,
  SettlmtDocCurrency,
  _SettlmtDocCurrency._Text.CurrencyName as CurrencyName : localized AS CurrencyNameasCurrencyNamelocalized,
  ExchangeRateDate,
  SupplierTotalNetAmount,
  CustomerTotalNetAmount,
  SettlmtDocIsCanceled,
  CanceledSettlmtDoc,
  SettlmtApplSts,
  _SettlmtApplSts._Text.SettlmtApplStsDesc : localized AS SettlmtApplStsDesclocalized,
  ExchangeRateType,
  _ExchangeRateType._Text.ExchangeRateTypeName : localized AS ExchangeRateTypeNamelocalized,
  SalesOffice,
  SalesGroup,
  SettlmtReltdCndnContr,
  SettlmtDocSmmrznCat,
  CreditControlAreaCurrency,
  ReleasedCreditAmount,
  SettlmtPartnerCat,
  SupplierSettlmtStatus,
  _SupplierSettlmtStatus._Text.SupplierSettlmtStatusName : localized AS SupplierSettlmtStatusNamelocalized,
  CustomerSettlmtStatus,
  _CustomerSettlmtStatus._Text.CustomerSettlmtStatusName : localized AS CustomerSettlmtStatusNamelocalized,
  SupplierSettlmtDocCat,
  CustomerSettlmtDocCat,
  SupplierSettlmtBlkgReason,
  CustomerSettlmtBlkgReason,
  FiscalPeriod,
  CndnContrType,
  _CndnContrType._Text.CndnContrTypeDesc : localized AS CndnContrTypeDesclocalized,
  CndnContrProcessCategory,
  _CndnContrProcessCategory._Text.CndnContrProcessCategoryDesc : localized AS CndnContrProcessCategoryDesclocalized,
  SettlmtDate,
  SettlmtDateCat,
  _SettlmtDateCat._Text.SettlmtDateCatName : localized AS SettlmtDateCatNamelocalized,
  ActualSettlmtDate,
  SettlmtDateSequentialID,
  AlternativeInvoicingParty,
  SettlmtBusProcCat,
  _SettlmtBusProcCat._Text.SettlmtBusProcCatName : localized AS SettlmtBusProcCatNamelocalized,
  PostingPartnerCat,
  SettlmtPeriodStartDate,
  SettlmtPeriodEndDate,
  SettlmtApplStsGrp,
  SettlmtDocAuthznCat,
  virtual TotalGrossAmount : wbrtw AS virtualTotalGrossAmountwbrtw
FROM R_SettlmtDocTP
;

Learn More