_DOCUI

_DOCUI is an SAP database table in S/4HANA. It contains 53 fields.

Fields (53)

KeyField CDS FieldsUsed 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
);