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 80 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 (80)
| 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 | Dev. 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 | ||||
| draftentitycreationdatetime | SYCH_BDL_DRAFT_CREATED_AT | Draft Created | ||||
| draftentitylastchangedatetime | SYCH_BDL_DRAFT_LAST_CHANGED_AT | Draft Changed | ||||
| draftadministrativedatauuid | SYCH_BDL_DRAFT_ADMIN_UUID | Admin. UUID | ||||
| draftentityoperationcode | SYCH_BDL_DRAFT_OPERATION_CODE | Operation Code | ||||
| hasactiveentity | SYCH_BDL_DRAFT_HASACTIVE | Has active | ||||
| draftfieldchanges | SYCH_BDL_DRAFT_FIELD_CHANGES | Draft Changes | ||||
| dummy_billplan_i_incl_eew_ps | CFD_DUMMY | Dummy |
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, -- Dev. 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]
DRAFTENTITYCREATIONDATETIME, -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
DRAFTENTITYLASTCHANGEDATETIME, -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
DRAFTADMINISTRATIVEDATAUUID, -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
DRAFTENTITYOPERATIONCODE, -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
HASACTIVEENTITY, -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
DRAFTFIELDCHANGES, -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
DUMMY_BILLPLAN_I_INCL_EEW_PS, -- Dummy [CFD_DUMMY]
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