Fields (16)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| acct_cur | acct_cur | 1 | |
| acct_no | acct_no | 1 | |
| ACMTrdgContrReturnSettledQty | TrdgContrItemReturnQuantity | 1 | |
| BAMId | BAMId | 1 | |
| bankkey | bankkey | 1 | |
| bic | bic | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ControllingAreaCurrency | ControllingAreaCurrency | 1 | |
| country | country | 1 | |
| holder | holder | 1 | |
| iban | iban | 1 | |
| NonAppliedPrvsnlSettledQty | NonAppliedPrvsnlSettledQty | 1 | |
| ProvisionalSettledQuantity | ProvisionalSettledQuantity | 1 | |
| RevenueRecognizedQuantity | RevenueRecognizedQuantity | 1 | |
| TotalAmountInCtrlgAreaCrcy | TotalAmountInCtrlgAreaCrcy | 1 | |
| TrdgContrItemOverFillRetQty | TrdgContrItemOverFillRetQty | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _SETTLEMENT (
ACCT_CUR,
ACCT_NO,
ACMTRDGCONTRRETURNSETTLEDQTY,
BAMID,
BANKKEY,
BIC,
COMPANYCODE,
CONTROLLINGAREACURRENCY,
COUNTRY,
HOLDER,
IBAN,
NONAPPLIEDPRVSNLSETTLEDQTY,
PROVISIONALSETTLEDQUANTITY,
REVENUERECOGNIZEDQUANTITY,
TOTALAMOUNTINCTRLGAREACRCY,
TRDGCONTRITEMOVERFILLRETQTY
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA