P_CAWRITEOFFHISTORYENHANCED

CDS View
12 Fields 3 CDS Views

P_CAWRITEOFFHISTORYENHANCED is a CDS View in S/4HANA. It contains 12 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_CAWriteOffAnalysis view from CONSUMPTION Analyse der Ausbuchungen
C_CAWriteOffHistory view from CONSUMPTION Ausbuchungen
P_CAWriteOffEnterpriseSearch view from CONSUMPTION Suche

Fields (12)

KeyField CDS FieldsUsed in Views
KEY CABPItemNumber CABPItemNumber 1
KEY CADocumentNumber CADocumentNumber 1
KEY CARepetitionItemNumber CARepetitionItemNumber 1
KEY CASubItemNumber CASubItemNumber 1
KEY CAWriteOffDocumentNumber CAWriteOffDocumentNumber 1
BusinessPartner BusinessPartner 1
CADocumentOriginCode CADocumentOriginCode 1
CADocumentType CADocumentType 1
CAWriteOffDate CAWriteOffDate 1
CAWriteOffReason CAWriteOffReason 1
CompanyCode CompanyCode 1
ContractAccount ContractAccount 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 P_CAWRITEOFFHISTORYENHANCED (
    CABPITEMNUMBER,
    CADOCUMENTNUMBER,
    CAREPETITIONITEMNUMBER,
    CASUBITEMNUMBER,
    CAWRITEOFFDOCUMENTNUMBER,
    BUSINESSPARTNER,
    CADOCUMENTORIGINCODE,
    CADOCUMENTTYPE,
    CAWRITEOFFDATE,
    CAWRITEOFFREASON,
    COMPANYCODE,
    CONTRACTACCOUNT,
    PRIMARY KEY (CABPITEMNUMBER, CADOCUMENTNUMBER, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER, CAWRITEOFFDOCUMENTNUMBER)
);

Learn More