BILLINGDOCUMENT

102 Fields

BILLINGDOCUMENT is an SAP database table in S/4HANA. It contains 102 fields.

Fields (102)

KeyField CDS FieldsUsed in Views
KEY BillingDocument BillingDocument 3
KEY PrecedingDocument PrecedingDocument 3
KEY PrecedingDocumentCategory PrecedingDocumentCategory,SDDocumentCategory 3
KEY SubsequentDocument BillingDocument,SubsequentDocument 3
KEY SubsequentDocumentCategory SubsequentDocumentCategory 3
AbsltAccountingExchangeRate AbsltAccountingExchangeRate 2
AccountingDocument AccountingDocument 2
AccountingExchangeRateIsSet AccountingExchangeRateIsSet 2
AccountingPostingStatus AccountingPostingStatus 1
AccountingTransferStatus AccountingTransferStatus 2
AcctgExchangeRateIsIndrctQtan AcctgExchangeRateIsIndrctQtan 2
AdditionalValueDays AdditionalValueDays 2
AssignmentReference AssignmentReference 2
BillingDocCombinationCriteria BillingDocCombinationCriteria 1
BillingDocumentCategory BillingDocumentCategory 1
BillingDocumentDate BillingDocumentDate,DocumentDate 4
BillingDocumentIsCancelled BillingDocumentIsCancelled 2
BillingDocumentType BillingDocumentType,SDDocumentType 4
BillingIssueType BillingIssueType 2
BillingQuantityUnit BillingQuantityUnit 1
BillToParty BillToParty 1
CancelledBillingDocument CancelledBillingDocument 2
CityCode CityCode 2
CompanyCode CompanyCode 2
ContractAccount ContractAccount 1
Country Country 2
County County 2
CreatedByUser CreatedByUser 2
CreationDate CreationDate 1
CreationDateTime CreationDateTime 1
CreationTime CreationTime 1
CreditControlArea CreditControlArea 1
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup 2
CustomerGroup CustomerGroup 2
CustomerPaymentTerms CustomerPaymentTerms 2
CustomerPriceGroup CustomerPriceGroup 2
CustomerTaxClassification1 CustomerTaxClassification1 2
CustomerTaxClassification2 CustomerTaxClassification2 2
CustomerTaxClassification3 CustomerTaxClassification3 2
CustomerTaxClassification4 CustomerTaxClassification4 2
CustomerTaxClassification5 CustomerTaxClassification5 2
CustomerTaxClassification6 CustomerTaxClassification6 2
CustomerTaxClassification7 CustomerTaxClassification7 2
CustomerTaxClassification8 CustomerTaxClassification8 2
CustomerTaxClassification9 CustomerTaxClassification9 2
DeviatingPostingDate DeviatingPostingDate 1
DistributionChannel DistributionChannel 4
Division Division 4
DocumentReferenceID DocumentReferenceID 1
DunningArea DunningArea 1
DunningBlockingReason DunningBlockingReason 1
DunningKey DunningKey 1
ExchangeRateDate ExchangeRateDate 1
ExchangeRateType ExchangeRateType 1
FiscalYear FiscalYear 1
FixedValueDate FixedValueDate 2
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 2
IncotermsTransferLocation IncotermsTransferLocation 1
IncotermsVersion IncotermsVersion 2
InvoiceListBillingDate InvoiceListBillingDate 1
InvoiceListStatus InvoiceListStatus 1
InvoiceListType InvoiceListType 1
IsEUTriangularDeal IsEUTriangularDeal 2
IsIntrastatReportingExcluded IsIntrastatReportingExcluded 2
IsIntrastatReportingRelevant IsIntrastatReportingRelevant 2
IsRelevantForAccrual IsRelevantForAccrual 2
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 2
LogicalSystem LogicalSystem 1
OverallBillingStatus OverallBillingStatus 2
OverallPricingIncompletionSts OverallPricingIncompletionSts 1
OverallSDProcessStatus OverallSDProcessStatus 1
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts 1
PartnerCompany PartnerCompany 1
PayerParty PayerParty 2
PaymentMethod PaymentMethod 2
PaymentReference PaymentReference 1
PrcgDocumentHostObjectNodeID PrcgDocumentHostObjectNodeID 2
PriceListType PriceListType 2
PricingDocument PricingDocument 2
PurchaseOrderByCustomer PurchaseOrderByCustomer 2
Region Region 2
ReversalReason ReversalReason 2
SalesDistrict SalesDistrict 2
SalesOrganization SalesOrganization 4
SAPObjectTypeInUppercase SAPObjectTypeInUppercase 2
SDDocumentCategory SDDocumentCategory 4
SDPricingProcedure SDPricingProcedure 2
SEPAMandate SEPAMandate 1
ShippingCondition ShippingCondition 2
SoldToParty SoldToParty 4
StatisticsCurrency StatisticsCurrency 1
TaxDepartureCountry TaxDepartureCountry 2
TotalGrossAmount TotalGrossAmount 2
TotalNetAmount TotalNetAmount 2
TotalTaxAmount TotalTaxAmount 1
TransactionCurrency TransactionCurrency 2
VATRegistration VATRegistration 2
VATRegistrationCountry VATRegistrationCountry 2
VATRegistrationOrigin VATRegistrationOrigin 2

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 BILLINGDOCUMENT (
    BILLINGDOCUMENT,
    PRECEDINGDOCUMENT,
    PRECEDINGDOCUMENTCATEGORY,
    SUBSEQUENTDOCUMENT,
    SUBSEQUENTDOCUMENTCATEGORY,
    ABSLTACCOUNTINGEXCHANGERATE,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGEXCHANGERATEISSET,
    ACCOUNTINGPOSTINGSTATUS,
    ACCOUNTINGTRANSFERSTATUS,
    ACCTGEXCHANGERATEISINDRCTQTAN,
    ADDITIONALVALUEDAYS,
    ASSIGNMENTREFERENCE,
    BILLINGDOCCOMBINATIONCRITERIA,
    BILLINGDOCUMENTCATEGORY,
    BILLINGDOCUMENTDATE,
    BILLINGDOCUMENTISCANCELLED,
    BILLINGDOCUMENTTYPE,
    BILLINGISSUETYPE,
    BILLINGQUANTITYUNIT,
    BILLTOPARTY,
    CANCELLEDBILLINGDOCUMENT,
    CITYCODE,
    COMPANYCODE,
    CONTRACTACCOUNT,
    COUNTRY,
    COUNTY,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONDATETIME,
    CREATIONTIME,
    CREDITCONTROLAREA,
    CUSTOMERACCOUNTASSIGNMENTGROUP,
    CUSTOMERGROUP,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPRICEGROUP,
    CUSTOMERTAXCLASSIFICATION1,
    CUSTOMERTAXCLASSIFICATION2,
    CUSTOMERTAXCLASSIFICATION3,
    CUSTOMERTAXCLASSIFICATION4,
    CUSTOMERTAXCLASSIFICATION5,
    CUSTOMERTAXCLASSIFICATION6,
    CUSTOMERTAXCLASSIFICATION7,
    CUSTOMERTAXCLASSIFICATION8,
    CUSTOMERTAXCLASSIFICATION9,
    DEVIATINGPOSTINGDATE,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTREFERENCEID,
    DUNNINGAREA,
    DUNNINGBLOCKINGREASON,
    DUNNINGKEY,
    EXCHANGERATEDATE,
    EXCHANGERATETYPE,
    FISCALYEAR,
    FIXEDVALUEDATE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INVOICELISTBILLINGDATE,
    INVOICELISTSTATUS,
    INVOICELISTTYPE,
    ISEUTRIANGULARDEAL,
    ISINTRASTATREPORTINGEXCLUDED,
    ISINTRASTATREPORTINGRELEVANT,
    ISRELEVANTFORACCRUAL,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LOGICALSYSTEM,
    OVERALLBILLINGSTATUS,
    OVERALLPRICINGINCOMPLETIONSTS,
    OVERALLSDPROCESSSTATUS,
    OVRLITMGENERALINCOMPLETIONSTS,
    PARTNERCOMPANY,
    PAYERPARTY,
    PAYMENTMETHOD,
    PAYMENTREFERENCE,
    PRCGDOCUMENTHOSTOBJECTNODEID,
    PRICELISTTYPE,
    PRICINGDOCUMENT,
    PURCHASEORDERBYCUSTOMER,
    REGION,
    REVERSALREASON,
    SALESDISTRICT,
    SALESORGANIZATION,
    SAPOBJECTTYPEINUPPERCASE,
    SDDOCUMENTCATEGORY,
    SDPRICINGPROCEDURE,
    SEPAMANDATE,
    SHIPPINGCONDITION,
    SOLDTOPARTY,
    STATISTICSCURRENCY,
    TAXDEPARTURECOUNTRY,
    TOTALGROSSAMOUNT,
    TOTALNETAMOUNT,
    TOTALTAXAMOUNT,
    TRANSACTIONCURRENCY,
    VATREGISTRATION,
    VATREGISTRATIONCOUNTRY,
    VATREGISTRATIONORIGIN,
    PRIMARY KEY (BILLINGDOCUMENT, PRECEDINGDOCUMENT, PRECEDINGDOCUMENTCATEGORY, SUBSEQUENTDOCUMENT, SUBSEQUENTDOCUMENTCATEGORY)
);

Learn More