I_CABILLGDOCITEM

CDS View
71 Fields 5 CDS Views

Abrechnungsbelegposition

I_CABILLGDOCITEM is a CDS View in S/4HANA. Abrechnungsbelegposition. It contains 71 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_CABillPrntBillgDocItem view_entity from COMPOSITE Abrechnungsbelegpositionen
I_CABillPrntInvcgItemBillgReq view_entity inner COMPOSITE Fakturierungsbelegobjektverknüpfungen
P_BSQPMPrvdrContrToBillgDoc view_entity from COMPOSITE
P_CABillgDocItem view_entity from COMPOSITE
R_CABillgDocItemTP view_entity from TRANSACTIONAL Billing Document Item - TP

Fields (71)

KeyField CDS FieldsUsed in Views
KEY CABillgDocItem CABillgDocItem,SubsequentDocumentItem 2
KEY CABillgDocument CABillgDocument,SubsequentDocument 2
BusinessArea BusinessArea 1
BusinessPlace BusinessPlace 1
CAAccountDeterminationCode CAAccountDeterminationCode 1
CAAltvMDOriginalIsEnbld CAAltvMDOriginalIsEnbld 1
CAAltvTaxCode CAAltvTaxCode 1
CAAltvTaxDeterminationCode CAAltvTaxDeterminationCode 1
CABillgCurrency CABillgCurrency 1
CABillgDeferredRevenueCategory CABillgDeferredRevenueCategory 1
CABillgDeferredRevenueDate CABillgDeferredRevenueDate 1
CABillgDocItemAmount CABillgDocItemAmount 1
CABillgDocItemCrtnMethod CABillgDocItemCrtnMethod 1
CABillgDocItemExternalNumber CABillgDocItemExternalNumber 1
CABillgDocItemIsBIRelevant CABillgDocItemIsBIRelevant 1
CABillgDocItemIsFICORelevant CABillgDocItemIsFICORelevant 1
CABillgDocItemIsReversal CAInvcgDocItemIsReversal 1
CABillgDocumentItemType CABillgDocumentItemType 1
CABillgFunction CABillgFunction 1
CABillgGroupingSourceItems CABillgGroupingSourceItems 1
CABillgGrpgOfAdditionalItems CABillgGrpgOfAdditionalItems 1
CABillgGrpgOfPaymentData CABillgGrpgOfPaymentData 1
CABillgIsPrepaidBalanceChg CABillgIsPrepaidBalanceChg 1
CABillgPartnerSettlementCat CABillgPartnerSettlementCat 1
CABillgQuantityAfterDecPoint CABillgQuantityAfterDecPoint 1
CABillgQuantityBeforeDecPoint CABillgQuantityBeforeDecPoint 1
CABillgReqReason CABillgReqReason 1
CABillgTaxGroup CABillgTaxGroup 1
CABillingQuantity CABillingQuantity 1
CABllbleItmDiscountKey CABllbleItmDiscountKey 1
CABllbleItmDiscountVersion CABllbleItmDiscountVersion 1
CAContract CAContract,PrecedingDocument 2
CADependentItemType CADependentItemType 1
CADiscBaseItmGroup CADiscBaseItmGroup 1
CAExternalTaxDate CAExternalTaxDate 1
CAInvcgAccrualPostingType CAInvcgAccrualPostingType 1
CAInvcgCorrectionCategory CAInvcgCorrectionCategory 1
CAInvcgDfrrdRevenueStatus CAInvcgDfrrdRevenueStatus 1
CAInvcgIsItemPostingRelevant CAInvcgIsItemPostingRelevant 1
CAInvcgIsItemPrintingRelevant CAInvcgIsItemPrintingRelevant 1
CAInvcgIsNotBPRelevant CAInvcgIsNotBPRelevant 1
CAInvcgSubstituteGroupPrinting CAInvcgSubstituteGroupPrinting 1
CAIsDocItemSimulated CAIsDocItemSimulated 1
CAIsDownPaymentRequest CAIsDownPaymentRequest 1
CAIsPrepaid CAIsPrepaid 1
CAIsRevenueAccountingRelevant CAIsRevenueAccountingRelevant 1
CAItemPeriodEndDate CAItemPeriodEndDate 1
CAItemPeriodStartDate CAItemPeriodStartDate 1
CAMainTransaction CAMainTransaction 1
CANetDueDate CANetDueDate 1
CAOtherTaxCode CAOtherTaxCode 1
CAProviderContractItemNumber CAProviderContractItemNumber,PrecedingDocumentItem 2
CAReasonSecurityDeposit CAReasonSecurityDeposit 1
CARevenueAccountingServiceType CARevenueAccountingServiceType 1
CAStatisticalItemCode CAStatisticalItemCode 1
CASubApplication CASubApplication 1
CASubTransaction CASubTransaction 1
CATaxCountry CATaxCountry 1
CATaxDateType CATaxDateType 1
CATaxDeterminationCode CATaxDeterminationCode 1
CATaxDetnType CATaxDetnType 1
CATaxIsIncluded CATaxIsIncluded 1
CompanyCode CompanyCode 1
ConditionType ConditionType 1
Division Division 1
ProfitCenter ProfitCenter 1
Segment Segment 1
TaxCode TaxCode 1
TaxJurisdiction TaxJurisdiction 1
UnitOfMeasure UnitOfMeasure 1
WithholdingTaxCode WithholdingTaxCode 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.

-- Abrechnungsbelegposition
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CABILLGDOCITEM (
    CABILLGDOCITEM,
    CABILLGDOCUMENT,
    BUSINESSAREA,
    BUSINESSPLACE,
    CAACCOUNTDETERMINATIONCODE,
    CAALTVMDORIGINALISENBLD,
    CAALTVTAXCODE,
    CAALTVTAXDETERMINATIONCODE,
    CABILLGCURRENCY,
    CABILLGDEFERREDREVENUECATEGORY,
    CABILLGDEFERREDREVENUEDATE,
    CABILLGDOCITEMAMOUNT,
    CABILLGDOCITEMCRTNMETHOD,
    CABILLGDOCITEMEXTERNALNUMBER,
    CABILLGDOCITEMISBIRELEVANT,
    CABILLGDOCITEMISFICORELEVANT,
    CABILLGDOCITEMISREVERSAL,
    CABILLGDOCUMENTITEMTYPE,
    CABILLGFUNCTION,
    CABILLGGROUPINGSOURCEITEMS,
    CABILLGGRPGOFADDITIONALITEMS,
    CABILLGGRPGOFPAYMENTDATA,
    CABILLGISPREPAIDBALANCECHG,
    CABILLGPARTNERSETTLEMENTCAT,
    CABILLGQUANTITYAFTERDECPOINT,
    CABILLGQUANTITYBEFOREDECPOINT,
    CABILLGREQREASON,
    CABILLGTAXGROUP,
    CABILLINGQUANTITY,
    CABLLBLEITMDISCOUNTKEY,
    CABLLBLEITMDISCOUNTVERSION,
    CACONTRACT,
    CADEPENDENTITEMTYPE,
    CADISCBASEITMGROUP,
    CAEXTERNALTAXDATE,
    CAINVCGACCRUALPOSTINGTYPE,
    CAINVCGCORRECTIONCATEGORY,
    CAINVCGDFRRDREVENUESTATUS,
    CAINVCGISITEMPOSTINGRELEVANT,
    CAINVCGISITEMPRINTINGRELEVANT,
    CAINVCGISNOTBPRELEVANT,
    CAINVCGSUBSTITUTEGROUPPRINTING,
    CAISDOCITEMSIMULATED,
    CAISDOWNPAYMENTREQUEST,
    CAISPREPAID,
    CAISREVENUEACCOUNTINGRELEVANT,
    CAITEMPERIODENDDATE,
    CAITEMPERIODSTARTDATE,
    CAMAINTRANSACTION,
    CANETDUEDATE,
    CAOTHERTAXCODE,
    CAPROVIDERCONTRACTITEMNUMBER,
    CAREASONSECURITYDEPOSIT,
    CAREVENUEACCOUNTINGSERVICETYPE,
    CASTATISTICALITEMCODE,
    CASUBAPPLICATION,
    CASUBTRANSACTION,
    CATAXCOUNTRY,
    CATAXDATETYPE,
    CATAXDETERMINATIONCODE,
    CATAXDETNTYPE,
    CATAXISINCLUDED,
    COMPANYCODE,
    CONDITIONTYPE,
    DIVISION,
    PROFITCENTER,
    SEGMENT,
    TAXCODE,
    TAXJURISDICTION,
    UNITOFMEASURE,
    WITHHOLDINGTAXCODE,
    PRIMARY KEY (CABILLGDOCITEM, CABILLGDOCUMENT)
);

Learn More