Fields (53)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| BankAccount | BankAccount | 1 | |
| BankCountry | BankCountry | 1 | |
| BankDetailReference | BankDetailReference | 1 | |
| BankNumber | BankNumber | 1 | |
| BusinessPartner | BusinessPartner | 1 | |
| CAAmountInTransactionCurrency | CAAmountInTransactionCurrency | 1 | |
| CABankAccountHolderName | CABankAccountHolderName | 1 | |
| CABankClearingAccount | CABankClearingAccount | 1 | |
| CAChargeAmountFromBank1 | CAChargeAmountFromBank1 | 1 | |
| CAClrdAmountInTransactionCrcy | CAClrdAmountInTransactionCrcy | 1 | |
| CADueAmountInTransactionCrcy | CADueAmountInTransactionCrcy | 1 | |
| CAItemNumberInReturnLot | CAItemNumberInReturnLot | 1 | |
| CAMassRunDate | CAMassRunDate | 1 | |
| CAMassRunID | CAMassRunID | 1 | |
| CANetAmountInTransCurrency | CANetAmountInTransCurrency | 1 | |
| CANetDueDate | CANetDueDate | 1 | |
| CANoteToPayeeInPayment | CANoteToPayeeInPayment | 1 | |
| CAOpenAmountInTransactionCrcy | CAOpenAmountInTransactionCrcy | 1 | |
| CAPaymentCompanyCode | CAPaymentCompanyCode | 1 | |
| CAPaymentDocument | CAPaymentDocument | 1 | |
| CAPaymentDocumentReference | CAPaymentDocumentReference | 1 | |
| CAPaymentLot | CAPaymentLot | 1 | |
| CAPaymentLotItem | CAPaymentLotItem | 1 | |
| CAPaymentMethod | CAPaymentMethod | 1 | |
| CAPaymentOrder | CAPaymentOrder | 1 | |
| CAPaymentOrderExpirationDate | CAPaymentOrderExpirationDate | 1 | |
| CAPaymentOrderExternalRef | CAPaymentOrderExternalRef | 1 | |
| CAPaymentOrderStatus | CAPaymentOrderStatus | 1 | |
| CARepaymentRequest | CARepaymentRequest | 1 | |
| CARepaymentRequestDocument | CARepaymentRequestDocument | 1 | |
| CAReturnCharge1 | CAReturnCharge1 | 1 | |
| CAReturnLot | CAReturnLot | 1 | |
| CAReturnReasonOfHouseBank | CAReturnReasonOfHouseBank | 1 | |
| CAStatusOfRepaymentRequest | CAStatusOfRepaymentRequest | 1 | |
| CATaxAmountForReturnCharge1 | CATaxAmountForReturnCharge1 | 1 | |
| CATaxAmountOfBankCharge1 | CATaxAmountOfBankCharge1 | 1 | |
| CompanyCode | CompanyCode | 1 | |
| FirstName | FirstName | 1 | |
| HouseBank | HouseBank | 1 | |
| HouseBankAccount | HouseBankAccount | 1 | |
| LastName | LastName | 1 | |
| NumberOfCADocumentBPItems | NumberOfCADocumentBPItems | 1 | |
| NumberOfCADocumentGLItems | NumberOfCADocumentGLItems | 1 | |
| PaidItemDueDate | PaidItemDueDate | 1 | |
| PayeeBankAccount | PayeeBankAccount | 1 | |
| PayeeBankCountry | PayeeBankCountry | 1 | |
| PayeeBankNumber | PayeeBankNumber | 1 | |
| PayeeIBAN | PayeeIBAN | 1 | |
| PayeeSWIFTCode | PayeeSWIFTCode | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| TaxCodeForFirstBankCharge | TaxCodeForFirstBankCharge | 1 | |
| TaxCodeForFirstReturnCharge | TaxCodeForFirstReturnCharge | 1 | |
| ValueDate | ValueDate | 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 _DOCUI (
BANKACCOUNT,
BANKCOUNTRY,
BANKDETAILREFERENCE,
BANKNUMBER,
BUSINESSPARTNER,
CAAMOUNTINTRANSACTIONCURRENCY,
CABANKACCOUNTHOLDERNAME,
CABANKCLEARINGACCOUNT,
CACHARGEAMOUNTFROMBANK1,
CACLRDAMOUNTINTRANSACTIONCRCY,
CADUEAMOUNTINTRANSACTIONCRCY,
CAITEMNUMBERINRETURNLOT,
CAMASSRUNDATE,
CAMASSRUNID,
CANETAMOUNTINTRANSCURRENCY,
CANETDUEDATE,
CANOTETOPAYEEINPAYMENT,
CAOPENAMOUNTINTRANSACTIONCRCY,
CAPAYMENTCOMPANYCODE,
CAPAYMENTDOCUMENT,
CAPAYMENTDOCUMENTREFERENCE,
CAPAYMENTLOT,
CAPAYMENTLOTITEM,
CAPAYMENTMETHOD,
CAPAYMENTORDER,
CAPAYMENTORDEREXPIRATIONDATE,
CAPAYMENTORDEREXTERNALREF,
CAPAYMENTORDERSTATUS,
CAREPAYMENTREQUEST,
CAREPAYMENTREQUESTDOCUMENT,
CARETURNCHARGE1,
CARETURNLOT,
CARETURNREASONOFHOUSEBANK,
CASTATUSOFREPAYMENTREQUEST,
CATAXAMOUNTFORRETURNCHARGE1,
CATAXAMOUNTOFBANKCHARGE1,
COMPANYCODE,
FIRSTNAME,
HOUSEBANK,
HOUSEBANKACCOUNT,
LASTNAME,
NUMBEROFCADOCUMENTBPITEMS,
NUMBEROFCADOCUMENTGLITEMS,
PAIDITEMDUEDATE,
PAYEEBANKACCOUNT,
PAYEEBANKCOUNTRY,
PAYEEBANKNUMBER,
PAYEEIBAN,
PAYEESWIFTCODE,
PROFITCENTER,
TAXCODEFORFIRSTBANKCHARGE,
TAXCODEFORFIRSTRETURNCHARGE,
VALUEDATE
);
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