BILLINGDOCUMENTREQUESTITEM

100 Fields

BILLINGDOCUMENTREQUESTITEM is an SAP database table in S/4HANA. It contains 100 fields.

Fields (100)

KeyField CDS FieldsUsed in Views
KEY BillingDocumentRequest BillingDocumentRequest 1
KEY BillingDocumentRequestItem BillingDocumentRequestItem 1
AdditionalMaterialGroup1 AdditionalMaterialGroup1 1
AdditionalMaterialGroup2 AdditionalMaterialGroup2 1
AdditionalMaterialGroup3 AdditionalMaterialGroup3 1
AdditionalMaterialGroup4 AdditionalMaterialGroup4 1
AdditionalMaterialGroup5 AdditionalMaterialGroup5 1
BaseUnit BaseUnit 1
Batch Batch 1
BillgDocReqBillgSts BillgDocReqBillgSts 1
BillgDocRequestItemInPartSgmt BillgDocRequestItemInPartSgmt 1
BillingDocumentRequestItemText BillingDocumentRequestItemText 1
BillingDocumentRequestType BillingDocumentRequestType 1
BillingQuantity BillingQuantity 1
BillingQuantityInBaseUnit BillingQuantityInBaseUnit 1
BillingQuantityUnit BillingQuantityUnit 1
BillingToBaseQuantityDnmntr BillingToBaseQuantityDnmntr 1
BillingToBaseQuantityNmrtr BillingToBaseQuantityNmrtr 1
BusinessArea BusinessArea 1
BusinessSolutionOrder BusinessSolutionOrder 1
BusinessSolutionOrderItem BusinessSolutionOrderItem 1
CashDiscountIsDeductible CashDiscountIsDeductible 1
ControllingArea ControllingArea 1
CostAmount CostAmount 1
CostCenter CostCenter 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
CreationTime CreationTime 1
CreditRelatedPrice CreditRelatedPrice 1
DepartureCountry DepartureCountry 1
Division Division 1
GrossAmount GrossAmount 1
HigherLevelItem HigherLevelItem 1
InternationalArticleNumber InternationalArticleNumber 1
ItemGrossWeight ItemGrossWeight 1
ItemIsRelevantForCredit ItemIsRelevantForCredit 1
ItemNetWeight ItemNetWeight 1
ItemVolume ItemVolume 1
ItemVolumeUnit ItemVolumeUnit 1
ItemWeightUnit ItemWeightUnit 1
MaterialCommissionGroup MaterialCommissionGroup 1
MatlAccountAssignmentGroup MatlAccountAssignmentGroup 1
MRPRequiredQuantityInBaseUnit MRPRequiredQuantityInBaseUnit 1
NetAmount NetAmount 1
OrderID OrderID 1
OrganizationDivision OrganizationDivision 1
OriginallyRequestedMaterial OriginallyRequestedMaterial 1
OriginSDDocument OriginSDDocument 1
OriginSDDocumentItem OriginSDDocumentItem 1
Plant Plant 1
PriceDetnExchangeRate PriceDetnExchangeRate 1
PriceDetnExchangeRateDate PriceDetnExchangeRateDate 1
PricingDate PricingDate 1
PricingReferenceMaterial PricingReferenceMaterial 1
PricingScaleQuantityInBaseUnit PricingScaleQuantityInBaseUnit 1
Product Product 1
ProductGroup ProductGroup 1
ProductHierarchyNode ProductHierarchyNode 1
ProductTaxClassification1 ProductTaxClassification1 1
ProductTaxClassification2 ProductTaxClassification2 1
ProductTaxClassification3 ProductTaxClassification3 1
ProductTaxClassification4 ProductTaxClassification4 1
ProductTaxClassification5 ProductTaxClassification5 1
ProductTaxClassification6 ProductTaxClassification6 1
ProductTaxClassification7 ProductTaxClassification7 1
ProductTaxClassification8 ProductTaxClassification8 1
ProductTaxClassification9 ProductTaxClassification9 1
ProfitCenter ProfitCenter 1
ProviderContract ProviderContract 1
ProviderContractItem ProviderContractItem 1
ReferenceDocSDDocCategory ReferenceDocSDDocCategory 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentItem ReferenceDocumentItem 1
ReferenceLogicalSystem ReferenceLogicalSystem 1
ReturnItemProcessingType ReturnItemProcessingType 1
SalesDocument SalesDocument 1
SalesDocumentItem SalesDocumentItem 1
SalesDocumentItemCategory SalesDocumentItemCategory 1
SalesDocumentItemType SalesDocumentItemType 1
SalesGroup SalesGroup 1
SalesOffice SalesOffice 1
SalesOrganization SalesOrganization 1
SalesSDDocumentCategory SalesSDDocumentCategory 1
ServiceDocument ServiceDocument 1
ServiceDocumentItem ServiceDocumentItem 1
ServiceDocumentType ServiceDocumentType 1
StatisticalValueControl StatisticalValueControl 1
StorageLocation StorageLocation 1
Subtotal1Amount Subtotal1Amount 1
Subtotal2Amount Subtotal2Amount 1
Subtotal3Amount Subtotal3Amount 1
Subtotal4Amount Subtotal4Amount 1
Subtotal5Amount Subtotal5Amount 1
Subtotal6Amount Subtotal6Amount 1
TaxAmount TaxAmount 1
TaxJurisdiction TaxJurisdiction 1
TimeSheetOvertimeCategory TimeSheetOvertimeCategory 1
TransactionCurrency TransactionCurrency 1
WBSElementInternalID WBSElementInternalID 1
ZeroVATRsn ZeroVATRsn 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BILLINGDOCUMENTREQUESTITEM (
    BILLINGDOCUMENTREQUEST,
    BILLINGDOCUMENTREQUESTITEM,
    ADDITIONALMATERIALGROUP1,
    ADDITIONALMATERIALGROUP2,
    ADDITIONALMATERIALGROUP3,
    ADDITIONALMATERIALGROUP4,
    ADDITIONALMATERIALGROUP5,
    BASEUNIT,
    BATCH,
    BILLGDOCREQBILLGSTS,
    BILLGDOCREQUESTITEMINPARTSGMT,
    BILLINGDOCUMENTREQUESTITEMTEXT,
    BILLINGDOCUMENTREQUESTTYPE,
    BILLINGQUANTITY,
    BILLINGQUANTITYINBASEUNIT,
    BILLINGQUANTITYUNIT,
    BILLINGTOBASEQUANTITYDNMNTR,
    BILLINGTOBASEQUANTITYNMRTR,
    BUSINESSAREA,
    BUSINESSSOLUTIONORDER,
    BUSINESSSOLUTIONORDERITEM,
    CASHDISCOUNTISDEDUCTIBLE,
    CONTROLLINGAREA,
    COSTAMOUNT,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CREDITRELATEDPRICE,
    DEPARTURECOUNTRY,
    DIVISION,
    GROSSAMOUNT,
    HIGHERLEVELITEM,
    INTERNATIONALARTICLENUMBER,
    ITEMGROSSWEIGHT,
    ITEMISRELEVANTFORCREDIT,
    ITEMNETWEIGHT,
    ITEMVOLUME,
    ITEMVOLUMEUNIT,
    ITEMWEIGHTUNIT,
    MATERIALCOMMISSIONGROUP,
    MATLACCOUNTASSIGNMENTGROUP,
    MRPREQUIREDQUANTITYINBASEUNIT,
    NETAMOUNT,
    ORDERID,
    ORGANIZATIONDIVISION,
    ORIGINALLYREQUESTEDMATERIAL,
    ORIGINSDDOCUMENT,
    ORIGINSDDOCUMENTITEM,
    PLANT,
    PRICEDETNEXCHANGERATE,
    PRICEDETNEXCHANGERATEDATE,
    PRICINGDATE,
    PRICINGREFERENCEMATERIAL,
    PRICINGSCALEQUANTITYINBASEUNIT,
    PRODUCT,
    PRODUCTGROUP,
    PRODUCTHIERARCHYNODE,
    PRODUCTTAXCLASSIFICATION1,
    PRODUCTTAXCLASSIFICATION2,
    PRODUCTTAXCLASSIFICATION3,
    PRODUCTTAXCLASSIFICATION4,
    PRODUCTTAXCLASSIFICATION5,
    PRODUCTTAXCLASSIFICATION6,
    PRODUCTTAXCLASSIFICATION7,
    PRODUCTTAXCLASSIFICATION8,
    PRODUCTTAXCLASSIFICATION9,
    PROFITCENTER,
    PROVIDERCONTRACT,
    PROVIDERCONTRACTITEM,
    REFERENCEDOCSDDOCCATEGORY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTITEM,
    REFERENCELOGICALSYSTEM,
    RETURNITEMPROCESSINGTYPE,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESDOCUMENTITEMCATEGORY,
    SALESDOCUMENTITEMTYPE,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SALESSDDOCUMENTCATEGORY,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    STATISTICALVALUECONTROL,
    STORAGELOCATION,
    SUBTOTAL1AMOUNT,
    SUBTOTAL2AMOUNT,
    SUBTOTAL3AMOUNT,
    SUBTOTAL4AMOUNT,
    SUBTOTAL5AMOUNT,
    SUBTOTAL6AMOUNT,
    TAXAMOUNT,
    TAXJURISDICTION,
    TIMESHEETOVERTIMECATEGORY,
    TRANSACTIONCURRENCY,
    WBSELEMENTINTERNALID,
    ZEROVATRSN,
    PRIMARY KEY (BILLINGDOCUMENTREQUEST, BILLINGDOCUMENTREQUESTITEM)
);

Learn More