APCASHDISCOUNT

APCASHDISCOUNT is an SAP database table in S/4HANA. It contains 23 fields.

Fields (23)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY AccountingDocumentItem AccountingDocumentItem 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY Supplier Supplier 1
AvailableCshDiscAmtOnKeyDate AvaiCshDiscAmtOnKeyDateOrg 1
CashDiscount1Days CashDiscount1Days 1
CashDiscount1InDspCrcy_E CashDiscount1InDspCrcy_E 1
CashDiscount2Days CashDiscount2Days 1
CashDiscount2InDspCrcy_E CashDiscount2InDspCrcy_E 1
Currency Currency 1
DueCalculationBaseDate DueCalculationBaseDate 1
ExpiredCshDiscAmtOnKeyDate ExpiredCshDiscAmtOnKeyDateOrg 1
ExpiringCashDiscountAmount ExpiringCashDiscountAmountOrg 1
FixedCashDiscount FixedCashDiscount 1
GrossAmountInDisplayCrcy_E GrossAmountInDisplayCrcy_E 1
InvoiceAmtWithExpiringCshDisc InvAmtWithExpiringCshDiscOrg 1
KeyDate KeyDate 1
NetPaymentDays NetPaymentDays 1
PaymentBlockingReason PaymentBlockingReason 1
PaymentTerms PaymentTerms 1
Term1Days Term1Days 1
Term2Days Term2Days 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 APCASHDISCOUNT (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    SUPPLIER,
    AVAILABLECSHDISCAMTONKEYDATE,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1INDSPCRCY_E,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2INDSPCRCY_E,
    CURRENCY,
    DUECALCULATIONBASEDATE,
    EXPIREDCSHDISCAMTONKEYDATE,
    EXPIRINGCASHDISCOUNTAMOUNT,
    FIXEDCASHDISCOUNT,
    GROSSAMOUNTINDISPLAYCRCY_E,
    INVOICEAMTWITHEXPIRINGCSHDISC,
    KEYDATE,
    NETPAYMENTDAYS,
    PAYMENTBLOCKINGREASON,
    PAYMENTTERMS,
    TERM1DAYS,
    TERM2DAYS,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR, SUPPLIER)
);