I_CADOCUMENTBPITEM

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.

-- Document Business Partner Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CADOCUMENTBPITEM (
    BUSINESSPARTNER,
    CAAPPLICATIONAREA,
    CABPITEMNUMBER,
    CACLEARINGDOCUMENTNUMBER,
    CACONTRACT,
    CADOCUMENTNUMBER,
    CADOCUMENTTYPE,
    CAPOSTINGDATE,
    CAPOSTINGDATEOFCLEARINGDOC,
    CARECONCILIATIONACCOUNT,
    CAREPETITIONITEMNUMBER,
    CASUBITEMNUMBER,
    CHARTOFACCOUNTS,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CONTRACTACCOUNT,
    DOCUMENTDATE,
    TRANSACTIONCURRENCY,
    _ACCTASSGMTCAT,
    _ACCTDETNCODE,
    _ALTVBPFORPAYMENT,
    _APPLAREA,
    _BUSINESSAREA,
    _BUSINESSPARTNER,
    _CAHEADER,
    _CAHEADERCOLLVBILLS,
    _CAHEADERFINALREC,
    _CAPARTNER,
    _CAREVNDISTRCURSTS,
    _CAREVNDISTRLASTSTS,
    _CAROUNDINGITEMCODE,
    _CASHFLOWACCOUNT,
    _CASUBAPPLICATION,
    _CAWITHHOLDINGTAXCAT,
    _CHARTOFACCOUNTS,
    _CLEARINGCURRENCY,
    _CLEARINGDOCHEADER,
    _CLEARINGREASON,
    _CLEARINGSTATUS,
    _CLRGRSTRCNCODE,
    _COMPANYCODECURRENCY,
    _COMPCODE,
    _COMPCODECASHFLOW,
    _COMPCODEPAYT,
    _CONTROLLINGAREA,
    _COUNTRY,
    _CURRENCY,
    _DBTFLORVALADJMTCODE,
    _DIVISION,
    _DOCHEADER,
    _DOCTYPE,
    _DUNNINGPROCEDURE,
    _FACTORINGRBLSTATUS,
    _FCTRNGCLRGCHKSTATUS,
    _GLPOSTINGCURRENCY,
    _INTERESTCODE,
    _INTPOSTINGREASONCODE,
    _MAINTRANSACTION,
    _NGTVPOSTINGCTRLCODE,
    _OFFSETTAXACCOUNT,
    _ORIGINDOCHEADER,
    _ORIGLSTSTCLITEMCODE,
    _OTHERTAXCODE,
    _PARTNERCOMPANY,
    _PAYTMETHOD,
    _PAYTPRENOTIFCODE,
    _PAYTSPECCATEGORY,
    _PERIODCODE,
    _PROFITCENTER,
    _PROVIDERCONTRACT,
    _PRTNSETTLEMENTSTATUS,
    _RECEIVINGCOUNTRY,
    _RECONACCOUNT,
    _SEGMENT,
    _SEPAPRENOTIFORIGNCD,
    _SEPAPRENOTIFRQMTCODE,
    _STATISTICALITEMCODE,
    _SUBSTITDOCCATEGORY,
    _SUBSTITDOCHEADER,
    _SUBTRANSACTION,
    _TAXACCOUNT,
    _WHLDGTAXSUPLMNT,
    _WITHHOLDINGTAXCODE,
    _WORKFLOWCHECKPROCESS,
    _WORKFLOWCHECKREASON,
    ALTVCONTRACTACCTFORCOLLVBILLS,
    BUSINESSAREA,
    BUSINESSPLACE,
    CAACCOUNTASSIGNMENT,
    CAACCOUNTASSIGNMENTCATEGORY,
    CAACCOUNTDETERMINATIONCODE,
    CAADDITIONALCONTRACT,
    CAADDITIONALDAYSFORCASHMGMT,
    CAADDRESSOFALTVBPFORPAYMENT,
    CAALTVBPFORPAYMENT,
    CAAMOUNTINLOCALCURRENCY,
    CAAMOUNTINSECONDCURRENCY,
    CAAMOUNTINTHIRDCURRENCY,
    CAAMOUNTINTRANSACTIONCURRENCY,
    CABANKOFALTVBPFORPAYMENT,
    CABASEAMOUNTFORWITHHOLDINGTAX,
    CABPITEMTEXT,
    CACARDOFALTVBPFORPAYMENT,
    CACASHDISCAMOUNTINCLEARINGCRCY,
    CACASHDISCOUNTDUEDATE,
    CACASHDISCOUNTRATE,
    CACASHFLOWACCOUNT,
    CACASHFLOWCOMPANYCODE,
    CACHANGEISFORBIDDEN,
    CACLEARINGAMOUNTINCLEARINGCRCY,
    CACLEARINGCURRENCY,
    CACLEARINGDATE,
    CACLEARINGPOSTINGISRESET,
    CACLEARINGREASON,
    CACLEARINGRESTRICTIONCODE,
    CACLEARINGSTATUS,
    CACURRENTFACTORINGSTATUSOFRBL,
    CADEFERRALDATE,
    CADOCBPITEMTOTALAMOUNTINTC,
    CADOCUMENTNUMBEROFORIGINITEM,
    CADOCUMENTORIGINCODE,
    CADOUBTFULORVALUEADJMTCODE,
    CADOWNPAYMENTOFFSETTAXACCOUNT,
    CADOWNPAYMENTTAXACCOUNT,
    CADUNNINGPROCEDURE,
    CAELIGIBLEAMOUNTFORCSHDISCOUNT,
    CAENDDATEOFBILLINGPERIOD,
    CAEXCHANGERATE,
    CAFACTORINGCHECKSTSFORCLRGINFO,
    CAFACTORINGITEM,
    CAGLPOSTINGAMOUNT,
    CAGLPOSTINGCURRENCY,
    CAGLPOSTINGTAXAMOUNT,
    CAGROUPINGCODEFORBPITEMS,
    CAGROUPINGCODEFORTAXITEMS,
    CAGROUPINGFORPAYMENT,
    CAGRPGCODEFORTRANSFTOCOLLAGCY,
    CAINTERESTCODE,
    CAINTERNALPOSTINGREASONCODE,
    CAISCASHFLOWITEM,
    CAISDOWNPAYMENTREQUEST,
    CAISINCLUDEDINCOLLECTIONCASE,
    CAISPARTOFJOINTLIABILITY,
    CAISSEPARATELINEITEMINGL,
    CAITEMISEXCLUDEDFROMDUNNING,
    CAITEMISONLYFORSETTLEMENT,
    CAITEMISWITHDRAWN,
    CAMAINTRANSACTION,
    CANEGATIVEPOSTINGCONTROLCODE,
    CANETDUEDATE,
    CANUMBEROFREPETITIONITEMS,
    CAOTHERTAXCODE,
    CAPARTNERSETTLEMENTSTATUS,
    CAPAYMENTCOMPANYCODE,
    CAPAYMENTMETHOD,
    CAPAYMENTPRENOTIFICATIONCODE,
    CAPAYMENTSPECIFICATIONCATEGORY,
    CAPERIODCODE,
    CAPROVIDERCONTRACTITEMNUMBER,
    CARECEIVINGCOUNTRY,
    CAREFERENCEDOCUMENT,
    CAREPETITIONGROUP,
    CAREVENUEDISTRCURRENTSTATUS,
    CAREVENUEDISTRFINALRECIPIENT,
    CAREVENUEDISTRLASTSTATUS,
    CAROUNDINGITEMCODE,
    CASEPAPRENOTIFEXECUTIONDATE,
    CASEPAPRENOTIFICATIONNUMBER,
    CASEPAPRENOTIFICATIONRQMTCODE,
    CASEPAPRENOTIFORIGINCODE,
    CASHPLANNINGGROUP,
    CASTARTDATEOFBILLINGPERIOD,
    CASTATISTICALCODEOFORIGINITEM,
    CASTATISTICALITEMCODE,
    CASUBAPPLICATION,
    CASUBSTITUTEDOCUMENTCATEGORY,
    CASUBSTITUTEDOCUMENTNUMBER,
    CASUBTRANSACTION,
    CASUPPLEMENTARYTAXCODE,
    CATAXAMOUNTINCLEARINGCRCY,
    CATAXAMOUNTINLOCALCURRENCY,
    CATAXAMOUNTINSECONDCURRENCY,
    CATAXAMOUNTINTHIRDCURRENCY,
    CATAXAMOUNTINTRANSCURRENCY,
    CATAXAMOUNTISSETFROMEXTERNAL,
    CATAXDATE,
    CATAXISCALCULATEDEXTERNALLY,
    CATAXPORTIONINLOCALCURRENCY,
    CATAXPORTIONINTRANSCURRENCY,
    CAVALUEDATEFORCLEARING,
    CAWITHHOLDINGTAXAMOUNT,
    CAWITHHOLDINGTAXCATEGORY,
    CAWITHHOLDINGTAXPERCENTAGE,
    CAWITHHOLDINGTAXSUPPLEMENT,
    CAWORKFLOWCHECKPROCESS,
    CAWORKFLOWCHECKREASON,
    CONTROLLINGAREA,
    COUNTRY,
    DIVISION,
    EXCHRATEISINDIRECTQUOTATION,
    PARTNERCOMPANY,
    PERSONNELNUMBER,
    PLANNEDAMTINTRANSACTIONCRCY,
    PLANNINGLEVEL,
    PROFITCENTER,
    SEGMENT,
    SEPAMANDATECAINTERNALID,
    TAXCODE,
    TAXJURISDICTION,
    WITHHOLDINGTAXCERTIFICATE,
    WITHHOLDINGTAXCODE,
    PRIMARY KEY (BUSINESSPARTNER, CAAPPLICATIONAREA, CABPITEMNUMBER, CACLEARINGDOCUMENTNUMBER, CACONTRACT, CADOCUMENTNUMBER, CADOCUMENTTYPE, CAPOSTINGDATE, CAPOSTINGDATEOFCLEARINGDOC, CARECONCILIATIONACCOUNT, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER, CHARTOFACCOUNTS, COMPANYCODE, COMPANYCODECURRENCY, CONTRACTACCOUNT, DOCUMENTDATE, TRANSACTIONCURRENCY)
);