_BILLING

_BILLING is an SAP database table in S/4HANA. It contains 18 fields.

Fields (18)

KeyField CDS FieldsUsed in Views
_AccountingDocument _AccountingDocument 1
_CompanyCode _CompanyCode 1
_FiscalYear _FiscalYear 1
AccountingDocument AccountingDocument 2
BillingDocument BillingDocument 1
BillingDocumentCategory BillingDocumentCategory 1
BillingDocumentDate BillingDocumentDate 2
BillingDocumentIsCancelled BillingDocumentIsCancelled 1
BillingDocumentType BillingDocumentType 3
billingFrequencyDesc billingFrequencyDescr 2
CancelledBillingDocument CancelledBillingDocument 1
CompanyCode CompanyCode 1
DocumentReferenceID DocumentReferenceID 2
FiscalYear FiscalYear 3
OverallBillingStatus OverallBillingStatus 1
SalesOrganization SalesOrganization 2
TotalNetAmount TotalNetAmount 1
TotalTaxAmount TotalTaxAmount 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 _BILLING (
    _ACCOUNTINGDOCUMENT,
    _COMPANYCODE,
    _FISCALYEAR,
    ACCOUNTINGDOCUMENT,
    BILLINGDOCUMENT,
    BILLINGDOCUMENTCATEGORY,
    BILLINGDOCUMENTDATE,
    BILLINGDOCUMENTISCANCELLED,
    BILLINGDOCUMENTTYPE,
    BILLINGFREQUENCYDESC,
    CANCELLEDBILLINGDOCUMENT,
    COMPANYCODE,
    DOCUMENTREFERENCEID,
    FISCALYEAR,
    OVERALLBILLINGSTATUS,
    SALESORGANIZATION,
    TOTALNETAMOUNT,
    TOTALTAXAMOUNT
);