DFKKBIX_BIP_I_D2
Draft table for entity R_CABILLGPLNITEMTP
DFKKBIX_BIP_I_D2 is an SAP database table in S/4HANA. Draft table for entity R_CABILLGPLNITEMTP. It contains 73 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_CABillgPlnItemDraft | view_entity | from | EXTENSION | Abrechnungsplanpos. Entwurf Erweiterung |
| R_CABillgPlnItemDraft | view_entity | from | BASIC | Billing Plan Item Draft |
Fields (73)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | cabillgplnnumber | billplanno_kk | Billing Plan | |||
| KEY | cabillgplnitem | billplanitem_kk | Item | |||
| KEY | draftuuid | sdraft_uuid | Draft Document ID | |||
| parentdraftuuid | sdraft_uuid | Draft Document ID | ||||
| cabillgplntype | biptype_kk | Billing Plan Type | ||||
| cabillgplnitmcat | bipitemcat_kk | Billing Pln Itm Cat. | ||||
| cabillgplnitmtype | bipitemtype_kk | Billing Plan Itm Typ | ||||
| cabillgplnitmtxt | bipitemtext_kk | Name | ||||
| cabillgplnitemextref | bipitemref_kk | Ext. Reference | ||||
| cabillgplnitemamount | betrw_kk | Amount | ||||
| transactioncurrency | waers_kk | Currency | ||||
| cataxisincluded | tax_included_kk | Gross | ||||
| cabillgplnitemquantity | bip_quantity_kk | Billing Quantity | ||||
| cabillgplnitemquantityunit | bip_qty_unit_kk | Unit of Measure | ||||
| cataxdeterminationcode | ermwskz | Tax Determination | ||||
| taxcode | mwskz | Tax Code | ||||
| cabillgplnitemstartdate | bipitem_valid_from_kk | Valid From | ||||
| cabillgplnitmenddate | bipitem_valid_to_kk | Valid to | ||||
| cabillgplnitemtermstartdate | bipitem_term_from_kk | Term From | ||||
| cabillgplnitemtermenddate | bipitem_term_to_kk | Term To | ||||
| cabillgplnitemrecurring | recurring_item_kk | RecurringBillgPlnItm | ||||
| cabillgcycle | cycle_kk | Billing Cycle | ||||
| castartdateforbillingperiod | cycle_startdate_kk | Start Date | ||||
| caconditiontype | kschl_kk | Condition Type | ||||
| cabillgplnitemamountdetntype | bip_amount_det_type_gfn_kk | Type of Amount Detn | ||||
| cabillgplnitemamountdatetype | bip_amount_date_type_gfn_kk | Type of Amount Detn Date | ||||
| cabillgplnitempricedatetype | bip_price_date_type_kk | Type Pricing Date | ||||
| cacontract | vtref_kk | Contract | ||||
| caprovidercontractitemnumber | vtpos_kk | Contract Item | ||||
| casubapplication | subap_kk | Subapplication | ||||
| caprovidercontractitemuuid | vtpid_kk | Contr.Item ID | ||||
| division | spart_kk | Division | ||||
| companycode | bukrs | Company Code | ||||
| businessarea | gsber | Business Area | ||||
| segment | segmt_kk | Segment | ||||
| camaintransaction | hvorg_kk | Main Trans. | ||||
| casubtransaction | tvorg_kk | Subtransaction | ||||
| cabillgplnitemservicetype | rai_service_type_kk | Service Type | ||||
| cadependentitemtype | dittype_gfn_kk | Dependent Item Type | ||||
| material | matnr_kk | Material | ||||
| salesorganization | vkorg | Sales Org. | ||||
| distributionchannel | vtweg | Distr. Channel | ||||
| caaccountdeterminationcode | kofiz_kk | Acct Determ. ID | ||||
| cainvcgoffsettingaction | inv_offset_action_kk | Action Offsett. | ||||
| cainvcgoffsettingcategory | inv_offset_cat_kk | Offsetting Cat. | ||||
| cainvcgoffsettingprocedure | inv_offset_proc_kk | Offsett. Proc. | ||||
| cainvcgoffsettingreferencekey | inv_offset_refid_kk | Offsetting Ref. | ||||
| cabillgplnitemreqdtelast | bip_request_date_last_kk | Last Request | ||||
| cabillgplnitemreqdtenext | bip_request_date_next_kk | Next Request | ||||
| cabillgplndvtgnextrequestdate | bip_request_date_next_dev_kk | Diff. ReqDate | ||||
| cabillgplnitemrequestedtodte | bip_requested_to_kk | Requested Until | ||||
| cabillgplnitemcanceled | bipitem_cancelled_kk | Item Discarded | ||||
| cabillgplnsubitmexist | subitem_exists_kk | Subitm Exists | ||||
| cabillgplnitemmain | billplanitem_main_kk | Main Item | ||||
| cabillgplnitmexcptnreason | bip_item_excreason_kk | Adjust. Reason | ||||
| cabillgplnitemchildexist | child_exists_kk | Follow-On Itm Exists | ||||
| cabillgplnitemparent | billplanitem_parent_kk | HigherLevelItem | ||||
| cabillgplnitemstatus | bipitem_status_kk | Status | ||||
| cabillgplnitemnrofbllbleitm | bit_requestnum_kk | No. of Requests | ||||
| caisrevnacctgtransfrecordrlvt | raoirel_kk | OrderItm Exists | ||||
| conditiontype | cond_type_kk | Condition Type | ||||
| conditionisforstatistics | cond_type_statistic_kk | Stat. Condition | ||||
| canetduedate | faedn_kk | Net Due Date | ||||
| cabillgplnitmisnottobereqd | xfeld | Checkbox | ||||
| cabllbleitmcosttype | co_type_gfn_kk | Billable Item Cost Type | ||||
| cabllbleitmcostsubtype | co_subtype_gfn_kk | Billable Item Cost Subtype | ||||
| caintcocompanycoderequesting | ico_bukrs_req_kk | ReqCCode | ||||
| caintcocompanycodesupplying | ico_bukrs_sup_kk | Supplying CCode | ||||
| caintcotype | ico_type_gfn_kk | Intercompany Settlement Type | ||||
| caintcosubtype | ico_subtype_gfn_kk | Intco Settlmt Subtype | ||||
| taxcalculationprocedure | kalsm_d | Procedure | ||||
| caapplicationarea | applk_kk | ApplicationArea |
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.
-- Draft table for entity R_CABILLGPLNITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKBIX_BIP_I_D2 (
MANDT, -- Client [mandt]
CABILLGPLNNUMBER, -- Billing Plan [billplanno_kk]
CABILLGPLNITEM, -- Item [billplanitem_kk]
DRAFTUUID, -- Draft Document ID [sdraft_uuid]
PARENTDRAFTUUID, -- Draft Document ID [sdraft_uuid]
CABILLGPLNTYPE, -- Billing Plan Type [biptype_kk]
CABILLGPLNITMCAT, -- Billing Pln Itm Cat. [bipitemcat_kk]
CABILLGPLNITMTYPE, -- Billing Plan Itm Typ [bipitemtype_kk]
CABILLGPLNITMTXT, -- Name [bipitemtext_kk]
CABILLGPLNITEMEXTREF, -- Ext. Reference [bipitemref_kk]
CABILLGPLNITEMAMOUNT, -- Amount [betrw_kk]
TRANSACTIONCURRENCY, -- Currency [waers_kk]
CATAXISINCLUDED, -- Gross [tax_included_kk]
CABILLGPLNITEMQUANTITY, -- Billing Quantity [bip_quantity_kk]
CABILLGPLNITEMQUANTITYUNIT, -- Unit of Measure [bip_qty_unit_kk]
CATAXDETERMINATIONCODE, -- Tax Determination [ermwskz]
TAXCODE, -- Tax Code [mwskz]
CABILLGPLNITEMSTARTDATE, -- Valid From [bipitem_valid_from_kk]
CABILLGPLNITMENDDATE, -- Valid to [bipitem_valid_to_kk]
CABILLGPLNITEMTERMSTARTDATE, -- Term From [bipitem_term_from_kk]
CABILLGPLNITEMTERMENDDATE, -- Term To [bipitem_term_to_kk]
CABILLGPLNITEMRECURRING, -- RecurringBillgPlnItm [recurring_item_kk]
CABILLGCYCLE, -- Billing Cycle [cycle_kk]
CASTARTDATEFORBILLINGPERIOD, -- Start Date [cycle_startdate_kk]
CACONDITIONTYPE, -- Condition Type [kschl_kk]
CABILLGPLNITEMAMOUNTDETNTYPE, -- Type of Amount Detn [bip_amount_det_type_gfn_kk]
CABILLGPLNITEMAMOUNTDATETYPE, -- Type of Amount Detn Date [bip_amount_date_type_gfn_kk]
CABILLGPLNITEMPRICEDATETYPE, -- Type Pricing Date [bip_price_date_type_kk]
CACONTRACT, -- Contract [vtref_kk]
CAPROVIDERCONTRACTITEMNUMBER, -- Contract Item [vtpos_kk]
CASUBAPPLICATION, -- Subapplication [subap_kk]
CAPROVIDERCONTRACTITEMUUID, -- Contr.Item ID [vtpid_kk]
DIVISION, -- Division [spart_kk]
COMPANYCODE, -- Company Code [bukrs]
BUSINESSAREA, -- Business Area [gsber]
SEGMENT, -- Segment [segmt_kk]
CAMAINTRANSACTION, -- Main Trans. [hvorg_kk]
CASUBTRANSACTION, -- Subtransaction [tvorg_kk]
CABILLGPLNITEMSERVICETYPE, -- Service Type [rai_service_type_kk]
CADEPENDENTITEMTYPE, -- Dependent Item Type [dittype_gfn_kk]
MATERIAL, -- Material [matnr_kk]
SALESORGANIZATION, -- Sales Org. [vkorg]
DISTRIBUTIONCHANNEL, -- Distr. Channel [vtweg]
CAACCOUNTDETERMINATIONCODE, -- Acct Determ. ID [kofiz_kk]
CAINVCGOFFSETTINGACTION, -- Action Offsett. [inv_offset_action_kk]
CAINVCGOFFSETTINGCATEGORY, -- Offsetting Cat. [inv_offset_cat_kk]
CAINVCGOFFSETTINGPROCEDURE, -- Offsett. Proc. [inv_offset_proc_kk]
CAINVCGOFFSETTINGREFERENCEKEY, -- Offsetting Ref. [inv_offset_refid_kk]
CABILLGPLNITEMREQDTELAST, -- Last Request [bip_request_date_last_kk]
CABILLGPLNITEMREQDTENEXT, -- Next Request [bip_request_date_next_kk]
CABILLGPLNDVTGNEXTREQUESTDATE, -- Diff. ReqDate [bip_request_date_next_dev_kk]
CABILLGPLNITEMREQUESTEDTODTE, -- Requested Until [bip_requested_to_kk]
CABILLGPLNITEMCANCELED, -- Item Discarded [bipitem_cancelled_kk]
CABILLGPLNSUBITMEXIST, -- Subitm Exists [subitem_exists_kk]
CABILLGPLNITEMMAIN, -- Main Item [billplanitem_main_kk]
CABILLGPLNITMEXCPTNREASON, -- Adjust. Reason [bip_item_excreason_kk]
CABILLGPLNITEMCHILDEXIST, -- Follow-On Itm Exists [child_exists_kk]
CABILLGPLNITEMPARENT, -- HigherLevelItem [billplanitem_parent_kk]
CABILLGPLNITEMSTATUS, -- Status [bipitem_status_kk]
CABILLGPLNITEMNROFBLLBLEITM, -- No. of Requests [bit_requestnum_kk]
CAISREVNACCTGTRANSFRECORDRLVT, -- OrderItm Exists [raoirel_kk]
CONDITIONTYPE, -- Condition Type [cond_type_kk]
CONDITIONISFORSTATISTICS, -- Stat. Condition [cond_type_statistic_kk]
CANETDUEDATE, -- Net Due Date [faedn_kk]
CABILLGPLNITMISNOTTOBEREQD, -- Checkbox [xfeld]
CABLLBLEITMCOSTTYPE, -- Billable Item Cost Type [co_type_gfn_kk]
CABLLBLEITMCOSTSUBTYPE, -- Billable Item Cost Subtype [co_subtype_gfn_kk]
CAINTCOCOMPANYCODEREQUESTING, -- ReqCCode [ico_bukrs_req_kk]
CAINTCOCOMPANYCODESUPPLYING, -- Supplying CCode [ico_bukrs_sup_kk]
CAINTCOTYPE, -- Intercompany Settlement Type [ico_type_gfn_kk]
CAINTCOSUBTYPE, -- Intco Settlmt Subtype [ico_subtype_gfn_kk]
TAXCALCULATIONPROCEDURE, -- Procedure [kalsm_d]
CAAPPLICATIONAREA, -- ApplicationArea [applk_kk]
PRIMARY KEY (MANDT, CABILLGPLNNUMBER, CABILLGPLNITEM, DRAFTUUID)
);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