I_BILLINGDOCUMENT

CDS View
148 Fields 89 CDS Views

Billing Document

I_BILLINGDOCUMENT is a CDS View in S/4HANA. Billing Document. It contains 148 fields. 89 CDS views read from this table.

CDS Views using this table (89)

ViewTypeJoinVDMDescription
A_BillingDocument view from COMPOSITE Billing Document Header
A_BillingDocumentItemText view inner COMPOSITE Item Text
A_BillingDocumentText view inner COMPOSITE Header Text
A_SubsqntBillgDocForSelfBillg view from COMPOSITE Subsequent Billing Document
C_BillgDocRedacted view from CONSUMPTION
C_BillgDocToBePostedSituation view_entity from CONSUMPTION Billing Doc To Be Posted for Situation
C_BillgDocumentSituationAnchor view_entity from CONSUMPTION Billing Document Situation Anchor
C_BillingDocument_F0797 view from CONSUMPTION Billing Document
C_BillingDocument_F2187 view from CONSUMPTION Customer 360 Billing Document
C_BillingDocumentFs view from CONSUMPTION Billing Document Fact Sheet
C_BSOrdProcFlwCrdtMemoCancln view from CONSUMPTION Crdt Memo Cancln Attrib for BSOrd Prgrs
C_BSOrdProcFlwCreditMemo view from CONSUMPTION Credit Memo Attrib for BSOrd Prgrs
C_BSOrdProcFlwCustInvc view from CONSUMPTION Customer Invoice Attrib for BSOrd Prgrs
C_BSOrdProcFlwDebitMemo view from CONSUMPTION Debit Memo Attrib for BSOrd Prgrs
C_BSOrdProcFlwInvcCancln view from CONSUMPTION Invc Cancln Attrib for BSOrd Prgrs
C_BSQPMBillingDocument view_entity from CONSUMPTION BSQPM Billing Document Attribute
C_Customer360CancelledInvoice view_entity from CONSUMPTION Customer 360 Invoice Cancelled
C_Customer360Invoice view_entity from CONSUMPTION Customer 360 Invoice
C_DelivProcFlowBillingDoc view from CONSUMPTION Delivery Process Flow - Node Billing Document
C_EG_StRpBillingItem view from CONSUMPTION Egypt ACR Specific Billing Item details of tax items
C_ESJIBillingDocumentQuery view from CONSUMPTION Billing Document
C_GB_StRpAuditFileSlsDistrC view_entity from CONSUMPTION GB HRMC Audit File for SD - Cube
C_RetsReferenceDocumentUnion view_entity union_all CONSUMPTION Returns Reference Document
C_ReturnRefDocItem_F1708 view inner CONSUMPTION Return Reference Document Item
C_ReturnsReferenceDocumentItem view inner CONSUMPTION Return Reference Document Item
C_ReturnsReferenceInvoiceVH view_entity from CONSUMPTION Customer Return Reference Invoice
C_SA_StRpBillingWthRefAcctgDoc view left_outer CONSUMPTION Billing Reference Documents for Saudi Arabia
C_SDDocumentShipToParty view union_all CONSUMPTION SD Document Complete Ship to Party
C_SlsDocFlfmtBillgDoc view from CONSUMPTION Sales Doc Fulfillment: Billing Document
ESH_N_BILLINGDOCUMENT view from
FAC_AUDIT_Z3_BILLHDRITEM view from Billing Document Header & Item
FAC_AUDIT_Z3_BILLHDRITEM view inner Billing Document Header & Item
FAC_AUDIT_Z3_PRICEELEMENT view left_outer Pricing Element
FISTRPGSTR1ITEM view left_outer
I_ARProcessFlowDocumentVH view union_all COMPOSITE Document Number
I_BillgDocForCorrespncHistory view inner BASIC Billing Document for Correspondence History
I_BillingDocEnhancedFields view from COMPOSITE Billing Document Enhanced Fields
I_BillingDocumentStdVH view from COMPOSITE Billing Document
I_CFinBillingDocument view union_all COMPOSITE CFin Billing Document: Header
I_EDCBillingDocumentRecords view_entity inner BASIC EDC Billing Document Records
I_ExciseDueDocBase view from COMPOSITE Excise Duelist Base
I_IN_StRpGSTRet view left_outer COMPOSITE Tax Item Details for GST Returns
I_LstMiSDInvoice view from COMPOSITE Last Mile Distribution SD Invoice
I_MPCustomerClearedItem view inner BASIC Master Project Accounting Customer Cleared Item
I_ProjectBillingDocDetails view inner BASIC Billing Document Details
I_PT_BillgDocCustAddrVers view inner COMPOSITE PT BillingDoc CustAddr Version
I_PT_SAFTBillgInvcSettlement view_entity inner COMPOSITE Billing Invoices Settlement Info
I_PT_SAFTBillgSlsInvcAmount view_entity from COMPOSITE Billing Document Total Amount
I_PT_SAFTBillgSlsInvcHeader view_entity from COMPOSITE Billing Document Header
I_PT_SAFTBillgWorkDocHdr view_entity from COMPOSITE Working Documents Header Collector
I_PT_SAFTBillingOneTimeAddr view_entity from COMPOSITE One Time Customer Addr for Billing Docs
I_PT_SAFTBillingTaxCheck view_entity inner COMPOSITE Tax Items Check for Billing Documents
I_PT_SAFTCustomerSalesInvoice view_entity inner COMPOSITE Customer from Billing Document
I_PT_SAFTOneTimeCustBillg view_entity inner COMPOSITE One Time Customer from Billing Document
I_PT_SAFTSalesInvoiceTax view_entity inner COMPOSITE Tax Master Data Section Collector
I_PT_SAFTShptInvcAsDeliv view_entity from COMPOSITE Shippment Invoices Outbound Delivery
I_PT_SAFTSlsInvcBillgCust view_entity inner COMPOSITE Customer from Billing Document
I_SAFTBillingCustomer view from COMPOSITE SAF-T Regular Billing Customers
I_SAFTBillingHeader view from BASIC SAF-T Billing Header
I_SAFTBillingOneTimeCustomer view from COMPOSITE SAF-T Billing OneTimeCustomers
I_SAFTBillingPaymentTerms view from BASIC SAF-T Billing Payment Terms
I_SDDocumentProcessFlowVH view inner COMPOSITE Billing Document based on Delivery Doc
I_SDDocumentProcessItemsFlowVH view inner COMPOSITE Billing Docs Items with Delivery Items
I_SlsOrdFlfmtBillingDoc view from COMPOSITE SOFM Billing Document
I_SrvcOrdBillgDelayedSituation view inner COMPOSITE Service Order not invoiced situation
I_StRpAdvncRetForSlsAndPurTxC view left_outer COMPOSITE Cube View which returns Sales and Purchases tax items
I_TaxItemProcessFlow view_entity inner COMPOSITE Tax Item Process Flow
P_AllwdOrdTypPerSlsOrg view union CONSUMPTION
P_ARProcessFlowBillingDoc view_entity from CONSUMPTION Billing Doc details for AR Process Flow
P_CanclnBillingDocProcFlow0 view from CONSUMPTION
P_CanclnBillingDocProcFlowM1 view inner CONSUMPTION
P_CanclnBillingDocProcFlowN0 view from CONSUMPTION
P_CN_GoldenTaxBillingDocument view from COMPOSITE
P_EG_StRpBillingItem view from COMPOSITE
P_HU_SDInvoice view from COMPOSITE
P_MY_BillingDocumentItem view from COMPOSITE
P_PL_SAFTBillingDocumentBasic view from COMPOSITE
P_PT_SAFTSALESINVPLANT view from COMPOSITE
P_SlsOrdFlfmt1stLvlSDProcSqnc2 view left_outer CONSUMPTION
P_StRpBillingDocumentItem view from COMPOSITE
P_StRpCalTaxReturn view left_outer COMPOSITE
P_StRpTaxReturnBox view left_outer COMPOSITE
P_TW_TaxItem view left_outer COMPOSITE
P_VE_StRpReverseSDDocument view_entity inner COMPOSITE Venezuela StRp Reverse SD Document
R_BillingDocumentItemTextTP view_entity inner TRANSACTIONAL Billing Document Item Text - TP
R_BillingDocumentTextTP view_entity inner TRANSACTIONAL Billing Document - Text TP
R_BillingDocumentTP view_entity from TRANSACTIONAL Billing Document - TP
v_sd_ci_item_party view inner
v_sd_ci_party view inner

Fields (148)

KeyField CDS FieldsUsed in Views
KEY BillingDocument BillingDocument,Invoice,OriginalReferenceDocument,SalesDocument,UI5NetworkGraphAttributeValue 38
KEY BillingDocumentDate BillingDocumentDate,DeliveryDate,DocumentDate,InvoiceDate 25
KEY CompanyCode CompanyCode 22
KEY CustomerPaymentTerms CustomerPaymentTerms,PaymentTerms 10
KEY FiscalYear FiscalYear 11
_AccountingDocument _AccountingDocument 1
_AccountingPostingStatus _AccountingPostingStatus 1
_AccountingTransferStatus _AccountingTransferStatus 2
_BillingDocumentCategory _BillingDocumentCategory 1
_BillingDocumentType _BillingDocumentType 6
_BillingIssueType _BillingIssueType 4
_CancelledBillingDocument _CancelledBillingDocument 1
_CityCode _CityCode 3
_CompanyCode _CompanyCode 4
_Country _Country 3
_County_2 _County,_County_2 3
_CreatedByUser _CreatedByUser 1
_CreditControlArea _CreditControlArea 1
_CustomerAccountAssgmtGroup _CustomerAccountAssgmtGroup 2
_CustomerGroup _CustomerGroup 2
_CustomerPaymentTerms _CustomerPaymentTerms 4
_CustomerPriceGroup _CustomerPriceGroup 2
_DistributionChannel _DistributionChannel 3
_Division _Division 3
_DunningArea _DunningArea 1
_DunningAreaText _DunningAreaText 1
_DunningBlockingReason _DunningBlockingReason 2
_DunningKey _DunningKey 2
_ExchangeRateType _ExchangeRateType 1
_FiscalYear _FiscalYear 2
_IncotermsClassification _IncotermsClassification 4
_IncotermsVersion _IncotermsVersion 3
_InvoiceClearingStatus _InvoiceClearingStatus 2
_InvoiceListStatus _InvoiceListStatus 1
_InvoiceListType _InvoiceListType 1
_Item _Item 1
_LogicalSystem _LogicalSystem 1
_OverallBillingStatus _OverallBillingStatus 7
_OverallPricingIncompletionSts _OverallPricingIncompletionSts 1
_OverallSDProcessStatus _OverallSDProcessStatus 1
_OvrlItmGeneralIncompletionSts _OvrlItmGeneralIncompletionSts 1
_PayerParty _PayerParty 4
_PriceListType _PriceListType 1
_Region _Region 3
_ReversalReason _ReversalReason 1
_SalesDistrict _SalesDistrict 1
_SalesOrganization _SalesOrganization 4
_SDDocumentCategory _SDDocumentCategory 3
_SDPricingProcedure _SDPricingProcedure 2
_ShippingCondition _ShippingCondition 1
_SoldToParty _SoldToParty 6
_StatisticsCurrency _StatisticsCurrency 1
_TaxDepartureCountry _TaxDepartureCountry 3
_TransactionCurrency _TransactionCurrency 7
_VATRegistrationCountry _VATRegistrationCountry 3
_VATRegistrationOrigin _VATRegistrationOrigin 3
AccountingDocument AccountingDocument 7
AccountingExchangeRate AccountingExchangeRate,ExchangeRate 4
AccountingExchangeRateIsSet AccountingExchangeRateIsSet 1
AccountingPostingStatus AccountingPostingStatus 2
AccountingTransferStatus AccountingTransferStatus 5
AdditionalValueDays AdditionalValueDays 1
AssignmentReference AssignmentReference 2
BillingDocCombinationCriteria BillingDocCombinationCriteria 1
BillingDocumentCategory BillingDocumentCategory 6
BillingDocumentIsCancelled BillingDocumentIsCancelled 10
BillingDocumentIsTemporary BillingDocumentIsTemporary 2
BillingDocumentType BillingDocumentType 26
BillingIssueType BillingIssueType 7
CancelledBillingDocument CancelledBillingDocument 10
CityCode CityCode 3
ContractAccount ContractAccount 1
Country Country,CustomerCountry 5
County County 3
CreatedByUser CreatedByUser 9
CreationDate CreationDate 8
CreationTime CreationTime 4
CreditControlArea CreditControlArea 1
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup 2
CustomerGroup CustomerGroup 3
CustomerPriceGroup CustomerPriceGroup 2
CustomerRebateAgreement CustomerRebateAgreement 2
CustomerTaxClassification1 CustomerTaxClassification1 4
CustomerTaxClassification2 CustomerTaxClassification2 4
CustomerTaxClassification3 CustomerTaxClassification3 4
CustomerTaxClassification4 CustomerTaxClassification4 4
CustomerTaxClassification5 CustomerTaxClassification5 4
CustomerTaxClassification6 CustomerTaxClassification6 4
CustomerTaxClassification7 CustomerTaxClassification7 4
CustomerTaxClassification8 CustomerTaxClassification8 4
CustomerTaxClassification9 CustomerTaxClassification9 4
DistributionChannel DistributionChannel 11
Division Division,OrganizationDivision 9
DocumentReferenceID DocumentReferenceID 6
DunningArea DunningArea 2
DunningBlockingReason DunningBlockingReason 2
DunningKey DunningKey 2
ExchangeRateDate ExchangeRateDate 5
ExchangeRateType ExchangeRateType 1
FiscalPeriod FiscalPeriod 2
FixedValueDate FixedValueDate 2
HierarchyTypePricing HierarchyTypePricing 1
IncotermsClassification IncotermsClassification 5
IncotermsLocation1 IncotermsLocation1 4
IncotermsLocation2 IncotermsLocation2 4
IncotermsTransferLocation IncotermsTransferLocation 2
IncotermsVersion IncotermsVersion 3
InternalFinancialDocument InternalFinancialDocument 1
InvoiceClearingStatus InvoiceClearingStatus 3
InvoiceListBillingDate InvoiceListBillingDate 1
InvoiceListStatus InvoiceListStatus 1
InvoiceListType InvoiceListType 2
IsEUTriangularDeal IsEUTriangularDeal 4
IsIntrastatReportingExcluded IsIntrastatReportingExcluded 2
IsIntrastatReportingRelevant IsIntrastatReportingRelevant 2
IsRelevantForAccrual IsRelevantForAccrual 2
LastChangeDate LastChangeDate 1
LogicalSystem LogicalSystem 2
ManualInvoiceMaintIsRelevant ManualInvoiceMaintIsRelevant 2
NmbrOfPages NmbrOfPages 1
OverallBillingStatus OverallBillingStatus 7
OverallPricingIncompletionSts OverallPricingIncompletionSts 1
OverallSDProcessStatus OverallSDProcessStatus 3
OvrlItmGeneralIncompletionSts OvrlItmGeneralIncompletionSts 1
PartnerCompany PartnerCompany 2
PayerParty PayerParty 12
PaymentMethod PaymentMethod 3
PaymentReference PaymentReference 1
PriceListType PriceListType 2
PricingDocument PricingDocument,SalesDocumentCondition 5
PurchaseOrderByCustomer PurchaseOrderByCustomer 6
Region Region 3
ReversalReason ReversalReason 3
SalesDistrict SalesDistrict 2
SalesOrganization SalesOrganization 27
SDDocumentCategory SDDocumentCategory 19
SDPricingProcedure SDPricingProcedure 3
SEPAMandate SEPAMandate 1
ShippingCondition ShippingCondition 2
SoldToParty SoldToParty 16
StatisticsCurrency StatisticsCurrency 1
TaxDepartureCountry TaxDepartureCountry 4
TotalNetAmount TotalNetAmount 19
TotalTaxAmount TaxAmount,TotalTaxAmount 10
TransactionCurrency TransactionCurrency 19
VATRegistration VATRegistration 4
VATRegistrationCountry VATRegistrationCountry 5
VATRegistrationOrigin VATRegistrationOrigin 4

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.

-- Billing Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLINGDOCUMENT (
    BILLINGDOCUMENT,
    BILLINGDOCUMENTDATE,
    COMPANYCODE,
    CUSTOMERPAYMENTTERMS,
    FISCALYEAR,
    _ACCOUNTINGDOCUMENT,
    _ACCOUNTINGPOSTINGSTATUS,
    _ACCOUNTINGTRANSFERSTATUS,
    _BILLINGDOCUMENTCATEGORY,
    _BILLINGDOCUMENTTYPE,
    _BILLINGISSUETYPE,
    _CANCELLEDBILLINGDOCUMENT,
    _CITYCODE,
    _COMPANYCODE,
    _COUNTRY,
    _COUNTY_2,
    _CREATEDBYUSER,
    _CREDITCONTROLAREA,
    _CUSTOMERACCOUNTASSGMTGROUP,
    _CUSTOMERGROUP,
    _CUSTOMERPAYMENTTERMS,
    _CUSTOMERPRICEGROUP,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _DUNNINGAREA,
    _DUNNINGAREATEXT,
    _DUNNINGBLOCKINGREASON,
    _DUNNINGKEY,
    _EXCHANGERATETYPE,
    _FISCALYEAR,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _INVOICECLEARINGSTATUS,
    _INVOICELISTSTATUS,
    _INVOICELISTTYPE,
    _ITEM,
    _LOGICALSYSTEM,
    _OVERALLBILLINGSTATUS,
    _OVERALLPRICINGINCOMPLETIONSTS,
    _OVERALLSDPROCESSSTATUS,
    _OVRLITMGENERALINCOMPLETIONSTS,
    _PAYERPARTY,
    _PRICELISTTYPE,
    _REGION,
    _REVERSALREASON,
    _SALESDISTRICT,
    _SALESORGANIZATION,
    _SDDOCUMENTCATEGORY,
    _SDPRICINGPROCEDURE,
    _SHIPPINGCONDITION,
    _SOLDTOPARTY,
    _STATISTICSCURRENCY,
    _TAXDEPARTURECOUNTRY,
    _TRANSACTIONCURRENCY,
    _VATREGISTRATIONCOUNTRY,
    _VATREGISTRATIONORIGIN,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGEXCHANGERATE,
    ACCOUNTINGEXCHANGERATEISSET,
    ACCOUNTINGPOSTINGSTATUS,
    ACCOUNTINGTRANSFERSTATUS,
    ADDITIONALVALUEDAYS,
    ASSIGNMENTREFERENCE,
    BILLINGDOCCOMBINATIONCRITERIA,
    BILLINGDOCUMENTCATEGORY,
    BILLINGDOCUMENTISCANCELLED,
    BILLINGDOCUMENTISTEMPORARY,
    BILLINGDOCUMENTTYPE,
    BILLINGISSUETYPE,
    CANCELLEDBILLINGDOCUMENT,
    CITYCODE,
    CONTRACTACCOUNT,
    COUNTRY,
    COUNTY,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CREDITCONTROLAREA,
    CUSTOMERACCOUNTASSIGNMENTGROUP,
    CUSTOMERGROUP,
    CUSTOMERPRICEGROUP,
    CUSTOMERREBATEAGREEMENT,
    CUSTOMERTAXCLASSIFICATION1,
    CUSTOMERTAXCLASSIFICATION2,
    CUSTOMERTAXCLASSIFICATION3,
    CUSTOMERTAXCLASSIFICATION4,
    CUSTOMERTAXCLASSIFICATION5,
    CUSTOMERTAXCLASSIFICATION6,
    CUSTOMERTAXCLASSIFICATION7,
    CUSTOMERTAXCLASSIFICATION8,
    CUSTOMERTAXCLASSIFICATION9,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    DOCUMENTREFERENCEID,
    DUNNINGAREA,
    DUNNINGBLOCKINGREASON,
    DUNNINGKEY,
    EXCHANGERATEDATE,
    EXCHANGERATETYPE,
    FISCALPERIOD,
    FIXEDVALUEDATE,
    HIERARCHYTYPEPRICING,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INTERNALFINANCIALDOCUMENT,
    INVOICECLEARINGSTATUS,
    INVOICELISTBILLINGDATE,
    INVOICELISTSTATUS,
    INVOICELISTTYPE,
    ISEUTRIANGULARDEAL,
    ISINTRASTATREPORTINGEXCLUDED,
    ISINTRASTATREPORTINGRELEVANT,
    ISRELEVANTFORACCRUAL,
    LASTCHANGEDATE,
    LOGICALSYSTEM,
    MANUALINVOICEMAINTISRELEVANT,
    NMBROFPAGES,
    OVERALLBILLINGSTATUS,
    OVERALLPRICINGINCOMPLETIONSTS,
    OVERALLSDPROCESSSTATUS,
    OVRLITMGENERALINCOMPLETIONSTS,
    PARTNERCOMPANY,
    PAYERPARTY,
    PAYMENTMETHOD,
    PAYMENTREFERENCE,
    PRICELISTTYPE,
    PRICINGDOCUMENT,
    PURCHASEORDERBYCUSTOMER,
    REGION,
    REVERSALREASON,
    SALESDISTRICT,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    SDPRICINGPROCEDURE,
    SEPAMANDATE,
    SHIPPINGCONDITION,
    SOLDTOPARTY,
    STATISTICSCURRENCY,
    TAXDEPARTURECOUNTRY,
    TOTALNETAMOUNT,
    TOTALTAXAMOUNT,
    TRANSACTIONCURRENCY,
    VATREGISTRATION,
    VATREGISTRATIONCOUNTRY,
    VATREGISTRATIONORIGIN,
    PRIMARY KEY (BILLINGDOCUMENT, BILLINGDOCUMENTDATE, COMPANYCODE, CUSTOMERPAYMENTTERMS, FISCALYEAR)
);

Learn More