I_CtrlgSettlmtDocumentSegment

DDL: I_CTRLGSETTLMTDOCUMENTSEGMENT Type: view_entity BASIC
40 Fields 1 Data Sources 1 Associations

Settlement Document Total Segment

I_CtrlgSettlmtDocumentSegment is a Basic CDS View that provides data about "Settlement Document Total Segment" in SAP S/4HANA. It reads from 1 data source (auas) and exposes 40 fields with key fields ControllingSettlementDocument, SettlmtDocumentSequenceNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
auas auas from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CtrlgSettlementDocument _SettlementHeader auas.belnr = _SettlementHeader.ControllingSettlementDocument

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Settlement Document Total Segment view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY ControllingSettlementDocument auas belnr SD Document
KEY SettlmtDocumentSequenceNumber auas lfdnr Tax sequence
ControllingBusTransacType auas vrgng Bus.Transaction
SettlementType auas perbz Settlement Type
PrimAssignmentSequenceNumber auas plfnr PrmAssgnmntNo
SecdryAssignmentSequenceNumber auas slfnr SecAssgnmnt No.
CostElement auas kstar Settlement CE
TransactionCurrency auas twaer Trans. Currency
ControllingArea _SettlementHeader ControllingArea Controlling Area
Ledger _SettlementHeader Ledger Ledger
ControllingAreaCurrency
TotalAmountInTransactionCrcy auas wtgbtr WTGBTR
TotalAmountInCtrlgAreaCrcy auas wkgbtr WKGBTR
FixedAmountInCtrlgAreaCrcy auas wkfbtr WKFBTR
TotalAmountInObjectCurrency auas wogbtr WOGBTR
TotalPriceVarcInCtrlgAreaCrcy auas pagbtr Price Variance
FixedPriceVarcInCtrlgAreaCrcy auas pafbtr Price Var. Fxd
UnitOfMeasure auas meinh Unit of Measure
TotalQuantity auas megbtr Total Quantity
FixedQuantity auas mefbtr Fixed Quantity
TotAmtInFreelyDfndCtrlgCrcy1 auas wagbtr Value/1Currency
TotAmtInFreelyDfndCtrlgCrcy2 auas wvgbtr Value/4Currency
TotAmtInFreelyDfndCtrlgCrcy3 auas wbgbtr Value/3Currency
TotAmtInFreelyDfndCtrlgCrcy4 auas wcgbtr Value/4Currency
TotAmtInFreelyDfndCtrlgCrcy5 auas wdgbtr Value/3Currency
TotAmtInFreelyDfndCtrlgCrcy6 auas wegbtr Value/6Currency
TotAmtInFreelyDfndCtrlgCrcy7 auas wfgbtr Value/7Currency
TotAmtInFreelyDfndCtrlgCrcy8 auas wggbtr Value/8Currency
TotalAmountInLocalCurrency auas whgbtr Value/LC
TotalAmountInAltvObjCurrency auas wsgbtr Value/alt. Obj. Crcy
ControllingPostingStructureKey auas datei Structure
ControllingPostingStructure auas key01 Key field
AssetTransactionType auas bwasl Trans. Type
PrftbltyAcctgTransfStrucAssgmt auas erzuo PATransStrAssig
ControllingObjectDebitType auas beltp Debit Type
ControllingKeySubNumber auas hrkft Origin group order
SenderClearingRecoveryCode auas sc_recid SndrClrRcvryInd
ReceiverDebitRecoveryCode auas rd_recid Rec.Recvry.Ind
QuantitiesAreIncomplete auas muvflg Qty Is Incomplete
_SettlementHeader _SettlementHeader

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 I_CtrlgSettlmtDocumentSegment.
-- 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 I_CtrlgSettlmtDocumentSegment AS
SELECT
  auas.belnr AS ControllingSettlementDocument,
  auas.lfdnr AS SettlmtDocumentSequenceNumber,
  auas.vrgng AS ControllingBusTransacType,
  auas.perbz AS SettlementType,
  auas.plfnr AS PrimAssignmentSequenceNumber,
  auas.slfnr AS SecdryAssignmentSequenceNumber,
  auas.kstar AS CostElement,
  auas.twaer AS TransactionCurrency,
  _SettlementHeader.ControllingArea AS ControllingArea,
  _SettlementHeader.Ledger AS Ledger,
  _SettlementHeader._ControllingArea.ControllingAreaCurrency AS ControllingAreaCurrency,
  auas.wtgbtr AS TotalAmountInTransactionCrcy,
  auas.wkgbtr AS TotalAmountInCtrlgAreaCrcy,
  auas.wkfbtr AS FixedAmountInCtrlgAreaCrcy,
  auas.wogbtr AS TotalAmountInObjectCurrency,
  auas.pagbtr AS TotalPriceVarcInCtrlgAreaCrcy,
  auas.pafbtr AS FixedPriceVarcInCtrlgAreaCrcy,
  auas.meinh AS UnitOfMeasure,
  auas.megbtr AS TotalQuantity,
  auas.mefbtr AS FixedQuantity,
  auas.wagbtr AS TotAmtInFreelyDfndCtrlgCrcy1,
  auas.wvgbtr AS TotAmtInFreelyDfndCtrlgCrcy2,
  auas.wbgbtr AS TotAmtInFreelyDfndCtrlgCrcy3,
  auas.wcgbtr AS TotAmtInFreelyDfndCtrlgCrcy4,
  auas.wdgbtr AS TotAmtInFreelyDfndCtrlgCrcy5,
  auas.wegbtr AS TotAmtInFreelyDfndCtrlgCrcy6,
  auas.wfgbtr AS TotAmtInFreelyDfndCtrlgCrcy7,
  auas.wggbtr AS TotAmtInFreelyDfndCtrlgCrcy8,
  auas.whgbtr AS TotalAmountInLocalCurrency,
  auas.wsgbtr AS TotalAmountInAltvObjCurrency,
  auas.datei AS ControllingPostingStructureKey,
  auas.key01 AS ControllingPostingStructure,
  auas.bwasl AS AssetTransactionType,
  auas.erzuo AS PrftbltyAcctgTransfStrucAssgmt,
  auas.beltp AS ControllingObjectDebitType,
  auas.hrkft AS ControllingKeySubNumber,
  auas.sc_recid AS SenderClearingRecoveryCode,
  auas.rd_recid AS ReceiverDebitRecoveryCode,
  auas.muvflg AS QuantitiesAreIncomplete
FROM auas
LEFT OUTER JOIN I_CtrlgSettlementDocument AS _SettlementHeader ON auas.belnr = _SettlementHeader.ControllingSettlementDocument  -- association [0..1]
;

Learn More