I_BILLINGDOCUMENTREQUEST
Billing Document Request
I_BILLINGDOCUMENTREQUEST is a CDS View in S/4HANA. Billing Document Request. It contains 47 fields. 13 CDS views read from this table.
CDS Views using this table (13)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_BillingDocumentRequest | view | from | COMPOSITE | Billing Document Request Header |
| C_BillgDocReqWorklist | view | from | CONSUMPTION | Billing Document Request |
| C_BillingDocRequestObjPg | view | from | CONSUMPTION | |
| C_BSOrdProcFlwBillgDocReq | view | from | CONSUMPTION | BDR Attrib for BSOrd Prgrs |
| C_BSQPMBillingDocumentRequest | view_entity | from | CONSUMPTION | BSQPM Billing Document Request |
| C_DspDocFlwBillgDocRequest | view_entity | from | CONSUMPTION | Billing Document Request Attributes |
| C_DspDocFlwBillgDocRequestVH | view_entity | from | CONSUMPTION | Billing Document Request |
| ESH_N_BILLINGDOCUMENTREQUEST | view | from | ||
| I_BillingDocumentRequestStdVH | view | from | COMPOSITE | Billing Document Request |
| P_ARProcessFlowBillgDocRequest | view_entity | from | COMPOSITE | Billing Document Request Attributes |
| R_BillgDocRequestItemTextTP | view_entity | inner | TRANSACTIONAL | Billing Document Request Item Text - TP |
| R_BillingDocumentRequestTextTP | view_entity | inner | TRANSACTIONAL | Billing Document Request Text - TP |
| R_BillingDocumentRequestTP | view_entity | from | TRANSACTIONAL | Billing Document Request - TP |
Fields (47)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillingDocumentRequest | BillingDocumentRequest,ReferenceSDDocument | 4 |
| _BillingDocumentRequestType | _BillingDocumentRequestType | 2 | |
| _BillingIssueType | _BillingIssueType | 2 | |
| _CompanyCode | _CompanyCode | 2 | |
| _Country | _Country | 1 | |
| _CustomerAccountAssgmtGroup | _CustomerAccountAssgmtGroup | 1 | |
| _CustomerPaymentTerms | _CustomerPaymentTerms | 2 | |
| _DunningBlockingReason | _DunningBlockingReason | 1 | |
| _DunningKey | _DunningKey | 1 | |
| _IncotermsClassification | _IncotermsClassification | 2 | |
| _IncotermsVersion | _IncotermsVersion | 2 | |
| _OvrlBillingDocReqStatus | _OvrlBillingDocReqStatus | 2 | |
| _ProposedBillingDocumentType | _ProposedBillingDocumentType | 2 | |
| _ReferenceDocSDDocCategory | _ReferenceDocSDDocCategory | 2 | |
| _SalesOrganization | _SalesOrganization | 2 | |
| _SDDocumentCategory | _SDDocumentCategory | 2 | |
| _SoldToParty | _SoldToParty | 1 | |
| _TransactionCurrency | _TransactionCurrency | 2 | |
| BillingDocumentDate | BillingDocumentDate | 5 | |
| BillingDocumentRequestType | BillingDocumentRequestType | 1 | |
| BillingIssueType | BillingIssueType | 2 | |
| CompanyCode | CompanyCode | 5 | |
| Country | Country | 1 | |
| CreatedByUser | CreatedByUser | 2 | |
| CreationDate | CreationDate | 1 | |
| CustomerAccountAssignmentGroup | CustomerAccountAssignmentGroup | 1 | |
| CustomerPaymentTerms | CustomerPaymentTerms | 3 | |
| CustomerTaxClassification1 | CustomerTaxClassification1 | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| Division | Division | 1 | |
| DocumentReferenceID | DocumentReferenceID | 1 | |
| DunningArea | DunningArea | 1 | |
| DunningBlockingReason | DunningBlockingReason | 1 | |
| DunningKey | DunningKey | 1 | |
| IncotermsClassification | IncotermsClassification | 2 | |
| IncotermsLocation1 | IncotermsLocation1 | 2 | |
| IncotermsLocation2 | IncotermsLocation2 | 1 | |
| IncotermsVersion | IncotermsVersion | 2 | |
| OverallBillingDocReqStatus | OverallBillingDocReqStatus | 3 | |
| PayerParty | PayerParty | 4 | |
| PricingDocument | SalesDocumentCondition | 2 | |
| SalesOrganization | SalesOrganization | 4 | |
| SoldToParty | SoldToParty | 5 | |
| TotalNetAmount | TotalNetAmount | 4 | |
| TotalTaxAmount | TotalTaxAmount | 2 | |
| TransactionCurrency | TransactionCurrency | 4 | |
| VATRegistration | VATRegistration | 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.
-- Billing Document Request
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLINGDOCUMENTREQUEST (
BILLINGDOCUMENTREQUEST,
_BILLINGDOCUMENTREQUESTTYPE,
_BILLINGISSUETYPE,
_COMPANYCODE,
_COUNTRY,
_CUSTOMERACCOUNTASSGMTGROUP,
_CUSTOMERPAYMENTTERMS,
_DUNNINGBLOCKINGREASON,
_DUNNINGKEY,
_INCOTERMSCLASSIFICATION,
_INCOTERMSVERSION,
_OVRLBILLINGDOCREQSTATUS,
_PROPOSEDBILLINGDOCUMENTTYPE,
_REFERENCEDOCSDDOCCATEGORY,
_SALESORGANIZATION,
_SDDOCUMENTCATEGORY,
_SOLDTOPARTY,
_TRANSACTIONCURRENCY,
BILLINGDOCUMENTDATE,
BILLINGDOCUMENTREQUESTTYPE,
BILLINGISSUETYPE,
COMPANYCODE,
COUNTRY,
CREATEDBYUSER,
CREATIONDATE,
CUSTOMERACCOUNTASSIGNMENTGROUP,
CUSTOMERPAYMENTTERMS,
CUSTOMERTAXCLASSIFICATION1,
DISTRIBUTIONCHANNEL,
DIVISION,
DOCUMENTREFERENCEID,
DUNNINGAREA,
DUNNINGBLOCKINGREASON,
DUNNINGKEY,
INCOTERMSCLASSIFICATION,
INCOTERMSLOCATION1,
INCOTERMSLOCATION2,
INCOTERMSVERSION,
OVERALLBILLINGDOCREQSTATUS,
PAYERPARTY,
PRICINGDOCUMENT,
SALESORGANIZATION,
SOLDTOPARTY,
TOTALNETAMOUNT,
TOTALTAXAMOUNT,
TRANSACTIONCURRENCY,
VATREGISTRATION,
PRIMARY KEY (BILLINGDOCUMENTREQUEST)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA